Question

3. Mobile Company manufactures computer technology devices. Selected financial data for Mobile is presented below, use the information to answer the following questions:
(Hint: Review Chapter 5 PowerPoint notes and Chapter 5 formula sheet.)

Current Assets	As of Dec. 31, 2017	Dec. 31, 2016
Cash and short-term investments	$1,267,038	$   616,604
Accounts Receivable (net)	490,816	665,828
Inventories	338,599	487,505
Prepaid Expenses and other current assets	292,511	291,915
Total Current Assets	$2,388,964	$2,061,852
Current Liabilities
Short-term borrowings	$   25,190	$   38,108
Current portion of long-term debt	182,295	210,090
Accounts payable	296,307	334,247
Accrued liabilities	941,912	743,999
Income taxes payable	203,049	239,793
Total Current Liabilities	1,648,753	1,566,237

Selected Income Statement Data - for the year ending December 31, 2017:
Net Sales	$4,880,000
Cost of Goods Sold	2,542,353
Operating Income	733,541
Net Income	230,101

Selected Statement of Cash Flow Data - for the year ending December 31, 2017:
Cash Flows from Operations	$1,156,084

Please compute the financial ratios below for 2017. Show your calculations and enter your results into the table below.

	2017
Current Ratio
Operating Cash Flow to Current Liabilities Ratio
Days Accounts Receivables Outstanding
Days Accounts Payable Outstanding
Inventory Turnover

Answer 1

a.

Current ratio = Current assets / Current Liabilities

= $2,388,964 / $1,648,753

= 1.45

Current Ratio is 1.45.

b.

Operating Cash Flow to Current Liabilities Ratio= Operating cash flow / Current Liabilities

= $1,156,084 / $1,648,753

= 0.70

Operating Cash Flow to Current Liabilities Ratio is 0.70.

c.

Days Accounts Receivables Outstanding = Accounts Receivables / (Sales / 365)

= $490,816 / ($4,880,000 / 365)

= $490,816 / $13,369.86

= 36.71 days

Days Accounts Receivables Outstanding is 36.71 days.

d.

Days Accounts Payables Outstanding = Accounts Receivables / (COGS / 365)

= $296,307 / ($2,542,353 / 365)

= $296,307 / $6,965.35

= 42.54 days

Days Accounts payables Outstanding is 42.54 days.

e.

Inventory turnover = COGS / Value of inventory

= $2,542,353 / $338,599

= 7.51 times

Inventory turnover ratio is 7.51.