Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A loan of $ 4 9 0 , 0 0 0 is amortized with payments at the end of each month and an interest rate

A loan of $490,000 is amortized with payments at the end of each month and an interest rate of 9.9%, compounded monthly.
Use Excel to create an amortization table showing each payment and the corresponding beginning blance, interest owed, payment amount, principal, and ending balance. Answer the following, rounding to the nearest penny.
Suppose the mortgage is paid off over 30 years.
a) Find the amount of each payment. $
b) Find the total of all payments made over the life of the loan. $
c) Find the total amount of interest paid over the life of the loan. $
Suppose that the mortgage is amortized over 15 years instead of 30 years.
d) Find the amount of the new payment. $
e) Find the dollar amount by which the monthly payment increased as compared to the 30-year amortization. $
per month
f) Find the total amount of interest paid over the life of the 15-year loan. $
g) Compare the answer from part c) and f) above to find the total amount of interest saved by amortizing over 15 years instead of 30 years.
$

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

Financial Accounting Version 3.0

Authors: Leah Kratz, Joe Ben Hoyle, C. J. Skender

3rd Edition

1453392904, 9781453392904

More Books

Students also viewed these Accounting questions

Question

9.7 List and briefly discuss four management development methods.

Answered: 1 week ago