Question

חד 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 $ $ $ $ $

Please write answers using an Excel Formula

Answer 1

196 197 198 199 200 201 202 203 204 Receive $150,000 from customers for cleaning services provided. $ Receive $50,000 from customers for snow removal. $ Pay $80,000 to workers providing the cleaning services. $ Pay $20,000 cash for supplies. $ Pay $5,000 in interest on a loan. $ Receive $2000 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 $ Reference 150,000 Revenue 50,000 Revenue 80,000 Cost of Revenue 20,000 Cost of Revenue 5,000 Interest Expense 2,000 Interest Revenue 5,000 SG&A Expense 2,000 SG&A Expense 3,600 Depreciation 2,000 SG&A Expense 205 206 207 208 209 210 Revenues Cost of Revenues SG&A (excluding Depreciation) Depreciation Interest Expense (Income) Taxes (30% of Pretax Income) $ $ $ $ $ $ 200,000 H198+H199 100,000 H200+H201 9,000 H204+H205+H207 1,200 H206/3 3,000 H202-H203 26,040 G221-30% 211 212 213 214 215 216 217 218 219 220 221 222 223 224 Gross Profit $ Earnings Before Interest, Taxes, Depreciation & Amortization (EBITDA) $ Earnings Before Interest and Taxes (EBIT) $ Pretax Income $ Net Income $ EBIT Margin (Operating Margin) 100,000 G210-G211 91,000 G218-G212 89,800 G219-G213 86,800 G220-214 60,760 G221-G215 45% G220/G210

$ $ Gross Profit Earnings Before Interest, Taxes, Depreciation & Amortization (EBITDA) Earnings Before Interest and Taxes (EBIT) Pretax Income Net Income EBIT Margin (Operating Margin) $ $ $ 100,000 G210-G211 91,000 G218-G212 89,800 G219-G213 86,800 G220-G214 60,760 G221-G215 45% G220/G210 Revenues - Cost of Revenues Gross Profit - SG&A Expenses EBITDA - Depreciation EBIT - Interest Expense Pretax Income - Taxes EBIT / Revenues Note: Please Comment down for any further clarifications.