In: Finance
Joshua & White Technologies: December 31 Balance Sheets | ||||
(Thousands of Dollars) | ||||
Assets | 2016 | 2015 | ||
Cash and cash equivalents | $21,000 | $20,000 | ||
Short-term investments | 3,759 | 3,240 | ||
Accounts Receivable | 52,500 | 48,000 | ||
Inventories | 84,000 | 56,000 | ||
Total current assets | $161,259 | $127,240 | ||
Net fixed assets | 218,400 | 200,000 | ||
Total assets | $379,659 | $327,240 | ||
Liabilities and equity | ||||
Accounts payable | $33,600 | $32,000 | ||
Accruals | 12,600 | 12,000 | ||
Notes payable | 19,929 | 6,480 | ||
Total current liabilities | $66,129 | $50,480 | ||
Long-term debt | 67,662 | 58,320 | ||
Total liabilities | $133,791 | $108,800 | ||
Common stock | 183,793 | 178,440 | ||
Retained Earnings | 62,075 | 40,000 | ||
Total common equity | $245,868 | $218,440 | ||
Total liabilities and equity | $379,659 | $327,240 | ||
Joshua & White Technologies December 31 Income Statements | ||||
(Thousands of Dollars) | ||||
2016 | 2015 | |||
Sales | $420,000 | $400,000 | ||
COGS except excluding depr. and amort. | 300,000 | 298,000 | ||
Depreciation and Amortization | 19,660 | 18,000 | ||
Other operating expenses | 27,600 | 22,000 | ||
EBIT | $72,740 | $62,000 | ||
Interest Expense | 5,740 | 4,460 | ||
EBT | $67,000 | $57,540 | ||
Taxes (40%) | 26,800 | 23,016 | ||
Net Income | $40,200 | $34,524 | ||
Common dividends | $18,125 | $17,262 | ||
Addition to retained earnings | $22,075 | $17,262 | ||
Other Data | 2016 | 2015 | ||
Year-end Stock Price | $90.00 | $96.00 | ||
# of shares (Thousands) | 4,052 | 4,000 | ||
Lease payment (Thousands of Dollars) | $20,000 | $20,000 | ||
Sinking fund payment (Thousands of Dollars) | $5,000 | $5,000 |
e. Perform a common size analysis. What has happened to the composition | ||||||
(that is, percentage in each category) of assets and liabilities? | ||||||
Common Size Balance Sheets | ||||||
Assets | 2016 | 2015 | ||||
Cash and cash equivalents | ||||||
Short-term investments | ||||||
Accounts Receivable | ||||||
Inventories | ||||||
Total current assets | ||||||
Net fixed assets | ||||||
Total assets | ||||||
Liabilities and equity | 2016 | 2015 | ||||
Accounts payable | ||||||
Accruals | ||||||
Notes payable | ||||||
Total current liabilities | ||||||
Long-term debt | ||||||
Total liabilities | ||||||
Common stock | ||||||
Retained Earnings | ||||||
Total common equity | ||||||
Total liabilities and equity | ||||||
Common Size Income Statements | 2016 | 2015 | ||||
Sales | ||||||
COGS except excluding depr. and amort. | ||||||
Depreciation and Amortization | ||||||
Other operating expenses | ||||||
EBIT | ||||||
Interest Expense | ||||||
EBT | ||||||
Taxes (40%) | ||||||
Net Income | ||||||
Joshua & White Technologies: December 31 Balance Sheets | ||||
(Thousands of Dollars) | ||||
% | % | |||
Assets | 2016 | 2015 | ||
Cash and cash equivalents | 21000 | 5.53% | 20000 | 6.11% |
Short-term investments | 3,759 | 0.99% | 3,240 | 0.99% |
Accounts Receivable | 52,500 | 13.83% | 48,000 | 14.67% |
Inventories | 84,000 | 22.13% | 56,000 | 17.11% |
Total current assets | 161259 | 42.47% | 127240 | 38.88% |
Net fixed assets | 2,18,400 | 57.53% | 2,00,000 | 61.12% |
Total assets | 379659 | 100.00% | 327240 | 100.00% |
Liabilities and equity | ||||
Accounts payable | 33600 | 8.85% | 32000 | 9.78% |
Accruals | 12,600 | 3.32% | 12,000 | 3.67% |
Notes payable | 19,929 | 5.25% | 6,480 | 1.98% |
Total current liabilities | 66129 | 17.42% | 50480 | 15.43% |
Long-term debt | 67,662 | 17.82% | 58,320 | 17.82% |
Total liabilities | 133791 | 35.24% | 108800 | 33.25% |
Common stock | 1,83,793 | 48.41% | 1,78,440 | 54.53% |
Retained Earnings | 62,075 | 16.35% | 40,000 | 12.22% |
Total common equity | 245868 | 64.76% | 218440 | 66.75% |
Total liabilities and equity | 379659 | 100.00% | 327240 | 100.00% |
ANALYSIS: | ||||
*The % of current assets to total assets has gone up in 2016 by nearly 4% points. | ||||
*Of the current assets the % of inventory has gone up by more than 5% in 2016 | ||||
*The total current liabilities has gone up by 2%, with the major increase in notes payable. | ||||
*There is an increase of 2% in total liabilities. | ||||
*Within equity, retained earnings composition has increased by more than 4% | ||||
Joshua & White Technologies December 31 Income Statements | ||||
(Thousands of Dollars) | ||||
2016 | % | 2015 | % | |
Sales | 420000 | 100.00% | 400000 | 100.00% |
COGS except excluding depr. and amort. | 3,00,000 | 71.43% | 2,98,000 | 74.50% |
Depreciation and Amortization | 19,660 | 4.68% | 18,000 | 4.50% |
Other operating expenses | 27,600 | 6.57% | 22,000 | 5.50% |
EBIT | 72740 | 17.32% | 62000 | 15.50% |
Interest Expense | 5,740 | 1.37% | 4,460 | 1.12% |
EBT | 67000 | 15.95% | 57540 | 14.39% |
Taxes (40%) | 26,800 | 6.38% | 23,016 | 5.75% |
Net Income | 40200 | 9.57% | 34524 | 8.63% |
Common dividends | 18125 | 4.32% | 17262 | 4.32% |
Addition to retained earnings | 22075 | 5.26% | 17262 | 4.32% |
Other Data | 2016 | 2015 | ||
Year-end Stock Price | $90.00 | $96.00 | ||
# of shares (Thousands) | 4,052 | 4,000 | ||
Lease payment (Thousands of Dollars) | $20,000 | $20,000 | ||
Sinking fund payment (Thousands of Dollars) | $5,000 | $5,000 | ||
ANALYSIS: | ||||
The NI % has increased by about 1% only. | ||||
Though COGS has decreased in %, the operating expenses have gone up. |