Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please include the breakdown of what figures are going into what cells. Thank you! 3 Cleaning Service You are running a cleaning service. During the
Please include the breakdown of what figures are going into what cells. Thank you!
3 Cleaning Service You are running a cleaning service. During the winter you also provide snow removal services. Write the Excel formula in the bellow yellow cells that calculate the appropriate values. $ $ $ > Receive $150,000 from customers for cleaning services provided. Receive $50,000 from customers for snow removal. Pay $80,000 to workers 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 phone bill of $2,000 Pay for a PC at the beginning of the year for $3,600 that you depreciate over 3 years Pay $2,000 for accounting services 150,000 50,000 80,000 20,000 5,000 2,000 5,000 2,000 3,600 2,000 > > > How much are: w No00o w NP00W NHO 00 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 au Margin) EBIT Margin (Operating Margin) * EBITDA is EBIT plus depreciation and amortizationStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started