Question

In: Finance

You are offered two options by the Waverley Toyota dealer for purchasing a Toyota Landcruiser 4WD.

2: Applications of finance (20 Mark)

Please answer the following questions. Show all your workings when calculations are required and round off your FINAL result to TWO decimal places.

You are offered two options by the Waverley Toyota dealer for purchasing a Toyota Landcruiser 4WD.

Option 1: Upfront where you pay $100,000 now. Option 2: 2- year monthly payment plan of $4500/month, starting today, with a final payment to be made 23 months from today.

a) If the market interest rate is 6% p.a., calculate the present value of each alternative and identify which alternative is cheaper. (4 marks)

b) If you could decide on the monthly payment amount for option 2, at 6% p.a. interest rate what would that amount be so that you are indifferent to the two options? (3 marks)

c) If the monthly payments of option 2 were to be made at the end of each month, how would your answer to part b) on the monthly payment amount be different? Explain briefly. NO CALCULATIONS ARE REQUIRED HERE. (3 marks)

d) What is the effective annual interest rate (EAR) that would make you indifferent to the two options? (Note that the market interest rate is not given, you need to solve for the interest rate that equates the present value of the two options). (6 marks)

e) Assume that you have chosen option 2 to purchase the car. Immediately after the 12th monthly payment, you encounter some temporary financial difficulty and are only able to afford monthly payment of $4000. After negotiating with the dealer, they are happy for you to pay $4000 per month for the rest of the contract period and a final lump sum payment right at the end of the contract. If the market interest rate is still 6% p.a., how much would this final lump sum payment be so that you will not be worse off by this new arrangement? (4 marks)

Solutions

Expert Solution

Following is the information provided in the question:

Option 1 : Upfront payment of $ 100,000 now.

Option 2 : Make monthly payment of $ 4500 for 24 months starting today.

Market Rate of interest: 6% p.a.

a) Calculation of present value of the two options

Option 1: PV will be $ 100,000 since the payment is made upfront at period 0.

Option 2: $ 4500*1 + $ 4500* PVAF @ 0.5%, 23m

                  = 4500+ 4500* 21.6757

                  = 4500+ 97540.65

                 = $ 102,040

Note: 24 monthly payments are made, first installment being paid at period 0. And therefore remaining 23 installment NPV is calculated using present value annuity factor ( PVAF) @ 0.5% (6% given rate is yearly and the installments are paid monthly and thus the rate has been converted to monthly) for 23 period.

Decision: Since the NPV of option 1 is less, it is a cheaper option.

b) To be indifferent to both the options, NPV of the options should be the same. Let the monthly payment be $ x, so the person is indifferent to the two options:

            $ 100,000   =    x*1 + x*21.6757

              X = 100,000

                      22.6757

                 = $ 4410

Therefore, monthly payment should be $ 4410, so the person is indifferent to the two options.

c) If the monthly payments of option 2 were to be made at the end of each month, then the present value of option 2 will be calculated by PVAF @ 0.5% for 24 periods, which will reduce the NPV of the option.

d) Calculation of effective annual interest rate (EAR) that would make you indifferent to the two options:

$ 100,000    =   $ 4500*1 + $ 4500* PVAF(%,y)

   PVAF = 95500

                   4500

              = 21.2222

Now, looking at the PVAF table, 21.2222 is the value for the rate of 8.6% p.a.

e) Following information is available:

Period 0                          $ 4500

Period 1-11                    $ 4500

Period 12-23                  $ 4000

Period 23                          ?

Now, to not be worse off by the new arrangement, NPV of the second option should be same as the original arrangement, which means the NPV should be $ 102040.65 as calculated in part (a) above.

Let the lump sum amount to be paid at the end of the contract be $ x:

          $ 102040 = $4500* 1 + $4500* PVAF (0.5%, 11m) + $4000* PVAF (0.5%, 12m) + x* PVF( 0.5%, 23m)

           102040 = 4500+ 4500* 10.6770 + 4000*10.9987 + x* 0.8916

              X = 5498.70

                      0.8916

                 = $ 6167.2275

        The lump sum amount to be paid at the end of the contract is $ 6167.

        


Related Solutions

You are offered two options by the Waverley Toyota dealer for purchasing a Toyota Landcruiser 4WD....
You are offered two options by the Waverley Toyota dealer for purchasing a Toyota Landcruiser 4WD. Option 1: Upfront where you pay $100,000 now. Option 2: 2- year monthly payment plan of $4500/month, starting today, with a final payment to be made 23 months from today. a) If the market interest rate is 6% p.a., calculate the present value of each alternative and identify which alternative is cheaper. (4 marks) b) If you could decide on the monthly payment amount...
You are offered two options by the Waverley Toyota dealer for purchasing a Toyota Landcruiser 4WD.
Question 2: Applications of finance You are offered two options by the Waverley Toyota dealer for purchasing a Toyota Landcruiser 4WD.Option 1: Upfront where you pay $100,000 now.Option 2: 2- year monthly payment plan of $4500/month, starting today, with a final payment to be made 23 months from today.a) If the market interest rate is 6% p.a., calculate the present value of each alternative and identify which alternative is cheaper. (4 marks)b) If you could decide on the monthly payment amount...
Suppose that you plan on purchasing a home and you are offered the following financing options....
Suppose that you plan on purchasing a home and you are offered the following financing options. (1) Annual interest rate of 6%, with additional upfront fees of $20,000 (These fees are not included in the $300,000 you will be financing, they will be paid upfront in cash). (2) Annual interest rate of 7% with additional upfront fees of $2,000 (also will not be financed, will be paid upfront in cash). You will make monthly payments for 30 years and you...
Amy was offered two options for a car she was purchasing: Lease option: Pay lease amounts...
Amy was offered two options for a car she was purchasing: Lease option: Pay lease amounts of $400 at the beginning of every month for 6 years. At the the end of 6 years, purchase the car for $13,500. Buy option: Purchase the car immediately for $25,000. The money is worth 7.40% compounded monthly. a. What is the Discounted Cash Flow (DCF) for the lease option?
A Toyota dealer consumes four kinds of engine oil A, B, C and D. This dealer...
A Toyota dealer consumes four kinds of engine oil A, B, C and D. This dealer buys its consumption each week. The dealer never buys the same brand in successive weeks, except brand D. If the dealer buys engine oil D then with same probability it can buy all kinds of engine oils next week. If the dealer perches brand C then next week it will buy D. However, if the dealer buys engine oil B then the next week...
You have a sum of $10,000 available for investments. You are offered two options: Deposit the...
You have a sum of $10,000 available for investments. You are offered two options: Deposit the sum in a bank for 3 years, with an interest rate of 10% compounded annually. The bank is also prepared to take on any additional investments at the same rate at any time for the next 3 years. Invest the $10,000 in a project with an annual return of $4200. The project life is 3 years. Which is the preferred option? Explain your answer....
You are considering purchasing a small commercial property for $1,000,000. A bank has offered you two...
You are considering purchasing a small commercial property for $1,000,000. A bank has offered you two different loan options, the first would require a down payment of 30% and would have an interest rate of 5.25%. The second option would require a downpayment of only 20%, but the interest rate would rise to 6%. Both loans would have 25 year terms. After determining your monthly payment for each, calculate how much you are effectively paying (solving for RATE) for the...
You need a new car and the dealer has offered you a price of $20,000, with...
You need a new car and the dealer has offered you a price of $20,000, with the following payment options: (a) pay cash and receive a $2000 rebate, or (b) pay a $5000 down payment and finance the rest with a 0% APR loan over 30 months. But having just quit your job and started an MBA program, you are in debt and you expect to be in debt for at least the next 2 1 2 years. You plan...
You need a new car and the dealer has offered you a price of $20,000​, with...
You need a new car and the dealer has offered you a price of $20,000​, with the following payment​ options: (a) pay cash and receive a $2,000 ​rebate, or​ (b) pay a $5,000 down payment and finance the rest with a 0% APR loan over 30 months. But having just quit your job and started an MBA​ program, you are in debt and you expect to be in debt for at least the next 2​ ½ years. You plan to...
You are offered a chance to buy a put or call option from a currency dealer...
You are offered a chance to buy a put or call option from a currency dealer with a strike price of USD 0.8300/CHF with June expiration and premium of USD 0.0050/CHF. Your Magic 8 Ball tells you that the spot exchange rate will reach USD 0.8400/CHF sometime between now and June. With your entire savings, or USD 10,000, you want to speculate using the options to make some profits to finance your graduation bash. If you do, i) which option...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT