Financial Modelling Laboratory

Learning Outcomes :

After completing this course, the student will be able to: Describe Spreadsheet Basic and Financial Statement; Analyze Cash Budget, Financial Statement, Financial Forecasting, Break Even Point and Leverage; Calculate Time Value of Money, Common Stock Valuation, Bond Valuation, The Cost of Capital, Capital Budgeting, Risk and Capital Budgeting; Apply Portfolio Statistics, Portfolio Risk and Return.

Topics :

1. Introduction to Excel 2007
2. The Basics Financial Statement
3. The Cash Budget
4. Financial Statement Analysis Tools
5. Financial Forecasting
6. Break Even Point and Leverage Analysis
7. The Time Value of Money
8. Common Stock Valuation
9. Bond Valuation
10. The Cost of Capital
11. Capital Budgeting
12. Risk and Capital Budgeting
13. Portfolio Statistics and Diversification