Question: please show work on excel Problem 4 12 Points You are financing a new home. The loan is for $281,000 and you are getting rate

please show work on excel
Problem 4 12 Points You are financing a new home. The loan is for $281,000 and you are getting rate of 3.9% per year compounded monthly. You have decided on a 15 year mortgage and will make monthly payments (end of the month). To get the ball roling, you are working extra hours and expect to pay an extra $550 per month to knock down the principle. You make these EXTRA payments for 5 years starting on month 1. The last EXTRA payment is on month 60. Build the amortization table. What month will you make your last payment? How much will the last payment be
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
