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
-
This assignment requires you to complete the 2022 tax reporting for a fictional woman named Anna Smith. Question 1 T1 - step 4 - line 66 This is Anna's taxable income Answer: Question 2 T1 - step...
-
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...
-
A Ferris wheel of radius 30 feet is rotating counterclock-wise with an angular velocity of 2 radians per second. How fast is a seat on the rim rising (in the vertical direction) when it is 15 feet...
-
The concentration of a drug in a patients bloodstream h hours after it was injected is given by Find and interpret A(h) = 0.17h h + 2
-
FRAUD PREVENTION AND DETERRENCE IN ACTION Assume the following facts: thirty-day collection period. The invoice is used to post-sales to the accounting system. Checks are received in the mailroom and...
-
Automobiles arrive at the drive-through window at a post office at the rate of 4 every 10 minutes. The average service time is 2 minutes. The Poisson distribution is appropriate for the arrival rate...
-
8) You own San Antonio's top rated food truck that sells the best carne asada tacos (good A) but the burger food truck (good B) next door just started a promotional sale: The burger truck...
-
According to the World Health Organization, in collaboration with UNICEF and IFRC (2020), COVID-19is definedas a diseasecaused by a new strain of corona-virus; as CO stands for corona, VI for virus,...
-
Your firm is contemplating the purchase of a new $500,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $44,000 at...
-
How can a postal code determine your life expectancy? now based on the question fill out the outline. Question Option: This is your chosen question, How can a postal code determine your typed in...
-
Franklin needs 1.25 meters of ribbon to wrap each gift. He has a spool of ribbon that contains 25 feet of ribbon. One meter is equivalent to approximately 3 feet. How many gifts of the same dimension...
-
Discuss the benefits. 1. Mobile banking depositing money /Paying bills. 2. Checking bank accounts with mobile banking/ getting alerts of fraud. 3. How mobile banking help reduces fraudulent activity?
-
Oman Holdings (OHI) is a distributor of a variety of products. The company's current earnings per share is 3.690 Rials and current book value per share is 15.760 Rials. EPS is forecasted to be 5.110...
-
Martin Stanaway is the partner in charge of the audit for a new client, Western Wonderland (WW). The client engaged Martin's audit firm in November 2017, in preparation for the 2018 audit. From 30...
-
How will relating product contribution margin s to the amount of the constrained resource they consume help a company maximize its profits?
-
A child receives \($100\),000 as a gift, which is deposited in a bank account earning 6 percent compounded semiannually. If \($5\),000 is withdrawn at the end of each half year, how long will the...
-
The plan was to leave $5,000 on deposit in a savings account for 15 years at 6.5 percent interest compounded annually. It became necessary to withdraw $1,500 at the end of the fifth year. How much...
-
A deposit of $3,000 is made in a savings account that pays 7.5 percent interest compounded annually. How much money will be available to the depositor at the end of 16 years? a. $8,877 b. $10,258 c....
For The Love Of Lemurs My Life In The Wilds Of Madagascar 1st Edition - ISBN: 1590565479 - Free Book
Study smarter with the SolutionInn App