Company Forecast Calculator
Play with assumptions on a top company and see the 5-year revenue, free cash flow, and DCF impact instantly. Built from SEC EDGAR filings across 360 companies.
View all free tools
Assumptions
Need this as an Excel model?
Keep iterating on the Apple forecast in Excel. The downloadable sample has every assumption you see here plus a fully integrated income statement, balance sheet, cash flow, and debt schedule - five years of SEC historicals and live formulas in a fully editable workbook.
How the calculator works
Every company in the picker starts with assumptions seeded from its most recent SEC-reported fiscal year - revenue growth, gross margin, capex intensity, and capital structure. Move a slider and the engine reprojects the next five years of income statement, free cash flow, and a simple unlevered DCF valuation. The full Excel model behind each company is one click away.
What the sliders drive
- Revenue growth compounds the top line each year, which flows into COGS, opex, capex, and working capital lines.
- Gross margin changes the share of revenue retained after cost of goods - the single biggest lever on operating income for most companies.
- Capex % drives the investment in PP&E and is subtracted from operating cash flow to get free cash flow.
- WACC is the discount rate for the DCF - higher WACC means a tougher hurdle and a lower present value.
- Terminal growth controls the long-run growth rate after the explicit five-year window, feeding the Gordon-growth terminal value.
Why this is a simple model
The calculator deliberately exposes a handful of drivers so the chart stays interpretable. Under the hood the engine still computes the other lines - R&D, SG&A, D&A, working-capital changes, dividends, buybacks - using the company’s historical ratios. If you want to override every assumption with full balance-sheet integrity, download the Excel model from the company page.
Banks, insurers, REITs, and homebuilders are excluded from the picker - their financial structure doesn’t fit a general-corporate driver model. We surface those companies on their dedicated pages instead.
Want the full Excel model?
Every company has a downloadable 3-statement Excel file with integrated balance sheet, every assumption exposed, and SEC EDGAR historicals baked in. Pick a company in the calculator above and use the download button, or browse the catalog.
Alex Tapio
Founder of Finamodel • Professional Financial Modeller • Ex-Deloitte
