BA4005 Financial Modelling - important questions - Anna University - MBA

   BA4004

Financial Modelling

MBA Anna University Exam

Important questions.

 Study only these questions 90% Mark guarantee*

Unit 1.

1. Financial Modelling and It's Needs

2. Steps to effective Financial Modelling

3. Time Value of Money

4. Lookup array functions - FV,PV, PMT, RATE, NPER, VLookup, HLookup, If, Countifetc

(The concept of These functions must be understood. Search each function in google mention that it is related to Financial Modelling. For example - type "PV in Financial Modelling" on google. You'll get the concept. Read and try to understand. Read untill you you understand something)

Unit 2.

1. Bond valuation formula & Excel format

2. Two basic Methods to calculate YTM - Rate Method & IRR method

3. Flexi bond & strip bond - YTM modelling

Unit 3.

1. Altman Z bankruptcy modeling

2. Indifference point modelling

3. Financial Break even modelling

4. Two stage growth Modelling (Gordon Growth Modelling

Unit 4.

1. Securities market line modelling

2. Portfolio risk calculation & optimisation and portfolio construction Modelling

Unit 5. 

1. Option pricing Modelling

(Learn how to do the modelling step by step in Excel Sheet. The procedures might be important)

NOTE:

If you are clear with these 10 questions I am sure that you will score 90% mark* . But 2 marks questions are not included here, study them separately.

Best Wishes.

- team

*Click to Read Conditions.