← Back to Templates


WACC Analysis (Stock Comparison)
Description

Builds a weighted average cost of capital for several companies side by side. The equity side uses beta with the risk free and market return assumptions you enter, while the debt side derives an effective borrowing rate from interest expense against long term and total debt.
Share count and price give the market value of equity, so the debt and equity weights are calculated rather than assumed. Sector labels sit next to each name, making it clear why a capital heavy business discounts its cash flows at a different rate than a lighter peer does.
Template Screenshots

Market data in your Excel sheets
1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.
See plans
▶
How does MarketXLS work? Watch Demo
Similar Templates
No similar templates found