ENTERPRISE DCF VALUATION MODEL
	Discounted Cash Flow Analysis with WACC
	5-Year Projection Period (FY2026E – FY2030E)
	Prepared by:	[Analyst Name]
	Date:	13-Feb-26
	Company:	[Company Name]
	Version:	1.0 - Draft
	TABLE OF CONTENTS
	Sheet	Description	Status
	ExecSummary	Executive Summary	Active
	Assumptions	Key Assumptions & Inputs	Active
	HistIS	Historical Income Statement	Active
	HistBS	Historical Balance Sheet	Active
	HistCF	Historical Cash Flow Statement	Active
	WorkCap	Working Capital Schedule	Active
	DACapex	D&A and Capex Schedule	Active
	ProjIS	Projected Income Statement	Active
	ProjBS	Projected Balance Sheet	Active
	ProjCF	Projected Cash Flow Statement	Active
	DebtSched	Debt Schedule & Credit Metrics	Active
	WACC	WACC Calculation (CAPM)	Active
	FCF	Free Cash Flow to Firm	Active
	DCFVal	DCF Valuation & Equity Bridge	Active
	Sensitivity	Sensitivity Analysis Tables	Active
	Scenarios	Scenario Analysis (Bull/Base/Bear)	Active
	Comps	Comparable Company Analysis	Active
	ErrCheck	Error Checks & Validation	Active
	COLOR CODING LEGEND
	Blue text = Hardcoded inputs (editable)
	Black text = Formulas (same sheet)
	Green text = Cross-sheet references
	Note: This model uses sample/placeholder data for illustrative purposes. Replace with actual company data before use.