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).

Zero2Hero — Zéro2Héros