Excel: loans and savings with PMT and FV
Sign up free to unlock this topic
Kindergarten is free, and guests can try one sample topic in every other grade. A free parent or teacher account opens every topic from Kindergarten to Grade 12, college and university, and saves progress. No credit card.
Try the free sample: The ideal gas law · Have a class or homeroom code? Join here
Key idea: Excel: loans and savings with PMT and FV
PMT(rate per period, number of periods, loan) gives a loan payment; FV(rate, periods, deposit) gives what regular savings grow to. For monthly amounts, divide the yearly rate by 12 and multiply the years by 12.
Key words
- Sign
- Money paid out is negative: use −A2 for a positive answer.
- Total interest
- Payment × number of payments − loan.
🔎 What to look for: Keep the rate and the number of periods in the same unit (both monthly).
