Revenue: Average revenue per car wash $14.00 Forecasted annual volume growth in carwashes 3 percent Expenses: Current variable costs per carwash Utilities (Elec/gas/water) $0.88 Detergents/chemicals 0.64 Maintenance costs 0.47 Site labor 1.34 Total Variable Costs $3.33 Fixed costs per carwash (Based on 37,500 carwashes) Salaries $5.60 Insurance 0.40 Operating costs 0.84 Advertising 0.62 Depreciation (current) 0.00** Total Fixed Costs 7.46 Total $10.79 *No net changes in working capital are expected **New equipment useful life 10 years with no salvage/disposal value- straight-line ***Rate of return (discount rate) 8% Investment/ Tax Information Interest Rate 8.00% Equipment Investment $250,000 Net book value if sold today $40,000 Useful Life (Years) 10 Salvage Value $0 Maintenance Cost Decrease Per Car Wash $0.25 Long Term Capital Gains Tax Rate 20.00% Corporate Income Tax Rate 21.00%

Compute the breakeven carwashes (dollars & carwashes) and margin of safety and degree of operating leverage under the following scenarios: a. If they decide not to upgrade b. If they decide to upgrade

Can you please show this in Excel sheet? Thank you