Use Excel to solve it

6.31 Harmony Auto Group sells and services imported and domestic cars. The owner wants to evaluate the option of outsourcing all of its new auto warranty ser- vice work to Winslow, Inc., a private repair service that works on any make and year car. Either a 5-year contract basis or 10-year license agreement is avail- able from Winslow. Revenue from the manufacturer will be shared with no added cost incurred by the car/ warranty owner. Alternatively, Harmony can con- tinue to do warranty work in-house for the foresee- able future. Use the estimates made by the Harmony owner to perform an annual worth evaluation at 10% per year to select the best option. Monetary values are Ye in $ million units. Contract License In-house First cost, $ Annual cost, $ per year Annual revenue, S per year Life, years 20 4. 0.2 1.3 10 2.5