Corporate Finance (The Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate)
11th Edition
ISBN: 9780077861759
Author: Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 3, Problem 9QP
External Funds Needed Dahlia Colby, CFO of Channing Florist Ltd., has created the firm’s pro forma
- a. Construct the current balance sheet for the firm using the projected sales figure.
- b. Based on Ms. Colby’s sales growth
forecast , how much does Charming Florist need in external funds for the upcoming fiscal year? - c. Construct the firm’s pro forma balance sheet for the next fiscal year and confirm the external funds needed that you calculated in part (b).
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
How do I construct a pro forma balance sheet for the next year and how do I calculate external funds needed?
Chachagogo, Inc. is planning its operations for next year, and the CEO wants you to forecast the firm's additional funds needed (AFN). Data for use in your forecast are shown below.
Based on the AFN equation, what is the AFN for the coming year?
Last year's sales P200,000
Sales growth rate 40%
Last year's current assets 65,000
Last year's noncurrent assets 70,000
Last year's profit margin 20.0% L
last year's accounts payable P50,000
Last year's notes payable P25,000
Last year's accruals P20,000
Target plowback ratio 75.0%
choices:
-44,000
-50,000
-54,000
-16,000
-40,000
Jonson, Inc. is planning its operations for the coming year, and the CEO wants you to forecast the firm's additional funds needed (AFN). Data for use in the forecast are shown below. However, the CEO is concerned about the impact of a change in the retention ratio from 90% that was used in the past to 50%, which the firm's investment bankers have recommended. Seventy-five percent of the total assets are considered…
Suppose that Gyp Sum Industries currently has the balance sheet shown below, and that sales for the year
just ended were $9.2 million. The firm also has a profit margin of 25 percent, a retention ratio of 30
percent, and expects sales of $7.2 million next year.
Assets
Current assets
Fixed assets
Total assets
Liabilities and Equity
Additional funds needed
$ 720,000 Current liabilities
4,800,000
Long-term debt
Equity
$5,520,000 Total liabilities and equity
$ 938,400
1,900,000
2,681,600
$5,520,000
If all assets and current liabilities are expected to shrink with sales, what amount of additional funds will
Gyp Sum need from external sources to fund the expected growth? (Enter your answer in dollars not in
millions. Negative amount should be indicated by a minus sign.)
Chapter 3 Solutions
Corporate Finance (The Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate)
Ch. 3 - Financial Ratio Analysis A financial ratio by...Ch. 3 - Industry-Specific Ratios So-called same-store...Ch. 3 - Sales Forecast Why do you think most long-term...Ch. 3 - Sustainable Growth In the chapter, we used...Ch. 3 - EFN and Growth Rate Broslofski Co. maintains a...Ch. 3 - Common-Size Financials One tool of financial...Ch. 3 - Asset Utilization and EFN One of the implicit...Ch. 3 - Comparing ROE and ROA Both ROA and ROE measure...Ch. 3 - Ratio Analysis Consider the ratio EBITD/Assets....Ch. 3 - Return on Investment A ratio that is becoming more...
Ch. 3 - Use the following information to answer the next...Ch. 3 - Prob. 12CQCh. 3 - Use the following information to answer the next...Ch. 3 - Use the following information to answer the next...Ch. 3 - Use the following information to answer the next...Ch. 3 - DuPont Identity If Wilkinson, Inc., has an equity...Ch. 3 - Equity Multiplier and Return on Equity Synovec...Ch. 3 - Using the DuPont Identity Y3K, Inc., has sales of...Ch. 3 - EFN The most recent financial statements for...Ch. 3 - Sales and Growth The most recent financial...Ch. 3 - Sustainable Growth If the Hunter Corp. has a ROE...Ch. 3 - Sustainable Growth Assuming the following ratios...Ch. 3 - Calculating EFN The most recent financial...Ch. 3 - External Funds Needed Dahlia Colby, CFO of...Ch. 3 - Sustainable Growth Rate The Wintergrass Company...Ch. 3 - Return on Equity Firm A and Firm B have debt-total...Ch. 3 - Ratios and Foreign Companies Prince Albert Canning...Ch. 3 - External Funds Needed The Optical Scam Company has...Ch. 3 - Days Sales in Receivables A company has net income...Ch. 3 - Ratios and Fixed Assets The Whisenhunt Company has...Ch. 3 - Calculating the Cash Coverage Ratio Panda Inc.s...Ch. 3 - Prob. 17QPCh. 3 - Prob. 18QPCh. 3 - Prob. 19QPCh. 3 - Fixed Assets and Capacity Usage For the company in...Ch. 3 - Calculating EFN The most recent financial...Ch. 3 - Prob. 22QPCh. 3 - Prob. 23QPCh. 3 - EFN and Internal Growth Redo Problem 21 using sale...Ch. 3 - Prob. 25QPCh. 3 - Prob. 26QPCh. 3 - Prob. 27QPCh. 3 - Sustainable Growth Rate Based on the results in...Ch. 3 - Prob. 29QPCh. 3 - Prob. 30QPCh. 3 - Prob. 1MCCh. 3 - Prob. 2MCCh. 3 - Prob. 3MCCh. 3 - Prob. 4MCCh. 3 - Prob. 5MC
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.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.arrow_forwardLong-Term Financing Needed At year-end 2018, Wallace Landscapings total assets were 2.17 million, and its accounts payable were 560,000. Sales, which in 2018 were 3.5 million, are expected to increase by 35% in 2019. Total assets and accounts payable are proportional to sales, and that relationship will be maintained. Wallace typically uses no current liabilities other than accounts payable. Common stock amounted to 625,000 in 2018, and retained earnings were 395,000. Wallace has arranged to sell 195,000 of new common stock in 2019 to meet some of its financing needs. The remainder of its financing needs will be met by issuing new long-term debt at the end of 2019. (Because the debt is added at the end of the year, there will be no additional interest expense due to the new debt.) Its net profit margin on sales is 5%, and 45% of earnings will be paid out as dividends. a. What were Wallaces total long-term debt and total liabilities in 2018? b. How much new long-term debt financing will be needed in 2019? [Hint: AFN New stock = New long-term debt.)arrow_forwardCheryl 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 yeararrow_forward
- Appalachian Registers, Inc. (ARI) has current sales of $50 million. Sales are expected to grow to $75 million next year. ARI currently has accounts receivable of $11 million, inventories of $15 million, and net fixed assets of $17 million. These assets are expected to grow at the same rate as sales over the next year. Accounts payable are expected to increase from their current level of $15 million to a new level of $20 million next year. ARI wants to increase its cash balance at the end of next year by $3 million over its current cash balances, which average $4 million. Earnings after taxes next year are forecasted to be $10 million. Next year, ARI plans to pay dividends of $1 million, up from $500,000 this year. ARI’s marginal tax rate is 34 percent. How much external financing is required by ARI next 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 ?arrow_forwardCompany is planning its operations for next year, and as its CFO, you will need to forecast the company’s additional funds needed (AFN) based on the following data. Dollars are in millions. Last year’s sales = $364 Last year’s accounts payable = $58Sales growth rate = 30% Last year’s notes payable = $50Last year’s total assets = $548 Last year’s accruals = $30Last year’s profit margin = 5.32% Target payout ratio = 60% Your company is operating at full capacity. Based on the AFN formula and the Percentage of Sales method, what is the AFN for the coming year? Round your answer to two decimal places of dollar, but ignore dollar and millions, e.g., xxx.xx. (Hint: Use the AFN General Formula in Financial Forecasting.) Answer:arrow_forward(B) Based on the following information, how much does the company need in external funds for the upcoming fiscal year? The company has Sales $ 5,700, Costs 4,200, Current assets 3,900, Fixed assets 8,100, Current liabilities 2,200, Long-term debt 3,750, and Equity 6,050. Sales increase 15% for the upcoming fiscal year. Payout ratio is 40% and Tax rate is 34%.arrow_forward
- Distribution Limited projects sales next year to be $4 million and expects to earn 5% of that amount after taxes. The company is currently in the process of projecting its financial needs and has made the following assumptions (projections): - Current Assets will equal 8% of sales, and fixed assets will remain at their current level of $1million. - Common equity is currently $0.6million (made up entirely of Retained earnings), and the company pays out half of its after-tax earnings in dividends. - The company has short-term payables that normally equal 7% of sales each and it has no long-term debt outstanding. What are the company’s financing needs for the coming year?arrow_forwardA company expects sales of $420 million next year assuming a 20% increase from the previous year. The firm anticipates $29.17 million in retained earnings after taxes and dividends have been paid, assuming that $1 million in depreciation expense have been deducted. Working capital is expected to represent 40% of change in sales. Required: Determine the amount of surplus (or deficit) in funds. k (INPUT YOUR ANSWER IN K, ROUNDED TO 2 DECIMAL PLACES. FOR EXAMPLE: 1.23. USE THE MINUS SIGN TO INDICATE A NEGATIVE ANSWER. FOR EXAMPLE: -1.23)arrow_forwardCURRENT ASSETS INVESTMENT POLICY Rentz Corporation is investigating the optimallevel of current assets for the coming year. Management expects sales to increase toapproximately $2 million as a result of an asset expansion presently being undertaken.Fixed assets total $1 million, and the firm plans to maintain a 60% debt-to-assets ratio.Rentz’s interest rate is currently 5% on both short- and long-term debt (which the firm uses in its permanent structure). Three alternatives regarding the projected current assets level are under consideration: (1) a restricted policy where current assets would be only 45% of projected sales, (2) a moderate policy where current assets would be 50% of sales, and (3) a relaxed policy where current assets would be 60% of sales. Earnings before interest and taxes should be 12% of total sales, and the federal-plus-state tax rate is 25%.a. What is the expected return on equity under each current assets level?b. In this problem, we assume that expected sales…arrow_forward
- Bondi Beachwear Company expects sales next year to be $310,000. Inventory and accounts receivable will have to be increased by $65,000 to accommodate this sales level. The company has a steady profit margin of 15 percent, with a 10 percent dividend payout. How much external funding will Bondi Beachwear Company have to seek? Assume there is no increase in liabilities other than that which will occur with the external financing. External funds neededarrow_forwardi need the answer quicklyarrow_forward(Forecasting financing needs) Beason Manufacturing forecasts its sales next year to be $5.6 million and expects to earn 4.3 percent of that amount after taxes. The firm is currently in the process of projecting its financing needs and has made the following assumptions (projections): • Current assets are equal to 19.3 percent of sales, and fixed assets remain at their current level of $1.1 million. • Common equity is currently $0.75 million, and the firm pays out half of its after-tax earnings in dividends. • The firm has short-term payables and trade credit that normally equal 12.1 percent of sales, and it has no long-term debt outstanding. What are Beason's financing needs for the coming year? Beason's expected net income for next year is $ 240,800 (Round to the nearest dollar.) Beason's expected common equity balance for next year is $ 870400. (Round to the nearest dollar.) Estimate Beason's financing needs by completing the pro forma balance sheet below: (Round to the nearest…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
How to build an investment portfolio; Author: The Finance Storyteller;https://www.youtube.com/watch?v=K4mWd2zBYVk;License: Standard Youtube License