Answered step by step
Verified Expert Solution
Link Copied!

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!

image text in transcribed

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 amortization

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In International Accounting Volume 20

Authors: J. Timothy Sale

1st Edition

0762313994, 9780762313990

More Books

Students also viewed these Accounting questions