WACC Calculator with Comparable Companies Analysis
Calculate weighted average cost of capital using comparable company benchmarking data
This template helps you determine your company's weighted average cost of capital (WACC) by analyzing financial metrics from comparable firms. Input your company data and comparable company information in the yellow cells, and the template automatically calculates WACC components and averages across the peer group. Perfect for corporate finance professionals, investment analysts, and business valuators who need to establish cost of capital baselines for investment decisions and valuation models.
What's inside
- Input cells for company and comparable firm data
- Automatic averaging of comparable company metrics
- WACC component calculations
- Peer group benchmarking
- SUM formulas for totaling financial inputs
Download this template
.xlsx · 1 sheet
$9/monthDownload up to 10 templates a month from a library of thousands. Cancel anytime.
- 10 downloads every month
- Cancel anytime
- 14-day refund policy
More in Business Planning & Strategy
Product Costing Sheet Format in Excel: Materials, Labour, Overhead & Selling Price
A costing sheet format in Excel that builds the true cost per unit of every product or recipe from materials with waste, labour by operation and allocated overheads, then prices it at your target margin. Works as a product costing template, cost sheet template and food or recipe costing template.
- 11 connected tabs, from a quick-start guide to Settings
- Classic cost sheet format: prime cost, works cost, cost of production, cost of sales
- Bill of materials or recipe with waste % per line
ISO 9001:2000 Cost Model
Track quality management system costs across ISO 9001:2000 clauses and project phases.
- Multi-project cost scaling
- Clause-by-clause cost breakdown
- Documentation phase cost tracking
WACC Calculator with Comparable Companies Analysis
Calculate weighted average cost of capital using comparable company benchmarking and financial inputs.
- Comparable company data input fields
- Automatic WACC calculation
- Average metrics across peer companies
Capital Budgeting Investment Analysis
Evaluate investment decisions with NPV and IRR calculations across multi-year cash flow projections.
- 10-year cash flow modeling
- NPV and IRR automated calculation
- Old vs. new asset comparison