Valuation models from annual reports

From annual reports to a valuation model you can check.

Upload one to three years of a company’s annual reports. herodocu reads the statements, shows you every historical figure to check and correct, then fills a DCF model: projected statements under three scenarios, WACC, two terminal values and sensitivities, all live Excel.

Download a filled sample

Free account · 1 PDF a month, up to 20 pages · No card required

Zenith Industries Limited · Valuation model₹ lakh
HistoricalsFY 2024-25FY 2025-26
Revenue from operations2,600.003,000.00
EBITDA375.00480.00
Profit after tax180.00240.00
Total assets2,490.002,740.00
Enterprise value
2,234.49
Equity value
1,979.49
Value per share
₹39.59

Fig. 1 — History from the accounts; a DCF at 14.1% WACC on the model’s default assumptions. Made-up accounts.

Checks OK .xlsx
  • Three years of history from the audited statements, placed on Schedule III
  • Every figure shown to you to check and correct before it is written
  • Every projection, DCF and sensitivity a live Excel formula

A full model, not a data dump.

Eleven sheets, every one of them formulas except the history and your assumptions. Change a driver and the statements, the value and the sensitivities follow.

Historicals

Three audited years

Profit and loss and balance sheet as the reports print them, with checks that profit ties and the balance sheet balances.

Assumptions

Three scenarios

Base, upside and downside drivers: growth, margins, capital expenditure, working capital days, tax and payout. A switch picks the case in use.

Schedules

Fixed assets, working capital, debt

Depreciation, capital expenditure, receivable, inventory and payable days, and borrowings repaid, year by year.

Financials

Projected statements

Profit and loss, balance sheet and cash flow, linked, with cash as the balancing figure and no circular references.

WACC and DCF

Two terminal values

Cost of equity by CAPM, free cash flow to the firm, a mid-year switch, and perpetuity growth weighed against an exit multiple.

Sensitivity

The answer, and how far it moves

Equity value against WACC and terminal growth or exit multiple, a summary with charts, and every check in one place.

Three steps, one company at a time.

  1. 01

    Upload the annual reports

    One to three years as PDFs, scanned or not, Division I or Ind AS. Each report prints the year before too, so two give three years.

  2. 02

    Check the figures

    Every input line of the model is shown, year by year. Type over any figure that was read wrongly; the model's checks are worked out again as you type.

  3. 03

    Download the model

    Only the history and the share count are written. Set your assumptions and every projection, value and sensitivity follows.

Nothing goes into the model until you have seen it.

A figure misread from a scan would carry through every projection. So the history is shown first, year by year. The model’s own checks run as you look: when profit does not tie, the lines it adds up are marked, you type over the wrong figure, and the check clears.

Check the historical figuresFY 2024-25FY 2025-26
Revenue from operations2,600.003,000.00
Employee benefits expense300.00350.00
Other expenses480.00445.00
Fig. 2 — A marked line is one a failing check adds up; a shaded one you have corrected. Illustrative figures.

Your assumptions, kept.

Download the model blank, set it up the way you work, and upload your copy with the next company’s reports: only the history and the share count are replaced. A simpler projections-and-DCF model is there too, for a quick look.

Download the blank model

Questions people ask.

Which reports does it read?
Indian financial statements on Schedule III, Division I or Division II (Ind AS), standalone or consolidated, from a text PDF or a scan. Annual reports and results announcements both work; it needs the balance sheet and the profit and loss.
What units is the model in?
Rupees in lakhs, as its sheets say. Reports in crores, thousands or rupees are converted when their units are known; when a report prints its units above the tables rather than in them, choose them on the page.
Are the assumptions set for the company?
No. The model opens on placeholder assumptions so that it works out end to end. Growth, margins, working capital days and the discount rate are yours to set for each company, and the Analysis sheet shows the history to set them against.
Where does the number of shares come from?
From the latest year's profit over its basic earnings per share. Earnings per share uses the year's weighted average, so change the count if shares were issued or bought back since; you can do that before downloading.
Can I use my own model?
Your copy of herodocu's model, with your assumptions in it, at no extra cost: upload it with the reports and only its history is replaced. Your firm's own Excel model can be filled too, as a custom engagement scoped and priced per model; tell us about it from the pricing page.

The reports stay yours.

The PDF is deleted as soon as extraction finishes, and is never used to train models. The model is filled in your browser, and nothing from it is stored.

Read how documents are handled

About a rupee a page.

Standard is ₹499 a month for 500 pages during the introductory offer. You pay for the pages read; herodocu’s model costs nothing extra. Filling your firm’s own model is scoped and priced per model.

Try it on the company you are looking at.

Upload its latest annual report free, with no card, and check the history against the statements yourself.