Determine WACC For A Publicly Traded Company Using Yahoo! Fi ✓ Solved

Determine WACC for a publicly traded company using Yahoo! Fi

Determine WACC for a publicly traded company using data from Yahoo! Finance for market cap and beta, and FINRA Bonds for debt data. Use market risk premium of 5% and risk-free rate of 3.5%, with a corporate tax rate of 40%. Provide a 350-700 word report detailing your calculated WACC, how data were used with formulas (substituting values), sources, and your confidence in the result. Include an Excel file showing calculations.

Paper For Above Instructions

Introduction and purpose. Weighted Average Cost of Capital (WACC) is a key discount rate used to evaluate investments and to assess firm value under the premise of capital budgeting and corporate finance theory. WACC represents the blended cost of capital from all sources, including equity and debt, weighted by their relative uses in the firm’s capital structure (Damodaran, 2023). The assignment asks for a transparent calculation using data that are publicly accessible, with explicit assumptions (e.g., market risk premium and risk-free rate) and a discussion of the data sources and confidence in the result (Koller, Goedhart, & Wessels, 2015). This paper selects Apple Inc. (AAPL) as the example company because it is widely covered in public data sources and has a substantial equity market value alongside bond issuance data available for estimation of the pre-tax cost of debt (Yahoo Finance; FINRA Bonds). References to standard WACC methodology are drawn from canonical corporate finance texts and practitioner-focused valuation literature (Brealey, Myers, & Allen, 2019; Ross, Westerfield, & Jaffe, 2019).

Data sources and key inputs. The calculation requires three primary data inputs: (a) the market value of equity (E), (b) the market value of debt (D), and (c) the cost of equity (rE) and the pre-tax cost of debt (rD). The equity value (E) is proxied by the firm’s equity market capitalization, which Yahoo Finance reports for publicly traded companies and is used widely in WACC calculations (Yahoo Finance, 2024). The beta (β) needed to estimate the cost of equity is also provided by Yahoo Finance and reflects systematic risk relative to the market (Yahoo Finance, 2024). The market value of debt (D) is harder to observe directly; here, data can be inferred from reported total debt in the company’s balance sheet and by cross-checking publicly available bond data from FINRA Bonds, which lists outstanding corporate bonds and their yields to maturity (FINRA Bonds, 2024). For WACC, the tax shield is incorporated via the corporate tax rate (Tc = 40% in this exercise). The model assumes a market risk premium (MRP) of 5% and a risk-free rate (rf) of 3.5%, consistent with the assignment’s stated parameters (Damodaran, 2023; Investopedia, 2024).

Spreadsheet logic and formulae. The WACC formula used is rWACC = (E/(E+D)) rE + (D/(E+D)) rD (1 - Tc). The cost of equity is calculated as rE = rf + β MRP, where β is the equity beta derived from Yahoo Finance’s data for the chosen company. The cost of debt rD is taken from the yield to maturity (YTM) on the firm’s publicly traded bonds; if multiple issues exist, an industry-standard approach is to use a representative, non-callable bond’s YTM to approximate the firm’s pre-tax cost of debt (Damodaran, 2023; Brigham & Ehrhardt, 2016). The input values chosen for this example (Apple Inc.) reflect publicly accessible data and widely accepted practice in WACC computation (Koller, Goedhart, & Wessels, 2015).

Illustrative calculation (Apple Inc.). Using publicly reported or publicly verifiable data, the following inputs are assumed for demonstration. Equity value (E) ≈ $2.7 trillion; debt value (D) ≈ $120 billion; beta (β) ≈ 1.09; market risk premium (MRP) = 5%; risk-free rate (rf) = 3.5%; tax rate (Tc) = 40%; pre-tax debt cost (rD) ≈ 3.2% based on publicly listed Apple bonds (non-callable issues) with yields observed on FINRA Bonds. The cost of equity is thus rE = 3.5% + 1.09 5% ≈ 9.0%. The weights are E/(E+D) ≈ 0.957 and D/(E+D) ≈ 0.043. Substituting into the WACC formula gives: rWACC ≈ 0.957 9.0% + 0.043 3.2% (1 - 0.40) ≈ 8.62% + 0.08% ≈ 8.70%.

Discussion of results and sensitivity. The computed WACC of approximately 8.7% for Apple reflects a heavy equity base relative to modest debt, given Apple’s enormous market capitalization versus relatively small total debt. The result aligns with common WACC ranges for large, low-risk tech incumbents, though real-world WACC can vary with changes in market conditions, debt issuance costs, and the firm’s actual capital structure at the measurement date (Damodaran, 2023; Koller, Goedhart, & Wessels, 2015). Sensitivity analysis reveals that WACC is notably sensitive to β and rD. If β rises from 1.09 to 1.20, rE increases to 10.0% or higher, pushing WACC toward 9.0% or more. Conversely, if rD falls to 2.5%, the after-tax cost of debt contribution shrinks, modestly lowering WACC by a few basis points. These sensitivities underscore the ongoing need to use current, company-specific inputs and to present a range of potential outcomes rather than a single point estimate (Damodaran, 2023; Brigham & Ehrhardt, 2016).

Data sources and justification. The primary data sources used in this construction are publicly accessible financial data services and canonical finance texts. Yahoo! Finance provides current market capitalization and beta values used to estimate rE (Yahoo Finance, 2024). FINRA Bonds is used to identify outstanding Apple corporate bonds and their current yields to maturity, which underpin the pre-tax cost of debt (FINRA Bonds, 2024). Apple’s own annual report (Form 10-K) provides the exact accounting debt levels and the company’s liquidity profile, which informs the reasonableness of the debt input (Apple 10-K, 2023). Foundational theory and method for WACC calculation are supported by standard corporate finance texts and widely cited practitioners (Brealey, Myers, & Allen, 2019; Ross, Westerfield, & Jaffe, 2019; Koller, Goedhart, & Wessels, 2015; Damodaran, 2023). Supporting background on equity risk premium and the cost of capital framework is provided by Damodaran (2023), Investopedia (2024), and McKinsey’s valuation literature (2015).

Summary of evidence and confidence. The calculated WACC rests on transparent, publicly verifiable inputs and a well-established formula. Nevertheless, several limitations exist. First, market values are dynamic; the measured E and D at any date may differ from those used in a static calculation, especially given Apple’s substantial cash and investments that affect net debt calculations. Second, the beta and cost of debt depend on market conditions and bond-specific features (callability, seniority), which may not be perfectly captured by a single estimate. Third, the assumed tax rate (Tc = 40%) is a simplification; effective tax rates vary by jurisdiction and corporate structure. Finally, the Market Risk Premium (MRP) and rf are subject to judgment and can be updated as market data evolve (Damodaran, 2023). Despite these caveats, the approach provides a rigorous and reproducible framework for WACC estimation and supports scenario analysis to illustrate how changes in inputs affect the discount rate used in capital budgeting.

Excel file. An accompanying Microsoft Excel workbook named “AAPL_WACC_Calculation.xlsx” accompanies this submission. The workbook contains separate sheets for inputs (E, D, β, rD, rf, MRP, Tc), the equity cost rE calculation, debt cost rD, and the final rWACC. It includes cell formulas that reproduce the numbers shown above and allows for quick scenario analyses by adjusting input values (e.g., β, rD, Tc). This fulfills the requirement to show the calculation workflow and supports the justification of the result with transparent computations.

References

  • Brealey, R. A., Myers, S. C., & Allen, F. (2019). Principles of Corporate Finance. McGraw-Hill Education.
  • Damodaran, A. (2023). What is the Cost of Capital? Damodaran Online. Retrieved from https://www.damodaran.com
  • Damodaran, A. (2023). Equity Risk Premiums. Damodaran Online. Retrieved from https://www.damodaran.com
  • Investopedia. (2024). Weighted Average Cost of Capital (WACC). Retrieved from https://www.investopedia.com/terms/w/wacc.asp
  • Koller, T., Goedhart, M., & Wessels, D. (2015). Valuation: Measuring and Managing the Value of Companies (7th ed.). Wiley.
  • McKinsey & Company. (2015). Valuation: Measuring and Managing the Value of Companies. Wiley.
  • Ross, S. A., Westerfield, R. W., & Jaffe, J. (2019). Corporate Finance (12th ed.). McGraw-Hill Education.
  • Yahoo Finance. (2024). Apple Inc. (AAPL) Market Data and Beta. Retrieved from https://finance.yahoo.com/quote/AAPL
  • FINRA Bonds. (2024). Apple Inc. Corporate Bonds — Data and YTM. Retrieved from https://www.finra.org/
  • Apple Inc. (2023). Form 10-K. Retrieved from https://www.apple.com/investor-relations

Related Assignments