Question

sales are projected to be $14,399. What is Ul 9. External Funds Needed Cheryl Colby, CFO of Charming Florist Ltd., has c reated the firms pro forma balance sheet for the next fiscal year. Sales are projected to grow by 15 percent to $211.6 milli Current assets, fixed assets, and short-term debt are 20 percent, 90 percent, and 15 percent of sales respectively. The company pays out 40 percent of its net income in dividends. The company currently has $32 million of long-term debt, and $16 million in common stock par value. The profit margin is 10 percent. on. a. Construct the current balance sheet for the firm using the projected sales figure. b. Based on the sales growth forecast, how much does the company need in external funds for the upcoming fiscal year? c. Construct the firms pro forma balance sheet for the next fiscal year and confirm the external funds needed that you calculated in part (b).

please show all work

0 0
Add a comment Improve this question Transcribed image text
Answer #1

( all fig. in millions)

a. workings-   

current sales - 211.6/(1+0.15) = 184

change in sales = 211.6-184= 27.6

current balamce sheet-

liabilities amount
common stock 16
retained profits (b.f.) 126.8
long term debts 32
short term debts (184*15%) 27.6
total 202.4
assets
fixed assets (184*90%) 165.6
current assets (184*20%) 36.8
total 202.4

b. External funds needed = [(assets/sales)*change in sales]-[(debt/sales)*change in sales]-[(projected sales*profit margin)*(1-dividend payout ratio)] = [(0.2+0.9)*27.6]-[0.15*27.6]-[(211.6*0.10)*(1-0.40)] = 30.36-4.14-12.696 = 13.524

c. projected net income = 211.6*10% = 21.16

addition to retained income = 21.16*60% = 12.696

pro forma balance sheet-

liabilities
common stock 16
retained earning (126.8+12.696) 139.496
external fund needed (b.f.) 13.524
long term debts 32
short term debts (211.6*15%) 31.74
total 232.76
assets
fixed assets (211.6*90%) 190.44
current assets (211.6*20%) 42.32
total 232.76
Add a comment
Know the answer?
Add Answer to:
please show all work sales are projected to be $14,399. What is Ul 9. External Funds...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • External Funds Needed: Cheryl Colby, CFO of charming Florist Ltd., has created the firm's pro forma...

    External Funds Needed: Cheryl Colby, CFO of charming Florist Ltd., has created the firm's pro forma balance sheet for the next fiscal year. Sales are projected to grow by 15 percent to $211.6 million. Current assets, fixed assets, and short-term debt are 20 percent, 90 percent, and 15 percent of sales respectively. The company pays out 40 percent of its net income in dividends. The company currently has $32 million of long term-debt, and $16 million in common stock par...

  • Dahlia Colby, CFO of Charming Florist Ltd., has created the firm’s pro forma balance sheet for...

    Dahlia Colby, CFO of Charming Florist Ltd., has created the firm’s pro forma balance sheet for the next fiscal year. Sales are projected to grow by 20 percent to $480 million. Current assets, fixed assets, and short-term debt are 20 percent, 70 percent, and 10 percent of sales, respectively. Charming Florist pays out 20 percent of its net income in dividends. The company currently has $125 million of long-term debt and $53 million in common stock par value. The profit...

  • Dahlia Colby, CFO of Charming Florist Ltd., has created the firm's pro forma balance sheet for...

    Dahlia Colby, CFO of Charming Florist Ltd., has created the firm's pro forma balance sheet for the next fiscal year. Sales are projected to grow by 10 percent to $440 million. Current assets, fixed assets, and short-term debt are 20 percent, 80 percent, and 10 percent of sales, respectively. Charming Florist pays out 30 percent of its net income in dividends. The company currently has $122 million of long-term debt and $50 million in common stock par value. The profit...

  • Corporate Finance

    Diana Dune, CFO of Rose Florist Ltd., has created the company's pro forma balance sheet for the next fiscal year. Sales are projected to grow 15 percent to $ 620 million. Current assets, fixed assets, and short-term debt are 25 percent, 80 percent, and 20 percent of sales, respectively. Rose florist shop pays 30 percent of its net profit in dividends. The company currently has $ 140 million in long-term debt and $ 68 million in par value for common...

  • 13. External Funds Needed The Optical Scam Company has forecast a sales growth rate of 15 percent for next year. The cu...

    13. External Funds Needed The Optical Scam Company has forecast a sales growth rate of 15 percent for next year. The current financial statements are shown here: Income Statement Sales $25,380,000 Costs 21,635,000 $3,745,000 Taxable income Taxes 1,498,000 Net income $2247,000 Dividends $786,450 Addition to retained earnings 1,460,550 Balance Sheet Liabilities and Owners' Equity Assets $ 5,200,000 Current assets $7,200,000 Short-term debt 6,000,000 Long-term debt Fixed assets 17.600,000 $3,200,000 Common stock 10,400,000 Accumulated retained earnings Total equity $13,600,000 Total assets...

  • 13. External Funds Needed The Optical Scam Company has forecast a sales growth rate of 15 percent for next year. The cu...

    13. External Funds Needed The Optical Scam Company has forecast a sales growth rate of 15 percent for next year. The current financial statements are shown here: Income Statement Sales $25,380,000 Costs 21,635,000 $ 3,745,000 Taxable income 1,498,000 Taxes $ 2,247,000 Net income $ 786,450 Dividends Addition to retained earnings 1,460,550 Balance Sheet Liabilities and Owners' Equity Assets $ 5,200,000 Current assets $7,200,000 Short-term debt 6,000,000 Long-term debt Fixed assets 17,600,000 $ 3,200,000 Common stock 10,400,000 Accumulated retained earnings Total...

  • Determining of external funds needed. n of External Funds Needed. Ina Corporation is thinking of purchasing...

    Determining of external funds needed. n of External Funds Needed. Ina Corporation is thinking of purchasing a new his new machine, the company expects sales to increase from $8,000,000 to 3.3 Determinatio $10,000,000n thi new machine, the company expects sales to increase from $8,000,000 to any knows that its assets, accounts payable, and accrued expenses vary directly with mpany's profit margin on sales is 8 percent, and the company plans to pay 40 percent machine. With sales. T of its...

  • Uberville Drivers Inc. reported $750,000 in sales in the recent year, $650,000 in costs and $10,000...

    Uberville Drivers Inc. reported $750,000 in sales in the recent year, $650,000 in costs and $10,000 in interest. The frm's tax rate is 34%, and recent year's dividend payment was $34,400. The company is planning to grow by 20% in the next year. Costs are proportional to sales. Interest is not. The company will face the same tax rate, and is targeting the same dividend payout ratio Construct a pro-forma income statement. What is the pro-forma addition to retained earnings?...

  • External Funds Needed The Optical Scan Company has forecast a 20 percent sales growth rate for...

    External Funds Needed The Optical Scan Company has forecast a 20 percent sales growth rate for next year. The current financial statements are shown here: 3.8 Statement of Comprehensive Income Sales Costs Taxable income Taxes Net income $30,400,000 26,720,000 $ 3,680,000 1,288,000 $ 2,392,000 Dividends Addition to retained earnings $ 956,800 1,435,200 Statement of Financial Position Assets Liabilities and shareholder's equity Current assets 7,200,000 Short-term debt Fixed assets 17,600,000 Long-term debt Common stock $6,400,000 4,800,000 $3,200,000 10,400,000 $13,600,000 $24.800,000 Accumulated...

  • The Optical Scam Company has forecast a sales growth rate of 25 percent for next year....

    The Optical Scam Company has forecast a sales growth rate of 25 percent for next year. Current assets, fixed assets, and short-term debt are proportional to sales. The current financial statements are shown here:    INCOME STATEMENT Sales $ 32,000,000 Costs 26,309,400 Taxable income $ 5,690,600 Taxes 1,991,710 Net income $ 3,698,890 Dividends $ 1,479,556 Addition to retained earnings 2,219,334    BALANCE SHEET Assets Liabilities and Equity Current assets $ 7,360,000 Short-term debt $ 7,040,000 Long-term debt 2,240,000 Fixed assets...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT