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 rollng, 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? I need the solution in excel sheet

College Algebra
1st Edition
ISBN:9781938168383
Author:Jay Abramson
Publisher:Jay Abramson
Chapter9: Sequences, Probability And Counting Theory
Section9.4: Series And Their Notations
Problem 56SE: To get the best loan rates available, the Riches want to save enough money to place 20% down on a...
icon
Related questions
Question

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 rollng, 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? I need the solution in excel sheet

Expert Solution
steps

Step by step

Solved in 5 steps with 11 images

Blurred answer
Recommended textbooks for you
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax