The following is an amortization schedule for a $250,000 loan with Interest rate xxx, monthly payment...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The following is an amortization schedule for a $250,000 loan with Interest rate xxx, monthly payment xxx, and service fee rate xxx. Please use the data table below to answer the questions below: A Payment 1 2 3 4 5 6 7 8 9 10 11 12 13 14 B P&I Constant C D Service Interest fee Rate Rate E Net Interest Rate 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.280% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250 % 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% F G Gross Principal Interest 300.38 1,041.67 301.63 1,040.42 302.89 1,039.16 304.15 1,037.90 305.42 1,036.63 306.69 1,035.36 307.97 1,034.08 309.25 1,032.80 310.54 1,031.51 311.84 1,030.21 313.14 1,028.91 314.44 1,027.61 315.75 1,026.30 317.07 1,024.98 H Service Fee c. Write at least one equation for how to calculate Net Interest. I Net Interest 52.08 989.59 52.02 988.40 51.96 987.20 51.90 986.00 51.83 984.80 51.77 983.59 51.71 982.37 51.64 981.16 51.58 979.93 51.51 978.70 51.44 977.47 51.38 976.23 51.32 974.98 973.73 J Unpaid Principal Balance 250,000.00 249,699.62 249,397.99 249,095.10 248,790.95 248,485.53 248,178.84 247,870.87 247,561.62 247,251.08 246,939.24 246,626.10 246,311.66 245,995.91 245,678.84 a. Without doing any major calculations and using the data in the table - please infer by using the table what the missing Service Fee value could be in the highlighted cell H14. b. There is one typo in this table. Please identify it and tell us what is incorrect about it. (Note: It is not a calculation error.) The following is an amortization schedule for a $250,000 loan with Interest rate xxx, monthly payment xxx, and service fee rate xxx. Please use the data table below to answer the questions below: A Payment 1 2 3 4 5 6 7 8 9 10 11 12 13 14 B P&I Constant C D Service Interest fee Rate Rate E Net Interest Rate 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.280% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250 % 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% F G Gross Principal Interest 300.38 1,041.67 301.63 1,040.42 302.89 1,039.16 304.15 1,037.90 305.42 1,036.63 306.69 1,035.36 307.97 1,034.08 309.25 1,032.80 310.54 1,031.51 311.84 1,030.21 313.14 1,028.91 314.44 1,027.61 315.75 1,026.30 317.07 1,024.98 H Service Fee c. Write at least one equation for how to calculate Net Interest. I Net Interest 52.08 989.59 52.02 988.40 51.96 987.20 51.90 986.00 51.83 984.80 51.77 983.59 51.71 982.37 51.64 981.16 51.58 979.93 51.51 978.70 51.44 977.47 51.38 976.23 51.32 974.98 973.73 J Unpaid Principal Balance 250,000.00 249,699.62 249,397.99 249,095.10 248,790.95 248,485.53 248,178.84 247,870.87 247,561.62 247,251.08 246,939.24 246,626.10 246,311.66 245,995.91 245,678.84 a. Without doing any major calculations and using the data in the table - please infer by using the table what the missing Service Fee value could be in the highlighted cell H14. b. There is one typo in this table. Please identify it and tell us what is incorrect about it. (Note: It is not a calculation error.)
Expert Answer:
Related Book For
Understanding Financial Accounting
ISBN: 978-1118849385
1st Canadian Edition
Authors: Christopher Burnley, Robert Hoskin, Maureen Fizzell, Donald
Posted Date:
Students also viewed these finance questions
-
3 4 5 6 7 8 9 10 11 12 13 A 14 Cost of the Asset 15 Life of the Asset in Years 16 Book Value of the Asset after 5 years 17 Depreciable Basis 18 Yearly depreciation 19 After tax Salvage Value in year...
-
Use the table below to answer the questions that follow: a. If this table reflects the supply of and demands for tickets to a particular World Cup soccer game, what is the stadium capacity? b. If the...
-
A partial amortization schedule for a 10-year note payable issued on January 1, 2016, is shown below. a. Using the financial statement model below, record the appropriate amounts for the following...
-
5.8 LAB: Structuring data using scale() and MinMaxScaler() The hmeq_small dataset contains information on 5960 home equity loans, including 7 features on the characteristics of the loan. Load the...
-
Sohail Corporation produced 80,000 tires and sold them for $100 each during 2011. The company determined that fixed manufacturing cost per unit was $25 per tire. The company reported gross profit of...
-
Identify three types of surety bonds and give an example where each can be used.
-
A subsidiary of a U.S. company began operations on January 1, 2017, in a country whose currency is identified as hyperinflationary. The subsidiarys local currency (LC) is its functional currency. The...
-
Dave Fletcher was able to deter-mine the activity times for constructing his laser scanning machine. Fletcher would like to determine ES, EF, LS, LF, and slack for each activity. The total project...
-
Problem 11-13 (Static) [LO 11-3, 11-4] Western Corporation, a calendar year, accrual basis corporation, reported $500,000 of net income after tax on its financial statements prepared in accordance...
-
From elementary physics, we know that when an object is subjected to a constant acceleration a, the relationship between distance d and time t is given by d = at2. Suppose that, during a seek, the...
-
(IN PYTHON)Use a doubly nested loop to show all of the coordinates between0, 0 and 1000, 1000 that do not have a multiple of 7 in them. Use asimilar nested loop to show all of the coordinates betwe 1...
-
A power plant burns 1 tonne of coal each hour and produces half a megawatt of power. Calculate the overall thermal efficiency if each kg of coal produces 6 MJ of energy. [ 1 tonne = 1 0 0 0 kg ]
-
Pretax income Selected financial information for the year just ended is shown below. $5,000,000 Interest received on municipal bonds 600,000 Gain on the sale of land reported this year but not...
-
On January 1, 2024, Red Flash Photography had the following balances: Cash, $23,000; Supplies, $9,100; Land, $71,000; Deferred Revenue, $6,100; Common Stock $61,000; and Retained Earnings, $36,000....
-
Madam Rapuri aged 56 is a resident, married to a househusband being a home maker and has been recently employed as a branch manager in Bandar Puteri, Petaling Jaya with effect from 1 July 2019....
-
5x219x-4 5x214x3 Simplify: 5x222x+8 x24x3
-
What are your current leadership style and traits? How did you arrive at the conclusions above - e.g. own reflections, feedback from peers, colleagues, etc. What advantages and disadvantages do your...
-
Pappa's Appliances uses the periodic inventory system. Details regarding the inventory of appliances at January 1, purchases invoices during the year, and the inventory count at December 31 are...
-
Would we normally expect a company to have an overall inflow or an overall outflow of cash from its operating activities? Explain why.
-
The following information relates to Bedford Companys accounts receivable: Accounts receivable balance on December 31, 2015........ $ 900,000 Allowance for doubtful accounts balance on December 31,...
-
During a discussion regarding the recent sale of a piece of equipment, your company president, Nanda Saloojee, stated: I dont understand what it means to have a gain from the sale of equipment. Why...
-
What internal control framework is used most often in the United States? a. Auditing Standard No. 2 b. SAS No. 99 c. COBIT d. \(\operatorname{COSO}\) e. Some other framework
-
Which would not be one of the six legs on the six-legged table of financial statements? a. The IRS b. Management c. External auditors d. PCAOB e. Board of Directors
-
Which statement is false? a. Waste Management made top drawer entries. b. Richard Scrushy of Tyco was never convicted. c. Adelphia used special purpose entities to commit their fraud. d....
Study smarter with the SolutionInn App