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 $330 million. Current assets, fixed assets, and short-term debt are 15 percent, 75 percent, and 5 percent of sales, respectively. Charming Florist pays out 25 percent of its net income in dividends. The company currently has $126 million of long-term debt and $54 million in common stock par value. The profit margin is 16 percent.

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 $330 million. Current assets, fixed assets, and short-term debt are 15 percent, 75 percent, and 5 percent of sales, respectively. Charming Florist pays out 25 percent of its net income in dividends. The company currently has $126 million of long-term debt and $54 million in common stock par value. The profit margin is 16 percent.

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter9: Capital Budgeting And Cash Flow Analysis

Section: Chapter Questions

Problem 20P

See similar textbooks

Similar questions

Broussard Skateboard’s sales are expected to increase by 15% from $8 million in 2018 to $9.2 million in 2019. Its assets totaled $5 million at the end of 2018. Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2018, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. The after-tax profit margin is forecasted to be 6%, and the forecasted payout ratio is 40%. Use the AFN equation to forecast Broussard’s additional funds needed for the coming year.
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
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
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)
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.
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.
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
The Boyd Corporation has annual credit sales of $1.6 million. Currentexpenses for the collection department are $35,000, bad-debt losses are1.5%, and the days sales outstanding is 30 days. The firm is consideringeasing its collection efforts such that collection expenses will be reduced to$22,000 per year. The change is expected to increase bad-debt losses to 2.5%and to increase the days sales outstanding to 45 days. In addition, sales areexpected to increase to $1,625,000 per year.Should the firm relax collection efforts if the opportunity cost of funds is16%, the variable cost ratio is 75%, and taxes are 40%?
Margetis Inc. carries an average inventory of $750,000. Its annual sales are $10 million, its cost of goods sold are 75% of annual sales, and its receivables collection period is twice as long as its inventory conversion period. The firm buys on terms of net 30 days, and it pays on time. Its new CFO wants to decrease the cash conversion cycle by 18 days, based on a 365-day year. He believes he can reduce the average inventory to $605,885 with no effect on sales. By how much must the firm also reduce its accounts receivable to meet its goal in the reduction of its cash conversion cycle? Please explain the process and show calculations.
Steber Packaging Inc. expects sales next year of $40 million. Of this total, 45 percent is expected to be for cash and the balance will be on credit, payable in 30 days. Operating expenses are expected to total $17 million. Accelerated depreciation is expected to total $12 million, although the company will only report $8 million of depreciation on its public financial reports. The marginal tax rate for Steber is 34 percent. Current assets now total $26 million and current liabilities total $14 million. Current assets are expected to increase to $29 million over the coming year. Current liabilities are expected to increase to $20 million. Compute the projected after-tax operating cash flow for Steber during the coming year. Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Round your answer to two decimal places. $ million