Acquire Customers
New customers equal marketing spend divided by customer acquisition cost.
This editable five-year workbook models right-of-way agent service revenue from customer acquisition, active cohorts, billable hours, and hourly rates, then connects inputs to financial statements.
Use the workbook to plan how marketing spend creates customers, how long service cohorts remain active, and how their billable hours convert into service revenue.
Editable operating assumptions feed the monthly calculation engine, which rolls the business plan into financial statements, scenario comparisons, and management reporting.
The model acquires customers from marketing spend and CAC, retains them by service cohort, converts active customers into billable hours, then applies hourly rates.
New customers equal marketing spend divided by customer acquisition cost.
Split new customers across service tiers and retain each cohort for its stated lifetime.
Add starting customers to every acquired cohort that remains within its stated lifetime.
Multiply active customers by average billable hours per active customer each month.
Multiply billable hours by hourly rates and total revenue across tiers and months.
The Revenue Assumptions sheet connects marketing, customer acquisition, service allocation, cohort lifetime, billable hours, and hourly rates to the revenue forecast.
REVENUE ASSUMPTIONS
The COGS & Operational Expenses sheet separates cost-of-service assumptions from variable and fixed operating expenses across the forecast period.
COGS & OPERATIONAL EXPENSES
The Scenario Analysis view compares Low, Base, and High cases across revenue, gross margin, contribution margin, and EBITDA over the five-year forecast.
SCENARIO ANALYSIS
The Dashboard combines model setup, scenario controls, headline KPIs, core financials, revenue mix, cash flow, profitability, and investment payback charts.
DASHBOARD
The ready-made model fits right-of-way services using customer acquisition, retained customer cohorts, billable hours, and hourly pricing; structurally different economics may require custom modeling.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when your business needs different revenue logic, operating schedules, or financial reporting.
ORDER A CUSTOM FINANCIAL MODELYou receive an instant-download, fully editable five-year financial model for Excel or Google Sheets with scenario analysis and linked financial reports.
Open and edit the financial model in Excel or Google Sheets.
Plan revenue, costs, cash flow, and financial performance across five projected years.
Compare Low, Base, and High cases through the model's scenario controls and charts.
Review projected income statement, cash flow, balance sheet, summary, and dashboard outputs.
The essential answers are visible in full, with no accordion clicks required.
Revenue starts with customers acquired from marketing spend and CAC, then applies service allocation, cohort lifetime, billable hours, and hourly rates.
You can edit launch date, starting customers, marketing budget and seasonality, CAC, service allocation, customer lifetime, billable hours, and hourly rates.
You can compare alternative revenue, gross margin, contribution margin, and EBITDA paths across the five-year forecast.
The workbook includes projected income statement, cash flow, balance sheet, summary, dashboard, break-even, ROIC, valuation, charts, and ratios.
Yes. Financial Models Lab offers custom financial modeling when you need different revenue logic, operating schedules, or reporting.
It is an editable planning forecast, not a guarantee of performance. Results depend on the assumptions you enter and the scenarios you review.
This comprehensive package includes everything you need to build a robust financial plan for your right-of-way agency, from detailed financial statements to a high-level visual dashboard.
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 the financials by hand and had a clean working model in place fast. It saved me about 12 hours and gave me a file I could actually send out without reworking every tab.
The cash-flow section made it much easier to see runway and likely shortfalls. I could spot a funding gap weeks earlier and walk into a lender call with clearer numbers.
My pricing, cost, and growth assumptions were all over the place before this. Now everything sits in one place, and I cut my planning time by half because the model finally made sense.