Company Valuation Model and Report Template (Excel and Word)

Value a company the way investors, buyers and valuers do, in files you own. Enter the company’s figures once and the workbook runs eight valuation methods, weights them for the company’s stage, draws a football field against the asking price, tests the sensitivity of the result and writes the summary paragraphs for your report. A 16-section Word report template and a two-page method guide complete the kit. No subscription, no macros.

VAL-01 Company Valuation Model (Excel)

• Eight methods in one model: discounted cash flow, comparable companies, precedent transactions, earnings multiples, adjusted net assets, liquidation value, the VC method and the Scorecard method
• Three years of historicals with automatic ratios, and a normalisation sheet for one-offs, owner pay and related-party terms that gives normalised EBITDA and seller’s discretionary earnings (SDE)
• Five-year forecast to free cash flow with Base, Upside and Downside drivers on one switch, and UAE Corporate Tax (9% above the AED 375,000 band) on operating profit
• WACC built up with CAPM and peer betas relevered for your capital structure, with a source and date field for every market input
• DCF with mid-year discounting, a first-year stub from the valuation date, terminal value by Gordon growth, exit multiple or both, cross-checks, and a bridge to equity value at the valuation date
• Up to 15 listed peers and 15 deals, with include switches, a date window, automatic outlier flags, quartiles and medians, and discounts for lack of marketability or control
• Liquidation value in an orderly and a forced sale, with recovery rates by asset class and creditors paid in order of priority
• Investor view: the ownership an investor needs, pre- and post-money value, and money multiple and IRR under bear, base and bull exits
• Reconciliation with suggested weights for five company stages; methods without data drop out and the weights rescale automatically
• Dashboard with the value range, value per share, football field, method weights and the drivers that move the value most, plus three sensitivity grids and 24 automatic model checks
• An example copy for a fictitious Dubai cold-chain logistics company, and a blank copy for your own valuation

VAL-02 Valuation Report Template (Word and PDF)

• 16 sections in the order boards and investors read: executive summary, scope and basis of value, company, market, historical analysis, normalisation, forecast, DCF, comparable companies, precedent transactions, earnings multiples, asset approach, investor view, reconciliation, sensitivity and risks, and assumptions and limiting conditions
• Each section opens with a writing guide and a worked example whose figures match the example workbook
• The workbook’s Summary Text sheet drafts the main paragraphs from your live figures, ready to paste in

VAL-03 Method Selector Guide (PDF)

Two pages: what each method measures, its formula, when to use it and what to watch, plus suggested weights by stage, the bridge from enterprise value to equity value and six checks before you rely on a number.

Who it is for

• Business owners preparing for a sale, a funding round or a shareholder change
• Angel, venture capital and private equity investors screening and pricing deals
• CFOs, accountants and advisers who need a consistent, documented method

Raising money? Pair it with the Investment Term Sheet Kit for the term sheet, cap table and exit waterfall.

Questions buyers ask

Which valuation methods does it include?

Eight: discounted cash flow (DCF), comparable companies, precedent transactions, earnings multiples, adjusted net assets, liquidation value, the VC method and the Scorecard method for pre-revenue companies. The model weights them for the company's stage, or you set your own weights, and reconciles them into one value range with a point estimate.

Can I value a startup that has no revenue yet?

Yes. Set the stage to Pre-revenue and the model leans on the VC method (what an investor can pay today for a target return at exit) and the Scorecard method (a local benchmark scaled by team, market, product and other factors). Methods without data drop out and the remaining weights rescale automatically.

Is the result a formal valuation?

No. It is an analysis tool that gives you a consistent, documented valuation for negotiations, funding rounds and board decisions. Where a court, regulator, auditor or tax authority will rely on the value, engage a qualified independent valuer; the workbook and report give them a clear starting point.

Where do the market inputs come from?

You enter them, each with a source and a date: the risk-free rate from government bond yields, equity and country risk premiums and industry betas from sources such as Damodaran Online, and peer and deal multiples from filings and deal announcements. The example figures are illustrative.

What do I need to use it?

Microsoft Excel (Microsoft 365, Excel 2016 or later, or Excel for the web) and Microsoft Word. There are no macros and no data tables, so every result recalculates instantly. Enter amounts in any currency and in units, thousands or millions.

Does it work for companies outside the UAE?

Yes. Set the currency and the corporate tax rate, switch off the UAE 0% band, and use the risk-free rate and country risk premium for your market. Everything else works the same way.