Pro lesson · 6 exercises · first one free
Money over time: FV, PMT and NPV
About this lesson
Grow a deposit, work out a loan payment and compare an investment with its cost.
Statistics, charts and tables · 6 short exercises in a live spreadsheet: you type each formula yourself and answer questions that make you predict results or spot bugs. Every answer is checked instantly.
What you'll practise
- Growing a deposit with compound interest
- Calculating a monthly loan payment
- Valuing future cash flows with NPV
- Understanding the sign of a loan payment
- Reading what the IRR means
- Finding the input that gives a target
Functions you'll use
- FV
- PMT
- NPV
- ROUND
Try the first exercise free
Type the formula in a real spreadsheet and get instant feedback. Exercise 1 of 6, no account needed.
Pro lesson
Unlock the whole lesson
Pro unlocks every lesson, the case studies and unlimited weak-spot review. The fundamentals track stays free.