Question

Assume that sales will grow at 5.00%. The following accounts (cash, accounts receivable, inventory, net fixed assets, accounts payable and accruals, as well as operating costs) are assumed to change with sales and will maintain their current percentage of sales rates into 2016. The dividend payout ratio will remain the same. Long-term debt and notes payable will remain constant into 2016 as will interest expense, as a result. The firm also does not plan to issue any additional common stock or conduct any share repurchases. The firm’s tax rate is 40%. Any additional funds needed will be sourced through a line-of-credit (LOC) and surpluses will be paid out through a special dividend.

	2015
Sales	$1,445.00
Operating Costs:	$1,245.00
EBIT	$200.00
Interest	$35.00
Earnings Before Taxes	$165.00
Taxes (40%)	$66.00
Net Income	$99.00
Dividends	$49.50
Addition to Retained Earnings	$49.50

BALANCE SHEET AS OF 12/31/2015:

ASSETS	2015
Cash	$72.25
Accounts Receivable	$144.50
Inventory	$289.00
Current Assets	$505.75
Net Fixed Assets (Net PPE)	$361.25
Total Assets (TA)	$867.00

LIABILITIES & SHAREHOLDER EQUITY	2015
Accounts Payable and Accruals	$36.13
Notes Payable	$40.00
Current Liabilities	$76.13
Long Term Debt	$310.00
Total Liabilities	$386.13
Common Stock	$300.00
Retained Earnings	$180.88
Owners' Equity	$480.88
Total Liabilities and Shareholder Equity	$867.00

In the following questions, determine the percentage-of-sale forecast factors:

Accounts Payable & Accruals:
Operating Costs:
Cash:
Accounts Receivable:
Inventory:
Net Fixed Assets (NFA):

Answer 1

2015
Sales	$1,445.00
Operating Costs:	$1,245.00
% of sales	86.2%
EBIT	$200.00
% of sales	13.8%
Interest	$35.00
Earnings Before Taxes	$165.00
% of sales	11.4%
Taxes (40%)	$66.00
Net Income	$99.00
% of sales	6.9%
Dividends	$49.50
Dividend payout %	50.0%
Addition to Retained Earnings	$49.50
ALANCE SHEET AS OF 12/31/2015:
ASSETS	2015
Cash	$72.25
% of sales	5.0%
Accounts Receivable	$144.50
% of sales	10.0%
Inventory	$289.00
% of sales	20.0%
Current Assets	$505.75
Net Fixed Assets (Net PPE)	$361.25
% of sales	25.0%
Total Assets (TA)	$867.00
LIABILITIES & SHAREHOLDER EQUITY	2015
Accounts Payable and Accruals	$36.13
% of sales	2.5%
Notes Payable	$40.00
Current Liabilities	$76.13
Long Term Debt	$310.00
Total Liabilities	$386.13
Common Stock	$300.00
Retained Earnings	$180.88
Owners' Equity	$480.88
Total Liabilities and Shareholder Equity	$867.00
percentage-of-sale forecast factors as calculared above:
Accounts Payable & Accruals:	2.5%
Operating Costs:	86.2%
Cash:	5.0%
Accounts Receivable:	10.0%
Inventory:	20.0%
Net Fixed Assets (NFA):	25.0%