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 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
Get step-by-step solutions from verified subject matter experts
