Patient Transport Financial Model Built for Real Planning, Not Blank Spreadsheets

What are the core revenue drivers?

Your platform's revenue comes from three main sources: commissions on rides, monthly subscription fees from both drivers and buyers, and extra fees for sellers. The model calculates gross merchandise value (GMV) based on the number of active buyers, their monthly order frequency, and an average order value (AOV) that ranges from $60 for individual patients to $83 for facilities. Your take rate starts at 15% plus a $2 fixed fee per order, forming the core of your revenue projections for medical transport.

Primary Revenue Streams

• Commission Revenue: A 13-15% take rate plus a $2 fixed fee on every trip.
• Seller Subscriptions: Monthly fees from drivers and fleets, from $29 to $240.
• Buyer Subscriptions: Monthly fees from patients and facilities, from $19 to $290.

What is the path to profitability?

You're projected to reach profitability in your second year. The model shows an EBITDA loss of $472,000 in Year 1, driven by initial investments in staff and marketing. However, the business turns EBITDA positive in Year 2 at $277,000 and achieves full breakeven by May 2027, just 17 months after launch. This trajectory shows how scaling revenue eventually outpaces both variable costs (like payment processing) and fixed overheads (like rent and salaries), leading to sustainable ambulette service profitability.

Levers for Improving Profitability

• Optimize Marketing Spend: Lower buyer and seller CAC, currently starting at $100 and $1,500.
• Increase Customer Lifetime Value: Boost repeat orders from high-value facility and insurance clients.
• Manage Operating Costs: Scale variable and COGS expenses slower than revenue growth.

How much initial capital is needed?

To get this non-emergency transport business off the ground, you'll need an initial investment of $155,000. This covers all one-time capital expenditures (CAPEX) required before you start generating significant revenue. The largest single expense is the $80,000 for core platform development, which is essential for creating a functional marketplace. This cost analysis for starting a medical transportation company ensures you have a clear picture of your day-one funding requirements.

Major Startup Costs

• Platform Core Development: $80,000
• Office Setup & Furnishings: $25,000
• Initial IT Equipment: $15,000

What are the cash flow dynamics?

Managing cash is everything for a startup. This financial feasibility study for a patient transport service shows that while you're growing, your cash balance will dip to a minimum of $221,000 in April 2027. The model's monthly cash flow statement is defintely critical for tracking your burn rate and ensuring you have enough liquidity to cover expenses before reaching profitability. It helps you anticipate funding needs and avoid running out of money during the crucial early stages.

How the Model Helps Manage Cash

• Monthly Cash Flow Projections: See your cash position for the next 60 months.
• Identifies Minimum Cash Point: Pinpoints exactly when and how low your cash balance will get.
• Supports Funding Strategy: Helps determine how much capital to raise and when.

What are the key financial metrics?

Beyond simple profit and loss, this model calculates the core metrics investors use to evaluate a business. The projected Internal Rate of Return (IRR), which measures the profitability of your initial investment, is 7%. Your payback period is 30 months, meaning you'll recoup your initial investment in two and a half years. These patient transportation business metrics provide a sophisticated financial overview that goes beyond basic revenue forecasting.

Top-Line Performance Indicators

• Internal Rate of Return (IRR): 7%
• Return on Equity (ROE): 14.87%
• Months to Payback: 30

What does the staffing plan look like?

Your team is your biggest operational expense. The model starts with a lean team of 5.5 full-time equivalents (FTEs) in Year 1, including a CEO, CTO, and one software engineer. The plan scales methodically, growing to 10 FTEs in Year 2 with the addition of a Head of Sales and a Marketing Specialist, and reaching 14 FTEs by Year 4. This structured approach ensures your payroll costs grow in line with your revenue and operational needs.

Key Hiring Milestones

• Year 1: Foundational team of 5.5 FTEs, including leadership and engineering.
• Year 2: Add Head of Sales, Marketing Specialist, and another support rep.
• Year 3: Scale engineering and customer support teams to 3 FTEs each.

How is customer acquisition modeled?

Growth is driven by a two-sided marketing effort to acquire both transport providers (sellers) and patients or facilities (buyers). The model allocates seperate marketing budgets, starting with $150,000 for sellers and $200,000 for buyers in Year 1. It then uses a declining Customer Acquisition Cost (CAC)—starting at $1,500 per seller and $100 per buyer—to project how many new users you acquire each month. This detailed non-emergency patient transport revenue forecasting spreadsheet connects your marketing spend directly to revenue growth.

Core Acquisition Assumptions

• Annual Marketing Budget: Separate budgets for acquiring sellers and buyers.
• Customer Acquisition Cost (CAC): Models cost to acquire each user type.
• Buyer & Seller Mix: Forecasts the blend of individuals, fleets, facilities, and insurers.

This patient transport financial model is 100% editable to match your specific business plan. You can easily adjust all core assumptions—from driver acquisition costs to commission rates—without needing to build complex formulas from scratch. This flexibility allows you to create detailed financial projections for your NEMT business plan that are both accurate and uniquely yours.

Tailor revenue streams to your model

Adjust all cost and payroll assumptions

Modify acquisition funnels and cohorts

Input your own startup cost estimates

Gain a clear, long-term view of your business's financial future with comprehensive five-year forecasts. This healthcare transport excel template projects everything from revenue and expenses to cash flow and profitability. Having a long-range NEMT financial plan helps you anticipate funding needs, set realistic growth targets, and make informed strategic decisions well ahead of time.

Forecast monthly and annual P&L

Project cash flow statements

Visualize balance sheet evolution

Track key financial ratios over time

Understanding your full cost structure is critical, and this model provides a clear breakdown of both startup costs for your NEMT business and recurring operational expenses. It helps you budget accurately for initial investments like platform development and office setup while also planning for ongoing costs like payroll, marketing, and software. This detailed cost analysis is essential for securing funding.

Itemize all initial capital expenses

Estimate fixed monthly overheads

Calculate variable costs per transaction

Plan your complete operational budget

How does your plan stack up against the real world? This model comes pre-loaded with researched assumptions for the non-emergency medical transportation finance sector. You can compare your projected performance on key patient transportation business metrics against industry standards, helping you build a more credible and defensible financial forecast for investors and stakeholders.

Validate your key assumptions

Compare against market data

Strengthen your business case

Set realistic performance targets

Whether you prefer Microsoft Excel or work collaboratively in Google Sheets, this template is built for you. It's fully compatible with both platforms, giving you the flexibility to work on your Mac or Windows machine or share it with your team for real-time updates. This ensures your financial planning workflow is seamless, no matter your preferred tool.

Use on any Mac or Windows device

Collaborate in real-time with your team

Access your plan from anywhere

No special software is required

Instantly grasp your company's financial health with a powerful, pre-built dashboard. It visualizes key metrics like revenue growth, EBITDA, cash flow, and customer acquisition costs through easy-to-read charts and graphs. This high-level summary is perfect for tracking progress and presenting a clear financial narrative to your team, advisors, or potential investors.

Visualize key performance indicators

Track revenue and profit trends

Monitor cash balance and burn rate

Present data in a clear, simple format

This downloadable financial model for a patient transport startup is designed to meet the rigorous standards of investors. The layout is clean, professional, and easy to follow, covering all the essential components they expect to see in a pitch. From the detailed assumptions tab to the three-statement financial summary, it provides a polished and credible view of your business.

Clean, professional, and readable layout

Follows standard financial reporting

Includes all key investor metrics

Ready for your pitch deck or business plan