7. Part of an amortization table is shown below. Determine the missing values in the table...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/03/65fb764212f3e_62565fb7641dd392.jpg)
Transcribed Image Text:
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. 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.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these mathematics questions
-
According to a study, time between taking a pain reliever and getting relief is a random variable that is normally distributed with a mean of 34 minutes and a standard deviation of 5.5 minutes. Let X...
-
Question: Old MathJax webview Old MathJax webview i need ans of these question but the source is alot Old MathJax webviewOld MathJax webview i need ans of these question but the source is alot these...
-
Identify two specific examples of Jim Crow Legislation in the South during the early Twentieth Century.
-
Accurate Job Costing must be done on three levels. Which of the following is not one of these levels? Tracking and controlling costs during jobs Tracking gross profit each month Filing records on...
-
Find the equation of the tangent line to y = cos x at x = 1.
-
What are three ways that a party can control its exposure to liability for breach of contract?
-
What would happen to the standard of living in the United States if people lost faith in the safety of our financial institutions? Why? AppendixLO1
-
Discuss the risks depicted by the fixed asset system flowchart for Problem 10. Describe the internal control improvements to the system that are needed to reduce theserisks. Vendor User Department...
-
Carla Corporation had net income of $125,000 for the fiscal year ending December 31, 2021. The company pays 15% income tax. For fiscal 2021, the weighted average number of common shares was 25,000....
-
Julio buys a koi fishpond (and fish to put in it) for his wife on their anniversary. He pays $8000 for the pond and fish with $2000 down. The dealer charges add-on interest of 3.5% per year, and...
-
Cmo se determinan los precios de los factores de produccin a travs de la demanda y oferta
-
Cauchy's sequence theorem
-
QUESTION: 1 Discuss Local Government and Administration of Tanzania
-
Discuss how Central Governments Exercise Control over Local Governments by Citing Examples
-
Find derivative of sin x,cos a,tan x,secx,csca, cot a
-
Find anti derivative of cos x,sin x,sec r,sec r tan r,csc xcotx,csc r
-
Jerome is single and age 28. Assume tax laws in 2021 are as described in the textbook, as supplemented by postings on Carmen and information in lectures. If no information is given about something,...
-
How will relating product contribution margin s to the amount of the constrained resource they consume help a company maximize its profits?
-
Study Time and Score. Refer to Exercise 14.55; 99%. Procedure 14.2 Regression t-Interval Procedure Purpose To find a confidence interval for the slope, 1, of the population regression line...
-
Exercise 4.141. a. Construct a scatterplot for the data. b. Decide whether using the rank correlation coefficient is reasonable. c. Decide whether using the linear correlation coefficient is...
-
According to the National Health and Nutrition Examination Survey, published by the National Center for Health Statistics, the serum (noncellular portion of blood) total cholesterol level of U.S....
-
Account for trading securities. (p. C-5) AppendixLO1
-
Kate Beckwith expects to invest $10,000 annually that will earn 8%. How many annual investments must Beckwith make to accumulate $303,243 on the date of the last investment? (Use Table B.4.)...
-
Account for available-for-sale securities. (p. C-6) AppendixLO1
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App