← Back to Templates

WACC Analysis (Stock Comparison)

Description

WACC Analysis (Stock Comparison) thumbnail

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

WACC Analysis (Stock Comparison) screenshot 1

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?
▶
How does MarketXLS work? Watch Demo

Similar Templates

No similar templates found