Question: BUSI 320 Comprehensive Problem 1 Version SPRING Use the following information to answer the questions below: note: all sales are credit sales Income Stmt info:

BUSI 320 Comprehensive Problem 1 Version SPRING

Use the following information to answer the questions below:

note: all sales are credit sales

Income Stmt info:

2019

2020

Sales

$ 900,000

$ 990,000

less Cost of Goods Sold:

300,000

320,000

Gross Profit

600,000

670,000

Operating Expenses

500,000

505,000

Earnings before Interest & Taxes

100,000

165,000

Interest exp

25,000

25,000

earnings before Taxes

75,000

140,000

Taxes

30,000

45,000

Net Income

$ 45,000

$ 95,000

Balance Sheet info:

12/31/2019

12/31/2020

Cash

60,000

$ 65,000

Accounts Receivable

100,000

$ 120,000

Inventory

80,000

$ 130,000

Total Current Assets

$ 240,000

$ 315,000

Fixed Assets (Net)

$ 300,000

$ 330,000

Total Assets

$ 540,000

$ 645,000

Current Liabilities

$ 130,000

$ 140,000

Long Term Liabilities

$ 170,000

$ 200,000

Total Liabilities

$ 300,000

$ 340,000

Stockholder's Equity

$ 240,000

$ 305,000

Total Liab & Equity:

$ 540,000

$ 645,000

Compute each of the following ratios for 2019 and 2020 and

indicate whether each ratio was getting "better" or "worse" from 2019 to 2020

and whether the 2020 ratio was "good" or "bad" compared to the Industry Avg

(round all numbers to 2 digits past the decimal place)

2019

2020

Getting Better or Getting Worse?

2020 Industry Avg

"Good" or "Bad" compared to Industry Avg

Profit Margin

5%

9.6%

Better

0.08

Good

Current Ratio

1.85

2.25

Better

1.80

Good

Quick Ratio

1.23

1.32

Better

1.12

Good

Return on Assets

8.3

14.73

Better

0.18

Bad

Debt to Assets

0.50

Receivables turnover

12.00

Avg. collection period*

22.10

Inventory Turnover**

8.25

Return on Equity

0.16

Times Interest Earned

6.15

*Assume a 360 day year

**Inventory Turnover can be computed 2 different ways. Use the formula listed in the text

(the one the text indicates many credit reporting agencies generally use)

Need help with last six parts of the problem.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!