( 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 |
please show all work sales are projected to be $14,399. What is Ul 9. External Funds...
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 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 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...
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 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 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 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 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 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. 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...