◆

FinModel Pro

Financial Modeling Suite

Research Preview

Select Model Type

Input Method

Model Assumptions

🏢

Company Information

Company Name

Base Year Revenue ($M)

LTM or most recent full-year revenue

Net Debt ($M)

Total debt minus cash; enter as positive number

Shares Outstanding (M)

📈

Revenue Growth

Annual Revenue Growth (% per year)

Y1

Y2

Y3

Y4

Y5

COGS (% of Revenue)

💰

Operating Assumptions

Base Year OPEX ($M)

OPEX Annual Growth Rate (%)

NWC (% of Revenue)

CAPEX (% of Revenue)

D&A (% of Revenue)

Effective Tax Rate (%)

🎯

Valuation Assumptions

WACC (%)

Weighted average cost of capital

LT Growth Rate (%)

Terminal / perpetuity growth rate

EBITDA Multiple (x)

Exit multiple applied to Year 5 EBITDA

—

Discounted Cash Flow Valuation — 5-Year Projection

DCF / Valuation —

Enterprise Value (NPV)

—

—

Equity Value

—

—

Price Per Share

—

—

Implied EV / EBIT

—

—

Revenue & EBIT Projections

5-Year Forecast ($M)

Free Cash Flow

Annual FCF ($M)

Valuation Bridge

EV composition: PV of FCFs + Terminal Value ($M)

OPEX vs. Gross Profit

Trend over 5-year projection ($M)

Sensitivity Analysis — Price Per Share ($)

WACC (rows) vs. LT Growth Rate (columns) · Base case outlined in white

WACC (%) vs LT Growth Rate (%)

Income Statement & DCF Summary

Export