Complete the following table: (Use Table 15.1.) Note: Round your intermediate calculations and final answer to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Complete the following table: (Use Table 15.1.) Note: Round your intermediate calculations and final answer to the nearest cent. Selling price Down payment Amount mortgage $ 124,000 $ 7,000 Rate 7.50 % Years 30 Monthly payment First Payment Broken Down Into Interest Principal Balance at end of month TABLE 15.1 Amortization table (mortgage principal and interest per $1,000) Rate 2.000 2.125 2.250 2.375 2.500 2.625 2.750 2.875 3.000 3.125 3.250 0.27083 3.375 0.28125 3.500 0.29167 3.625 0.30208 3.750 0.31250 3.875 0.32292 4.000 0.33333 4.125 4.250 4.375 4.500 4.625 4.750 4.875 5.000 5.125 5.250 5.375 5.500 5.625 5.750 5.875 6.000 6.125 6.250 6.375 6.500 6.625 6.750 6.875 7.000 7.125 7.250 7.375 7.500 Interest Only 0.16667 0.17708 0.18750 0.19792 0.20833 0.21875 0.22917 0.23958 0.25000 0.26042 7.625 7.750 7.875 8.000 0.55208 0.56250 0.57292 0.58333 0.59375 0.60417 0.61458 0.06250 10 Year 0.63542 0.64583 0.65625 0.66667 9.20135 9.25743 9.31374 9.37026 9.42699 9.48394 9.54110 6.72689 6.78622 9.59848 6.84586 9.65607 9.71388 9.77190 9.83014 9.88859 9.94725 10.00612 10.06521 15 Year 6.43509 6.49281 6.55085 6.60921 6.66789 11.41850 11.48241 11.54653 11.61085 11.67537 11.74010 6.90582 6.96609 7.02669 5.67196 4.87316 7.08760 5.73557 4.93945 7.14883 5.79960 5.00624 7.21037 5.86404 5.07352 7.27222 5.92888 5.14131 7.33440 5.99414 5.20959 10.12451 7.39688 6.05980 5.27837 0.34375 10.18403 7.45968 6.12587 5.34763 0.35417 10.24375 7.52278 6.19234 5.41738 0.36458 10.30369 6.25922 5.48761 0.37500 10.36384 6.32649 5.55832 0.38542 6.39417 5.62951 0.39583 6.46224 5.70117 0.40625 6.53070 5.77330 0.41667 6.59956 5.84590 0.42708 6.66881 5.91896 0.43750 6.73844 5.99248 0.44792 6.80847 0.45833 6.87887 0.46875 6.94966 0.47917 7.02084 0.48958 0.50000 0.51042 0.52083 0.53125 0.54167 10.42420 10.48477 10.54556 10.60655 7.90794 10.66776 10.72917 10.79079 10.85263 10.91467 10.97692 11.03938 11.10205 11.16493 11.22801 11.29130 11.35480 11.80504 11.87017 11.93552 12.00106 12.06681 12.13276 7.58620 7.64993 7.71397 7.77832 7.84297 7.97320 8.03878 8.10465 8.17083 8.23732 8.30410 8.37118 8.43857 8.50625 8.57423 8.64250 8.71107 8.77994 8.84909 8.91854 8.98828 9.05831 9.12863 9.19923 9.27101 20 Year 5.05883 9.34130 9.41276 9.48450 9.55652 5.11825 5.17808 5.23834 5.29903 5.36014 5.42166 5.48361 5.54598 5.60876 7.09238 7.16431 7.23661 7.30928 7.38232 7.45573 7.52950 7.60364 7.67814 7.75299 7.82820 7.90376 7.97967 8.05593 25 Year 4.23854 4.29966 4.36131 4.42348 4.48617 4.54938 4.61311 8.13254 8,20949 8.28677 8.36440 4.67735 4.74211 4.80738 30 Year 3.69619 3.75902 3.82246 3.88653 3.95121 4.01651 4.08241 4.14892 4.21604 4.28375 4.35206 4.42096 4.49045 4.56051 4.63116 4.70237 4.77415 4.84650 4.91940 4.99285 5.06685 5.14140 5.21647 5.29208 5.36822 5.44487 5.52204 5.59971 5.67789 5.75656 5.83573 6.06645 6.14087 6.21575 6.29106 6.36682 6.44301 6.51964 6.59669 6.67417 6.75207 6.83039 6.90912 6.98825 7,06779 7.14773 7.22807 7.30880 7.38991 7.47141 7.07794 7.55329 7.16412 7.63554 7.25069 7.71816 7.33765 5.91538 5.99551 6.07611 6.15717 6.23870 6.32068 6.40311 6.48598 6.56929 6.65302 6.73719 6.82176 6.90675 6.99215 40 Year 3.02826 3.09444 3.16142 3.22921 3.29778 3.36714 3.43728 3.50818 3.57984 3.65226 3.72541 3.79930 3.87391 3.94923 4.02526 4.10198 4.17938 4.25746 4.33620 4.41559 4.49563 4.57629 4.65758 4.73947 4.82197 4.90505 4.98870 5.07293 5.15770 5.24302 5.32888 5.41525 5.50214 5.58952 5.67740 5.76575 5.85457 5.94385 6.03357 6.12373 6.21431 6.30531 6.39672 6.48852 6.58071 6.67327 6.76620 6.85948 6.95312 Complete the following table: (Use Table 15.1.) Note: Round your intermediate calculations and final answer to the nearest cent. Selling price Down payment Amount mortgage $ 124,000 $ 7,000 Rate 7.50 % Years 30 Monthly payment First Payment Broken Down Into Interest Principal Balance at end of month TABLE 15.1 Amortization table (mortgage principal and interest per $1,000) Rate 2.000 2.125 2.250 2.375 2.500 2.625 2.750 2.875 3.000 3.125 3.250 0.27083 3.375 0.28125 3.500 0.29167 3.625 0.30208 3.750 0.31250 3.875 0.32292 4.000 0.33333 4.125 4.250 4.375 4.500 4.625 4.750 4.875 5.000 5.125 5.250 5.375 5.500 5.625 5.750 5.875 6.000 6.125 6.250 6.375 6.500 6.625 6.750 6.875 7.000 7.125 7.250 7.375 7.500 Interest Only 0.16667 0.17708 0.18750 0.19792 0.20833 0.21875 0.22917 0.23958 0.25000 0.26042 7.625 7.750 7.875 8.000 0.55208 0.56250 0.57292 0.58333 0.59375 0.60417 0.61458 0.06250 10 Year 0.63542 0.64583 0.65625 0.66667 9.20135 9.25743 9.31374 9.37026 9.42699 9.48394 9.54110 6.72689 6.78622 9.59848 6.84586 9.65607 9.71388 9.77190 9.83014 9.88859 9.94725 10.00612 10.06521 15 Year 6.43509 6.49281 6.55085 6.60921 6.66789 11.41850 11.48241 11.54653 11.61085 11.67537 11.74010 6.90582 6.96609 7.02669 5.67196 4.87316 7.08760 5.73557 4.93945 7.14883 5.79960 5.00624 7.21037 5.86404 5.07352 7.27222 5.92888 5.14131 7.33440 5.99414 5.20959 10.12451 7.39688 6.05980 5.27837 0.34375 10.18403 7.45968 6.12587 5.34763 0.35417 10.24375 7.52278 6.19234 5.41738 0.36458 10.30369 6.25922 5.48761 0.37500 10.36384 6.32649 5.55832 0.38542 6.39417 5.62951 0.39583 6.46224 5.70117 0.40625 6.53070 5.77330 0.41667 6.59956 5.84590 0.42708 6.66881 5.91896 0.43750 6.73844 5.99248 0.44792 6.80847 0.45833 6.87887 0.46875 6.94966 0.47917 7.02084 0.48958 0.50000 0.51042 0.52083 0.53125 0.54167 10.42420 10.48477 10.54556 10.60655 7.90794 10.66776 10.72917 10.79079 10.85263 10.91467 10.97692 11.03938 11.10205 11.16493 11.22801 11.29130 11.35480 11.80504 11.87017 11.93552 12.00106 12.06681 12.13276 7.58620 7.64993 7.71397 7.77832 7.84297 7.97320 8.03878 8.10465 8.17083 8.23732 8.30410 8.37118 8.43857 8.50625 8.57423 8.64250 8.71107 8.77994 8.84909 8.91854 8.98828 9.05831 9.12863 9.19923 9.27101 20 Year 5.05883 9.34130 9.41276 9.48450 9.55652 5.11825 5.17808 5.23834 5.29903 5.36014 5.42166 5.48361 5.54598 5.60876 7.09238 7.16431 7.23661 7.30928 7.38232 7.45573 7.52950 7.60364 7.67814 7.75299 7.82820 7.90376 7.97967 8.05593 25 Year 4.23854 4.29966 4.36131 4.42348 4.48617 4.54938 4.61311 8.13254 8,20949 8.28677 8.36440 4.67735 4.74211 4.80738 30 Year 3.69619 3.75902 3.82246 3.88653 3.95121 4.01651 4.08241 4.14892 4.21604 4.28375 4.35206 4.42096 4.49045 4.56051 4.63116 4.70237 4.77415 4.84650 4.91940 4.99285 5.06685 5.14140 5.21647 5.29208 5.36822 5.44487 5.52204 5.59971 5.67789 5.75656 5.83573 6.06645 6.14087 6.21575 6.29106 6.36682 6.44301 6.51964 6.59669 6.67417 6.75207 6.83039 6.90912 6.98825 7,06779 7.14773 7.22807 7.30880 7.38991 7.47141 7.07794 7.55329 7.16412 7.63554 7.25069 7.71816 7.33765 5.91538 5.99551 6.07611 6.15717 6.23870 6.32068 6.40311 6.48598 6.56929 6.65302 6.73719 6.82176 6.90675 6.99215 40 Year 3.02826 3.09444 3.16142 3.22921 3.29778 3.36714 3.43728 3.50818 3.57984 3.65226 3.72541 3.79930 3.87391 3.94923 4.02526 4.10198 4.17938 4.25746 4.33620 4.41559 4.49563 4.57629 4.65758 4.73947 4.82197 4.90505 4.98870 5.07293 5.15770 5.24302 5.32888 5.41525 5.50214 5.58952 5.67740 5.76575 5.85457 5.94385 6.03357 6.12373 6.21431 6.30531 6.39672 6.48852 6.58071 6.67327 6.76620 6.85948 6.95312
Expert Answer:
Answer rating: 100% (QA)
To complete the table we will use the provided amortization table Table 151 to calculate the monthly ... View the full answer
Related Book For
Horngrens Accounting
ISBN: 978-0134674681
12th edition
Authors: Tracie L. Miller nobles, Brenda L. Mattison, Ella Mae Matsumura
Posted Date:
Students also viewed these finance questions
-
The Polaris Company uses a job-order costing system. The following transactions occurred in October: a. Raw materials purchased on account, $210,000. b. Raw materials used in production, $189,000...
-
The treasurer of Kelly Bottling Company (a corporation) currently has $200,000 invested in preferred stock yielding 10 percent. He appreciates the tax advantages of preferred stock and is considering...
-
1. Prepare the journal entry for A&Gs purchase of the conveyor on January 1, 2011. (Round "PV Factor" to 5 decimal places Round your intermediate calculations and final answers to the nearest dollar...
-
The Best Buy Co. Inc. 10-K report has the following footnote related to leasing activities. The future minimum lease payments under our capital and operating leases by fiscal year (not includ- ing...
-
Sylvester files as a single taxpayer during 2015 and claims one personal exemption. He itemizes deductions for regular tax purposes. He paid charitable contributions of $7,000, real estate taxes of...
-
What is the purpose of economic theory in general? Of international economic theories and policies in particular?
-
What are the advantages of using debt finance?
-
Olathe Company exchanges old delivery equipment for new delivery equipment. The book value of the old delivery equipment is $31,000 (cost $61,000 less accumulated depreciation $30,000). Its fair...
-
yerHomework.aspx?homeworkId=641541742&questionid=5&flu Chikungua - Wikip.... Coagulacin intrava... E MYELT k Question 2 Part 1 in the accompanying bar graph are from a random sample of 854 adu ce in...
-
Table 1: Calculation of 3 month forward rates using the simple interest rate parity principle (4 marks) Exchange rate Forward rate 3 months Workings (show calculations in this column) from now...
-
Your birthday is next week and instead of other presents, your parents promised to give you $1,800in cash. Since you have a part-time job and, thus, don't need the cash immediately, you decide to...
-
The following information is provided for the first month of operations for Legal Services Inc.: Prepare a T-accounts to reflect the following business transaction: The Company provided legal...
-
A copper rod is 34.0 m on a winter day when the temperature is -5.0C (Linear expansion coefficient of copper 17 x 10-6/C). How long is the rod on a summer day when the temperature is 38.0C? Express...
-
Pricing Manager, District 6SW From: Vice President, Marketing Re: Strategic Pricing Decision Our (Time Warner's) only competitor is District 6SW currently provides bundled services at $84.95. We are...
-
What's driving the big law firm mergers in Philly and across the U.S.? It was a record year for law firm mergers in 2019, with the announcements by two venerable Philadelphia institutions ranking as...
-
Consider the scenario shown below, with 10 different servers (four shown) connected to 10 different clients. The pairs share a common middle hop with a transmission capacity of R = 200 Mbps. Each...
-
Question 1 Social norms Unwritten rules of behavior that are considered acceptable in a group or society A fixed, over-generalized belief about a particular group or class or people The tendency to...
-
Explain the term "Equivalent Units". Why are they calculated in process costing? [4 Marks] [minimum 350 words]
-
The stockholders' equity of Lakeside Occupational Therapy, Inc. on December 31, 2017, follows: On April 30, 2018, the market price of Lakeside's common stock was $16 per share and the company...
-
What is the purpose of the raw materials subsidiary ledger? How is it related to the general ledger?
-
Estella Osage publishes an online travel magazine. In need of cash, the business applies for a loan with National Bank. The bank requires borrowers to submit financial statements. With little...
-
Assume that Mexico has a 1-year interest rate that is higher than the U.S. 1-year interest rate. Assume that you believe in the international Fisher effect (IFE) and interest rate parity. Assume zero...
-
Assume that locational arbitrage ensures that spot exchange rates are properly aligned. Also assume that you believe in purchasing power parity. The spot rate of the British pound is $1.80. The spot...
-
The U.S. 3-month interest rate (unannualized) is 1 percent. The Canadian 3-month interest rate (unannualized) is 4 percent. Interest rate parity exists. The expected inflation over this period is 5...
Study smarter with the SolutionInn App