← 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

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work? Watch Demo
Similar Templates
No similar templates found