FirstRanker Logo

FirstRanker.com - FirstRanker's Choice is a hub of Question Papers & Study Materials for B-Tech, B.E, M-Tech, MCA, M.Sc, MBBS, BDS, MBA, B.Sc, Degree, B.Sc Nursing, B-Pharmacy, D-Pharmacy, MD, Medical, Dental, Engineering students. All services of FirstRanker.com are FREE

📱

Get the MBBS Question Bank Android App

Access previous years' papers, solved question papers, notes, and more on the go!

Install From Play Store

Download JNTUH MBA 4th Sem 2019 April Financial Modeling Question Paper

Download JNTUH (Jawaharlal Nehru Technological University Hyderabad) MBA Fourth Year (4th Semester) 2019 April Financial Modeling Question Paper.

This post was last modified on 04 December 2019

This download link is referred from the post: JNTUH MBA 4th Semester Last 10 Year Question Papers (2010-2020) All Regulation - (JNTU Hyderabad)


Firstranker's choice

Hall Ticket No

FirstRanker.com

--- 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

  1. (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]
  2. (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]
  3. --- Content provided by FirstRanker.com ---

UNIT II

  1. (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]
  2. (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]
  3. --- Content provided by FirstRanker.com ---

UNIT - III

  1. (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]
  2. (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]
  3. --- Content provided by FirstRanker.com ---

UNIT - IV

  1. (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]
  2. (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]
  3. --- Content provided by FirstRanker.com ---

UNIT - V

  1. (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]
  2. (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]
  3. --- 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 ---