Financial Functions & What-If Analysis
What you will be able to do
- Use PV, FV, PMT, NPV and IRR
- Calculate depreciation
- Run Goal Seek, Data Tables and Scenario Manager
- Appraise an investment
17 lessons and projects. Short, practical steps in a spreadsheet, with real Excel for the features a browser cannot run.
Outline
Module 1: Time value of money
- FV and PV
- PMT
- IPMT and PPMT
- RATE and NPER
- NPV and the timing trap
- IRR
- XNPV and XIRR
- MIRR
Module 2: Depreciation
- SLN and DB
- DDB and SYD
- Goal SeekReal Excel
- One-variable Data TableReal Excel
- Two-variable Data TableReal Excel
- Scenario ManagerReal Excel
- Solver basicsReal Excel
- Formula-based scenario switch
Project: investment appraisal
Completing it earns a certificate of completion. It is not an accreditation or a professional qualification.
Start free