Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Mrs . Barb E . wants to purchase a new house for $ 4 7 0 , 0 0 0 . She has just enough

Mrs. Barb E. wants to purchase a new house for $470,000. She has just enough savings for the 20% down payment, which means that she will need a loan for the remaining amount. The mortgage will be a 30-year loan with monthly payments and a 3.375% APR. Mrs. Barb E. would like to pay back the loan as soon as possible. She plans on paying $400 each month, in addition to the monthly payment, to reduce the principal.
a) Find the monthly payment for the mortgage. Please enter the payment in cell C22. The number should be formatted using Currency with two decimals.
b) Build an amortization table to calculate how many payments does she save with the additional $400 each month.
Enter the amortization table in cells B28:H389.
Utilize formulas, and not Excel functions, to find the Interest and Principal payments every period.
The table must only include relative and absolute references.
The formulas entered in period 1 should be able to be copied down to the end of the table.
Enter the number of periods saved in cell D26.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Inside Private Equity

Authors: James M. Kocis, James C. Bachman IV, Austin M. Long III, Craig J. Nickels

1st Edition

0470421894, 978-0470421895

More Books

Students also viewed these Finance questions

Question

1. Define and explain culture and its impact on your communication

Answered: 1 week ago