# Step-by-Step Solution Let's break down the analysis based on the provided spreadsheet image. We'll go through the **Weighted Average Cost of Capital (WACC)** calculation since that's the focus of the sheet and the main calculation asked in the comprehensive question. --- ## **Step 1: Gather Required Inputs** ### **A. Stock Information** - **Market Value of Equity (E):** $620,000 - **Cost of Equity (Re):** 16% - **Equity Weight:** \[ \text{Equity Weight} = \frac{E}{E + D} = \frac{620,000}{620,000 + 480,000} \] ### **B. Bond Information** - **Market Value of Debt (D):** $480,000 - **Cost of Debt (Rd):** 11% - **Tax Rate (Tc):** 21% - **Debt Weight:** \[ \text{Debt Weight} = \frac{D}{E + D} = \frac{480,000}{620,000 + 480,000} \] #### **Explanation (Step 1):** - We need the market values (not book values) for the weights. - The cost of equity and after-tax cost of debt will be plugged into the WACC formula. --- ## **Step 2: Calculate WACC** ### **A. Calculate Weights** \[ E + D = 620,000 + 480,000 = 1,100,000 \] \[ \text{Equity Weight} = \frac{620,000}{1,100,000} = .5636 \text{ (rounded to 4 decimals)} \] \[ \text{Debt Weight} = \frac{480,000}{1,100,000} = .4364 \text{ (rounded to 4 decimals)} \] ### **B. Apply WACC Formula** \[ \text{WACC} = (E/V) \cdot Re + (D/V) \cdot Rd \cdot (1 - Tc) \] Plug in values: \[ \text{WACC} = (.5636 \times .16) + (.4364 \times .11 \times (1 - .21)) \] \[ = .0902 + (.4364 \times .11 \times .79) \] \[ = .0902 + (.4364 \times .0869) \] \[ = .0902 + .0379 \] \[ = .1281 \text{ or } 12.81\% \] #### **Explanation (Step 2):** - The WACC formula blends the cost of equity and after-tax cost of debt, weighted by their market values. - The tax shield is applied to the debt component. --- ## **Final Answer** **The Weighted Average Cost of Capital (WACC) for this project is:** \[ \boxed{12.81\%} \] --- ### **Summary of Steps:** 1. **Gathered all necessary input values and calculated equity and debt weights based on market values.** 2. **Plugged values into the WACC formula and solved step-by-step, applying the tax shield to the debt.** Let me know if you want to walk through the NPV or cash flow calculations as well!