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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!