FINANCIAL MODELING USING EXCEL SYLLABUS

                        The objective of this subject is enrich students with  the skills required to build powerful models in finance with the help of Excel . The modeling techniques are used in derivatives , valuation , project evaluation etc.


MODULES / TOPICS 

1. FEATURES OF EXCEL :

2. FINANCE FUNCTIONS :

3. STATISTICAL FUNCTIONS :
  • Standard Deviation , Variance and Analysis of Co Variance in Excel . 
  • Co-efficient of Determination in Excel .
  • Trend Analysis and T Test in Excel . 

4. EXCEL IN ACCOUNTING :
  • Common Size Statements From Trial Balance in Excel .
  • Analyzing Financial Statements Using Spreadsheet Model .

5. EXCEL IN PROJECT APPRAISAL :
  • Determining Project Viability , Risk Analysis in Project Appraisal .
  • Simulation in Project Appraisal .
  • DCF Valuation , Risk Analysis in Valuation .

6.EXCEL IN PORTFOLIO THEORY :
  • Determining efficient Portfolio .
  • Markowitz Model and Sharp Single Index Model.
  • Portfolio Investment Process .
  • Calculation of Beta and Alpha .

7. EXCEL IN BOND VALUATION:
  • PV Model in Excel .
  • Bonds Yield and Measures Duration in Excel .
  • Bond Value Theorem in Excel .

8. EXCEL IN DERIVATIVES :
  • Black and Scholes Model in Excel .
  • Greeks in Excel .
CONTENT TO BE ADDED SOON .... 

ORDER NOW RECOMMENDED BOOKS- SPONSORED BY AMAZON