Total interest on a loan

Premium

In B5, work out how much interest the loan costs in total: all the monthly payments added up, minus the amount borrowed. That is PMT(B3/12,B4*12,-B2)*B4*12-B2.

B5
ABCDEF
1Loan Value
2Amount borrowed 50000
3Interest rate per year 0.07
4Years 3
5Total interest
6
7
8

Premium lesson

Unlock Loans: PMT and NPER and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:Investments: FV, NPV and IRRBudget

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?