Firstranker's choice
Hall Ticket No
--- Content provided by FirstRanker.com ---
Question Paper Code: CMB420
MBA IV Semester End Examinations (Regular) - April, 2019
Regulation: R16
FINANCIAL MODELING
(MBA)
--- Content provided by FirstRanker.com ---
Time: 3 Hours
Max Marks: 70
Answer ONE Question from each Unit
All Questions Carry Equal Marks
All parts of the question must be answered in one place only
--- Content provided by FirstRanker.com ---
UNIT I
- (a) Explain the steps that are followed in creating a model. [7M]
(b) What is financial model? Explain any two types of financial model. [7M] - (a) Discuss steps involved in computing average of numbers from a data set given. [7M]
(b) Explain advanced features of excel. If we want to add a data labels in chart, what is the procedure to be followed. [7M]
--- Content provided by FirstRanker.com ---
UNIT II
- (a) Explain sensitivity analysis of goal seek in Excel. [7M]
(b) Discuss the steps involved in creating two variable data sets for statistical distributions. [7M] - (a) Explain the formulate Syntax and its use “= NORMINV(RAND(), B2, C2),” a hypothetical syntax. [7M]
(b) How excel supports the business analyst in developing models in finance using simulation. [7M]
--- Content provided by FirstRanker.com ---
UNIT - III
- (a) Define project appraisal. Explain the key steps in developing a financial statement model. [7M]
(b) Explain the steps to prepare trail balance statement using excel for determining project viability. [7M] - (a) Assure that you have been given historical stock prices of one year. Explain steps involved in developing a model to simulate the expected return and volatility of the stock. [7M]
(b) Write the formulae for Net Present Value (NPV) equation. Explain how do you substitute the values in excel. [7M]
--- Content provided by FirstRanker.com ---
UNIT - IV
- (a) Explain the steps involved in developing black and schools model to price options in excel. [7M]
(b) Determine efficient portfolio and create various types of portfolios of fixed income portfolio management using excel. [7M] - (a) Explain the steps involved in highlighting cells with a value of less than 20 from a given data set. [7M]
(b) Explain the following financial functions: i)DISC ii) Duration iii) Net Present Value (NPV) [7M]
--- Content provided by FirstRanker.com ---
UNIT - V
- (a) What is Macro's. Discuss how Macro's can be recorded and edited. [7M]
(b) What is debugging? Explain few syntax errors and ways of debugging it/them. [7M] - (a) Briefly explain about designing advanced in financial models using visual basic application uses forms. [7M]
(b) Explain advanced features of actual model building and decision rules of functions. [7M]
--- Content provided by FirstRanker.com ---
This download link is referred from the post: JNTUH MBA 4th Semester Last 10 Year Question Papers (2010-2020) All Regulation - (JNTU Hyderabad)
--- Content provided by FirstRanker.com ---