Please write answers using an Excel Formula

H $ $ A B C D E G 193 Cleaning Service 194 You are running a cleaning service. 195 During the winter you also provide snow removal services. 196 Write the Excel formula in the yellow cells below that calculate the appropriate values. 197 198 Receive $150,000 from customers for cleaning services provided. 199 Receive $50,000 from customers for snow removal. 200 Pay $80,000 to workers providing the cleaning services. 201 Pay $20,000 cash for supplies 202 Pay $5,000 in interest on a loan 203 Receive $2000 interest on cash in the bank 204 Pay $5,000 cash on a advertisement in the local newspaper 205 Pay for your office phone bill of $2,000 206 Pay for a PC at the beginning of the year for $3,600 (straight line depreciate - 3 years) 207 Pay $2,000 for accounting services 208 $ $ $ 150,000 50,000 80,000 20,000 5,000 2,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 EBIT Margin (Operating Margin) Interest Income is a Negative and Interest Expense is a Positive ** EBITDA is EBIT plus depreciation and amortization