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 :
- Financial Functions in Excel .
- Creating Dynamic Models .
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
ORDER NOW RECOMMENDED BOOKS- SPONSORED BY AMAZON