E3.3 Please provide explanation as much as possible (LO 3) HQ Ltd. purchased a used truck...
E3.3
Please provide explanation as much as possible
(LO 3) HQ Ltd. purchased a used truck from Trans Auto Sales Inc. HQ paid a $4,000 down payment and signed a note that calls for 36 payments of $1,033.34 at the end of each month. The stated rate of interest in the note is 4%. As an incentive for entering into the contract, Trans has agreed to forgive the first two payments under the lease.
Instructions
a.
What was the purchase price of the used truck excluding the incentive given? To calculate, use (1) a financial calculator or (2) Excel function PV.
b.
What effect, if any, does the forgiveness of the first two payments have on the purchase price of the truck?
c.
Calculate the present value of the 34 payments of $1,033.34 that will be made by HQ for payments 3 to 36 inclusive. You will need to perform two steps.
-
1.Calculate the present value of the 34 payments as of the end of the second month following the purchase of the used truck. Use (a) a financial calculator or (b) Excel function PV.
-
2.Take the result from the first calculation and calculate the present value as of the date of purchase. Use (a) a financial calculator or (b) Excel function PV.
d.
What amount should HQ use to record the purchase of the truck?
e.
What amount of interest should be accrued at the end of the first month following the purchase?
Thank you
Homework Answers
Assumin stated rate of interest 4% is on monthly basis.
a. Purchase price of the truck excluding incentive = $23,538.68
| Month | Payment | Discount Factor @4% | Present Vlaue |
| 0 | $ 4,000.00 | 1 | $ 4,000.00 |
| 1 | $ 1,033.34 | 0.9615 | $ 993.60 |
| 2 | $ 1,033.34 | 0.9246 | $ 955.38 |
| 3 | $ 1,033.34 | 0.8890 | $ 918.64 |
| 4 | $ 1,033.34 | 0.8548 | $ 883.30 |
| 5 | $ 1,033.34 | 0.8219 | $ 849.33 |
| 6 | $ 1,033.34 | 0.7903 | $ 816.66 |
| 7 | $ 1,033.34 | 0.7599 | $ 785.25 |
| 8 | $ 1,033.34 | 0.7307 | $ 755.05 |
| 9 | $ 1,033.34 | 0.7026 | $ 726.01 |
| 10 | $ 1,033.34 | 0.6756 | $ 698.09 |
| 11 | $ 1,033.34 | 0.6496 | $ 671.24 |
| 12 | $ 1,033.34 | 0.6246 | $ 645.42 |
| 13 | $ 1,033.34 | 0.6006 | $ 620.60 |
| 14 | $ 1,033.34 | 0.5775 | $ 596.73 |
| 15 | $ 1,033.34 | 0.5553 | $ 573.78 |
| 16 | $ 1,033.34 | 0.5339 | $ 551.71 |
| 17 | $ 1,033.34 | 0.5134 | $ 530.49 |
| 18 | $ 1,033.34 | 0.4936 | $ 510.09 |
| 19 | $ 1,033.34 | 0.4746 | $ 490.47 |
| 20 | $ 1,033.34 | 0.4564 | $ 471.60 |
| 21 | $ 1,033.34 | 0.4388 | $ 453.46 |
| 22 | $ 1,033.34 | 0.4220 | $ 436.02 |
| 23 | $ 1,033.34 | 0.4057 | $ 419.25 |
| 24 | $ 1,033.34 | 0.3901 | $ 403.13 |
| 25 | $ 1,033.34 | 0.3751 | $ 387.62 |
| 26 | $ 1,033.34 | 0.3607 | $ 372.71 |
| 27 | $ 1,033.34 | 0.3468 | $ 358.38 |
| 28 | $ 1,033.34 | 0.3335 | $ 344.60 |
| 29 | $ 1,033.34 | 0.3207 | $ 331.34 |
| 30 | $ 1,033.34 | 0.3083 | $ 318.60 |
| 31 | $ 1,033.34 | 0.2965 | $ 306.34 |
| 32 | $ 1,033.34 | 0.2851 | $ 294.56 |
| 33 | $ 1,033.34 | 0.2741 | $ 283.23 |
| 34 | $ 1,033.34 | 0.2636 | $ 272.34 |
| 35 | $ 1,033.34 | 0.2534 | $ 261.86 |
| 36 | $ 1,033.34 | 0.2437 | $ 251.79 |
| Total | $ 23,538.68 |
b. Incentive of 2 month's payment $1033.34 p.m. need to be transfered to profit and loss and debit Trans Auto Sales Inc. account at the end of each waiver month.
c. Present value of the 34 payments of $1,033.34 that will be made by HQ = $17,589.71
1. Present value of the 34 payments as of the end of the second month following the purchase of the used truck = $19,025.03
| Month | Payment | Discount Factor @4% | Present Vlaue |
| 3 | $ 1,033.34 | 0.9615 | $ 993.60 |
| 4 | $ 1,033.34 | 0.9246 | $ 955.38 |
| 5 | $ 1,033.34 | 0.8890 | $ 918.64 |
| 6 | $ 1,033.34 | 0.8548 | $ 883.30 |
| 7 | $ 1,033.34 | 0.8219 | $ 849.33 |
| 8 | $ 1,033.34 | 0.7903 | $ 816.66 |
| 9 | $ 1,033.34 | 0.7599 | $ 785.25 |
| 10 | $ 1,033.34 | 0.7307 | $ 755.05 |
| 11 | $ 1,033.34 | 0.7026 | $ 726.01 |
| 12 | $ 1,033.34 | 0.6756 | $ 698.09 |
| 13 | $ 1,033.34 | 0.6496 | $ 671.24 |
| 14 | $ 1,033.34 | 0.6246 | $ 645.42 |
| 15 | $ 1,033.34 | 0.6006 | $ 620.60 |
| 16 | $ 1,033.34 | 0.5775 | $ 596.73 |
| 17 |
$ 1,033.3
Know the answer?
Add Answer to:
|
HQ Ltd. purchased a used truck from Trans Auto Sales Inc. HQ paid a $3,800 down payment and signed a note that calls for 36 payments of $1,025.00 at the end of each month. The stated rate of interest in the note is 6%. As an incentive for entering into the contract, Trans has agreed to forgive the first two payments under the lease. 1.What was the purchase price of the used truck excluding the incentive given?
please be as clear and as
simple as possible. I am trying to understand it. show me the
steps, not only the answers. thank you in advance.
Page 1246 Ch 26 - Ill 26-25 Payments made annually at end of year, Interest is quoted Annually Capital Investment Net Annual Cash Flows Annuity Payments Intererst Rate Calculate Present Value 1) Calculate Using Financial Calculator 3) Calculate Using MS Excel 130,000 39,000 5 Years 12% N = 5, PMT = 39,000, I/Y...