Question

In: Finance

Dec. 31, 2015 Dec. 31, 2014 Assets Cash and cash equivalents 129,852 593,175 Accounts receivable, net...

Dec. 31, 2015 Dec. 31, 2014
Assets
Cash and cash equivalents 129,852 593,175
Accounts receivable, net 433,638 279,835
Inventories 783,031 536,714
Prepaid expenses and other current assets 152,242 87,177
Deferred income taxes 52,498
Total current assets 1,498,763 1,549,399
Property and equipment, net 538,531 305,564
Goodwill 585,181 123,256
Intangible assets, net 75,686 26,230
Deferred income taxes 92,157 33,570
Other long-term assets 78,582 57,064
Total assets 2,868,900 2,095,083
Liabilities and Stockholders Equity
Accounts payable 200,460 210,432
Accrued expenses 192,935 147,681
Current maturities of long term-debt 42,000 28,951
Other current liabilities 43,415 34,563
Total current liabilities 478,810 421,627
Long-term debt, net of current maturities 352,000 255,250
Long-term line of credit, noncurrent 275,000 0
Other long-term liabilities 94,868 67,906
Total liabilities 1,200,678 744,783
Stockholders' equity
Additional paid-in capital 636,630 508,350
Retained earnings 1,076,533 856,687
Accumulated other comprehensive loss -45,013 -14,808
Total stockholders' equity 1,668,150 1,350,229
Total liabilities and stockholders' equity 2,868,828 2,095,012

A) Compute the current ratio and quick ratio for 2015 and 2014. Comment on any observed trends.

B) Compute times interest earned and liabilities to equity ratios for 2015 and 2014. Comment on any noticeable changes.

C) Summarize your findings about the company's liquidity and solvency. Do you have any concerns about its ability to met its debt obligations?

Solutions

Expert Solution

1. Current Ratio is a comparison of current assets to current liabilities, calculated by dividing the total current assets by total current liabilities.

Thus for 2014, Total Current Asset: 1,549,399

Total Current Liabilities: 421,627

Current Ratio for 2014 would be: = 3.67:1

For 2015, Total Current Asset:1,498,763

Total Current Liabilities: 478,810

Current Ratio for 2015 would be: = 3.13:1

2. Quick assets are current assets that can be converted to cash within 90 days or in the short-term. Cash, cash equivalents, short-term investments or marketable securities, and current accounts receivable are considered quick assets. The formula as per the question above would be: (Cash and cash equivalents+Accounts receivable, net/Total Current Liabilities)

Thus for 2014 =

(593,175+279,835)/421,627

= 2.071

For 2015

(129,852+433,638)/478,810 = 1.177

3.

1. Account receivables have increased significantly in 2015, impacting the cash position of the company.
2. Prepaid expenses have risen sharply in 2015, indicating good future planning related to expenses.
3. Significant rise in Assets (Goodwill, intangible assets and Property & instruments)

4. Decline in liquidity rations from 2014 to 2015, however both current and quick ratios are at comfortable levels.

5. In 2015, the firm has taken a long term credit line of 275,000, impacting the long term liquidity situation of the company,


Related Solutions

Dec. 31, 2015 Dec. 31, 2014 Assets Cash and cash equivalents 129,852 593,175 Accounts receivable, net...
Dec. 31, 2015 Dec. 31, 2014 Assets Cash and cash equivalents 129,852 593,175 Accounts receivable, net 433,638 279,835 Inventories 783,031 536,714 Prepaid expenses and other current assets 152,242 87,177 Deferred income taxes 52,498 Total current assets 1,498,763 1,549,399 Property and equipment, net 538,531 305,564 Goodwill 585,181 123,256 Intangible assets, net 75,686 26,230 Deferred income taxes 92,157 33,570 Other long-term assets 78,582 57,064 Total assets 2,868,900 2,095,083 Liabilities and Stockholders Equity Accounts payable 200,460 210,432 Accrued expenses 192,935 147,681 Current maturities...
Dec. 31, 20Y3 Dec. 31, 20Y2 Assets Cash $269,150 $248,070 Accounts receivable (net) 97,500 89,090 Inventories...
Dec. 31, 20Y3 Dec. 31, 20Y2 Assets Cash $269,150 $248,070 Accounts receivable (net) 97,500 89,090 Inventories 275,250 263,780 Investments 0 102,200 Land 141,180 0 Equipment 303,680 233,220 Accumulated depreciation—equipment (71,100) (62,890) Total assets $1,015,660 $873,470 Liabilities and Stockholders' Equity Accounts payable (merchandise creditors) $183,830 $172,070 Accrued expenses payable (operating expenses) 18,280 22,710 Dividends payable 10,160 7,860 Common stock, $10 par 54,850 42,800 Paid-in capital: Excess of issue price over par-common stock 206,180 118,790 Retained earnings 542,360 509,240 Total liabilities and...
Dec. 31, 20Y6 Dec. 31, 20Y5 Assets Cash $273,020 $256,310 Accounts receivable (net) 98,900 92,060 Inventories...
Dec. 31, 20Y6 Dec. 31, 20Y5 Assets Cash $273,020 $256,310 Accounts receivable (net) 98,900 92,060 Inventories 279,200 272,560 Investments 0 105,590 Land 143,210 0 Equipment 308,050 240,970 Accumulated depreciation-equipment (72,120) (64,980) Total assets $1,030,260 $902,510 Liabilities and Stockholders' Equity Accounts payable $186,480 $177,790 Accrued expenses payable 18,540 23,470 Dividends payable 10,300 8,120 Common stock, $10 par 55,630 44,220 Paid-in capital: Excess of issue price over par-common stock 209,140 122,740 Retained earnings 550,170 526,170 Total liabilities and stockholders’ equity $1,030,260 $902,510...
Dec. 31, Year 2 Dec. 31, Year 1 ASSETS Current assets: Cash and cash equivalents $...
Dec. 31, Year 2 Dec. 31, Year 1 ASSETS Current assets: Cash and cash equivalents $ 92,069   $ 72,634 Accounts receivables, net 55,947 75,492 Inventories 50,784 53,129 Prepaid expenses    12,112    13,057 Total current assets 210,912 214,312 Equipment 145,444 134,312 Less: Accumulated depreciation (50,515) (36,689) Total assets $305,841 $311,935 LIABILITIES AND STOCKHOLDERS’ EQUITY Current liabilities: Accounts payable $ 25,466 $ 34,879 Accrued liabilities     40,574     40,722 Total current liabilities     66,040     75,601 Long-term debt     10,422    ...
Devin E Corporation Balance Sheet As of December 31, 2015 2014 Assets: Cash & Cash Equivalents...
Devin E Corporation Balance Sheet As of December 31, 2015 2014 Assets: Cash & Cash Equivalents $41,900 $25,000 Accounts Receivable 24,000 6,250 Inventory 30,000 36,000      Current Assets 95,900 67,250 Land 25,000 10,000 Equipment 42,000 38,500 Less: Accumulated Depreciation (14,000) (7,000) 53,000 41,500 Total Assets 148,900 108,750 Liabilities: Accounts Payable 17,500 22,500 Accrued Salaries Payable 5,500 8,000 Rent Expense Payable 2,200 1,000 Income Tax Payable 6,900 4,000 Current Liabilities 32,100 35,500 Long-term notes payable 50,000 30,000 Total Liabilities 82,100 65,500...
Cash and cash equivalents, Dec. 31 prior year-end $ 45,000 Cash and cash equivalents, Dec. 31...
Cash and cash equivalents, Dec. 31 prior year-end $ 45,000 Cash and cash equivalents, Dec. 31 current year-end 126,540 Cash received as interest 4,500 Cash paid for salaries 130,500 Bonds payable retired by issuing common stock (no gain or loss on retirement) 140,000 Cash paid to retire long-term notes payable 225,000 Cash received from sale of equipment 110,250 Cash received in exchange for six-month note payable 45,000 Land purchased by issuing long-term note payable 81,200 Cash paid for store equipment...
balance sheet 12/31/2014 12/31/2015 Assets Current Assets Cash in bank $     57,000 $    65,000 Accounts receivable         75,00
balance sheet 12/31/2014 12/31/2015 Assets Current Assets Cash in bank $     57,000 $    65,000 Accounts receivable         75,000        82,000 Inventory         66,000        75,000 Prepaid expenses           6,000          8,000 Total Current Assets $   204,000 $   230,000 Fixed Assets Machinery & equipment $     25,200 $    18,000 Total Fixed Assets (net of depreciation) $     25,200 $    18,000 TOTAL Assets $   229,200 $   248,000 Liabilities and Equity Current Liabilities Accounts payable $     89,000 $    90,000 Total Current Liabilities $     89,000 $    90,000 Long-term Debt Bank loans payable $     62,000 $    50,000 Total Long-term Debt $     62,000 $    50,000 Total Liabilities $   151,000 $   140,000 Owners' Equity         78,200...
Assets 2019 2018 Amount Cash & equivalents $20,000.00 Cash & equivalents $10,000.00 Accounts Receivable $15,000.00 Accounts...
Assets 2019 2018 Amount Cash & equivalents $20,000.00 Cash & equivalents $10,000.00 Accounts Receivable $15,000.00 Accounts Receivable $25,000.00 Inventory $10,000.00 Inventory $15,000.00 Total current assets $45,000.00 Total current assets $50,000.00 Net Plant and equipment $50,000.00 Net Plant and equipment $60,000.00 Total assets $95,000.00 Total assets $110,000.00 Liabilities and equity Liabilities and equity Accounts payable $5,000.00 Accounts payable $7,000.00 Accruals $2,000.00 Accruals $3,000.00 Notes payable $10,000.00 Notes payable $5,000.00 Total current liabilities $17,000.00 Total current liabilities $15,000.00 Long term debts $25,000.00...
1 Dec. 31, 20Y8 Dec. 31, 20Y7 2 Assets 3 Cash $146,480.00 $179,640.00 4 Accounts receivable...
1 Dec. 31, 20Y8 Dec. 31, 20Y7 2 Assets 3 Cash $146,480.00 $179,640.00 4 Accounts receivable (net) 225,010.00 241,920.00 5 Inventories 321,600.00 298,870.00 6 Prepaid expenses 13,030.00 10,420.00 7 Equipment 654,380.00 537,900.00 8 Accumulated depreciation-equipment (169,970.00) (133,130.00) 9 Total assets $1,190,530.00 $1,135,620.00 10 Liabilities and Stockholders’ Equity 11 Accounts payable (merchandise creditors) $240,960.00 $236,720.00 12 Mortgage note payable     0.00 335,410.00 13 Common stock, $10 par 510,000.00 247,000.00 14 Paid-in capital: Excess of issue price over par—common stock 430,000.00 310,000.00 15...
Cash and cash equivalents balance, December 31, 2014 $ 38,000 Cash and cash equivalents balance, December...
Cash and cash equivalents balance, December 31, 2014 $ 38,000 Cash and cash equivalents balance, December 31, 2015 106,856 Cash received as interest 3,800 Cash paid for salaries 110,200 Bonds payable retired by issuing common stock (no gain or loss on retirement) 170,000 Cash paid to retire long-term notes payable 190,000 Cash received from sale of equipment 93,100 Cash received in exchange for six-month note payable 38,000 Land purchased by issuing long-term note payable 98,600 Cash paid for store equipment...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT