194 196 199 204 B C D E F G H J K 193 Cleaning Service You are running a cleaning service. 195 During the winter you also provide snow removal services. Write the Excel formula in the yellow cells below that calculate the appropriate values. 197 198 Receive $150300 from customers for cleaning services provided S 150,300 Receive $50200 from customers for snow removal $ 50.200 200 Pay $80400 to workers providing the services $ 80,400 201 Pay $20100 cash for supplies S 20,100 202 Pay $5,000 in interest on a loan $ 5,000 203 Receive $7000 interest on cash in the bank $ 7,000 Pay $5,000 cash on a advertisement in the local newspaper $ 5,000 205 Pay for your office phone bill of $2,000 $ 2,000 206 Pay for a PC at the beginning of the year for $3,600 (straight line depreciate - 3 years) $ 3,600 207 Pay $2,000 for accounting services S 2,000 208 209 How much are: 210 Revenues Cost of Revenues 212 SG&A (excluding Depreciation) 213 Depreciation 214 Interest Expense (Income)* 215 Taxes (30% of Pretax Income) 216 217 218 Gross Profit 219 Earnings Before Interest, Taxes, Depreciation & Amortization (EBITDA)* Earnings Before Interest and Taxes (EBIT)** 221 Pretax Income 222 Net Income 223 EBIT Margin (Operating Margin) * Interest Income is a Negative and Interest Expense is a Positive 225 **Depreciation is always shown as a positive number. There is no such thing as negative Depreciation. Accountants subtract expenses on the Income Statement. 226 ***EBITDA is EBIT plus depreciation and amortization. 227 211 220 224