PRIN.OF CORP.FINANCE-CONNECT ACCESS
13th Edition
ISBN: 2810023360757
Author: BREALEY
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 29, Problem 22PS
Long-term financial plans
- a. Use the Dynamic Mattress model in Table 29.9 and the spreadsheets to produce pro forma income statements,
balance sheets , and statements of cash flows for 2019–2023. Assume business as usual, except that sales and costs are now planned to expand by 30% per year, as are fixed assets and net working capital. The interest rate isforecasted to remain at 10% and stock issues are ruled out. Dynamic also sticks to its 60% dividend payout ratio. - b. What are the firm’s debt ratio and interest coverage under this plan?
- c. Can the company continue to finance expansion by borrowing?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
3. After studying the Financial Forecast and planning, go through the assumption date given
below and calculate how much Discretionary financing will we need in 2021 year?
Suppose this year's sales will total $32 million.
Next year, we forecast sales of $50 million.
Net income should be 5% of sales.
Dividends should be 50% of earnings.
If this year's information's are as follows:
This year
% of $32m
Assets
Current Assets
Fixed Assets
$8m
25%
$16m.
50%
Total Assets
$24m
Liab, and Equity
Accounts Payable
Accrued Expenses
Notes Payable
Long Term Debt
$4m
12.5%
$4m
12.5%
$1m
nla
$6m
Total Liabilities
$15m
Common Stock
Retained Earnings
Equity
Total Liab. & Equity
$7m
nla
$2m
$9m
$24m
Start with the partial model in the file Ch07 P25 Build a Model.xlsx on the textbook’s Web site. Selected data for the Derby Corporation are shown here. Use the data to answer the following questions.a. Calculate the estimated horizon value (i.e., the value of operations at the end of the forecast period immediately after the Year-4 free cash flow). Assume growth becomes constant after Year 3.b. Calculate the present value of the horizon value, the present value of the free cash flows, and the estimated Year-0 value of operations. c. Calculate the estimated Year-0 price per share of common equity. INPUTS (In Millions) YearCurrent Projected0 1 2 3 4Free cash flow −$20.0 $20.0 $80.0 $84.0Marketable securities $40Notes payable $100Long-term bonds $300Preferred stock $50WACC 9.00%Number of shares of stock 40
Rachel the chief financial officer of sunrise fruit snakcs, needed to determine the compnays projected cost of capital for next year, to do so , wshe needed to know the following infomraiont expect
a) the proejcted equity level for next year
b) the projected intereset rate on next years debt
The projected debt level for next year
D0 the projected cash balance for next year
Chapter 29 Solutions
PRIN.OF CORP.FINANCE-CONNECT ACCESS
Ch. 29 - Sources and uses of cash State whether each of the...Ch. 29 - Sources and uses of cash Table 29. 11 shows...Ch. 29 - Prob. 3PSCh. 29 - Sources and uses of cash and working capital...Ch. 29 - Prob. 5PSCh. 29 - Prob. 6PSCh. 29 - Cash cycle A firm is considering several policy...Ch. 29 - Collections on receivables Here is a forecast of...Ch. 29 - Collections on receivables If a firm pays its...Ch. 29 - Forecasts of payables Dynamic Futon forecasts the...
Ch. 29 - Cash budget Table 29.13 lists data from the budget...Ch. 29 - Short-term financial plans a. Paymore places...Ch. 29 - Short-term financial plans Which items in Table...Ch. 29 - Short-term financial plans Work out a short-term...Ch. 29 - Prob. 16PSCh. 29 - Prob. 17PSCh. 29 - Long-term financial plans Corporate financial...Ch. 29 - Prob. 19PSCh. 29 - Prob. 20PSCh. 29 - Long-term financial plans Construct a new model...Ch. 29 - Long-term financial plans a. Use the Dynamic...Ch. 29 - Long-term financial plans Table 29.15 summarizes...Ch. 29 - Long-term financial plans Abbreviated financial...Ch. 29 - Prob. 25PSCh. 29 - Forecast growth rate What is the maximum possible...Ch. 29 - Forecast growth rate a. What is the internal...Ch. 29 - Forecast growth rate Bio-Plasma Corp. is growing...Ch. 29 - Long-term plans Table 29.18 shows the 2019...
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
- Start with the partial model in the file Ch07 P25 Build a Model.xlsx on the textbook’s Web site. Selected data for the Derby Corporation are shown here. Use the data to answer the following questions. Calculate the estimated horizon value (i.e., the value of operations at the end of the forecast period immediately after the Year-4 free cash flow). Assume growth becomes constant after Year 3. Calculate the present value of the horizon value, the present value of the free cash flows, and the estimated Year-0 value of operations. Calculate the estimated Year-0 price per share of common equity.arrow_forwardAssume your organization wishes to make a Php 200,000 investment with a private equity firm in 2021. Taking into account all of the risks, the current discount rate is 12%, and the revenue stream/dividends are as follows: 2022 50002023 60002024 70002025 80002026 90002027 100002028 11000 Determine the following:a. NPV for the period 2022 through 2028;b. Total NPV using manual computation;c. Total NPV using the Excel function; andd. IRR rate.arrow_forwardAssume today is 15 Jan 2020. You t e the following information regarding Salalah Ceramics 31 Dec 2019 31 Dec 2020 31 Dec 2021 31 Dec 2022 Cash Flow from 12000 Operations Cash Investment 7600 Cash flow from operations will grow by 10% every year up to 2022 and cash investment will grow by 20% every year up to 2022. FCF growth after 2022 will be 5% and required return is 12%. Assuming net debt is 7000 1. What is the firm's enterprise value 2. What is the firm's value of equityarrow_forward
- On the basis of the financial information given in this case, complete the WACC table that is prepared for this project . What was the WACC for Atlassian as at 2022? What was the WACC one year earlier? Estimate the important financial information such as the after-tax cost of debt, the risk-free rate, the market risk premium, the cost of equity and the weight of debt and equity. Clearly specify and justify the assumptions and calculations required for these analyses (ie. how did you select the beta, risk-free rate, market return, etc). WACC Calculation for Atlasian 2021 2022 Shares Outstanding (in millions) Share Price Market Value Equity Total Market Value of Debt Total Capital - Atlassian Weight of Debt Weight of Equity Cost of Debt Effective Interest Rate for Atlassian Tax Rate After-tax Cost of Debt Cost of Equity Beta Market risk premium Rf Cost of…arrow_forwardSERVICIOS EDUCATIVOS IMPRESOS S.A. wants to do a scenario analysis for the coming year (2022). The pessimistic prediction for sales is $900,000; the most likely amount of sales is $1,125,000; and the optimistic prediction is $1,280,000. The company's income statement for the most recent year is the following: SERVICIOS EDUCATIVOS IMPRESOS S.A. - Income Statement for the year ended December 2021 0 Sales revenue Less: Cost of goods sold Gross profits Less: Operating expenses Operating profits Less: Interest expense Net profits before taxes Less: Taxes (rate = 25%) Net profits after taxes $937,500 421,875 $515,625 234,375 $281,250 30,000 $251,250 62,813 $188,437 Use the percent-of-sales method, the income statement for December 31, 2021 and the sales revenue estimates to develop pessimistic • most likely • optimistic pro forma income statements for the coming year.arrow_forwardAssume your organization wishes to make a Php 200,000 investment with a private equity firm in 2021. Taking into account all of the risks, the current discount rate is 12%, and the revenue stream/dividends are as follows: 2022 50002023 60002024 70002025 80002026 90002027 100002028 11000 Determine the following: DO IT IN EXCELa. NPV for the period 2022 through 2028;b. Total NPV using manual computation;c. Total NPV using the Excel function; andd. IRR rate.arrow_forward
- Give only typing answer with explanation and conclusion to all parts Assume that Abiproffy has a $112.5 million capital budget planned for the coming year. You have determined its present capital structure (80% equity and 20% debt) is optimal, and its net income is forecasted at $140 million. Use the residual distribution model approach to determine Abiproffy’s total dollar distribution. Assume for now that the distribution is in the form of a dividend. Abiproffy has 100 million shares. Answer the following questions. What is the forecasted dividend payout ratio? What is the forecasted dividend per share? What would happen to the payout ratio and DPS if net income were forecasted to decrease to $90 million? To increase to $160 million? In general terms, how would a change in investment opportunities affect the payout ratio under the residual payment policy?arrow_forwardEstimate Pharma’s sustainable sales growth rate based on its 2019 financial statements. [Hint: You need to estimate the beginning of period stockholders’ equity based on the information provided.] What financial policy change might Pharma Biotech make to improve its sustainable growth rate? Show your calculations.arrow_forwardChachagogo, 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…arrow_forward
- as « Question 15 of 50 > Clayton Industries is planning its operations for next year. Ronnie Clayton, 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? Dollars are in millions. Last year's sales So Sales growth rate g Last year's total assets A0* Last year's profit margin PM $350 Last year's accounts payable Last year's notes payable Last year's accruals Target payout ratio %3D $40 30% $50 $500 $30 5% %3D 60% O a. $102.8 O b. $108.2 O c. $125.9 O d. $113.9 O e. $119.9 0 Icon Key P Type here to search W 8:24 SN3コロ 4/12/ acearrow_forwardMichael We have created various scenarios each with a forecast for our expected sales volume, revenues, expenses, risks, etc. At a high level, here are how each of the scenarios looks like. Calculate NPV for Scenario A. Use the information provided on the right. Round to the nearest whole number. Scenario Comparison ($) Scenario A Scenario B Scenario C Initial Investment 2,000,000 2,000,000 2,000,000 Expected interest rate: 12% Forecasting period: 5 years PV annuity factor: 3.6048 Annual Net Income 545, 100 426,995 1,644,385 Annual Cash Flow 648,050 -493,005 2,564,385 NPV -3,777,184 7,244,095arrow_forwardCurrent and projected free cash flows for Radell Global Operations are shown below. Actual Projected 2019 2020 2021 2022 Free cash flow $603.460 $664.140 $704.187 $746.440 (millions of dollars) Growth is expected to be constant after 2021, and the weighted average cost of capital is 10.8%. What is the horizon (continuing) value at 2022 if growth from 2021 remains constant? Do not round intermediate calculations. Enter your answer in millions. For example, an answer of $1 million should be entered as 1, not 1,000,000. Round your answer to the nearest whole number.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
- Fundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Financial Projections for Startups Basic Walkthrough; Author: Mike Lingle;https://www.youtube.com/watch?v=7avegQF4dxI;License: Standard youtube license