Question

In: Finance

Green Lumber has - Total sales of $387,200, - Total assets of $429,600, - Current liabilities...

Green Lumber has - Total sales of $387,200, - Total assets of $429,600, - Current liabilities of $45,000, - Dividends paid of $24,000, - Net income of $57,700.

Assume that all costs, assets, and current liabilities change spontaneously with sales. The tax rate and dividend payout ratios remain constant. Assume the firm is currently operating at full capacity.

If the firm's managers project a firm growth rate of 12 percent for next year, what will be the amount of external financing needed to support this level of growth?

Solutions

Expert Solution

Answer:

Projected Increase in Assets = Assets * Sales Growth Rate
Projected Increase in Assets = $429,600 * 12%
Projected Increase in Assets = $51,552

Spontaneous Increase in Current Liabilities = Current Liabilities * Sales Growth Rate
Spontaneous Increase in Current Liabilities = $45,000 * 12%
Spontaneous Increase in Current Liabilities = $5,400

Profit Margin Rate = Net Income / Sales * 100
Profit Margin Rate = $57,700 / $387,200 * 100 = 14.90%

Dividend Payout Ratio = Dividend / Net Income * 100
Dividend Payout Ratio = $24,000 / $57,700 * 100 = 41.59%

Retention Rate = 1 - Dividend Payout Ratio
Retention Rate = 1 - 0.4159 = 0.5841 or 58.41%

Expected Sales = $387,200 * 12% = $46,464

Increase in Retained Earning = Expected Sales * Profit Margin * Retention Rate
Increase in Retained Earning = $46,464 * 14.90% * 58.41%
Increase in Retained Earning = $4,043.80

External Fund Needed = Projected Increase in Assets – Spontaneous Increase in Liabilities – Increase in Retained Earnings
External Fund Needed = $51,552 - $5,400 - $4,043.80
External Fund Needed = $42,108.20


Related Solutions

A firm has Current Assets of $500,000, Inventory of $200,000, Current Liabilities of $700,000, Total Assets...
A firm has Current Assets of $500,000, Inventory of $200,000, Current Liabilities of $700,000, Total Assets of $3,000,000 and Total Liabilities of $3,500,000. Which of the following statements is correct: a. this firm is bankrupt b. this firm has a Quick Ratio that is greater than one c. this firm has positive equity d. this firm is technically insolvent
Flying Penguins Corp. has total current assets of $8,755,000, current liabilities of $5,855,000, and a quick...
Flying Penguins Corp. has total current assets of $8,755,000, current liabilities of $5,855,000, and a quick ratio of 0.78. How much inventory does it have? (Round answer to nearest dollar, e.g. 5,675.) Level of inventory $
($ in millions) Current assets 115 Fixed and other assets 165 Total assets 280 Current liabilities...
($ in millions) Current assets 115 Fixed and other assets 165 Total assets 280 Current liabilities 81 Long-term debt 48 Stockholders' equity 151 Total liabilities and equity 280 Common shares outstanding (millions) 14 Total revenues 436 Total operating costs and expenses 350 Interest expense 15 Income taxes 23 Net profits 48 Dividends paid to common stockholders 13 On the basis of this​ information, calculate as many​ liquidity, activity,​ leverage, profitability, and common stock measures as you can. ​(​Note: Assume the...
The total assets and total liabilities (in millions) of Keurig Green Mountain Inc and starbucks corporation follow
The total assets and total liabilities (in millions) of Keurig Green Mountain Inc and starbucks corporation followParticulars Keurig Green MountainStarbucksAssets`$4,002$12,446Liabilities1,2886,628Determine the owner's Equity of each company
Duffert Industries has total assets of $1,050,000 and total current liabilities (consisting only of accounts payable...
Duffert Industries has total assets of $1,050,000 and total current liabilities (consisting only of accounts payable and accruals) of $150,000. Duffert finances using only long-term debt and common equity. The interest rate on its debt is 9% and its tax rate is 40%. The firm's basic earning power ratio is 15% and its debt-to capital rate is 40%. What are Duffert's ROE and ROIC? Do not round your intermediate calculations. a. 9.04%; 8.93% b. 16.12%; 11.66% c. 13.90%; 10.50% d....
1. Quick Ratio= current assets-inventories/ current liabilities 2. Debt to Assets ratio= total debt/total assets 3....
1. Quick Ratio= current assets-inventories/ current liabilities 2. Debt to Assets ratio= total debt/total assets 3. Earnings Per Share (EPS)=total earnings/outstanding shares (must first solve net income-preferred divideneds= total earnings) 4. Net Income (Net profit)=total revenues-total expenses I need help finding the answer to these equations for Target Corporation for 2015 and 2016. please refer to the links for the 10k reports for the company. 2015- https://corporate.target.com/_media/TargetCorp/annualreports/2015/pdfs/Target-2015-Annual-Report.pdf 2016- https://corporate.target.com/_media/TargetCorp/annualreports/2016/pdfs/Target-2016-Annual-Report.pdf?ext=.pdf
Your firm has the following balance sheet statement items: total current liabilities of $805,000; total assets...
Your firm has the following balance sheet statement items: total current liabilities of $805,000; total assets of $2,886,875; net fixed assets of $1,842,823; and long-term debt of $200,000. What is the amount of the firm's total current assets?
Rock construction has current assets of 45 million, total liabilities and equity of 67 million, and...
Rock construction has current assets of 45 million, total liabilities and equity of 67 million, and sales of 59 million. How would current assets be expressed on a common size balance sheet?
AFC Ltd Sales growth 10% Current assets/Sales 15% Current liabilities/Sales 8% Net fixed assets/Sales 77% Costs...
AFC Ltd Sales growth 10% Current assets/Sales 15% Current liabilities/Sales 8% Net fixed assets/Sales 77% Costs of goods sold/Sales 70% Depreciation rate 10% Interest rate on debt 5% Interest paid on cash and marketable securities 4% Tax rate 30% Dividend payout ratio 40% Year 0 1 2 3 4 5 Income statement Sales 1000 1100 1210 1331 1464 1611 Costs of goods sold -700 -770 -847 -932 -1025 -1127 EBITDA 300 330 363 399 439 483 Interest payments on debt...
Calculate total current assets and total current liabilities that would appear in the company’s year-end balance sheet.
The trial balance for K and J Nursery, Inc., listed the following account balances at December 31, 2018, the end of its fiscal year:cash, $16,000accounts receivable, $11,000inventories, $25,000equipment (net), $80,000accounts payable, $14,000wages payable, $9,000interest payable, $1,000note payable (due in 18 months), $30,000common stock, $50,000Calculate total current assets and total current liabilities that would appear in the company’s year-end balance sheet.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT