Dr. Agarwal
Home About Us School Activities Corporate Sector People College & University
 

Excel in Corporate Finance

 
     
 
Online Certificate Programme in Corporate Finance via MS Excel
 
     
 
Course Content
 
     
 
Spurred by the success of its existing Finance programs, MSF has launched an online course called ‘Excel in Corporate Finance’. This program provides a ‘ready-made recipe’ to carve out a successful career in insurance companies, financial firms, the banking sector, etc., in areas such as investor education and counseling, project choice, portfolio management, and risk analysis.
  
       
  The basic material for the course will consist of Excel workbooks and written material that explains both the Finance concepts and their implementation in Excel. These will be supported by video clips, discussion boards, online chat sessions, and FAQs, to provide you a full-featured service.

The course consists of 15 modules. Each module is designed for one week of study. The list of modules is:

 
       
 
  1. Doing Simple mathematics with Excel

  2. Understanding Compound Interest, Finding EMIs

  3. Cash Flows I – Net Present Value

  4. A Powerful Excel Feature – Goal Seek

  5. Cash Flows II – Internal Rate of Return

  6. Introducing Bonds: The Price-Yield Curve

  7. Theory of Bonds: Macaulay and Modified Duration

  8. Immunizing Portfolios

  9. An Introduction to Spot and Forward Rates

  10. Immunization by Considering Spot Rates and Convexity

  11. A Powerful Excel Tool – Solver

  12. Mean Variance Analysis for 2 & 3 Assets

  13. The Capital Assets Pricing Model (CAPM)

  14. Jensen's Index and Sharp Ratio

  15. Applications in Corporate Finance

 
       
Registration Form
Course Content
Evaluation Scheme
Sample Material