· advanced
Modelling and Decisions in Excel
The difference between a spreadsheet and a model: assumptions you can change in one place, arithmetic that shows its reasoning, and a number at the end that supports a decision rather than just existing.
Written in house, from the work rather than from a syllabus. Every example is one we would use ourselves, and every exercise is checked against the same engine that grades your answer.
What you’ll learn
- Separate assumptions from calculations so a model can be questioned
- Project a value forward by compounding, and work a growth rate back out
- Work out a repayment, a rate or a term with PMT, RATE and NPER
- Decide whether a project is worth doing with NPV and IRR, and say what each assumes
- Build a sensitivity table showing how the answer moves when an assumption does
- Audit a workbook you did not write, and find what it is hiding
Before you start
- · Excel Foundations, in particular absolute and mixed references
- · Summarising and Reporting in Excel, or comfort building a grid from one formula