Question

In: Finance

Cash 20 Accounts payable 20 Accounts Receivable 30 Notes payable 50 Inventory 30 Long-term debt 80...

Cash

20

Accounts payable

20

Accounts Receivable

30

Notes payable

50

Inventory

30

Long-term debt

80

Net Fixed assets

180

Common Stock

90

Retained Earnings

20

Total assets

260

Total liabilities and equity

260

Sales for the year just ended were 400. The firm is operating at much less than full capacity, so it will not need to increase fixed assets. Sales are expected to grow by 5% next year, the profit margin is 6%, and the dividend payout ratio is 60%. How much additional funding will be needed by the firm?

Solutions

Expert Solution

Additional Funds Needed [AFN] for the coming year

Expected Next Year Sales

Expected Next Year Sales = Last year sales x (1 + Growth Rate)

= 400 x (1 + 0.04)

= 400 x 1.04

= 420

After Tax profit Margin

After Tax profit Margin = Expected Next Year Sales x Profit Margin

= 420 x 6.00%

= 25.20

Dividend Pay-out

Dividend Pay-out = After Tax profit Margin x Dividend Pay-out Ratio

= 25.20 x 60%

= 15.12

Additions to Retained Earnings

Additions to Retained Earnings = After Tax profit Margin - Dividend Pay-out

= 25.20 – 15.12

= 10.08

Increase in Total Assets

Increase in Total Assets = Total Assets x Percentage of Increase in sales

= 260 x 4.00%

= 13.00

Increase in Spontaneous liabilities

Increase in Spontaneous liabilities = [Accounts Payable + Accruals] x Percentage of Increase in sales

= [20 + 50] x 4.00%

= 70 x 4.00%

= 3.50

Additional Funds Needed [AFN]

Therefore, the Additional Funds Needed [AFN] = Increase in Total Assets – Increase in in Spontaneous liabilities – Additions to retained earnings

= 13.00 - $3.50 – 10.08

= -0.58 (Negative)

“Hence, the Additional Funds Needed (AFN) for the coming year will be -0.58 (Negative)”


Related Solutions

Explain how the accounts receivable, inventory, power and equipment, accounts payable, wages payable and long-term debt...
Explain how the accounts receivable, inventory, power and equipment, accounts payable, wages payable and long-term debt impacted cash flow from one year to the next. 200-word minimum.
Assets Liabilities and Equity Cash $ 25,000 Accounts payable $ 25,000 Accounts receivable 156,000 Long-term debt...
Assets Liabilities and Equity Cash $ 25,000 Accounts payable $ 25,000 Accounts receivable 156,000 Long-term debt 103,000 Inventory 79,000 Common stock ($7 par; 21,000 3,000 shares outstanding) Plant and equipment 190,000 Additional paid-in capital 155,000 Retained earnings 146,000 $450,000 $450,000 Construct a new balance sheet showing the impact of a two-for-one split. If the current market price of the stock is $50, what is the price after the split? Round the par value and the market price after the split...
Asset Liabilities and owners equity Cash 600 Accounts Payable 700 Inventory 80 Notes Payable 200 Accounts...
Asset Liabilities and owners equity Cash 600 Accounts Payable 700 Inventory 80 Notes Payable 200 Accounts Receivable 400 Current Maturing LTD 40 Fixed assets 1500 Stock 1300 Accumulated Depreciation (90) Retained Earnings 250 Total 2490 Total 2490 Use the following balance sheet for Delta Company to answer the following 3 questions. 1.Which of the following statements is accurate in regards to Delta's financial position? Delta's NWC suggests that solvency is a concern. Delta's NWC suggests that the firm has a...
Assets Liabilities & Owners’ Equity Cash $500,000 Accounts Payable 0 Accounts Receivable $550,000  Notes Payable $600,000 Inventory...
Assets Liabilities & Owners’ Equity Cash $500,000 Accounts Payable 0 Accounts Receivable $550,000  Notes Payable $600,000 Inventory $750,000 Accruals $400,000 Total Current Assets $1,800,000 Total Current Liabilities 1,000,000 Net Plant & Equip $6,200,000 Long-Term Debt $4,000,000 Total Debt $5,000,000 Retained Earnings $1,500,000 Stockholders’ Equity $1,500,000 Total Equity 3,000,000 Total Assets $8,000,000 Total Liabilities & Owners’ Equity $8,000,000 You currently work for Capital One Financial. The firm is interested in pursuing a new banking project, but they are unsure of where and...
Cash ​$30,000 Accounts receivable 63,800 Accounts payable 52,500 ​Short-term notes payable 11,000 Inventories 66,000 Gross fixed...
Cash ​$30,000 Accounts receivable 63,800 Accounts payable 52,500 ​Short-term notes payable 11,000 Inventories 66,000 Gross fixed assets 1,061,000 Accumulated depreciation 86,000 ​Long-term debt 210,000 Common stock 480,000 Other assets 25,000 Retained earnings ​? Complete the part of the​ common-sized balance sheet below.  ​(Round to one decimal place. NOTE​: Input the Accumulated depreciation account as a negative​ value.) Common-sized Balance Sheet ASSETS Cash $ 30,000 % Accounts receivable 63,800 Inventories 66,000 Total current assets $ 159,800 % Gross fixed assets $...
  Cash $ 80 Accounts Payable $ 26   Accounts Receivable 12 Wages and Other Expenses Payable 111...
  Cash $ 80 Accounts Payable $ 26   Accounts Receivable 12 Wages and Other Expenses Payable 111   Inventories 188 Long-Term Debt 203   Other Current Assets 26 Other Long-Term Liabilities 44   Property, Plant, and Equipment 355 Contributed Capital 356   Other Assets 99 Retained Earnings 20 Assume that the following events occurred in the quarter ended December 31 (amounts provided are in whole dollars): Paid $2,000,000 cash for an additional “other asset”. Issued additional shares for $2,000,000 in cash. Purchased property, plant, and...
Cash $   Current liabilities $   Accounts receivable $   Long-term debt $40,000 Inventories $   Common stock $  ...
Cash $   Current liabilities $   Accounts receivable $   Long-term debt $40,000 Inventories $   Common stock $   Fixed assets $   Retained earnings $60,000 Total assets $200,000 Total liabilities and equity $   Sales $   Cost of goods sold 1. Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.1x Days sales outstanding: 38 days Inventory turnover ratio: 4x Fixed assets turnover: 2.5x Current ratio: 2.5x Gross profit margin on sales: (Sales - Cost of goods sold)/Sales...
A company has Cash of $1000, Accounts Receivable of $200, Inventory of $300, Long-Term Assets of...
A company has Cash of $1000, Accounts Receivable of $200, Inventory of $300, Long-Term Assets of $4000, Accounts Payable of $500 and a Long-Term Bank Loan of $5000. Calculate the company's current ratio. Question 1 options: 1 2 3 4 Question 2 Using the following information, calculate the inventory turnover for ABC Retailers: Sales are $4800, Cost of Goods Sold is $2000, operating expenses are $1000, and average inventory is $500. Question 2 options: 4 5 6 7 Question 3...
Insurance Expense $12,000 Accounts Receivable $10,000 Cash 37,000 Notes Payable 15,000 Accounts Payable 13,000 Willis, Capital,...
Insurance Expense $12,000 Accounts Receivable $10,000 Cash 37,000 Notes Payable 15,000 Accounts Payable 13,000 Willis, Capital, Dec. 31, 2018 ? Advertising Expense 2,000 Salaries Expense 21,000 Service Revenue 125,000 Equipment 105,000 Willis, Withdrawals 9,000 Owner contribution 25,000 PrintDone Accent PhotographyAccent Photography works weddings and​ prom-type parties. The balance of WillisWillis​, Capital was $ 18 comma 000$18,000 at DecemberDecember 3131​, 20172017. At DecemberDecember 3131​, 20182018​, the​ business's accounting records show these​ balances: LOADING... ​(Click the icon to view the​ accounts.) Prepare...
You have $60,000 in cash, $40,000 in accounts receivable, $100,000 in inventory, $65,000 in accounts payable,...
You have $60,000 in cash, $40,000 in accounts receivable, $100,000 in inventory, $65,000 in accounts payable, $25,000 in accrued expenses on 12/31/2017. What was your net working capital balance on this date?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT