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...
-
An EM wave propagating in a certain medium is described by E = 25 sin (2 10 6 t 6x) a z , V/m (a) Determine the direction of wave propagation. (b) Compute the period T, the wavelength , and the...
-
In each game following, what happens if Jill goes first? 1. 2. 3. 4. 5. 6. 7. 8. Jack's Strategy Left Jack gets 1 Jill gets 1 Right Jack gets4 Jill gets 2 Up Jill's Strategy Jack gets 2 Jack gets 3...
-
To what extent and for what reasons do you think disclosure levels in stock markets around the world are likely to change during the next ten years? In the context of increasing competition for...
-
What opportunities might current IMF lending policies to developing nations create for international businesses? What threats might they create?
-
A BIU Ap D Cheaters, scope of inference: Exercise 1.5 introduces a study where researchers studying the relationship between honesty, age, and self-control conducted an experiment on 160 children...
-
A. The Sunsoria Company employs a job-order pricing method and uses a predetermined overhead rate to apply manufacturing overhead to Work in Process inventory. In the current month, the business had...
-
help lila, she believes a performance report based on a Flexible Budget would be more useful. Create a flexible budget below using the information given and identify the amount of the variances as...
-
Provide correct journal entries for these The following information relates to the debt investments of Concord Inc. during a recent year: 1 . On February 1 , the company purchased Gibbons Corp. 1 0 %...
-
Many manufacturers are now increasingly combining both offline and online channels to bring their products to customers. In your opinion, what are these companies trying to achieve with such a move?...
-
12. [5] Compute the mean and variance of B dB where T = (0,) is a constant.
-
Dec 1 Dec 3 Dec 6 Dec 9 Dec 12 Dec 15 Dec 18 Dec 21 Dec 24 Dec 26 Dec 27 Dec 28 Dec 30 DECEMBER 2023 TRANSACTIONS FOR BOOK PURPOSES Kelly took $25,000 of personal money and invested the cash into...
-
1. Explain why there occurs variation in return on IT investment in terms of complementary assets.
-
The Foreign Corrupt Practices Act requires that all U.S. corporations under the juris-diction of he Securities and Exchange Commission maintain an adequate system of internal control. C must file...
-
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...
-
The Welding Department of Nagano Manufacturing Company has the following production and manufacturing cost data for February 2002. All materials are added at the beginning of the process. Nagano uses...
-
With the popularity of the Apple iPad, the tablet computer market is experiencing high growth rates and record demand levels. Using the Internet as a research tool, complete a five forces analysis...
-
The ledger of Grogan Company has the following work in process account. Production records show that there were 800 units in the beginning inventory, 30% complete, 1,100 units started, and 1,300...
Study smarter with the SolutionInn App