Answered step by step
Verified Expert Solution
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 $ is amortized with payments at the end of each month and an interest rate of 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 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 years instead of years.
d Find the amount of the new payment. $
e Find the dollar amount by which the monthly payment increased as compared to the year amortization. $
per month
f Find the total amount of interest paid over the life of the year loan. $
g Compare the answer from part c and f above to find the total amount of interest saved by amortizing over years instead of years.
$
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started