Skip to main content

Financial Planner

Builds a full multi-year financial projection: revenue, costs, P&L, balance sheet, cash flow, and loan schedules. Renders statements, ratios, and a dashboard with burn rate and runway. Export to Excel or PDF.

B
Written by Baltej Singh

What it does

Builds a full multi-year financial projection for your startup — revenue, costs, profit & loss, balance sheet, cash flow, and loan schedules. You enter your assumptions once and Nautis renders the statements, ratios, and a dashboard with burn rate and runway. Export to Excel or PDF when you're ready to share.

Who can use it

  • Anyone in your organization with read access to the Financial Planner module.

  • Creating and editing projections needs create or update permission and a verified email.

  • The Financial Planner must be enabled on your plan.

How to get here

From the sidebar, open Fundraising and click Financial Planner.

Step-by-step: create a projection

  1. Click New Project.

  2. Choose: Blank Project or an industry template (SaaS, E-commerce, Restaurant, Services, Mobile App).

  3. Fill in: Project Name, Description, Projection Period (3-Year or 5-Year), Currency, Shared Access.

  4. Click Create Project.

Step-by-step: enter your inputs

Work the tabs in this order:

Revenue Items

  1. Click Revenue Items tab.

  2. Add each product or service: Name, unit price, billing frequency, forecasted units sold, COGS per unit.

Model Inputs

  1. Click Model Inputs.

  2. Add Operating Expenses with year-over-year growth.

  3. Add Non-Operating Income, Other Taxes, Non-Recurring Expenses.

  4. Enter tax rate and depreciation.

Profit & Loss

Calculated, not entered. Shows revenue, COGS, gross profit, operating expenses, EBITDA, taxes, net profit year by year.

Balance Sheet

  1. Click Balance Sheet.

  2. Add starting balances for assets and liabilities.

  3. Nautis projects each line forward.

Cash Flow

Calculated. Shows cash from operations, investing, financing — rolls forward cash balance.

Loan Schedule

  1. Click Loan Schedule.

  2. Add loans with principal, interest rate, term, start date.

  3. Nautis builds amortization and flows interest into P&L, principal into cash flow.

Notes

Use Notes to document assumptions. Investors love a notes page.

Step-by-step: view the Dashboard

  1. Click Dashboard tab.

  2. See: Revenue trend chart, expense breakdown pie, EBITDA / net profit / gross margin metrics, burn rate, cash runway, year-over-year deltas.

Step-by-step: run scenarios

  1. Clone the project from the list (or create a new one with the same template).

  2. Rename and edit assumptions.

  3. Use Compare from the list to lay two projections side by side.

Typical scenarios: lower growth, higher CAC, slower hiring, delayed funding.

Step-by-step: export

  • Export Excel — multi-sheet workbook (pick what to include).

  • Export PDF — printable report.

Step-by-step: edit project settings

Click Edit Project to change name, description, currency, projection period, or shared access.

Tips & limits

  • Start with a template matching your business model.

  • Build in order: revenue → expenses → balance sheet → loans.

  • P&L and Cash Flow are derived. Fix the source if numbers look wrong.

  • Use Notes to spell out assumptions — separates a credible model from a guess.

  • Run at least two scenarios — base case and stressed case.

  • Shared access lets co-founders or your accountant edit live.

FAQ

Do I need accounting experience?

It helps, but templates fill in standard line items.

Can I change the projection period after creating it?

Yes. Edit Project and switch between 3-Year and 5-Year.

How is runway calculated?

Current cash divided by monthly net burn.

Can I model a fundraising round?

Yes — add the inflow on the cash flow side and adjust balance sheet equity.

Can I share with my accountant?

Add them via Shared Access, or use Export Excel.

What happens if I delete a revenue item?

P&L, balance sheet, and cash flow recalculate immediately. Set units to zero to keep but switch off.

Can I import historical numbers?

Use the import option on Revenue Items to pull from your invoices module.

Did this answer your question?