In: Accounting
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 | $ |
Solution:
Part A Increase in percentage of sales
Sales for the year 2016 = $ 36,000 (thousand dollars)
It is stated in that question that above sales is after utilising 64% of the total assets.
So, Sales at 100% utilisation is $36000/64% =$56,250 (thousand dollars)
Increase in sales percentage = {(56250-36000)/36000}*100
which is 56.25%
Part B
Notes: Related workings are given in the right side of the cell itself. It is better to anaylse Income statement with balance sheet at same time for better understanding.
In case of Short term bank loans, no info is given. Hence same figure of previous year is taken.
If sales increases by 25% then sales will be $36000*125%, which is $45,000(thousands in dollars)
Krogh Lumber's Pro Forma Income statement December 31,2017
Particular | 2016 ($thousand dollars) | 2017($ thousand dollars) | |
Sales | 36,000 | 45,000 | |
Operating costs (includes depreciation) | 30,783 | 36,000 | 80% of sales |
EBIT | 5,217 | 9,000 | |
Interest Expenses | 1,017 | 2,342 | total liabilities * 10.5% |
EBT | 4,200 | 6,658 | |
Taxes (40%) | 1,680 | 2,663 | 40% of EBT |
Net Income | 2,520 | 3,995 | |
Dividends | 1,512 | 2,397 | 60% of net income |
Addition to RE | 1,008 | 1,598 |
Krogh Lumber's Proforma Balance Sheet for December 31,2017
Assets | 2016 ($thousand of dollars) | 2017($ thousands of dollars) | |
Cash | 1,800 | 2,250 | (Increase by 25%) |
Accounts Receivable | 10,800 | 13,500 | (Increase by 25%) |
Inventories | 12,600 | 15,750 | (Increase by 25%) |
Fixed Assets | 21,600 | 21,600 | No Change |
Total Assets | 46,800 | 53,100 |
Liabilities and Assets | 2016 ($thousand of dollars) | 2017($ thousands of dollars) | |
Payables + Accruals | 9,720 | 7,806 | (35% of total liabilities) |
Short term bank loans | 3,472 | 3,472 | (No further details given, hence unchanged) |
Total Current Liabilities | 13,192 | 11,278 | |
Long term bonds | 5,000 | 11,024 | (Total liabilities-Total current liabilities)-Balancing Figure |
Total Liabilities | 18,192 | 22,302 | (42% of total assets) |
Common Stock | 2,000 | 2,592 | (Total liab and eq-Retained earnings-total liabilties) |
Retained Earnings | 26,608 | 28,206 | |
Total Common Equity | 28,608 | 30,798 | |
Total Liab. And equity | 46,800 | 53,100 |