BA4005 Financial Modelling Syllabus:

BA4005 Financial Modelling Syllabus – Anna University PG Syllabus Regulation 2021

COURSE OBJECTIVE:

 Making students to build financial models by including various fields of study viz Financial Management and Derivatives.

UNIT I INTRODUCTION TO FINANCIAL MODELLING & BUILT IN FUNCTIONS USING SPREAD SHEETS

Introduction to Financial Modelling- Need for Financial Modelling- Steps for effective financial modelling-Introduction to Time value of money & Lookup array functions :FV,PV,PMT,RATE,NPER, Vlookup, Hlookup ,if, countifetc – Time value of Money Models: EMI with Single & Two Interest rates –Loan amortisation modelling-Debenture redemption modelling

UNIT II BOND & EQUITY SHARE VALUATION MODELLING

Bond valuation – Yield to Maturity(YTM): Rate method Vs IRR method-Flexi Bond and Strip Bond YTM Modelling-Bond redemption modelling -Equity share valuation : Multiple growth rate valuation modelling with and without growth rates

UNIT III CORPORATE FINANCIAL MODELLING

Alt Man Z score Bankruptcy Modelling-Indifference point modelling – Financial Break even modelling -Corporate valuation modelling (Two stage growth)- Business Modelling for capital budgeting evaluation: Payback period ,NPV ,IRR and MIRR

UNIT IV PORTFOLIO MODELLING

Risk ,Beta and Annualised Return –Security Market Line Modelling –Portfolio risk calculation (Equal Proportions)-Portfolio risk optimisation (varying proportions)-Portfolio construction modelling

UNIT V DERIVATIVE MODELLING

Option pay off modelling: Long and Short Call & Put options -Option pricing modeling (B-S Model)-Optimal Hedge Contract modelling

COURSE OUTCOMES:

1. Develop fast, efficient and accurate excel skills
2. Design and construct useful and robust financial modelling applications
3. Recognize efficient financial budgeting and forecasting techniques
4. Familiarise the students with the valuation modelling of securities
5. The course establishes the platform for students to develop various portfolio models

REFERENCES:

1. Wayne L Winston,” Microsoft Excel 2016-Data Analysis and Business Modelling ”,PHI publications, (Microsoft Press),New Delhi,2017.
2. Chandan Sen Gupta, ”Financial analysis and Modelling –Using Excel and VBA” , Wiley Publishing House ,2014’
3. Craig W Holden,”Excel Modelling in Investments” Pearson Prentice Hall, Pearson Inc, New Jersey,5th Edition 2015
4. Ruzhbeh J Bodanwala , ”Financial management using excel spread sheet”, Taxman Allied services Pvt Ltd, New Delhi,3rd Edition 2015.

Related posts:

  1. BA4202 Financial Management Syllabus
  2. BA4002 Financial Markets Syllabus
  3. BA4004 Financial Derivatives Syllabus
  4. BA4003 Banking and Financial Services Syllabus
  5. PD4004 Quality and Financial Concepts in Product Development Syllabus
  6. EV4016 Air Quality Modelling Syllabus
  7. BD4091 Predictive Modelling Syllabus
  8. AR3010 Parametric Modelling and Coding Syllabus
  9. EV4012 Water Quality Modelling Syllabus
  10. EV4014 Climate Change and Modelling Syllabus
  11. RS4014 Spatial Data Modelling Syllabus
  12. BY4010 Bioprocess Modelling and Simulation Syllabus
  13. RS4017 Geomatics for Environmental Monitoring and Modelling Syllabus
  14. EY4001 Modelling and Analysis of Energy Systems Syllabus
  15. PX4003 Electromagnetic Field Computation and Modelling Syllabus
  16. IL4004 Management Accounting and Financial Management Syllabus
  17. AR3014 Digital Tools for Building Modelling and Analysis Syllabus
  18. AM4212 Design and Modelling of Vehicle Components Laboratory Syllabus