Financial Modeling with Spreadsheets

Course content

1. 1Spreadsheet design principlesComing
2. 2Time value of money functionsComing
3. 3Loan and mortgage schedulesComing
4. 4Building a three-statement modelComing
5. 5Revenue and cost forecastingComing
6. 6Working capital and cash flowComing
7. 7Discounted cash flow valuationComing
8. 8Sensitivity tables and scenariosComing
9. 9Monte Carlo simulation in a spreadsheetComing
10. 10Charts and dashboards for decision makersComing
11. 11Checking, auditing and documenting modelsComing
12. 12Capstone: a complete company modelComing

Requirements

• FIN-201 Corporate Finance
• ACCT-101 Introductory Financial Accounting

Recommended background. You can start any course at any time.

Description

Building clean, auditable spreadsheet models for budgets, forecasts, loans, valuation and scenario analysis.

Part of the Business stream, typically taken in year 2.