Financial Modeler & Risk Simulator

General Setup

Company Name:

Time Horizon (Years):

Currency:

Enable Inflation:

Inflation Rate (%):

Revenue Forecasts

Base Sales (Year 0):

Revenue Growth Rate (%):

Enable Volume/Price Split:

COGS & Operating Expenses

COGS (% of Revenue):

Operating Expenses (% of Revenue):

Opex is Fixed:

Fixed Opex Amount (Year 0):

SG&A (% of Revenue):

Capex & Depreciation

Capex Forecast:

Depreciation Method:

Asset Life (Years):

Initial Net Fixed Assets (Year 0):

Working Capital

Financing & Tax

Initial Debt (Year 0):

Interest Rate (%):

Debt Repayment Schedule (Annual):

Tax Rate (%):

Dividend Payout Ratio (% of Net Income):

Financial Dashboard

Revenue vs Costs

Valuation Components

Free Cash Flow Timeline

Capital Structure

Sensitivity Analysis (Tornado)

Financial Reports

Income Statement

Balance Sheet

Cash Flow Statement

Valuation Summary

Key Ratios

Economic Profit

Risk & Uncertainty Modelling

Risk Variables

Simulation Settings

Number of Iterations:

Simulation Seed (optional):

Confidence Level (% for VaR):

Financial Model & Risk Simulator