FINANCIAL MODELING LABORATORY (2 Credits)

Learning Outcomes:

On successful completion of this course, student will be able to: LO1 – Describe Spread Sheet Basic for Excel and Financial Statement; LO2 – Analyze Cash Budget, Financial Statement, Financial Forecasting, Break Even Point and Leverage; LO3 – Calculate Time Value of Money, Common Stock Valuation, Bond Valuation, The Cost of Capital, Capital Budgeting, Risk and Capital Budgeting; LO4 – Apply Portfolio Statistics and Diversification.

Topics:

1. Introduction to Excel;
2. The Basic Financial Statements;
3. Financial Statement Analysis Tools;
4. The Cash Budget;
5. Financial Statement Forecasting;
6. Break-Even 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.