In: Accounting
EXCESS CAPACITY
Krogh Lumber's 2016 financial statements are shown here.
Krogh Lumber: Balance Sheet as of December 31, 2016 (Thousands of Dollars) | ||||
Cash | $1,800 | Accounts payable | $7,200 | |
Receivables | 10,800 | Notes payable | 3,472 | |
Inventories | 12,600 | Accrued liabilities | 2,520 | |
Total current assets | $25,200 | Total current liabilities | $13,192 | |
Mortgage bonds | 5,000 | |||
Net fixed assets | 21,600 | Common stock | 2,000 | |
Retained earnings | 26,608 | |||
Total assets | $46,800 | Total liabilities and equity | $46,800 |
Krogh Lumber: Income Statement for December 31, 2016 (Thousands of Dollars) | |||
Sales | $36,000 | ||
Operating costs including depreciation | 30,783 | ||
Earnings before interest and taxes | $5,217 | ||
Interest | 1,017 | ||
Earnings before taxes | $4,200 | ||
Taxes (40%) | 1,680 | ||
Net income | $2,520 | ||
Dividends (60%) | $1,512 | ||
Addition to retained earnings | $1,008 |
Krogh Lumber Pro Forma Income Statement December 31, 2017 (Thousands of Dollars) | |||
2016 | 2017 | ||
Sales | $36,000 | $ | |
Operating costs (includes depreciation) | 30,783 | ||
EBIT | $5,217 | $ | |
Interest expense | 1,017 | ||
EBT | $4,200 | $ | |
Taxes (40%) | 1,680 | ||
Net Income | $2,520 | $ | |
Dividends | $1,512 | $ | |
Addition to RE | $1,008 | $ |
Krogh Lumber Pro Forma Balance Statement December 31, 2017 (Thousands of Dollars) | |||
2016 | 2017 | ||
Assets | |||
Cash | $1,800 | $ | |
Accounts receivable | 10,800 | ||
Inventories | 12,600 | ||
Fixed assets | 21,600 | ||
Total assets | $46,800 | $ | |
Liabilities and Equity | |||
Payables + accruals | $9,720 | $ | |
Short-term bank loans | 3,472 | ||
Total current liabilities | $13,192 | $ | |
Long-term bonds | 5,000 | ||
Total liabilities | $18,192 | $ | |
Common stock | 2,000 | ||
Retained earnings | 26,608 | ||
Total common equity | $28,608 | $ | |
Total liab. and equity | $46,800 | $ |
We need to consider following Ration to develop balance sheet - year 2017 | |||
Income Statement Projection | |||
Yesr 2016 $'00 | Yesr 2017 $'000 | ||
Sales | 36,000 | 46,800 | 30% increase in 2017 as cpmpared with Yr 2016 |
Operating Cost | 30,783 | 39,780 | Operating cost to sales ratio =85% |
Operatimg margin | 5,217 | 7,020 | |
Gross Profit % | 14% | 15% | |
Interest expenses | 1,017 | 1,172 | 11.5% on
( Total Debt= Short + Long dent) 11.5%* ( 3568+6627) |
EBT | 4,200 | 5,848 | |
Less - tax@40% | 1,680 | 2,339 | |
Net income | 2,520 | 3,509 | |
Dividend @60% | 1,512 | 2,105 | |
net profit | 1,008 | 1,403 |
Yesr 2016 $'00 | Yesr 2017 $'000 | Remarks | |
Balance Sheet | |||
Cash | 1,800 | 2,340 | As per Question - all assets will grow at the same rate as sales -30% |
Account Receivable | 10,800 | 14,040 | |
Inventories | 12,600 | 16,380 | |
Fixed asset | 21,600 | 21,600 | |
Total Asset | 46,800 | 54,360 | |
Paybale + Accual | 9,720 | 12,636 | |
Short term bank Loan | 3,472 | 3,568 | 35%
*(Total Debt- Payable ) 35% *(22831-12636) |
Total current Liability | 13,192 | 16,204 | |
Long term Bond | 5,000 | 6,627 | 65%
*(Total Debt- Payable ) 65% *(22831-12636) |
Total Debt- Liability | 18,192 | 22,831 | 42% of $ 54360 |
Common Stock | 2,000 | 3,518 | plug in |
Retained earning | 26,608 | 28,011 | Closing
Balance $26608+$1403 |
Total Equity | 28,608 | 31,529 | |
Total Liability+ Equity | 46,800 | 54,360 |