Use the total-cost approach to determine the present value of cash flows...

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 $23,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 $ 3,900 Repairs, first year $ 1,800 Repairs, second year $ 4,300 Repairs, third year $ 6,300 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 $58,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 $14,500 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 17%. Use Excel or a financial calculator to solve. 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 to the nearest dollar.) Now Purchase Alternative: Purchase of cars Annual servicing costs Repairs Resale value of cars Total cash flows Net present value Lease Alternative: Security deposit Annual lease payments Refund of deposit Total cash flows Net present value 2. Which alternative should the company accept? Lease alternative Purchase alternative