Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

7. Part of an amortization table is shown below. Determine the missing values in the table labeled A, B, C, D Payment Monthly Interest

image

7. Part of an amortization table is shown below. Determine the missing values in the table labeled A, B, C, D Payment Monthly Interest Principal Outstanding A) number payment paid paid balance 0 $175 000 B) 1 2 3 4 $1164.28 $1020.83 $1164.28 $1020.00 $1164.28 $1164.28 $1018.31 $143.45 $174 856.55 $174 712.27 B $145.13 $174 567.14 $145.97 D 5 A $1017.46 $146.82 $174 274.35 D) 8. The amortization table below shows the first 3 payments and last 3 payments on a mortgage. Use the table to answer the following questions. Monthly payment Interest paid Principal paid Outstanding balance Payment number 0 $200 000.00 1 $954.83 $666.67 $208.00 $199 711.84 2 $954.83 $665.71 $209.15 $199 422.71 3 $954.83 $664.74 $210.30 $199 132.62 : : : 358 $954.83 $9.49 $945.35 $1900.16 359 $954.83 $6.33 $948.50 $951.66 360 $954.83 $3.17 $951.66 $0.00 $343 738.80 $143 738.80 $200 000.00 TOTAL a) What is the initial amount of the mortgage and what is the regular monthly payment each month? Initial Mortgage Amount:. b) What is the outstanding balance after payment number 2? c) What is the amortization period? Show your work. Monthly Payment: d) What is the total interest paid over the life of the mortgage? e) What percent of the total amount paid is interest? Show your work. f) How does the interest paid in the first 3 months compare with the principal paid in the first 3 months? Explain why.

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_2

Step: 3

blur-text-image_3

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

Elementary Statistics

Authors: Neil A. Weiss

8th Edition

321691237, 978-0321691231

More Books

Students also viewed these Mathematics questions