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:
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...
-
The radius of a spherical watermelon is growing at a constant rate of 2 centimeters per week. The thickness of the rind is always one-tenth of the radius. How fast is the volume of the rind growing...
-
Refer to the partially completed table of the six basic solutions to the e-system In basic solution (D), which variables are nonbasic? (A) (B) (C) (D) (E) (F) 2x1 + 5x2 + S = 32 x + 2x + $ = 14 X1 X2...
-
What type of coverage does a personal property floater provide?
-
The following transactions of Emergency Pharmacies occurred during 2014 and 2015: 2014 Mar 1 Borrowed $360,000 from Lessburg Bank. The six-year, 10% note requires payments due annually, on March 1....
-
Required information [The following information applies to the questions displayed below.] PowerTap Utilities is planning to issue bonds with a face value of $2,500,000 and a coupon rate of 10 perc...
-
Differentiate between the types of immigration discussed in the second website. Based on what you read, is there a certain status that allows a person more rights when seeking a home in the United...
-
Discuss the 2008, 2016, and 2020 Electoral College results acknowledging Agnew's key argument, King's critique, and Agnew's response as well as Johnston's observations. How would you apply space,...
-
It is now January. The current annual interest rate is 3%. The June futures price for gold is $1,246.30, while the December futures price is $1,251. Assume the June contract expires in exactly 6...
-
A 20-kg box is at rest on a rough inclined surface of 15 degrees, where the coefficient of static and kinetic friction is 0.35 and 0.25 respectively. (a) Will the box remain stationary? (b) A force...
-
Instructions Before making any last decisions about the new campaign, Costa's Customs would like you to look over their last attempt at digital marketing. It was a complete failure, and Costa's...
-
Your lender now offers you a 30-year fixed-rate home mortgage with 3.6% interest per year. If you can afford a monthly payment of $3,000, what is maximum price of a house that you can afford?
-
Describe how OWL, RDF, and RDFS can be effectively used to develop the EHR with examples for each of them. You may consider a particular scenario for use and then describe how each of these could be...
-
Starr Co. had sales revenue of $540,000 in 2014. Other items recorded during the year were: Cost of goods sold ..................................................... $330,000 Salaries and wages...
-
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....
-
Which fraud scheme did Sunbeam not do? a. Cookie-jar reserves b. Accelerated revenues from leasing equipment c. Channel stuffing d. Guaranteed sales e. Improper bill and hold
-
Which would be a corrective control? a. Process redesign b. Drug testing c. Using document control numbers d. Job rotation e. Event notifications
-
Which is not one of the three B's of fraud? a. Bucks b. Babes c. Booze d. Bets e. \(B\) and \(C\) above
Study smarter with the SolutionInn App