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

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

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

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
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 S&H construction company expects to have total sales next year totaling $14,500,00 In addition, the firm pays taxes at 35 percent and will owe $318,000 in interest expenses. Based on last year’s operations the firm’s management predicts that its cost of goods sold will be 58 percent of sales and operating expenses will total 32 percent. What is your estimate of the firm’s net income after taxes for the coming year ? Complete the pro-forma income statement below Round to the nearest dollar Pro-forma income statement Sales Cost of goods sold Gross profit Operating expenses Net operating expenses Interested expenses Earnings before taxes Taxes Net income
To estimate Missed Places Inc.'s (MP) external financing needs, the CFO needs to figure out how much equity her firm will have at the end of next year. At the end of the most recent fiscal year, MP's retained earnings were $158,000. The Controller has estimated that over the next year, gross profits will be $360,700, earnings after tax will total $21,400, and MP will pay $12,400 in dividends. What are the estimated retained earnings at the end of next year? (Please show work and explain) Intellus has long-term debt of $5 million, owners' equity of $7.75 million, current assets of $1 million, gross fixed assets of $20 million, and accumulated depreciation of $7 million. What is the firm’s net working capital? (Please show work and explain)
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
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
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…
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?
The newspaper reported last week that SunRise Enterprises earned $34.19 million this year. The report also stated that the firm’s return on equity is 13 percent. The firm retains 85 percent of its earnings. What will next year's earnings be?
It was reported last week that Blue Bell Enterprises earned $18.5 million this year. The report also stated that the firm’s return on equity is 11 percent. The firm retains 80 percent of its earnings. What will next year's earnings be? Round to the nearest whole dollar.
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?