Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

answer the following questions and use the financial statement ratios to support your answers where appropriate: Do you feel that the company is able to

answer the following questions and use the financial statement ratios to support your answers where appropriate:

Do you feel that the company is able to meet its current and long term obligations as they become due?

Comment on the profitability of the company with respect to the various profitability ratios that you computed.

Would you lend money to this company for the long term?

Comment on the ability of the company to collect its receivables and mange inventory.

Ratios before

2014

2015

2016

Industry Average

Liquidity

Current

2.39

2.68

2.90

3.12

Quick

1.10

1.16

1.21

1.56

Working Capital

$ 98,750.00

$ 100,450.00

$ 103,000.00

$ 110,000.00

Leverage

Debt to Total Assets (%)

20.97%

21.98%

22.89%

20.89%

Times Interest Earned

8.75

9.12

9.56

10.22

Activity

Inventory Turnover (sales)

8.21

9.91

10.12

10.52

Fixed Asset Turnover

3.43

3.51

3.59

3.64

Total Asset Turnover

2.15

2.20

2.25

2.56

Average Collection Period (days)

14.95

14.69

14.42

14.28

Accounts Receivable Turnover

24.08

24.50

24.97

25.21

Days in Inventory

44.46

36.83

36.07

43.21

Profitability

Gross Profit Margin (%)

21.10%

22.50%

24.03%

24.56%

Net Profit (%)

6.89%

7.25%

7.89%

8.03%

Return on Total Assets (%)

15.50%

16.10%

16.24%

16.07%

Return on Equity (%)

20.15%

21.89%

22.15%

22.06%

Payout Ratio (%)

15.10%

15.84%

16.09%

16.86%

Ratios after calculated

Ratios (answers are all rounded by 4 decimal places)

Current ratio = Current assets / Current liabilities
= 161000 / 59500 = 2.7059
?
Quick ratio = Cash + Accounts receivable / Current liabilities
= (34400+36600) / 59500 = 1.1933
?
Working capital = Current assets - Current liabilities
= 161000 - 59500 = 101500
?
Accounts receivable turnover = credit sales / average accounts receivable
= 881500 / (34750+36600) / 2 = 24.7092
?
Average collection period = 365 / Accounts receivable turnover
=365 / 24.71 = 14.7718
?
Inventory turnover = Cost of goods sold / Average inventory
= 693900 / (62400+90000) / 2 = 9.1063
?
Days in inventory = Number of days in the period / Inventory turnover
=365 / 9.11 = 40.0821
?
Debt to total assets ratio = Total liabilites / Total assets
= (59500+35000) / 418100 = 0.2260
?
Gross profit ratio = Gross profit / Sales
= 187600 / 881500 = 0.2128
?
Profit margin ratio = Profit / Sales
= 65800 / 881500 = 0.0746
?
Return on assets ratio = Net profit / Average total assets
= 65800 / (469225+418100) / 2 = 0.1490
?
Asset turn over ratio = Net sales / Average total assets
= 881500 / (469225+418100) / 2 = 1.9959

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

The Pricing Strategy Audit

Authors: Kent B. Monroe

1st Edition

1907766006, 978-1907766008

More Books

Students also viewed these Accounting questions

Question

6. How do histories influence the process of identity formation?

Answered: 1 week ago