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 | ||
| f. Perform a percent change analysis. What does this tell you about the change in profitability | ||||||
| and asset utilization? | ||||||
| Percent Change Balance Sheets | Base | |||||
| Assets | 2016 | 2015 | ||||
| Cash and cash equivalents | ||||||
| Short-term investments | ||||||
| Accounts Receivable | ||||||
| Inventories | ||||||
| Total current assets | ||||||
| Net fixed assets | ||||||
| Total assets | ||||||
| Base | ||||||
| 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 | ||||||
| Base | ||||||
| Percent Change 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 | % Change | ||
| Cash and cash equivalents | $21,000 | $20,000 | 5.00% | ||
| Short-term investments | 3,759 | 3,240 | 16.02% | ||
| Accounts Receivable | 52,500 | 48,000 | 9.38% | ||
| Inventories | 84,000 | 56,000 | 50.00% | ||
| Total current assets | $161,259 | $127,240 | 26.74% | ||
| Net fixed assets | 218,400 | 200,000 | 9.20% | ||
| Total assets | $379,659 | $327,240 | 16.02% | ||
| Liabilities and equity | |||||
| Accounts payable | $33,600 | $32,000 | 5.00% | ||
| Accruals | 12,600 | 12,000 | 5.00% | ||
| Notes payable | 19,929 | 6,480 | 207.55% | ||
| Total current liabilities | $66,129 | $50,480 | 31.00% | ||
| Long-term debt | 67,662 | 58,320 | 16.02% | ||
| Total liabilities | $133,791 | $108,800 | 22.97% | ||
| Common stock | 183,793 | 178,440 | 3.00% | ||
| Retained Earnings | 62,075 | 40,000 | 55.19% | ||
| Total common equity | $245,868 | $218,440 | 12.56% | ||
| Total liabilities and equity | $379,659 | $327,240 | 16.02% | ||
| Joshua & White Technologies December 31 Income Statements | |||||
| (Thousands of Dollars) | |||||
| 2016 | 2015 | 0.05% | |||
| Sales | $420,000 | $400,000 | 5.00% | ||
| COGS except excluding depr. and amort. | 300,000 | 298,000 | 0.67% | ||
| Depreciation and Amortization | 19,660 | 18,000 | 9.22% | ||
| Other operating expenses | 27,600 | 22,000 | 25.45% | ||
| EBIT | $72,740 | $62,000 | 17.32% | ||
| Interest Expense | 5,740 | 4,460 | 28.70% | ||
| EBT | $67,000 | $57,540 | 16.44% | ||
| Taxes (40%) | 26,800 | 23,016 | 16.44% | ||
| Net Income | $40,200 | $34,524 | 16.44% | ||