Question

E ry es. Save inkedi. St Auto inkedi. inkedi A B D 1 BUSI 320 Comprehensive Problem 1 Version FALL 2 Use the following inform
Comprehensive_Problem_1_FALL_2020_in_EXCEL (Protected View] - Excel Formulas Data Review View Tell me what you want to do...
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks!
Statement of Earnings 2019 2020
Sales    800,000.00      880,000.00
Cost of goods sold (220,000.00)    (240,000.00)
Gross Profit    580,000.00      640,000.00
Less: Operating expenses (480,000.00)    (505,000.00)
Earning before interest and taxes    100,000.00      135,000.00
Less: Interest expense     (25,000.00)       (25,000.00)
Income before tax      75,000.00      110,000.00
Taxes     (25,000.00)       (30,000.00)
Net Income      50,000.00        80,000.00
Statement of Financial Position
Assets 2019 2020
Cash      60,000.00        65,000.00
Accounts Receivable      90,000.00        95,000.00
Inventory    110,000.00      130,000.00
Total Current Assets    260,000.00      290,000.00
Fixed Assets (Net)    300,000.00      330,000.00
Total Assets    560,000.00      620,000.00
Liabilities & Stockholders' Equity
Liabilities 2019 2020
Current Liabilities    130,000.00      140,000.00
Long Term Liabilities    170,000.00      200,000.00
Total Liabilities    300,000.00      340,000.00
Stockholders' Equity    260,000.00      280,000.00
Total Liabilities & Stockholders' Equity    560,000.00      620,000.00
Quick Assets 2019 2020
Cash      60,000.00        65,000.00
Accounts Receivable      90,000.00        95,000.00
Total Quick Assets    150,000.00      160,000.00
Final Answer 2019 2020 Comments Industry Comments
Profit Margin
Net Income/ Sales 6.25% 9.09% Worse        0.08 Bad
Current Ratio
Current Assets/Current Liabilities      2.00      2.07 Worse        1.80 Good
Quick Ratio
Quick Assets/Current Liabilities      1.15      1.14 Better        1.12 Good
Return on Assets
(Net Income+ Interest Expense) / Total Assets 13.39% 16.94% Worse        0.18 Bad
Debt to Assets
Total Liabilities/ Total Assets 53.57% 54.84% Better        0.60 Good
Receivable Turnover
Sales/ Accounts Receivable      8.89      9.26 Worse      12.00 Bad
Average Collection period
365/ Receivable Turnover 41.06 39.40 Worse      22.10 Bad
Inventory Turnover
Cost of goods sold/ Inventory      2.00      1.85 Better        8.25 Bad
Return on Equity
Net Income/ Total Equity 19.23% 28.57% Better        0.16 Good
Times Interest Earned
Earnings before interest and taxes/ Interest expense      4.00      5.40 Worse        8.15 B
Know the answer?
Add Answer to:
E ry es. Save inkedi. St Auto inkedi. inkedi A B D 1 BUSI 320 Comprehensive...
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
  • Please provide step by step explanation for answer. BUSI 320 Comprehensive Problem 1 Version FALL Use...

    Please provide step by step explanation for answer. BUSI 320 Comprehensive Problem 1 Version FALL Use the following information to answer the questions below: note: all sales are credit sales Income Stmt info: Sales $ less Cost of Goods Sold: Gross Profit Operating Expenses Earnings before Interest & Taxes Interest exp earnings before Taxes Taxes Net Income $ 2019 800,000 $ 220.000 580,000 480.000 100,000 25,000 75,000 25.000 50,000 $ 2020 880,000 240.000 640,000 505.000 135,000 25.000 110,000 30.000 80,000...

  • L M N BUSI 320 Comprehensive Problem 1 Spring 2020 Use the following information to answer...

    L M N BUSI 320 Comprehensive Problem 1 Spring 2020 Use the following information to answer the questions below: note: all sales are credit sales Income Stmt info: Sales $ less Cost of Goods Sold: Gross Profit 2018 1,000,000 $ 400,000 600,000 2019 1,050,000 432,000 618,000 Compute each of the following ratios for 2018 and 2019 and indicate whether each ratio was getting "better" or "worse" from 2018 to 2019 and was "good" or "bad" compared to the Industry Avg...

  • BUSI 320 Comprehensive Problem 1 Spring 2020 Use the following information to answer the questions below:...

    BUSI 320 Comprehensive Problem 1 Spring 2020 Use the following information to answer the questions below: note: all sales are credit sales Income Stmt info: 2018 Sales $ 1,000,000 less Cost of Goods Sold: 400.000 Gross Profit 600,000 Operating Expenses 350,000 Earnings before Interest & Taxes 250,000 Interest exp - 20.000 earnings before Taxes 230,000 Taxes 69.000 Net Income $ 161,000 2019 $ 1,050,000 432.000 618,000 365,750 252,250 20.400 231,850 69.555 $ 162,295 Balance Sheet info: Cash Accounts Receivable Inventory...

  • U Format BUSI 320 Comprehensive Problem 1 Summer 1 2Use the following Information to answer the...

    U Format BUSI 320 Comprehensive Problem 1 Summer 1 2Use the following Information to answer the questions below 3note: all sales are credit sales Income Stmt info: 2018 Sales S less Cost of Goods Sold: 1,100,000 1,155,000 Gross Profit 775,000 804,000 Operating Expenses 575,000 609,500 10 Earnings before Interest & Taxes Interest exp earnings before Taxes 175,000 164,500 13 Taxes 14 Net income S 98,700 15 16 Balance Sheet info: 12/31/17 12/31/18 55,000 S 17 Cash 52,250 18 Accounts Receivable...

  • Cell Styles Office Update To keep up-to-date with security updates, fixes, and impro... Che C37 Income...

    Cell Styles Office Update To keep up-to-date with security updates, fixes, and impro... Che C37 Income Stmt info: less Cost of Goods Sold: Gross Profit Operating Expenses Earnings before Interest & Taxes Interest exp earnings before Taxes Taxes Sales 1,000,000$ 1,100,000 424,000 676,000 65,750 310,250 25,500 284,750 600,000 350,000 250,000 25,000 12 225,000 13 Net Income 135,000$ 170,850 15 16 17 18 19 Inventory 20 Total Current Assets 21 Fixed Assets (Net) 22 Total Assets Balance Sheet info Cash Accounts...

  • Cell Styles Office Update To keep up-to-date with security updates, fixes, and impro... Che C37 Income...

    Cell Styles Office Update To keep up-to-date with security updates, fixes, and impro... Che C37 Income Stmt info: less Cost of Goods Sold: Gross Profit Operating Expenses Earnings before Interest & Taxes Interest exp earnings before Taxes Taxes Sales 1,000,000$ 1,100,000 424,000 676,000 65,750 310,250 25,500 284,750 600,000 350,000 250,000 25,000 12 225,000 13 Net Income 135,000$ 170,850 15 16 17 18 19 Inventory 20 Total Current Assets 21 Fixed Assets (Net) 22 Total Assets Balance Sheet info Cash Accounts...

  • Use the following information to answer the question below: note all sales are credit sales. Compute...

    Use the following information to answer the question below: note all sales are credit sales. Compute each of the following ratios for 2018 and 2019 and indicate whether each ratio was getting "better" or "worse" from 2018 to 2019 and was "good" or "bad" compared to the industry Avg. 2019 (round all numbers to 2 digits past the decimal place). Income Stmt info: 2018 2019 Sales $ 1,000,000 $ 1,050,000 less Cost of Goods Sold: - 400,000 _ 432.000 Gross...

  • Corporate Finance Problem 1

    BUSI 320 Comprehensive Problem1 Version FALL Use the following infomation to answer the questions below: note: allsales are credit sales Income Stmt info: 2019 2020 Sales 800,000S 880,000 less Cost of Goods Sold: 220,000 240.000 Gross Profit Operating Expenses Earnings before Interest& Taxes 580,000 640,000 480,000 S05,000 100,000 135,000 Interest exp 25.000 25.000 earnings before Taxes 75,000 110,000 25,000- 30.000 Taxes Net Income S 50,000 S 80,000 Balance Sheet info: 12/31/19 12/31/20 Cash 60,000 65,000 3 ACCounts Receivable 90,000 95,000...

  • FILL IN THE BLANKS Use the following information to answer the questions on page 2 below...

    FILL IN THE BLANKS Use the following information to answer the questions on page 2 below Note: all sales are credit sales Income Stmt info: 2017 2018 less Cost of Goods Sold: Gross Profit Operating Expenses Earnings before Interest & Taxes Interest exp earnings before Taxes Taxes Net Income Sales 1,000,000 $1,100,000 424,000 676,000 365,750 310,250 25,500 284,750 113,900 170,850 400,000 600,000 350,000 250,000 25,000 225,000 90,000 135,000 $ 12/31/ Balance Sheet info: Cash Accounts Receivable Inventory Total Current Assets...

  • 1 TE22 DE DE &a...EEEEEEEEE Income Stmt info: 2018 2017 Sales $ 900,000 $ 990,000 less...

    1 TE22 DE DE &a...EEEEEEEEE Income Stmt info: 2018 2017 Sales $ 900,000 $ 990,000 less Cost of Goods Sold: 325,000 346,125 Gross Profit 575,000 643,875 Operating Expenses 450,000 477,000 Earnings before Interest & Taxes 125,000 166,875 Interest exp 25,000 31,000 earnings before Taxes 100,000 135,875 Taxes 40,000 54,350 Net Income $ 60,000 $ 81,525 12/31/2018 63,600 89,600 Balance Sheet info: Cash Accounts Receivable Inventory Total Current Assets Fixed Assets (Net) Total Assets 12/31/2017 60,000 80,000 110,000 250,000 300,000 550,000...

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
ADVERTISEMENT