Company Valuation Model — DCF + Comparable Company Multiples (Bilingual - Español - English)

A fully integrated Excel valuation model designed to estimate company value using Discounted Cash Flow (DCF) analysis and Comparable Company Multiples, with supporting WACC, financial projections, sensitivity analysis, and valuation summary.

The model provides a structured framework for performing a comprehensive company valuation from operating assumptions through Enterprise Value, Equity Value, and implied value per share. It combines intrinsic valuation through DCF with relative valuation using comparable companies, allowing users to cross-check valuation results across multiple methodologies.

The model includes CAPM-based WACC calculation, cost of equity, cost of debt, capital structure, direct or comparable-based beta, historical financial data, projected operating assumptions, working capital drivers, CapEx, taxes, and terminal value assumptions.

The DCF section builds Unlevered Free Cash Flow from Revenue through EBITDA, EBIT, NOPAT, D&A, CapEx, and changes in Net Working Capital. It calculates present values of projected FCF, terminal value, Enterprise Value, Equity Value, and value per share using both Gordon Growth and Exit EV/EBITDA Multiple approaches.

The model also includes three sensitivity analysis tables covering WACC versus terminal growth, WACC versus exit multiple, and WACC versus terminal growth for value per share.

The Comparable Company Multiples section allows users to enter selected peer companies and automatically calculates Market Capitalization, Enterprise Value, EV/Revenue, EV/EBITDA, EV/EBIT, P/E, D/E, and unlevered beta. Statistical analysis includes minimum, 25th percentile, median, mean, 75th percentile, and maximum values, with median multiples applied to the target company.

A Precedent Transactions section is also included for transaction-based cross-checking, while the Valuation Summary consolidates the valuation ranges from DCF, comparable companies, and precedent transactions.

The workbook includes built-in integrity checks covering WACC, terminal growth, diluted shares, beta methodology, terminal assumptions, sensitivity consistency, transaction/comparable data sufficiency, and projection chronology.

The DEMO data is illustrative and should be replaced with real, verifiable financial and market information before performing an actual valuation.

Ideal for: financial analysts, investment professionals, corporate finance teams, business owners, entrepreneurs, students, and users who need a structured Excel framework for company valuation and financial analysis.

Contents:

• Excel Financial Valuation Model — English & Spanish

• DEMO

• User Manual

• .ODS Copy