Monthly loan payment is calculated using PMT function in Excel :
rate = 5.8% / 12 (converting annual rate into monthly rate)
nper = 72 (72 month loan)
pv = 76500 (loan amount)
PMT is calculated to be $1,260.62
Monthly loan payment is $1,260.62
Effective annual rate (EAR) = (1 + (APR/n))n - 1
where n = number of compounding periods per year
Effective annual rate (EAR) = (1 + (5.8%/12))12 - 1
Effective annual rate (EAR) = 5.9567%
Get Answers For Free
Most questions answered within 1 hours.