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 $330 million. Current assets, fixed assets, and short-term debt are 25 percent, 70 percent, and 15 percent of sales, respectively. Charming Florist pays out 25 percent of its net income in dividends. The company currently has $121 million of long-term debt and $49 million in common stock par value. The profit margin is 9 percent. 1. Based on Ms. Colby’s sales growth forecast, how much does Charming Florist need in external funds for the upcoming fiscal year? 2. Construct the firm’s pro forma balance sheet for the next fiscal year 3. Calculate the external funds needed

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 $330 million. Current assets, fixed assets, and short-term debt are 25 percent, 70 percent, and 15 percent of sales, respectively. Charming Florist pays out 25 percent of its net income in dividends. The company currently has $121 million of long-term debt and $49 million in common stock par value. The profit margin is 9 percent. 1. Based on Ms. Colby’s sales growth forecast, how much does Charming Florist need in external funds for the upcoming fiscal year? 2. Construct the firm’s pro forma balance sheet for the next fiscal year 3. Calculate the external funds needed

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter4: Financial Planning And Forecasting

Section: Chapter Questions

Problem 9P

See similar textbooks

Similar questions

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 $179.4 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 $27.2 million of long-term debt, and $13 million in common stock par value. The profit margin is 10 percent. Prepare the current balance sheet for the firm using the projected sales figure. Based on the sales growth forecast, how much does the company need in external funds for the upcoming fiscal year
Suppose that Psy Ops Industries currently has the balance sheet shown below, and that sales for the year just ended were $4.4 million. The firm also has a profit margin of 20 percent, a retention ratio of 25 percent, and expects sales of $7.4 million next year. Assets Liabilities and Equity Current assets $ 1,980,000 Current liabilities $ 1,672,000 Fixed assets 3,700,000 Long-term debt 1,800,000 Equity 2,208,000 Total assets $ 5,680,000 Total liabilities and equity $ 5,680,000 If fixed assets have enough capacity to cover the increase in sales and all other assets and current liabilities are expected to increase with sales, what amount of additional funds will Psy Ops need from external sources to fund the expected growth? Note: Enter your answer in dollars not in millions. Negative amount should be indicated by a minus sign.
The S&H construction company expects to have total sales next year totaling $15,300. In addition, the firm pays taxes at 35 percent and will owe $280,000 in interest expense. Based on last year’s operations the firm’s management predicts that its cost of goods sold will be 57 percent of sales and operating expenses will total 32 percent. What is your estimate of firm’s net income after taxes for the coming year? Complete the forma income statement below Round to the nearest dollar Pro-forma income statement Sales Cost of goods sold Gross profit Operating expenses Net operating income Interest expenses Earnings before taxes Taxes Net income
The Optical scam company has forecast a sales growth of 20 percent for next year. The current financial statements are shown below: What is pro forma balance sheet for next year? Sales $ 31,600,000 Costs 26,675,500 Taxable income $ 4,924,500 Taxes 1,723,575 Net income $ 3,200,925 Dividends $ 1,280,370 Addition to retained earnings 1,920,555 Balance Sheet Assets Liabilities and Owners' Equity Current assets $ 7,320,000 Accounts payable $ 5,688,000 Long-term debt 6,636,000 Fixed assets 20,172,000 Common stock $ 1,594,000 Accumulated retained earnings 13,574,000 Total equity $ 15,168,000 Total assets $ 27,492,000 Total liabilities and equity
Hendo Inc. is constructing its pro forma financial statements for this year. At years end, Assets were $650,000 and Accounts Payable (the only liabilities account) was $175,000. Sales for the year were $825,000. Hendo expects to grow by 12% this year. Assets and Accounts Payable are expected to grow proportionally to Sales. Common Stock currently equals $175,000 and Retained Earnings are $127,000. Hendo plans to sell $18,000 of new common stock this year. The firm's profit margin on Sales is 5.5%, and 45% of its earnings will be paid out in dividends. How much NEW long-term debt financing will Hendo need this year to finance its expected growth? Hendo is currently operating at full capapcity.
Blue Co. has a capital structure that consists of 25% equity and 75% liabilities. The company expects to report P3,000,000 in net income this year, and 50% of the it will be paid out as dividends to the shareholders. Determine how large must the firm’s capital budget be this year without resorting to issue any new common stock.
Pellagia is a nationwide retail chain specializing in women’s apparel. The company has 135 million shares outstanding, 30 percent of which are publicly traded with a current market price of $5.63 per share. The company is expected to earn a net income of $38 million in the next twelve months. Forecast sales and EBITDA are $633 million and $57 million, respectively. Debt outstanding is $120 million. What is the current enterprise value of Pellagia?
The Optical Scam Company has forecast an 17 percent sales growth rate for next year. The current financial statements are shown below. Current assets, fixed assets, and short-term debt are proportional to sales. INCOME STATEMENT Sales $ 47,000,000 Costs 37,900,000 Taxable income $ 9,100,000 Taxes 3,185,000 Net income $ 5,915,000 Dividends $ 2,366,000 Additions to retained earnings $ 3,549,000 BALANCE SHEET Assets Liabilities and Equity Current assets $ 15,930,000 Short-term debt $ 12,690,000 Long-term debt 13,190,000 Fixed assets 40,000,000 Common stock $ 4,000,000 Accumulated retained earnings 26,050,000 Total equity $ 30,050,000 Total assets $ 55,930,000 Total liabilities and equity $ 55,930,000…
CCC currently has sales of $28,000,000 and projects sales of $39,200,000 for next year. The firm's current assets equal $9,000,000 while its fixed assets are $8,000,000. The best estimate is that current assets will rise directly with sales while fixed assets will rise by $500,000. The firm presently has $3,600,000 in accounts payable, $1,800,000 in long-term debt, and $11,600,000 in common equity. All current liabilities are expected to change directly with sales. CCC plans to pay $1,000,000 in dividends next year and has a 5.0% net profit margin. Assuming the increase in fixed assets will occur, what is the most sales could equal next year without using discretionary sources of funds? (Round your answer to the nearest dollar.) $30,330,300 $27,300,000 $33,619,950 $24,103,170 $25,721,514
Blue Co., a firm that is operating at full capacity, has a balance sheet as of December 31, 2021, that shows that it has a total of P2,300,000 in assets on which two-thirds is fixed asset while current liabilities amounts to P950,000. In 2021, the net income is 190,000, payout ratio is 40%, and profit margin is 15% and no changes in these ratios are projected for the coming years. Sales are projected to increase by 10% next year. How much is the additional financing needed?
The newspaper reported last week that Tisch Enterprises earned $34.07 million this year. The report also stated that the firm’s return on equity is 16 percent. The firm retains 75 percent of its earnings. What will next year's earnings be?
Steph & Sons has a capital structure that consists of 20 percent equity and 80 percent debt. The company expects to report $3 million in net income this year, and 60 percent of the net income will be paid out as dividends. What is the debt structure of the capital budget?