Mortgage calculation

frctl

Full Member
Joined
Jun 29, 2019
Messages
252
A family has a $80,000, 20-year mortgage at 8% compounded monthly.
(A)Find the monthly payment

A = 80000, r = 0.08, 12 x 20 = 240
Screen Shot 2020-04-28 at 11.20.43 AM.png
PMT = I get the wrong answer
(should be 669.15)
 
Your formula seems correct. Maybe you're just typing it into your calculator wrong? The following works in a spreadsheet:-

=80000 * (0.08/12) / (1 - (1 + 0.08/12)^-240)
≈669.15
 
Top