Trusted by 25,000+ startup founders, investors and CPAs
Formula Confidence Restored
Megan Carter, NY
This template kept one broken cell from turning into a mess, so I could check the numbers fast and keep the model intact. It saved me a full day of rework before my meeting.
Simple Enough To Use
Brian Hall, TX
I’m not an Excel expert, and this model still made sense right away. I filled in the tabs without getting lost, and it got me to a clean forecast in under an hour.
Cleaner Assumptions, Faster Planning
Lauren Mitchell, FL
Pricing, costs, and growth were all over the place before, but this template put everything in one place. That made it much easier to review assumptions and book a planning call with confidence.
MODEL OVERVIEW
What Is the Financial Model of the Navy Architecture Company?
It is a five-year workbook that modeles the purchase of customers, active customers, hours paid, service rates, scenarios and integrated financial results.
Use the model to translate the customer pipelines and professional service into revenue, costs, cash flow and financial statements of the company.
You can edit the launch time, marketing expenses, purchase cost, customer mix, customer duration, hours paid, hourly rates, operating costs, staff and capital expenditure.
Built around the economy of servicesThe revenue schedule is made from customers from acquisition through maintenance, accountable workload, prices and monthly income.
CLIENT-COHORT INCOME ENGINE
How Does the Navy Architecture Company Calculate Revenue?
The model acquires customers from marketing expenditure, keeps each cohort at service level, transforms active customers into hours paid and uses adjusted hourly rates.
01
Buy Clients
New customers are equally spending marketing expenditure divided into the costs of purchasing the customer.
02
Cohorts
New customers are divided by service level and retained for the duration of each level.
03
Active Clients Track
Customers starting a connection with all the cohorts of customers that remain active.
04
Build Pay Hours
Active customers multiply for average monthly hours paid for the matching level.
05
Calculate Income
Hours paid multiply by hourly rates and then revenues are added up at different levels and months.
FORM OF CORRECTIONRevenue = Hours Paid × Hourly Rate
01 / REVENUE
How to Configure Clients and Customers?
The revenue worksheet combines the start-up time, marketing, CAC, customer allocation, customer duration, hours paid and hourly rates with the customer-hort revenue schedule.
REVENUE
The revenue view shows the editorial acquisition of customers, a mix of services, retention, hours paid and price assumptions.
02 / COGS & OPEX
How to Structure Direct and Operational Costs?
The COGS & OPEX worksheet separates direct service costs, variable operating costs and fixed running costs for monthly and annual forecasts.
COGS & OPEX
View COGS & OPEX organizes direct, variable and fixed assumptions of operating costs.
03 / SCENARIOS
How Can we Compare Low, Basic and High Matters?
The Scenarios compared low, base and high results in terms of revenues, gross margin, premium margins and EBITDA in the five-year forecast.
SCENARIOS
The scenario view shows low, basic and high pathways to key financial results.
04 / DASHBOARD
What Does the Distribution Board Have in Common?
The dashboard combines a configuration model, scenario control, revenue mix, profitability, cash flow, return on investment and the most important financial indicators in one management view.
DASHBOARD
The data table summarises configuration checks, scenario results, revenue mix, profitability, cash flow and return.
FIT OF PRODUCTS
Is the Financial Model of the Navy Architecture Company Suitable for You?
It fits with companies whose revenues are mainly driven by retained customer cohorts and hours paid, while generally different economics may need a custom structure.
MODEL BY MADA READY
Good Example
Your services are sold mainly by paid working hours.
Marketing expenses and CAC are significant drivers of new customers.
Customer levels vary in terms of retention, workload or hourly prices.
You want low, base and high financial plans.
CUSTOMS STRUCTURE
Consider Custom Pattern
Your revenue depends mainly on service contracts for a fixed-price vessel or intermediate stages.
You need a project-level backlog, a WIP, or a percentage accounting logic.
Your operating model requires a specialized ability to use subcontractors' resources or schedules.
You need reporting structures that are materially different from the workbook.
The template is the starting point of planning, not a guarantee of performance.
FINANCIAL MODEL SERVICE
Do You Need a Model Built Around Your Requirements?
The Lab financial models can build or adapt a model when you need different revenue logic, operational schedules or financial reporting.
You will receive an immediate, fully edited financial model with five-year forecasts, scenario analysis and integrated financial reports.
01
Editable workbook
Updated business assumptions, operating factors, costs, staff and financial expenditure.
02
Five-year forecast
A full five-year business review.
03
Analysis of scenarios
Compare low, baseline and high cases with key forecast results.
04
Financial statements
Preview income account, cash flow, balance sheet, dashboard and summary of results.
BEFORE BUYING IMPORTANT INFORMATION
Naval Architecture Firm Financial Model FAQ
The basic answers are visible in their entirety, without clicking on the accordion.
01
How does the model calculate the revenue from marine architecture?
Revenues are calculated from active customers, average monthly billing hours and hourly rates according to service level. Customer cohorts are created from marketing expenses and CAC, and then stored for their specific customer lifetime.
02
What are the assumptions I can change?
You can edit the launch date, customer start, marketing budget and seasonality, CAC, level allocation, customer life, hours paid and hourly rates. Cost, wages, CAPEX and financial inputs are also editable in the workbook.
03
What can I compare in Low, Base and High scenarios?
You can compare alternative revenue, gross margin, premium margin and EBITDA in the five-year forecast. The scenario view makes the differences between the three paths visible on the graphs.
04
What financial results are taken into account?
The product contains a statement of income, a statement of cash flow, a balance sheet, a dashboard, a summary, an analysis of scenarios and additional analytical reports. These results are updated from assumptions and timetables of model calculations.
05
Can the Financial Models Lab adapt it to its own requirements?
Yes. Financial Models Lab offers custom financial modelling for buyers who need different revenue logic, operating schedules or reporting structures.
06
Is the workbook a forecast or a guarantee?
This is a planning forecast based on assumptions entered in the workbook, not a guarantee of financial results. Actual results may differ from modeled results.
What Does the Naval Architecture Firm Financial Model Contain?
This naval architecture financial model provides everything you need to build a comprehensive financial plan, from initial startup cost estimation to a full five-year forecast and valuation.
All-in-one Dashboard
Core inputs and core outputs
Low/Base/High
Three scenario analysis
Professional Charts
Presentation ready
ROE Components
DuPont analysis
Revenue Inputs
Researched revenue assumptions
Bank-Ready Reports
Lender-friendly financial outputs
Revenue Breakdown
Revenue stream detailed view
KPI Dashboard
Performance metrics benchmark
Choosing a selection results in a full page refresh.
REVENUE
COGS & OPEX
SCENARIOS
DASHBOARD
