FINANCIAL MODELING LABORATORY (2 Credits)

Learning Outcomes:

On successful completion of this course, student will be able to: Describe Spread Sheet Basic for Excel 2013 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 and Diversification.

Topics:

1. Introduction to Excel 2013;
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.