home / homework help / questions and answers / business / finance / financing deficit stevens textile's 2013 financial ...

Question

Financing Deficit

Stevens Textile's 2013 financial statements are shown below:

Balance Sheet as of December 31, 2013 (Thousands of Dollars)

Cash	$ 1,080		Accounts payable	$ 4,320
Receivables	6,480		Accruals	2,880
Inventories	9,000		Line of credit	0
Total current assets	$16,560		Notes payable	2,100
Net fixed assets	12,600		Total current liabilities	$ 9,300
			Mortgage bonds	3,500
			Common stock	3,500
			Retained earnings	12,860
Total assets	$29,160		Total liabilities and equity	$29,160

Income Statement for December 31, 2013 (Thousands of Dollars)

Sales	$36,000
Operating costs	32,440
Earnings before interest and taxes	$ 3,560
Interest	460
Pre-tax earnings	$ 3,100
Taxes (40%)	1,240
Net income	$ 1,860
Dividends (45%)	$ 837
Addition to retained earnings	$ 1,023

Suppose 2014 sales are projected to increase by 10% over 2013 sales. Use the forecasted financial statement method to forecast a balance sheet and income statement for December 31, 2014. The interest rate on all debt is 7%, and cash earns no interest income. Assume that all additional debt in the form of a line of credit is added at the end of the year, which means that you should base the forecasted interest expense on the balance of debt at the beginning of the year. Use the forecasted income statement to determine the addition to retained earnings. Assume that the company was operating at full capacity in 2013, that it cannot sell off any of its fixed assets, and that any required financing will be borrowed as notes payable. Also, assume that assets, spontaneous liabilities, and operating costs are expected to increase by the same percentage as sales. Determine the additional funds needed. Round your answers to the nearest dollar. Do not round intermediate calculations.Calculate AFN and Notes Payable?

12-8
Key Input Data:		Used in the
		forecast
Sales Increase		15%
Tax rate		40%
Dividend Payout Ratio		45%
Interest Rate on Loans		10%
		(000)
		2010	Forecasting	2010			2011	2011
		Actual	basis	Ratios			Inputs	Forecast
Sales		$36,000	Growth				???	???
Expenses (excluding depr. & amort.)		$32,440	% of sales	???			???	???
EBIT		$3,560						???
Net Interest Expense		$460	Interest rate x beginning of year debt					???
EBT		$3,100						???
Taxes (40%)		$1,240						???
Net Income		$1,860						???
Common dividends		$837	Payout Ratio				???	???
Addition to retained earnings (DRE)		$1,023						???
		(000)						(000)
		2010	Forecasting	2010			2011
		Actual	basis	Ratios			Inputs	Without AFN		AFN	With AFN
Assets:
Cash and cash equivalents	A*	1,080.00	% of sales	???			???	???			???
Short-term investments	A*	-	Previous					???		???	???
Accounts Receivable	A*	6,480.00	% of sales	???			???	???			???
Inventories	A*	9,000.00	% of sales	???			???	???			???
Total current assets	A*	16,560.00						???			???
Fixed assets	A*	12,600.00	% of sales	???			???	???			???
Total assets	A*	29,160.00						???			???
Liabilities and equity
Accounts payable	L*	4,320.00	% of sales	???			???	???			???
Accruals	L*	2,880.00	% of sales	???			???	???			???
Notes payable		2,100.00	Previous					???		???	???
Total current liabilities		9,300.00						???			???
Long-term debt		3,500.00	Previous					???			???
Total liabilities		12,800.00						???			???
Common stock		3,500.00	Previous					???			???
Retained Earnings		12,860.00	Previous + Change in R/E				???	???			???
Total common equity		16,360.00						???			???
Total liabilities and equity		29,160.00						???			???
Required assets =								???
Specified sources of financing =								???
Additional funds needed (AFN) =								???
Required additional notes payable =								???
Additional short-term investments =								???