Question: Please show in excel Problem 4 12 Points You are financing a new home. The loan is for $231,000 and you are getting rate of

Please show in excel Problem 4 12 Points You are financing aPlease show in excel

Problem 4 12 Points You are financing a new home. The loan is for $231,000 and you are getting rate of 3.8% per year. You have decided on a 15 year mortgage and will make monthly payments (end of the month). To get the ball rollng, you are working extra hours and expect to pay an extra $510 per month to knock down the principle. You make these payments for 5 years starting on month 1. The last 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!