Please box all the answers

Cleaning Service You are running a cleaning service. During the winter you also provide snow removal services. Write the Excel formula in the yellow cells below that calculate the appropriate values. $ $ $ $ Receive $150300 from customers for cleaning services provided Receive $50100 from customers for snow removal Pay $80400 to workers providing the services Pay $20200 cash for supplies Pay $5,000 in interest on a loan Receive $7000 interest on cash in the bank Pay $5,000 cash on a advertisement in the local newspaper Pay for your office phone bill of $2,000 Pay for a PC at the beginning of the year for $3,600 (straight line depreciate - 3 years) Pay $2,000 for accounting services $ $ 150,300 50,100 80,400 20,200 5,000 7,000 5,000 2,000 3,600 2,000 $ $ How much are: Revenues $ $ $ Cost of Revenues SG&A (excluding Depreciation) Depreciation Interest Expense (Income)* Taxes (30% of Pretax Income) $ $ $ Gross Profit $ $ Earnings Before Interest, Taxes, Depreciation & Amortization (EBITDA)* Earnings Before Interest and Taxes (EBIT)** Pretax Income $ $ Net Income $ sk EBIT Margin (Operating Margin) Interest Income is a Negative and Interest Expense is a Positive **Depreciation is always shown as a positive number. There is no such thing as negative Depreciatio