Beryls Iced Tea currently rents a bottling machine for $50,000 per year, including all maintenance expenses. It is considering purchasing a machine instead, and is comparing two options:

A. Purchase the machine it is currently renting for $150,000. This machine will require $20,000 per year in ongoing maintenance expenses.

B. Purchase a new, more advanced machine for $250,000. This machine will require $15,000 per year in ongoing maintenance expenses and will lower bottling costs by $10,000 per year. Also, $35,000 will be spent upfront in training the new operators of the machine.

Answer needs to be in the following Excel Format (Please show all cell formulas).

Beryl's Iced Tea currently rents a bottling machine for $50,000 per year, including all maintenance expenses. It is considering purchasing a machine instead, and is comparing two options: a. Purchase the machine it is currently renting for $150,000. This machine will require $20,000 per year in ongoing maintenance expenses. b. Purchase a new, more advanced machine for $250,000. This machine will require $15,000 per year in ongoing maintenance expenses and will lower bottling costs by $10,000 per year. Also, $35,000 will be spent upfront in training the new operators of the machine. Suppose the appropriate discount rate is 8% per year and the machine is purchased today. Maintenance and bottling costs are paid at the end of each year, as is the rental of the machine. Assume also that the machines will be depreciated via the straight-line method over seven years and that they have a 10-year life with a negligible salvage value. The marginal corporate tax rate is 35%. Should Beryl's Iced Tea continue to rent, purchase its current machine, or purchase the advanced machine? Discount rate 8% 35% Tax rate Useful life (years) Rent Machine Year 1 Year 2 Year 3 Year 4 -$50,000 Year 5 Year 6 -$50,000 -$50,000 Rent FCF (rent) NPV Purchase Current Machine Maintenance -$20,000 -$20,000 -$20,000 Depreciation Capital Expenditures FCF (purchase current) NPV Purchase Advanced Machine Maintenance -$15,000 -$15,000 -$15,000 $10,000 Other Costs $10,000 $10,000 Depreciation Capital Expenditures FCF (purchase advanced) NPV Beryl's Iced Tea should Year 0 -$150,000 -$35,000 -$250,000 -$50,000 -$20,000 -$15,000 $10,000 -$50,000 -$20,000 -$15,000 $10,000 -$50,000 -$20,000 -$15,000 $10,000 Year 7 -$50,000 -$20,000 -$15,000 $10,000 Year 8 -$50,000 -$20,000 -$15.000 $10,000 Year 9 -$50,000 -$20,000 -$15,000 $10,000 Year 10 -$50,000 -$20,000 -$15,000 $10,000