Question

In: Finance

Q1: Current sales are $360,000, current assets $80,000, accounts payable $15,000, accruals $5,000, net profit margin...

Q1:

Current sales are $360,000, current assets $80,000, accounts payable $15,000, accruals $5,000, net profit margin of 5% with a 50% dividend payout. If I expect sales to increase by 20% and no fixed assets are needed, what is my external funds requirement? Take to 4 decimal places when calculating.

Q2:

Current sales are $360,000, current assets $80,000, accounts payable $15,000, accruals $5,000, net profit margin of 5% with a 50% dividend payout. If I expect sales to increase by 20% and am at capacity so my fixed assets of $80,000 will also need to be increased by the 20%, now what is my external funds requirement? Take to 4 decimal places when calculating.

Solutions

Expert Solution

Answer to Question 1:

Current Sales = $360,000
Growth Rate = 20%

Current Liabilities = Accounts Payable + Accruals
Current Liabilities = $15,000 + $5,000
Current Liabilities = $20,000

Expected Sales = Current Sales * (1 + Growth Rate)
Expected Sales = $360,000 * 1.20
Expected Sales = $432,000

Retention Ratio = 100% - Payout Ratio
Retention Ratio = 100% - 50%
Retention Ratio = 50%

Expected Addition to Retained Earnings = Expected Sales * Profit Margin * Retention Ratio
Expected Addition to Retained Earnings = $432,000 * 5% * 50%
Expected Addition to Retained Earnings = $10,800

Increase in Current Assets = Current Assets * Growth Rate
Increase in Current Assets = $80,000 * 20%
Increase in Current Assets = $16,000

Increase in Current Liabilities = Current Liabilities * Growth Rate
Increase in Current Liabilities = $20,000 * 20%
Increase in Current Liabilities = $4,000

External Funds Requirement = Increase in Current Assets - Increase in Current Liabilities - Expected Addition to Retained Earnings
External Funds Requirement = $16,000 - $4,000 - $10,800
External Funds Requirement = $1,200

Answer to Question 2:

Current Sales = $360,000
Growth Rate = 20%

Current Liabilities = Accounts Payable + Accruals
Current Liabilities = $15,000 + $5,000
Current Liabilities = $20,000

Expected Sales = Current Sales * (1 + Growth Rate)
Expected Sales = $360,000 * 1.20
Expected Sales = $432,000

Retention Ratio = 100% - Payout Ratio
Retention Ratio = 100% - 50%
Retention Ratio = 50%

Expected Addition to Retained Earnings = Expected Sales * Profit Margin * Retention Ratio
Expected Addition to Retained Earnings = $432,000 * 5% * 50%
Expected Addition to Retained Earnings = $10,800

Increase in Current Assets = Current Assets * Growth Rate
Increase in Current Assets = $80,000 * 20%
Increase in Current Assets = $16,000

Increase in Fixed Assets = Fixed Assets * Growth Rate
Increase in Fixed Assets = $80,000 * 20%
Increase in Fixed Assets = $16,000

Increase in Current Liabilities = Current Liabilities * Growth Rate
Increase in Current Liabilities = $20,000 * 20%
Increase in Current Liabilities = $4,000

External Funds Requirement = Increase in Current Assets + Increase in Fixed Assets - Increase in Current Liabilities - Expected Addition to Retained Earnings
External Funds Requirement = $16,000 + $16,000 - $4,000 - $10,800
External Funds Requirement = $17,200


Related Solutions

Current sales are $360,000, current assets $80,000, accounts payable $15,000, accruals $5,000, net profit margin of...
Current sales are $360,000, current assets $80,000, accounts payable $15,000, accruals $5,000, net profit margin of 5% with a 50% dividend payout. If I expect sales to increase by 20% and no fixed assets are needed, what is my external funds requirement? Take to 4 decimal places when calculating.
Current assets are $94,700. Accounts payable is $36,200, net income is $12,400 and sales are $110,800....
Current assets are $94,700. Accounts payable is $36,200, net income is $12,400 and sales are $110,800. What is the net working capital turnover rate? Select one: a. 0.21 b. 0.85 c. 1.68 d. 1.89 e. None of the above.
Nerk pharm. net profit margin was 10% on sales of $2,000,000. Debt to assets was 40%...
Nerk pharm. net profit margin was 10% on sales of $2,000,000. Debt to assets was 40% with total liabilities of $500,000. How much was the Return on Assets?
Llegget industries had total assets of $1,050,000 and total current liabilites (consisting only of accounts payable and accruals) of $150,000.
please show all work and calculations.Llegget industries had total assets of $1,050,000 and total current liabilites (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 firms basic earning power is 15% and its debt - to cpaital rate is 40%. what are dufferts ROE and ROIC? do not round your intermediate calculations.
Cash & M/S 30,000 Accruals 20,000 Receivables 70,000 Accounts Payable 60,000 Inventories      120,000           Notes Payable 80,000...
Cash & M/S 30,000 Accruals 20,000 Receivables 70,000 Accounts Payable 60,000 Inventories      120,000           Notes Payable 80,000 Fixed Assets 380,000 L-T Liabilities 140,000 Total Assets 600,000 Common Equity 300,000 Total 600,000 Annual Sales   = $1,200,000 Net Income     = $48,000 Cost of Goods Sold = $960,000 Number of Shares Outstanding = 30,000 What is the current ratio of the firm? What is the debt ratio of the firm? What is the total asset turnover ratio of the firm? What is the...
What is the firm's current year net profit margin?
Category Prior Year Current YearAccounts payable ??? ???Accounts receivable 320,715 397,400Accruals 40,500 33,750Additional paid in capital 500,000 541,650Cash 17,500 47,500Common Stock 94,000 105,000COGS 328,500 428,048.00Current portion long-term debt 33,750 35,000Depreciation expense 54,000 54,731.00Interest expense 40,500 41,017.00Inventories 279,000 288,000Long-term debt 339,670.00 401,877.00Net fixed assets 946,535 999,000Notes payable 148,500 162,000Operating expenses (excl. depr.) 126,000 161,905.00Retained earnings 306,000 342,000Sales 639,000 850,323.00Taxes 24,750 48,686.00What is the firm's current year net profit margin?
Balance Sheet Cash&MS- 30,000 Accruals- 20,000 Receivables- 70,000 Accounts Payable- 60,000 Inventories- 120,000 Notes Payable- 80,000...
Balance Sheet Cash&MS- 30,000 Accruals- 20,000 Receivables- 70,000 Accounts Payable- 60,000 Inventories- 120,000 Notes Payable- 80,000 Fixed Assets- 480,000 L-T Liabilities- 140,000 Total Assets= 700,000 Common Equity- 400,000 Annual Sales- 1,400,000 Cost of Goods Sold- 960,000 Net Income- 63,000 Number of Shares Outstanding- 30,000 What is the current ratio, debt ratio, total asset turnover ratio of the firm? What is the days sales outstanding (DSO) of the firm? (Use a 360-day year.) What is the profit margin of the firm?...
A firm has Net income- $195,000 Profit Margin- 10.0% Accounts Receivable- $100,000 Percent of Sales On...
A firm has Net income- $195,000 Profit Margin- 10.0% Accounts Receivable- $100,000 Percent of Sales On Credit- 85% Fill out the rest of the information below, show all work and calculations Sales-? Credit Sales-? Receivables Turnover- ? Times Days sales in Receivables- ? Days
if a firm's debt is $100,000, a firm's assets are $200,000, the net profit margin is...
if a firm's debt is $100,000, a firm's assets are $200,000, the net profit margin is 0.20, and the total asset turnover is 0.80, what is the firm's ROE?
Category Prior Year Current Year Accounts payable ??? ??? Accounts receivable 320,715 397,400 Accruals 40,500 33,750...
Category Prior Year Current Year Accounts payable ??? ??? Accounts receivable 320,715 397,400 Accruals 40,500 33,750 Additional paid in capital 500,000 541,650 Cash 17,500 47,500 Common Stock 94,000 105,000 COGS 328,500 428,048.00 Current portion long-term debt 33,750 35,000 Depreciation expense 54,000 54,731.00 Interest expense 40,500 41,017.00 Inventories 279,000 288,000 Long-term debt 339,670.00 401,877.00 Net fixed assets 946,535 999,000 Notes payable 148,500 162,000 Operating expenses (excl. depr.) 126,000 161,905.00 Retained earnings 306,000 342,000 Sales 639,000 850,323.00 Taxes 24,750 48,686.00 What is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT