Question

Stevens Textile Corporation's 2019 financial statements are shown below:

Balance Sheet as of December 31, 2019 (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, 2019 (Thousands of Dollars)

Sales	$36,000
Operating costs	34,000
Earnings before interest and taxes	$ 2,000
Interest	160
Pre-tax earnings	$ 1,840
Taxes (25%)	460
Net income	$ 1,380
Dividends (40%)	$    552
Addition to retained earnings	$ 828

Stevens grew rapidly in 2019 and financed the growth with notes payable and long-term bonds. Stevens expects sales to grow by 10% in the next year but will finance the growth with a line of credit, not notes payable or long-term bonds. Use the forecasted financial statement method to forecast a balance sheet and income statement for December 31, 2020. The interest rate on all debt is 6%, and cash earns no interest income. The 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 2019, that it cannot sell off any of its fixed assets, and that assets, spontaneous liabilities, and operating costs are expected to increase by the same percentage as sales. Determine the required line of credit. Do not round intermediate calculations. Round your answers to the nearest dollar.

LOC: $  

Answer 1

0 Book1 - Excel Tell me what you want to do 0 - Avneet Sidana (Securities) X Share Formulas Data Review View Developer Calibri 111 - ^ ^ ===> ASSE Home Insert Page Layout % Cut Calibri BE Copy Paste B IU - Clipboard Font E12 - X for Wrap Text General = 1 General D.% x 0 Σ AutoSum 9 Fill - A E ES Protect &.99 Insert Delete Format E Merge & Center, Alignment Conditional Format as Cell Formatting Table Styles Styles Clear Sort & Find & Filter - Select Editing Protection Number Cells You need to sign in to the Azure Information Protection service Sign in Public E F G к Sensitivity: Internal and Restricted А D 5 Balance sheet 6 2009 forecast increase 2010 7 cash 1080.00 10% 1188 8 receivables 6480.00 10% 7128 9 inventories 9000.00 10% 9900 10 total current assets 16560.00 18216) 11 net fixed assets 12600.00 10% 14490 12 total assets 29160.00 32706.00 13 14 accounts payable 4320.00) 10% 4752.00 15 accruals 2880.00 10% 3168.00 16 line of credit 0.00 1908.00 1908.00 17 notes payable 2100.00 2100.00 18 total current liabilities 9300.00 10020.00 19 mortgage bonds 3500.00 3500.00 20 common stock 3500.00 3500.00 21 retained earnings 12860.00 918.00 13778.00 22 total liabilities and equity 29160.00 32706.00 23 Sheet1 Internal and Restricted Confidential н Income Statement Column1 2019 projected growth Sales 36000.00 10% Operating costs 34000.00 10% Earnings before interest and taxes 2000.00 Interest 160.00 Pre-tax earnings 1840.00 Taxes (25%) 460.00 Net income 1380.00 Dividends (40%) 552 Addition to retained earnings 828.00 2020 > 39600 37400 2200 160.00 2040.00 510 1530.00 612 918.00 Ready 0 9 gl -- F + 95% ( 1) 30-11-2019 52 13:51 O 9 Type here to search = W E.

Assuming 10% growth in forecast sales and operating costs, as well as assets(as given in the question)
retained earnings = net income - dividend paid
therefore addition in retained earnings = $918
Now, total assets = 32706
hence line of credit = increase in total assets - increase in retained earnings- increase in current liabilities

=> (32706-29100)- 918 -(10200-9300) = $1908.