Question

In: Finance

14) B Markets has sales of $848,600, net income of $94,000, dividends paid of $28,200, total...

14) B Markets has sales of $848,600, net income of $94,000, dividends paid of $28,200, total assets of $913,600, and current liabilities of $78,900. Assume that all costs, assets, and current liabilities change spontaneously with sales. The tax rate and dividend payout ratios remain constant. If the firm's managers project a firm growth rate of 15 percent for next year, what will be the amount of external financing needed to support this level of growth? Assume the firm is currently operating at full capacity.

A: $49,535

B: $68,211

C: −$10,406

D: $13,909

E; $32,408

Solutions

Expert Solution

External Financing Needed [EFN]

Profit margin ratio

Profit margin ratio = [Net Income / Sales] x 100

= [$94,000 / $848,600] x 100

= 11.07707%

Dividend pay-out ratio

Dividend pay-out ratio = [Dividend paid / Net Income] x 100

= [$28,200 / $94,000] x 100

= 30%

Expected Next Year Sales

Expected Next Year Sales = Current years sales x [1 + Growth rate]

= $848,600 x [1 + 0.15]

= $848,600 x 1.15

= $975,890

After Tax profit Margin

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

= $975,890 x 11.07707%

= $108,100

Dividend Pay-out

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

= $108,100 x 30%

= $32,430

Additions to Retained Earnings

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

= $108,100 - $32,430

= $75,670

Increase in Total Assets

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

= $913,600 x 15%

= $137,040

Increase in Spontaneous liabilities

Increase in Spontaneous liabilities = Total current liabilities x Percentage of Increase in sales

= $78,900 x 15%

= $11,835

External Financing Needed [EFN]

Therefore, the External Financing Needed [EFN] = Increase in Total Assets – Increase in in Spontaneous liabilities – Additions to retained earnings

= $137,040 - $11,835 - $75,670

= $49,535


Related Solutions

8 A firm paid total cash dividends of $119 and had net income of $217 in...
8 A firm paid total cash dividends of $119 and had net income of $217 in 2008. If it earned $328 in 2009 and maintained the same dividend payout ratio that it paid in this year, what will the firm's total dividends be? Please round to two decimals
1) Net income: A) is calculated by subtracting total expenses and total dividends from total revenues....
1) Net income: A) is calculated by subtracting total expenses and total dividends from total revenues. B) occurs when total revenues are less than total expenses. C) is often referred to as the "bottom line" on an income statement. D) decreases total stockholders' equity. 2) On January 1, 2017, total assets for Wininger Technologies were $140,000; on December 31, 2017, total assets were $155,000. On January 1, 2017, total liabilities were $111,000; on December 31, 2017, total liabilities were $118,000....
Wildhorse Co. had net income of $175240 and paid dividends of $40000 to common stockholders and...
Wildhorse Co. had net income of $175240 and paid dividends of $40000 to common stockholders and $19000 to preferred stockholders in 2020. Wildhorse Co.’s common stockholders’ equity at the beginning and end of 2020 was $862000 and $1370000, respectively. Wildhorse Co.’s return on common stockholders’ equity was 11.00%. 14.00%. 10.00%. 16.00%.
Sheffield Corp. had net income of $163625 and paid dividends of $48500 to common stockholders and...
Sheffield Corp. had net income of $163625 and paid dividends of $48500 to common stockholders and $16500 to preferred stockholders in 2020. Sheffield Corp.’s common stockholders’ equity at the beginning and end of 2020 was $890000 and $1250000, respectively. Sheffield Corp.’s return on common stockholders’ equity was 13.75%. 10.75%. 9.75%. 15.75%.
Net income for the year was $117,000. Dividends of $114,000 cash were declared and paid. Scoreteck’s...
Net income for the year was $117,000. Dividends of $114,000 cash were declared and paid. Scoreteck’s only noncash expense was $87,000 of depreciation. The company purchased plant assets for $87,000 cash. Notes payable of $37,000 were issued for $37,000 cash.    Complete the following spreadsheet in preparation of the statement of cash flows. (The statement of cash flows is not required.) Report operating activities under the indirect method. (Enter all amounts as positive values.) SCORETECK CORPORATION Spreadsheet for Statement of...
Assume that in 2017, The Shallonz Corporation reported net income of $143 million, and paid dividends...
Assume that in 2017, The Shallonz Corporation reported net income of $143 million, and paid dividends totaling $36.5 million throughout the year. Their net income has been growing at about 5% per year for some time, but it is expected to grow by 20% in 2018. Growth is expected to return to the normal 5% the following year and thereafter. It has also been estimated that the company will need about $52 million in funds for capital expenditures in 2018....
Neiman Corp. has Net Income of $31,722 and Total Equity of $118,857. Also, its Sales are...
Neiman Corp. has Net Income of $31,722 and Total Equity of $118,857. Also, its Sales are $285,760, Total Assets are $245,626 and Total Liabilities are $126,769, but only $41,769 are from Current Liabilities. Porter’s Debt/Equity ratio is accordingly 1.067. Neiman's Total Asset Turnover ratio suggests that $1.163 dollars in sales is generated for each $1 of assets. Also, the Profit Margin shows that the firm has a Net Income of $0.111 for every $1 in sales. Industry average ratios: ROE...
A company has $20 billion of sales and $1 billion of net income. Its total assets...
A company has $20 billion of sales and $1 billion of net income. Its total assets are $10 billion. The company’s total assets equal total invested capital, and its capital consists of half debt and half common equity. The firm’s interest rate is 5%, and its tax rate is 25%. What is its profit margin? What is its ROA? What is its ROE? What is its ROIC? Would this firm’s ROA increase if it used less leverage? (The size of...
Small Company reported 20X7 net income of $43,000 and paid dividends of $14,000 during the year....
Small Company reported 20X7 net income of $43,000 and paid dividends of $14,000 during the year. Mock Corporation acquired 30 percent of Small's shares on January 1, 20X7, for $99,000. At December 31, 20X7, Mock determined the fair value of the shares of Small to be $127,000. Mock reported operating income of $81,000 for 20X7. Required: Compute Mock's net income for 20X7 assuming it a. Carries the investment in Small at fair value. b. Uses the equity method of accounting for its investment in...
In 2015, the Keenan Company paid dividends totaling $2,340,000 on net income of $13.6 million. Note...
In 2015, the Keenan Company paid dividends totaling $2,340,000 on net income of $13.6 million. Note that 2015 was a normal year and that for the past 10 years, earnings have grown at a constant rate of 7%. However, in 2016, earnings are expected to jump to $20.4 million and the firm expects to have profitable investment opportunities of $10.2 million. It is predicted that Keenan will not be able to maintain the 2016 level of earnings growth because the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT