Question
Balance Sheet 2014 2015 2016 Assets Cash $9,000 $7,282 $14,000 Short-term investments 48,000 20,000 71,632 Accounts receivable 351,200 632,160 878,000 Inventories 751,200 1,287,360 1,716,480 Total
Balance Sheet | ||||||
2014 | 2015 | 2016 | ||||
Assets | ||||||
Cash | $9,000 | $7,282 | $14,000 | |||
Short-term investments | 48,000 | 20,000 | 71,632 | |||
Accounts receivable | 351,200 | 632,160 | 878,000 | |||
Inventories | 751,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 | $39,790 | $36,840 | |||
Total assets | $1,468,800 | $2,886,592 | $,516,952 | |||
2011 | 2012 | 2013 | ||||
Liabilities & Equity | ||||||
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,800 | 460,000 | 1,680,936 | |||
Retained earnings | 203,768 | 97,632 | 296,216 | |||
Total equity | $663,768 | $557,632 | $1,977,152 | |||
Total liabilities & Equity | $1,468,800 | $2,886,592 | $3,516,952 | |||
Note: E denotes, estimated ; the 2013 data for forecasts. | ||||||
Income Statement | ||||||
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 & Amortization | 18,900 | 116,960 | 120,000 | |||
Total operating Cost | $3,222,900 | $5,816,960 | $6,532,962 | |||
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 | ||||||
Stock price | $8.50 | $6.00 | $12.17 | |||
Shares outstanding | 100,000 | 100,000 | 250,000 | |||
2011 | 2012 | 2013E | ||||
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 payment | $40,000 | $40,000 | $40,000 | |||
Note: E denotes estimated ; the 2013 data are forecasts. | ||||||
Ratio Analysis | ||||||
2014 | 2015 | 2016E | 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.3 | 39.6 | ------------------ | 32.0 | ||
Fixed assets turnover | 10.0 | 6.2 | ----------------- | 7.0 | ||
Total assets turnover | 2.3 | 2.0 | --------------- | 2.5 | ||
Debt ratio | 54.8% | 80.7% | -------------- | 50.0% | ||
TIE | 3.3 | 0.1 | -------------- | 6.2 | ||
EBITDA Coverage | 2.6 | 0.8 | -------------- | 8.0 | ||
Profit margin | 2.6% | -1.6% | -------------- | 3.6% | ||
Basic earning power | 14.2% | 0.6% | -------------- | 17.8% | ||
ROA | 6.0% | -3.3% | -------------- | 9.0% | ||
ROE | 13.3% | -17.1% | -------------- | 17.9% | ||
Price / Earnings (P/E) | 9.7 | -6.3 | -------------- | 16.2 | ||
Price / Cash flow | 8.0 | 27.5 | ------------- | 7.6 | ||
Market / Book | 1.3 | 1.1 | ------------- | 2.9 | ||
Use the extended DuPont equation to provide a summary and overview of Computrons finan- cial condition as projected for 2016. What are the firms major strengths and weaknesses?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started