Using the principles from Sidebar 16-3, prepare an amortization schedule for a 60-month car loan with an
Question:
Using the principles from Sidebar 16-3, prepare an amortization schedule for a 60-month car loan with an annual percentage rate of 11% and an initial principal of $17,000. The monthly interest rate is based on Eq.(16-4). The loan is originated on January 10, 2009, and the payments are due on the tenth of each month. If the payment date falls on a Saturday or Sunday, then the payment is due the following Monday.
Use the same format as was used in Figure16-3.
Transcribed Image Text:
Annual Percentage Rate Principal: 20,000.00 Monthly Payment: $635.99 Interest Rate Beginning Monthly Monthly Principa Ending Interest Reduction Principal 20,000.00 635.99 152.88 483.11 19,516.89 3/19/2004 0.0071507 19,516.89 635.99 139.56 496.43 19,020.46 4/19/2004 0.0076438 9,020.46 635.99 145.39 490.60 18,529.86 635.99 137.07 498.92 18.030.94 6/21/2004 0.0081370 18,030.94 635.99 146.72 489.27 17,541.67 7/19/2004 0.0069041 17,541.67 635.99 121 514.88 17,026.79 8/19/2004 0.0076438 17,026.79 635.99 130.15 505.84 16,520.95 635.99 130.36 505.63 16,015.32 10/19/2004 0.0071507 16,015.32 635.99 114.52 521.47 15,493.85 11/19/2004 0.0076438 15,493.85 635.99 118.43 517.56 14,976.29 12/20/2004 0.0076438 14,976.29 635.99 114.48 521.51 14,454.78 1/19/2005 0.0073973 14,454.78 635.99106.93 529.06 13,925.72 2/21/2005 0.0081370 13,925.72 635.99 113.31 522.68 13,403.04 92.54 543.45 12,859.59 4/19/2005 0.0071507 12,859.59 635.99 91.95 544.04 12,315.55 91.10 544.89 11,770.66 6/20/2005 0.0078904 11,770.66 635.99 92.88 543.11 11,227.55 80.28 555.71 10,671.84 81.57554.42 10,117.42 9/19/2005 0.0076438 10,117.42 635.99 77.34 558.65 9,558.77 70.71 565.28 8,993.49 73.18 562.81 8,430.68 58.21 577.78 7,852.90 60.03 575.96 7,276.94 57.42 578.57 6,698.37 46.25 589.74 6,108.63 45.19 590.80 5,517.83 5/19/2006 0.0073973 5,517.83 635.99 40.82 595.17 4,922.66 37.63 598.36 4.324.30 31.99 604.00 3,720.30 8/21/2006 0.0081370 3,720.30 635.99 30.27 605.72 3,114.58 9/19/2006 0.0071507 3,114.58 635.99 22.27 613.72 2,500.86 10/19/2006 0.0073973 2,500.86 635.99 18.50 617.49 1,883.37 14.86 621.131,262.24 635.28 0.0076438 20,000.00 5/9/2004 0.0073973 18.529.86 9/20/2004 0.0078904 16,520.95 3/21/2005 0.0069041 13,403.04 635.99 5/19/2005 0.0073973 12,315.55 635.99 7/19/2005 0.0071507 11,227.55 635.99 8/19/2005 0.0076438 10,671.84 635.99 10/19/2005 0.0073973 11/21/2005 0.0081370 12/19/2005 0.0069041 1/19/2006 0.0076438 0.0078904 3/20/2006 0.0069041 0.0073973 9,558.77 635.99 8,993.49 635.99 8,430.68 7,852.90 635.99 7,276.94 635.99 6,698.37 635.99 6,108.63 635.99 635.99 0.0076438 0.0073973 4,922.66 4,324.30 635.99 635.99 7/19/2006 11/20/2006 0.0078904 12/19/2006 0.0071507 1/19/2007 1,883.37 635.99 1,262.24 635.99 9.03 626.96 4.86 635.28 22,899.79 2,899.79 20,000.00 0.0076438 635.28
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 61% (18 reviews)
Amortization Annual Percentage Rate 1100 Term 60 Principal 1700000 Monthly Payment 36939 Scheduled Monthly Payment Payment Interest Beginning Monthly Monthly Principal Ending Date Date Rate Principal ...View the full answer
Answered By
PALASH JHANWAR
I am a Chartered Accountant with AIR 45 in CA - IPCC. I am a Merit Holder ( B.Com ). The following is my educational details.
PLEASE ACCESS MY RESUME FROM THE FOLLOWING LINK: https://drive.google.com/file/d/1hYR1uch-ff6MRC_cDB07K6VqY9kQ3SFL/view?usp=sharing
3.80+
3+ Reviews
10+ Question Solved
Related Book For
Construction Accounting And Financial Management
ISBN: 9780132675055
3rd Edition
Authors: Steven J. Peterson
Question Posted:
Students also viewed these Finance questions
-
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...
-
Prepare an amortization schedule for a three-year loan of $69,000. The interest rate is 9 percent per year, and the loan calls for equal annual payments. How much interest is paid in the third year?...
-
Prepare a debt amortization schedule for a bond issued at discount. Assume that the bond matures in 12 years with market interest rate at time of issue-10% annually and 5% semiannually. The stated...
-
A teacher has just given an algebra exam. What are some of the statistics she could compute?
-
Continuation of Problems 8 and 37. Another explanation is that the stones move only when the water dumped on the playa during a storm freezes into a large, thin sheet of ice. The stones are trapped...
-
Compound interest means that you add the interest (say, 2%) to a starting balance (say, $100) for a period of time (say its a year) to get a new balance ($102.00 in this example). During the next...
-
Elea nor Davis is a single woman. Although she has a good income and uses credit wisely, she has been denied a loan to buy a house and does not know why. She believes that she may have been...
-
Robertos Steakhouse tracks customer complaints every day and then follows up with their customers to resolve problems. For the past 30 days, they received a total of 22 complaints from unhappy...
-
Using High-Low to Calculate Fixed Cost, Calculate the Variable Rate, and Construct a Cost Function Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Month Labor Cost($)...
-
Consider two economies, Home and Foreign. The DC/FC exchange is determined by the asset approach to the exchange rate. Both countries are identical in the following ways: Production function is...
-
Modify the spreadsheet from Problem 41 to handle a term of 1 to 360 months. Test your spreadsheet by entering data from Appendix E and Problems 11 through 14. Compare your answer to the solutions to...
-
A manager has up to $190,000 available to invest in new construction equipment for the company. The manager must purchase a new dump truck and does not have a need for a second dump truck. The...
-
In your own words, describe the difference between a managed fund and an index fund. Which one do you think could help you achieve your investment goals?
-
Justify the statement: A refrigerating machine works on the principle of the second law of thermodynamics.
-
Explain the influence of temperature and pressure on chemical potential.
-
What do you mean by fugacity of solid and liquids?
-
If a Celsius temperature is two-thirds the corresponding Fahrenheit temperature, determine both the temperatures.
-
What is the significance of the Poynting pressure correction factor?
-
Warren Buffett's company, Berkshire Hathaway, is one of the world's most successful investment companies. Therefore, it might come as a surprise that a company owned by Berkshire Hathaway may have...
-
Write an SQL statement to display all data on products having a QuantityOnHand greater than 0.
-
The ____________ form of small business ownership protects owners from any personal losses greater than their original investments, while the ____________ form separates them completely from any...
-
Define each of the following terms: a. Derivative b. Corporate risk management c. Financial futures; forward contract d. Hedging; natural hedge; long hedge; short hedge; perfect hedge e. Swap;...
-
Define each of the following terms: a. Derivative b. Corporate risk management c. Financial futures; forward contract d. Hedging; natural hedge; long hedge; short hedge; perfect hedge e. Swap;...
-
Give two reasons stockholders might be indifferent between owning the stock of a firm with volatile cash flows and that of a firm with stable cash flows.
-
7. On a nonliquidating distribution of appreciated property subject to debt, in terms of computing the shareholder's dividend: A. The fair market value is the amount of the distribution to the...
-
The firm stop producing additional units. If marginal product is , the firm should continue production if it can sell the output for more than the costs.
-
The government of Great Britain is seeking, under a treaty, to extradite Ann to face murder charges. She is a Canadian citizen. Ann argues that she has the right under the Charter to remain in...
Study smarter with the SolutionInn App