Chapter 9 - Homework 6 Template

xlsx

School

University of Texas, Dallas *

*We aren’t endorsed by this school

Course

4337

Subject

Finance

Date

Apr 3, 2024

Type

xlsx

Pages

8

Uploaded by AmbassadorLobster4056

Report
Given Debt beta 0.20 Levered equity beta 1.60 Market Risk Premium 5% Risk free rate 7% Borrowing rate (before tax) 8% Number of common shares 2,000 Tax rate 30% Solution After-tax cost of debt Levered cost of equity Years 1 2 3 Sales $ 100,000.00 $ 100,000.00 $ 100,000.00 Operating income (Earnings Before Interest and Taxes) 22,000.00 22,000.00 22,000.00 Less: Cash tax payments Net operating profits after taxes (NOPAT) Plus: Depreciation expense $ 8,000.00 $ 8,000.00 $ 8,000.00 Less: Investments in Net Working Capital in new Capital (CAPEX) Firm free cash flow (FCF) Equity Free Cash Flow Calculation 1 2 3 (Firm) Free Cash Flow Less: Interest x (1 - Tax Rate) (Equity) Free Cash Flow Debt Valuation Present value of interest for Years 1-4 Present value of principal in Year 4 Debt Value Equity Valuation Present value of EFCFs for Years 1-4 Present value of EFCFs for Years 5 and beyond Equity Value Enterprise Value = Debt value + Equity value Market Value Proportion After-Tax Cost Long-term Debt Equity Total Problem 9-4: Traditional WACC Valuation a. What is Canton's cost of equity capital? What is the after-tax cost of debt for the firm? b. Calculate the equity free cash flows for Canton for each of the next four years. c. Using the estiamted market values of Canton's debt and equity and the after-tax cost of capital, calculate its
See the answer to part b above. Present value of firm free cash flows: Planning horizon (4 years) Terminal value In year 4 Present Value Enterprise Value = Value of invested capital Enterprise Value Less: Debt Equals: Shareholder value No. of shares (000) Value per share a. Computing Canton's unlevered cost of equity Risk free rate 7% Market risk premium 5% Levered equity beta 1.60 Debt beta 0.20 Unlevered beta #DIV/0! Unlevered cost of equity b. Unlevered FCFs for Years 1-4 Unlevered FCFs = Firm FCFs 1 2 3 (Firm) Free Cash Flow c. Interest Tax Savings = Interest Expense x Tax Rate d. Estimated APV Present value of Unlevered FCFs #DIV/0! Present value of Interest Tax Savings - Estimated APV e. Estimated per share value APV (firm value) $ - less: Debt (25,000.00) Equals: Shareholder value No. of shares (000) 2,000 Value per share d. What are the firm free cash flows for Canton for years 1-4? e. Estimate the enterprise value of Canton using the Traditional WACC method. f. What is the value per share of equity for Canton? Problem 9-6: APV Valuation To unlever the equ case) and debt is a following equation
Solution Legend = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output 4 $ 100,000.00 22,000.00 $ 8,000.00 4 Product WACC.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
25,000.00 2,000 4 uity beta where the level of debt is fixed (as in this assumed to have a beta of zero, we solve the n: 𝛽 𝑈 = 𝛽 𝐸 + 𝛽 𝐷 (1 − 𝑇) 𝐷 𝐸 ቂ1 + (1 − 𝑇) 𝐷 𝐸
Pro Forma Income 1 2 Sales $ 100,000.00 $ 100,000.00 Cost of goods sold (40,000.00) (40,000.00) Gross profit $ 60,000.00 $ 60,000.00 Operating expenses (excluding depreciation) (30,000.00) (30,000.00) Depreciation expense (8,000.00) (8,000.00) Operating income (Earnings Before Interest and Taxes) $ 22,000.00 $ 22,000.00 Less: Interest expense (2,000.00) (2,000.00) Earnings before taxes $ 20,000.00 $ 20,000.00 Less: Taxes (6,000.00) (6,000.00) Net income $ 14,000.00 $ 14,000.00 Solution = Value given in p = Formula/Calcul = Qualitative anal = Goal Seek or So = Crystal Ball Inp = Crystal Ball Out
Statements ($000) 3 4 $ 100,000.00 $ 100,000.00 (40,000.00) (40,000.00) $ 60,000.00 $ 60,000.00 (30,000.00) (30,000.00) (8,000.00) (8,000.00) $ 22,000.00 $ 22,000.00 (2,000.00) (2,000.00) $ 20,000.00 $ 20,000.00 (6,000.00) (6,000.00) $ 14,000.00 $ 14,000.00 n Legend problem lation/Analysis required lysis or Short answer required olver cell put tput
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Actual Projected Sales Reve 0 1 2 3 Sales $ 100,000 $ 100,000 $ 100,000 $ 100,000 Proforma Balance Shee 0 1 2 3 Current Assets $ 15,000 $ 15,000 $ 15,000 $ 15,000 Property, Plant & Equipment 40,000 40,000 40,000 40,000 Total $ 55,000 $ 55,000 $ 55,000 $ 55,000 Accruals & Payables $ 5,000 $ 5,000 $ 5,000 $ 5,000 Long-term debt 25,000 25,000 25,000 25,000 Equity 25,000 25,000 25,000 25,000 Total $ 55,000 $ 55,000 $ 55,000 $ 55,000 Invested Capital $ 50,000 $ 50,000 $ 50,000 $ 50,000 Solution Legend = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer requir = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output We use the equity account to make the balance sheet balance. The added equity is raised either through the retention of earnings or sale of new common shares.
enues 4 5 $ 100,000 $ 100,000 ets ($000) 4 5 $ 15,000 $ 15,000 40,000 40,000 $ 55,000 $ 55,000 $ 5,000 $ 5,000 25,000 25,000 25,000 25,000 $ 55,000 $ 55,000 $ 50,000 $ 50,000 red