Enterprise Budget Builder

You have a saved session from a previous visit.

Entity Setup

Configure the basic parameters for your budget model.

Entity Name *

Budget Year *

Model Tier *

Tier 1 — Starter

Income Statement only. 6 sheets. Best for simple budgets.

Tier 2 — Standard

IS + Revenue/COGS/OpEx drivers. 10 sheets. Configure how each line item builds up.

Tier 3 — Full

IS + BS + CF + all drivers. 15+ sheets. Complete three-statement model.

Scenario Names Every model uses two scenarios. Customize the names or leave blank for defaults.

Scenario 1 (conservative)

Scenario 2 (target)

Forecast Horizon

12 Months

Year 1 only

24 Months

Year 1 + Year 2

Weekly Cash Flow Forecast Rolling weekly cash flow breakdown (Tier 3 only)

Version Label Optional. Used in the filename (e.g., "v1")

Here's Your Income Categories

Review projected amounts for . Edit any cell to customize.

Apply % to all unedited sources

Name		Esc %		Freq	Total
⚠
TOTALS

Here's Your Expense Categories

Review projected amounts for . Edit any cell to customize.

Apply % to all unedited categories

Category		Esc %		Freq	Total
⚠
TOTALS

Add your line items. For each source, choose a driver type to control how the budget builds up.

Configure your expense categories and employee roster.

Other Income/Expenses (investment income, one-time items) appear below EBITDA on the Income Statement, not here.

Personnel Modeling Approach

Enter each employee individually with salary, bonus, and benefits. Enter a single total annual amount for all personnel costs (salary + benefits combined).

Total Annual Personnel Cost ($) Include all salaries, benefits, taxes, and bonus costs.

Year 2 Growth (%)

Employee Roster

Benefits

Payroll Tax Rate (%)

Health Ins. / Employee / Month ($)

401(k) Match Rate (%)

Plan New Hires

Assets

Configure opening balances and asset schedules for the balance sheet.

Opening Balances

Opening Cash ($)

Opening Accounts Receivable ($)

AR Collection Schedule

How quickly do you collect receivables? Must sum to 100%.

0-30 Days (%)

31-60 Days (%)

61-90 Days (%)

91-120 Days (%)

Total: % ✓

Prepaid Expenses

Existing Prepaids

New Prepaids (planned)

Other Assets

Fixed Assets (PP&E)

Note: If "Computer Equipment" is included, the model will automatically link new-hire technology costs from the Personnel section to this category for depreciation.

Intangible Assets

Goodwill, patents, software, or other intangible assets with amortization schedules.

Original Cost ($)

Useful Life (months)

Accum. Amortization ($)

Opening NBV:

Investment Assets

Opening balances and expected yields by scenario.

Public Market Investments

Publicly traded equities, bonds, ETFs, and mutual funds. Enter opening balances and expected returns by scenario.

Private Investments

Private equity, venture capital, and other illiquid investments tracked at cost basis.

Opening Balance ($)

Real Estate

Properties held at appraised value (static balance, no depreciation).

Collectibles

Art, wine, jewelry, vehicles, and other collectibles held at appraised value.

Liabilities

Configure accounts payable, credit facilities, and loans.

Accounts Payable

Opening AP Balance ($)

AP Payment Schedule (must sum to 100%)

Month 1 (%)

Month 2 (%)

Month 3 (%)

Month 4 (%)

Total: % ✓

Revolving Credit Line

Credit Limit ($)

Spread over SOFR (bps)

Opening Balance ($)

Enter Monthly Utilization Forecast

Existing Term Loans

Credit Cards

Track balances, interest charges, and payments for each credit card.

Real Estate Debt

Mortgages and other real estate-secured loans with amortization schedules.

Vehicles & Recreation Debt

Auto loans, boat/yacht financing, RV loans, and other vehicle/recreation debt.

Investment Leverage

Margin or securities-based lending facility for investment leverage. Rate = SOFR + Spread.

Facility Limit ($)

Spread over SOFR (bps)

Opening Balance ($)

Enter Monthly Utilization Forecast

Accrued Liabilities

These appear as line items on the Balance Sheet. Accrued Payroll is calculated automatically from the personnel model. Opening balances are entered directly in Excel.

Enter Values Now

Provide opening equity balances for the model

Enter in Excel

Skip for now and fill in the workbook later

Prior Year Retained Earnings ($)

Prior Year Net Income ($)

Auto-calculated as the plug that balances the opening balance sheet. You can override this value directly in the Excel file.

The workbook will generate with $0 defaults for Prior Year RE and NI. Owner's Equity will auto-calculate as the balancing plug in the Excel file.

Interest Income on Cash

Earn interest on the average monthly cash balance. Enter rates in basis points (100 bps = 1%).

Other Income / Expense

One-time or non-operating income and expenses (e.g., gain/loss on asset sale, miscellaneous).

Review Your Inputs

Verify everything looks correct before generating your workbook.

Entity Setup

Entity Name
Budget Year
Tier
Client Type
Scenarios
Horizon
Weekly CF

( sources)

Name	Driver	Key Value
		—

( items)

Name	Driver	Key Value
		—

Category	Driver	Value
		—

Assets

Opening Cash
Opening AR
Fixed Asset Categories
Prepaids
Intangibles (NBV)
Investments
Public Market Investments
Private Investments
Real Estate
Collectibles

Liabilities

Opening AP
Credit Line
Loans
Credit Cards
Real Estate Debt
Vehicles & Rec Debt
Investment Leverage

Retained Earnings
Prior Year NI

Will enter in Excel (Owner's Equity auto-calculates)
Interest Income on Cash
Other Income
Other Expenses

📋

Ready to Generate

Your budget model for ( months) is ready to be built.

Generating your budget model...

✓

Workbook Generated

Your file has been downloaded.

Back to Home

Pro tip: Download and review your workbook first — make any adjustments you need in Excel. When you're ready, upload the finalized model to the Dashboard Wizard to unlock client reports and sophisticated analysis.

Open Dashboard Wizard

Error:

Revenue

COGS

Gross Margin

OpEx

EBITDA