Important Topics for Financial Analytics subject

 

UNIT-1

Long Questions

1.    Define Financial Analytics? Discuss the Need & Importance of Financial analytics

2.    Describe scientific methods in Finance

3.    Explain how Financial analytics helpful for Business and also explain uses of it

4.    Discuss empirical studies & research in Finance

5.    Outline various software packages for Financial data analysis

Short questions

1.    Financial Analytics Vs. Financial Analysis

2.    Financial Analytics Vs. Financial Modeling

3.    What is Financial Data?

4.    What are various steps in SPSS

 

UNIT-2

1.    Explain various Financial functions used in MS Excel

2.    Discuss the PV, FV, NPV & IRR functions calculation process using Excel

3.    Explain Various Finance tools used under Portfolio Management

4.    Discuss the Annual return & Risk calculation process using Excel

5.    Discuss the correlation function using example and its calculation process using Excel

 

Short questions

1.    Define Finance Function

2.    PV Vs. FV function in excel

3.    NPV Vs. IRR function in excel

4.    Angle of Incidence

5.    XNPV & XIRR

6.    What is Annuities?

7.    Beta/Market Beta/Systematic Risk

UNIT-3

Long Questions

1.    Explain various characteristics of statistics & Various types

2.    Discuss various scaling Techniques using examples

3.    Discuss the Graphical representation of data using MS Excel

4.    Discuss the applications of measures of central tendency

5.    Explain important characteristic of good measure of dispersion

Short questions

1.    Descriptive statistical tools

2.    Symmetry, Skewness & kurtosis

3.    Population vs. Sample

4.    Parametric Vs. Non-Parametric Test

5.    Independent Vs. Dependent variable

6.    Correlation Vs. Regression

UNIT-4

Long Questions

1.    Explain the Applications of correlation from Investment point of view

2.    Write the step by step procedure of calculation of Avg. Return, Risk & portfolio using example

3.    Discuss the Calculation procedure of  MMULT & TRASPOSE functions in MS Excel using example

4.    What is Scatter Plot diagram, explain the procedure to draw using MS Excel

5.    Explain various types of correlation using examples

 

Short questions

 

1.    Investment vs. speculation

2.    Risk vs. Return

3.    Systematic Risk vs. Unsystematic Risk

4.    Positive correlation vs. Negative correlation

5.    CAPM

6.    SML

UNIT-5

Long Questions

1.    Explain the concept of Financial forecasting & its significance

2.    Discuss various types of Financial forecasting

3.    What is simple linear regression, explain its applications (Using MS Excel)

4.    What is Multiple linear regression, explain its applications (Using MS Excel)

5.    Explain the concept of Testing the equality of population regression coefficient to be zero using examples

 

 

Short questions

1.    Dummy variable

2.    Predictive variable Vs. Dependent variable

3.    Simple linear regression Vs. Multiple linear regression

4.    List out categorical variables

5.    List out quantitative methods in Finance

 

UNIT-6

Long Questions

1.    Explain Predictive analytics need & importance

2.    Discuss the applications of Time series analysis concept

3.    Explain the concept of Time plot statistics

4.    Discuss various Time series forecasting methods

5.    Discuss the concept of Autoregressive time series model and its applications

6.    Explain the concept of Random walk and Unit root concepts

7.    Discuss various Trend models in Predictive analytics

 

Short questions

1.    ARMA Vs. ARIMA

2.    Time series Vs. Cross sectional

3.    Time series Vs. Panel data

4.    Panel survey Vs. Longitude survey

5.    Stationary data vs. Non-stationary data