Question

Please calculate the ratios for 2016 and prepare an analysis of where the company is now,...

Please calculate the ratios for 2016 and prepare an analysis of where the company is now, where the strengths are and the weaknesses are, what it must do to regain its financial health, and what actions should be taken.  
include detailed math calculation steps, final results, clear verbal explanation on weaknesses and strengths, and your recommendations.   
Balance Sheets
Assets
2014
2015
2016
Cash
$         9,000
$        7,282
$       14,000
Short-Term Investments.
48,600
20,000
71,632
Accounts Receivable
351,200
632,160
878,000
Inventories
715,200
1,287,360
1,716,480
  Total Current Assets
$  1,124,000
$ 1,946,802
$  2,680,112
Gross Fixed Assets
491,000
1,202,950
1,220,000
Less: Accumulated Depreciation
146,200
263,160
383,160
  Net Fixed Assets
$     344,800
$    939,790
$     836,840
Total Assets
$  1,468,800
$ 2,886,592
$  3,516,952
Liabilities And Equity
2014
2015
2016
Accounts Payable
$     145,600
$    324,000
$     359,800
Notes Payable
200,000
720,000
300,000
Accruals
136,000
284,960
380,000
  Total Current Liabilities
$     481,600
$ 1,328,960
$  1,039,800
Long-Term Debt
323,432
1,000,000
500,000
Common Stock (100,000 Shares)
460,000
460,000
1,680,936
Retained Earnings
203,768
97,632
296,216
  Total Equity
$     663,768
$    557,632
$  1,977,152
Total Liabilities And Equity
$  1,468,800
$ 2,886,592
$  3,516,952
Income Statements
2014
2015
2016
Sales
$  3,432,000
$ 5,834,400
$  7,035,600
Cost Of Goods Sold
2,864,000
4,980,000
5,800,000
Other Expenses
340,000
720,000
612,960
Depreciation
18,900
116,960
120,000
  Total Operating Costs
$  3,222,900
$ 5,816,960
$  6,532,960
  EBIT
$     209,100
$      17,440
$     502,640
Interest Expense
62,500
176,000
80,000
  EBT
$     146,600
$  (158,560)
$     422,640
Taxes (40%)
58,640
(63,424)
169,056
Net Income
$       87,960
$    (95,136)
$     253,584
Other Data
2014
2015
2016
Stock Price
$           8.50
$          6.00
$         12.17
Shares Outstanding
100,000
100,000
250,000
EPS
$         0.880
$      (0.951)
$         1.014
DPS
$         0.220
$        0.110
$         0.220
Tax Rate
40%
40%
40%
Book Value Per Share
$         6.638
$        5.576
$         7.909
Lease Payments
$       40,000
$      40,000
$       40,000
Ratio Analysis
2014
2015
2016
Industry Average
Current
2.3
1.5
2.7
Quick
0.8
0.5
1.0
Inventory Turnover
4.8
4.5
6.1
Days Sales Outstanding
             37.4
            39.5
32.0

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1
Ratio analysis of 2016:
Ratios Formula Calculation 2016 Result 2016 Industry Avg. Remark on comparison
Current ratio CA/CL 2680112/1039800 2.6 2.7 company is performing in parallel to industry
Quick ratio CA-Inve./CL (2680112-1716480)/1039800 0.9 1 company is performing inferior to industry
Inventory Turnover COGS/avg Inventory 5800000*2/(1287360+1716480) 3.9 6.1 company would not able to move inventory as industry is doing
Days Sales Outstanding 365/AR turnover 365/(7035600*2 /(632160+878000)) 39.2 32 company is providing more credit to its customers in comparison to industry.
0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Using XYZ Company's income statements and balance sheets below, compute the company's cash conversation cycle (CCC)....
Using XYZ Company's income statements and balance sheets below, compute the company's cash conversation cycle (CCC). 2015 2014 Assets Cash $ 85,632 $ 84,530 Accounts receivable 878,000 778,000 Inventories 1,716,480 1,820,330 Total current assets $ 2,680,112 $ 2, 682,860 Gross fixed assets 1,197,160 1,197,160 Less accumulated depreciation 380,120 390,255 Net fixed assets $ 817,040 $ 806,905 Total assets $ 3,497,152 $ 2,690,930 Liabilities and Equity Accounts payable $ 436,800 $ 525,700 Accruals 408,000 395,000 Notes payable 300,000 300,000 Total current...
Bethesda Mining Company reports the following balance sheet information for 2015 and 2016. Prepare the 2015...
Bethesda Mining Company reports the following balance sheet information for 2015 and 2016. Prepare the 2015 and 2016 common-size balance sheets for Bethesda Mining. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) BETHESDA MINING COMPANY Balance Sheets as of December 31, 2015 and 2016 2015 2016 2015 2016 Assets Liabilities and Owners’ Equity Current assets Current liabilities Cash $ 65,470 % $ 82,487 % Accounts payable $ 186,922 %...
HYDRO COMPANY Balance Sheet December 31, 2015 Cash $40,000 Current liabilities $80,000 Accounts receivable (net) 80,000...
HYDRO COMPANY Balance Sheet December 31, 2015 Cash $40,000 Current liabilities $80,000 Accounts receivable (net) 80,000 10% Bonds payable 120,000 Inventory 130,000 Common Stock 200,000 Plant and equipment (net) 250,000 Retained earnings 100,000 Total assets $500,000 Total Liabilities and Stockholders' Equity $500,000 Sales revenues for 2015 were $800,000, gross profit was $320,000, and net income was $36,000. The income tax rate was 40 percent. One year ago, accounts receivable (net) were $76,000, inventory was $110,000, total assets were $460,000, and...
14 Compare the reasons for the changes in return on equity for Eastnorth Manufacturing and its...
14 Compare the reasons for the changes in return on equity for Eastnorth Manufacturing and its industry. Balance Sheets for INDUSTRY: December 31 2017 2016 2015 ASSETS Cash and marketable securities $30,000 $25,000 $20,000 Accounts receivable 110,000 90,000 60,000 Inventories 100,000 80,000 80,000 Total current assets 240,000 195,000 160,000 Gross plant and equipment 250,000 220,000 200,000 Less: accumulated depreciation −100,000 −65,000 −50,000 Net plant and equipment 150,000 155,000 150,000 Land 50,000 50,000 50,000 Total fixed assets 200,000 205,000 200,000 Total...
The most recent financial statements for Moose Tours, Inc., appear below. Sales for 2016 are projected...
The most recent financial statements for Moose Tours, Inc., appear below. Sales for 2016 are projected to grow by 25 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. MOOSE TOURS, INC. 2015 Income Statement   Sales $ 753,000   Costs 588,000   Other expenses 24,000   Earnings before interest and taxes $ 141,000   Interest expense 10,000   Taxable income $ 131,000...
CHAPTER 2 PROBLEMS/CORPORATE FINANCE P2-1       The following data apply to A.L. Kaiser & Company ($ million):...
CHAPTER 2 PROBLEMS/CORPORATE FINANCE P2-1       The following data apply to A.L. Kaiser & Company ($ million): Cash and equivalents………………………………………………………………………………………………….$100.00 Fixed assets…………………………………………………………………………………………………………………$283.50 Sales$..............................................................................................................................1,000.00 Net income………………………………………………………………………………………………………………….$50.00 Quick ratio…………………………………………………………………………………………………...................2.0x Current ratio………………………………………………………………………………………………………………..3.0x DSO ……………………………………………………………………………………………………………………………40.0 days ROE……………………………………………………………………………………………………………………………..12.0% Kaiser has no preferred stock—only common equity, current liabilities, and long-term debt. Find Kaiser’s (1) accounts receivable (A/R), (2) current liabilities, (3) current assets, (4) total assets, (5) ROA, (6) common equity, and (7) long-term debt. P2-2       Data for Unilate Textiles’ 2015 financial statements are given in Tables...
Balance Sheet 2016 2015 2014 Cash 50,000 45000 40,000 Accounts receivable 80,000 70000 60,000 Inventories 180,000...
Balance Sheet 2016 2015 2014 Cash 50,000 45000 40,000 Accounts receivable 80,000 70000 60,000 Inventories 180,000 145000 110,000 Plant & equipment 300,000 280000 260,000 Less accumulated depreciation -40,000 -30000 -20,000 Total assets 570,000 510000 450,000 Accounts payable 100,000 125000 150,000 Accrued liabilities 70,000 60000 50,000 Mortgage payable 80,000 40000 60,000 Common stock 130,000 110000 90,000 Retained earnings 190,000 175000 160,000 Total liabilities and equity 570,000 510000 450,000 Income Statement 2014 2015 2016 Net Sales 680,000 600,000 640000 Cost of goods...
Green Company is considering acquiring the assets of Gold Corporation by assuming Gold’s liabilities and by...
Green Company is considering acquiring the assets of Gold Corporation by assuming Gold’s liabilities and by making a cash payment. Gold Corporation has the following balance sheet on the date negotiations occur: Gold Corporation Balance Sheet January 1, 2016 Assets Liabilities and Equity Accounts receivable . . . . . . . . . . . . $100,000 Total liabilities . . . . . . . . . . . . . . . . . $200,000 Inventory ....
Alexander Company Comparative Balance Sheets December 31, 2013 and December 13, 2014 Assets 2013 2014 Difference...
Alexander Company Comparative Balance Sheets December 31, 2013 and December 13, 2014 Assets 2013 2014 Difference Cash          40,000       334,000       294,000 Accounts Receivable       255,000       215,000       (40,000) Inventory       430,000       350,000       (80,000) Prepaid Expenses            2,000            1,200             (800) Plant Property & Equipment    1,104,000    1,256,000       152,000 Accumulated Depr - Equipment     (280,000)     (366,000)       (86,000) Total Assets    1,551,000    1,790,200       239,200 Liabilities & Stockholder’s Equity Accounts Payable...
Forten Company, a merchandiser, recently completed its calendar-year 2016 operations. For the year, (1) all sales...
Forten Company, a merchandiser, recently completed its calendar-year 2016 operations. For the year, (1) all sales are credit sales, (2) all credits to Accounts Receivable reflect cash receipts from customers, (3) all purchases of inventory are on credit, (4) all debits to Accounts Payable reflect cash payments for inventory, and (5) Other Expenses are paid in advance and are initially debited to Prepaid Expenses. The company’s income statement and balance sheets follow. FORTEN COMPANY Comparative Balance Sheets December 31, 2016...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT