Three-Statement Model and DCF Valuation by Viren MakwanaThree-Statement Model and DCF Valuation by Viren Makwana

Three-Statement Model and DCF Valuation

Portfolio project
Viren Makwana

Three-Statement Model and DCF

An original Excel model for a hypothetical growth-stage B2B software company, built the way an investor or banker would test a fundraise or valuation.
What the model does
Income statement, balance sheet and cash flow, fully linked from one assumptions sheet
Revenue growth, margin, working capital and capex drivers by year
Balance sheet check and cash floor check on every projection year
Unlevered free cash flow, end-of-year discounting and Gordon growth terminal value
Equity bridge, value per share and a WACC by terminal growth sensitivity grid
Base case: ₹286 Cr enterprise value, 4.5x forward revenue, revenue CAGR of 37% to FY2030 and a 33% EBITDA margin.
Useful for founders preparing a raise, investors testing a valuation and CFO teams building a plan.

0 likes · 1 view · Nov 6, 2026

Linked P&L, balance sheet and cash flow for a growth-stage B2B software company, with an unlevered DCF and WACC and growth sensitivity.

Tags