Question

CORPORATE FINANCE 1191 industry Analysis-Top 3 M week 2: Excel Sirmulatio × px09151507549128931 1547325320784 Building an Income Statement-Excell FILE HOME INSERTİ PAGELAYOUTI FORMULAS DATA REVIEW VIEW Sign In Colors 囚Fonts. Widthe Automatic 11Height: Automatic- swt Arrange Margins Orientation Sine Print Breaks Background Print Area Themes ffects Titles Page Setup Scale to rit A1 Bllys Exterminators, Inc, has sales of $734,000, costs of $315,000, depreciation expense of $48,000, interest expense of $35,000, and a tax rate of 35 percent. What is the net income for this firm? Sales Costs Depreciation expense Intorest expense S T34,000 315,000 48,000 Tax rate 35% Cash dividends s 85,000 Shares outstanding Complete the following analysis. Do not hard code values in your answers.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

The income statement for the company is:

Income Statement

Sales $734,000
Costs ($315,000)
Depreciation ($48,000)
EBIT $371,000
Interest ($35,000)
EBT $336,000
Taxes (35%) ($117,600)
Net income $218,400
Add a comment
Know the answer?
Add Answer to:
CORPORATE FINANCE 1191 industry Analysis-Top 3 M week 2: Excel Sirmulatio × px09151507549128931 1547325320784 Building an...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Billy's Exterminators, Inc., has sales of $734,000, costs of $315,000, de of $48.000, interest expense of...

    Billy's Exterminators, Inc., has sales of $734,000, costs of $315,000, de of $48.000, interest expense of $35,000, and a tax rate of 35 percent. W income for this firm? inco Sales Costs Depreciation expense Interest expense 734,000 315,000 48,000 35,000 35% Tax rate 85.000 Cash dividends 110 000 Shares outstanding Complete the following analysis. Do not hard code values in your answers. Income Statement Sales Costs Depreciation expense EBIT Interest expense ЕВТ Taxes (35%) Net income e

  • Please show what to write on the blanks. For example (=D7+D8) Billy's Exterminators, Inc., has sales...

    Please show what to write on the blanks. For example (=D7+D8) Billy's Exterminators, Inc., has sales of $734,000, costs of $315,000, depreciation expense of $48,000, interest expense of $35,000, and a tax rate of 35 percent. What is the net income for this firm? Sales Costs Depreciation expense Interest expense $ 734,000 315,000 48,000 35,000 10 35% 12 13 14 15 16 17 18 Tax rate Cash dividends Shares outstanding $ 85,000 110,000 Tax rate Cash dividends Shares outstanding 12...

  • 1. Calculate the net income. ? X - Sign In FILE * Building an Income Statement...

    1. Calculate the net income. ? X - Sign In FILE * Building an Income Statement - Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri - 11A A = % D D B IU. . . A. Alignment Number Conditional Format Cell Formatting as Table Styles Font Styles M Paste Editing Cells - Clipboard G18 AB Billy's Exterminators, Inc., has sales of $734,000, costs of $315,000, depreciation expense of $48,000, interest expense of $35,000, and a tax rate...

  • All answers must be entered as a formula! 1. Calculate the net income. Building an Income...

    All answers must be entered as a formula! 1. Calculate the net income. Building an Income Statement Exce HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VEW Sign in Paste B nl. |B- 5--. Algnment Number Conditional Format asCell . ormatting TableStylelEditing A B Billy's Exterminators, Inc., has sales of $734,000, costs of $315,000, depreciation expense of $48,000, interest expense of $35,000, and a tax rate of 35 percent. What is the net income for this firm? Sales Costs Depreciation expense...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT