Acquire Customers
New customers equal marketing spend ÷ customer acquisition cost.
It is an editable five-year Excel and Google Sheets workbook for recurring port-management service revenue, monthly and annual forecasts, scenarios, and linked financial reports.
Use the model to plan customer acquisition, service-tier mix, customer retention, recurring fees, operating costs, staffing, capital needs, and resulting financial performance.
Editable launch, marketing, CAC, allocation, lifetime, and monthly-fee assumptions flow through customer cohorts into revenue, statements, and management reports.
The model converts marketing spend into new customers, allocates them across service tiers, retains active cohorts, and applies monthly fees to calculate revenue.
New customers equal marketing spend ÷ customer acquisition cost.
New customers are distributed across service tiers using editable allocation percentages.
Starting customers and unexpired cohorts form the active customer base by tier.
Active customers in each tier are multiplied by that tier’s monthly fee.
Monthly revenue is summed across service tiers and forecast months to produce total revenue.
The Revenue Assumptions view links marketing spend, CAC, customer allocation, cohort lifetime, starting customers, and monthly fees to recurring service revenue.
REVENUE ASSUMPTIONS
The COGS & OPEX worksheet organizes direct costs, variable expenses, and fixed overhead so cost assumptions feed monthly and annual forecasts consistently.
COGS & OPEX
The Scenario Analysis view compares Low, Base, and High paths for revenue, gross margin, contribution margin, and EBITDA across the five-year forecast.
SCENARIO ANALYSIS
The Dashboard combines scenario controls, core financials, revenue mix, profitability, cash flow, payback, and key metrics in one management view.
DASHBOARD
The ready-made model fits recurring service operations using acquisition, tier allocation, customer retention, and monthly fees; materially different operating logic may need custom modeling.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when you need different revenue logic, operating schedules, or financial reporting.
ORDER A CUSTOM FINANCIAL MODELYou receive an editable Port Management Service financial model with five-year monthly and annual forecasts, scenario analysis, and linked financial reporting for download.
Update customer, revenue, cost, staffing, capital, financing, and scenario assumptions.
Review monthly projections that roll into annual financial views across five years.
Compare Low, Base, and High cases across modeled revenue, margins, and EBITDA.
Use linked income statement, cash flow, balance sheet, Dashboard, Summary, and management reports.
The essential answers are visible in full, with no accordion clicks required.
It calculates new customers from marketing spend and CAC, allocates them by tier, retains active cohorts, and multiplies active customers by monthly tier fees.
You can change launch date, starting customers, annual marketing budget, monthly marketing seasonality, CAC, tier allocation, customer lifetime or churn convention, and monthly fees.
You can compare how alternative assumptions change revenue, gross margin, contribution margin, and EBITDA across the five-year forecast.
The workbook includes income statement, cash flow, balance sheet, Dashboard, Summary, break-even, ROIC, Charts, KPIs, and additional management reports.
Yes. Financial Models Lab offers custom financial modeling when different revenue logic, operating schedules, or reporting structures are required.
It is a planning forecast based on editable assumptions, not a guarantee of business performance or financial results.
This downloadable port management budget template for Excel includes everything you need to build a comprehensive financial plan for your service.
Core inputs and core outputs
Three scenario analysis
Presentation ready
DuPont analysis
Researched revenue assumptions
Lender-friendly financial outputs
Revenue stream detailed view
Performance metrics benchmark
I stopped building port revenue and cost schedules by hand, and that alone saved me a full day. The template gave me a clean starting point so I could move straight to planning instead of wrestling with spreadsheets.
I could finally see margins and break-even without digging through formulas. That made my lender call much easier, and I had the numbers ready in one meeting.
The pricing, cost, and growth inputs were all in one place, so the model felt easy to follow. I cleaned up my assumptions in under an hour and shared a clearer forecast with my team.