*Figure 4.3: HST Capital Structure. Source: Excel
** Full calculations for Capital Structure model can be found in the attached Excel file here
*Figure 4.4: HST Cost of Debt. Source: Excel
** Full calculations for Cost of Debt model can be found in the attached Excel file here
*Figure 4.5: HST pre-tax Cost of Debt. Source: FactSet
*Figure 4.6: HST Cost of Common Equity. Source: Excel
I was able to examine the second component cost of capital, equity, by using the CAPM model (capital asset pricing model). This model shows the relationship between risk and the expected return of an asset. Its components include the risk free rate which I sourced from 10 year government yields since they are considered a "riskless investment vehicle." I then sought out the firms beta from multiple sources including Valueline, Fact Set, and S & P Capital IQ. I ended up using a beta of 1.16 which I pulled from Fact Set since it was the median of the three. The last component of the CAPM model is the market risk premium which was given from Fernandez et al. 2021 at 5.50%. I added the risk free rate and the beta then multiplied that value by the MRP to get a cost of equity at 9.98%. This is the expected rate of return an investor can expect to recieve when investing in the company.
** Full calculations for Cost of Common Equity model can be found in the attached Excel file here
*Figure 4.7: HST Sensitivity Analysis. Source: ValueLine, Factset, S&P Capital IQ.
After calculating the WACC, cost of debt, and cost of equity, I then conducted a WACC sensitivity analysis to wrap up my findings. In my analysis, WACC was dependent on beta as pictured in figure 4.7 above. I tested multiple betas that were sourced from Value Line, Fact Set, and S&P Capital IQ. The range of the three betas was only 0.15. If WACC was calculated with the lowest beta of 1.1 from Value Line, WACC would decrease to 6.87%. Using the Fact Set beta of 1.6, WACC sat at 7.10% and with S&P Capital IQs beta of 1.25, WACC rose to 7.45%. As you can see, WACC is highly dependent on beta.
** Full calculations for Sensitivity Analysis can be found in the attached Excel file here