The Manning Company has financial statements as shown next, which are representatives of the company's historical average.
The firm is expecting a 40% increase in sales next year, and management is concerned about the company's need for external funds. The increase in sales is expected to be carried out without any expansion of fixed assets, but rather through more efficient asset utilization in the existing store. Among liabilities, only current liabilities vary directly with sales.
Income Statement
Sales $280,000
Expenses 220,600
Earnings before interest and taxes $59,400
Interest 8,900
Earnings before taxes $50,500
Taxes 16,900
Earnings after taxes $33,600
Dividends $11,760
Balance Sheet
Assets Liabilities and Stockholders Equity
Cash $6000 Accounts payable $21,200
Accounts receivable 44,000 Accrued wages 2,150
Inventory 62,000 Accrued taxes 4,650
Current assets $112,000 Current liaiblities $28,000
Fixed assets 99,000 Notes payable 8,900
Long-term debt 24,500
Common stock 123,000
Retained earnings 26,600
Total assets $211,000 Total liabilities and Stockholders' equity $211,000
Using the percent-of-sales method, determine whether the company has external financing needs, or a surplus of funds. A profit margin and payout ratio must be found from the income statement. Do not intermediate calculations, input the amount as a positive value,

Respuesta :

Answer:

external funds needed = $3,024

Explanation:

we can use the external funds needed formula to determine if the company will need to borrow money from external sources:

EFN = [(A/S) x (Δ Sales)] - [(L/S) x (Δ Sales)] - {[PM x FS x (1 - d)]}

A/S: change in assets given a change in sales  = current assets / current sales = $112,000 / $280,000 = 0.4 (fixed assets not included)

Δ Sales = change in total sales  = $280,000 x 40% = $112,000

L/S: change in liabilities given a change in sales  = current liabilities / current sales = $28,000 / $280,000 = 0.1 (long term debt not included)

PM: Profit margin  = $33,600 / $280,000 = 0.12

FS: Forecasted sales   = $392,000

d: dividend payout = $11,760 / $33,600 = 0.35

1 - d = 0.65

EFN = [0.4 x $112,000] - [0.1 x $112,000] - {[0.12 x $392,000 x 0.65} = $44,800 - $11,200 - $30,576 = $3,024

The external funds needed = $3,024

  • The calculation is as follows:

EFN = [(A ÷ S) × (Δ Sales)] - [(L ÷ S) × (Δ Sales)] - {[PM  ×FS × (1 - d)]}

here

A/S: change in assets given a change in sales  

= current assets ÷ current sales

= $112,000 ÷ $280,000

= 0.4 (fixed assets not included)

Δ Sales = change in total sales  = $280,000  × 40% = $112,000

L÷ S: change in liabilities given a change in sales  

= current liabilities ÷ current sales

= $28,000 ÷ $280,000

= 0.1 (long term debt not included)

Now

PM: Profit margin  = $33,600 / $280,000 = 0.12

FS: Forecasted sales   = $392,000

d: dividend payout = $11,760 ÷ $33,600 = 0.35

And,

1 - d = 0.65

so,

EFN = [0.4  × $112,000] - [0.1  × $112,000] - {[0.12  × $392,000  × 0.65}

= $44,800 - $11,200 - $30,576

= $3,024

Learn more: https://brainly.com/question/4626564?referrer=searchResults