Stuck on this problem, can someone solve this for me?
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 $21,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 Repairs, first year Repairs, second year Repairs, third year 3.700 $ 1600 $ 4,100 $ 6,100 At the end of three years, the fleet could be sold for one-half of the origindi purchase price. Lease alternative: The company can lease the cars under a three-year lease contract. The lease cost would be $56,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 $13,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 15%, 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 2 $ $ 0 $ 0 $ 0 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 $ 0 $ 0 $ 0 $ 0 2. Which alternative should the company accept? O Lease alternative O Purchase alternative