← 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

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

Similar Templates

No similar templates found