Question

The Riteway Ad Agency provides cars for its sales staff. In the past, the company has always purchased its cars from a dealer and then sold the cars after three years of use. The company’s present fleet of cars is three years old and will be sold very shortly. To provide a replacement fleet, the company is considering two alternatives:
Purchase alternative: The company can purchase the cars, as in the past, and sell the cars after three years of use. Ten cars will be needed, which can be purchased at a discounted price of $27,000 each. If this alternative is accepted, the following costs will be incurred on the fleet as a whole:
Annual cost of servicing, taxes, and licensing $ 4,300
Repairs, first year $ 2,200
Repairs, second year $ 4,700
Repairs, third year $ 6,700
At the end of three years, the fleet could be sold for one-half of the original purchase price.
Lease alternative: The company can lease the cars under a three-year lease contract. The lease cost would be $70,000 per year (the first payment due at the end of Year 1). As part of this lease cost, the owner would provide all servicing and repairs, license the cars, and pay all the taxes. Riteway would be required to make a $15,000 security deposit at the beginning of the lease period, which would be refunded when the cars were returned to the owner at the end of the lease contract.
Riteway Ad Agency’s required rate of return is 20%.
Required:
1. Use the total-cost approach to determine the present value of the cash flows associated with each alternative. (Any cash outflows should be indicated by a minus sign. Round discount factor(s) to 3 decimal places.)

Answer 1

Answer:

The present value of purchase is $ 209,907.41  

The present value of lease is $ 153,773.15  

Find attached spreadsheet.

Explanation:

The present of value of both options need to be calculated in order to determine the viable option:

Present value of purchase=($27,000*10)+($4,300+$2,200)/(1+20%)^1+($4,300+$4,700)/(1+20%)^2+($4,300+$6,700)/(1+20%)^3-($27000*10*0.5)/(1+20%)^3=$209,907.41  

Present value of lease option=$15,000+$70,000/(1+20%)^1+$70,000/(1+20%)^2+$70,000/(1+20%)^3-$15,000/(1+20%)^3=$ 153,773.15  

Download xlsx