ESBD_449251_1756218658081_City Financial Analysis.xlsx

XLSX spreadsheet 31 KB Posted Aug 28, 2025

Attached to: 2025-004 - Advanced Life Support ("ALS") and/or Mobile Intensive Care Unite ("MICU") Emergency Ambulance Services for City of Forney
Solicitation number: 2025-004
Issued by: Kenedy County, Texas

About this file

Written by GovTribe AI · Aug 30, 2025

The file is a City Financial Analysis Excel spreadsheet with a detailed five-year financial projection for an ambulance or emergency medical services (EMS) operation. The spreadsheet comprehensively tracks potential revenue streams, trip volumes, payer mix, and detailed expense categories across multiple dimensions including personnel, operational costs, medical supplies, vehicles, and administrative overhead. The financial model is structured to analyze potential financial performance from Year 1 through Year 5, with granular breakdowns of revenue sources such as emergency transports (ALS 1, ALS 2, BLS) and payer categories including Medicare, Medicaid, commercial insurance, and private pay.

The financial projection indicates zero revenue and zero expenses across all five years, suggesting this is a template or placeholder document rather than an actual operational budget. The spreadsheet includes extensive line-item categories for expenses such as salaries and wages, payroll taxes, employee benefits, purchased services, general and administrative costs, vehicle expenses, medical supplies, and other operating expenses. The model appears designed to provide a comprehensive financial planning tool for an EMS organization, allowing detailed tracking of potential revenue sources, trip volumes, and comprehensive expense categories to support financial planning and operational budgeting.

View the file

Other files

File	Type	Posted
ESBD_449251_1756218659854_City of Forney RFP Newspaper Advertisement Exclusive EMS RFP to paper.pdf	PDF	Aug 28, 2025
ESBD_449251_1756218661356_City of Forney, TX EMS RFP 8.26.pdf	PDF	Aug 28, 2025

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Revenue Description Year 1 Year 2 Year 3 Year 4 Year 5 Comment / Explanation

Patient Revenue

ALS 1 Emergency (A0427)	0.0%	0.0%	0.0%	0.0%	0.0%
Base charge per trip	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Mileage charge per mile	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other (describe)

BLS Emergency (A0429)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Base charge per trip	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Mileage charge per mile	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other (describe)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

ALS 2 Emergency (A0433)	0.0%	0.0%	0.0%	0.0%	0.0%
Base charge per trip	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Mileage charge per mile	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other (describe)

Treat/No Transport as a percentage of total trips	0.0%	0.0%	0.0%	0.0%	0.0%
Treat/No Transport charge per trip	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other (describe)

Trip Volume and Payer Mix:
Number of total trips (including Treat/No Transport)	- 0	- 0	- 0	- 0	- 0

Number of ALS 1 Emergency transports	- 0	- 0	- 0	- 0	- 0
Number of ALS 2 Emergency transports	- 0	- 0	- 0	- 0	- 0
Number of BLS Non Emergency transports	- 0	- 0	- 0	- 0	- 0
Number of Treat/No Transport completed trips	- 0	- 0	- 0	- 0	- 0

Payer Mix (percentage of trips):
Medicare	0.0%	0.0%	0.0%	0.0%	0.0%
Medicaid	0.0%	0.0%	0.0%	0.0%	0.0%
Commercial Insurance	0.0%	0.0%	0.0%	0.0%	0.0%
Private Pay & Other	0.0%	0.0%	0.0%	0.0%	0.0%

Other Revenue:
Revenue
Volume	- 0	- 0	- 0	- 0	- 0
Gross Revenue	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Net Collections	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

All Other Revenue
Volume	- 0	- 0	- 0	- 0	- 0
Gross Revenue	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Net Collections	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Additional Calculations Year 1 Year 2 Year 3 Year 4 Year 5 Comment / Explanation

&F &"-,Bold"&A

Page &P of &N

Expense

Description			Year 1	Year 2	Year 3	Year 4	Year 5	Comment / Explanation
Operating Expense Assumptions
	Salary Range (Year 1)
Headcount (FTEs)	Low	High	FTEs by year
Paramedics	$ - 0	$ - 0	- 0	- 0	- 0	- 0	- 0
EMTs	$ - 0	$ - 0	- 0	- 0	- 0	- 0	- 0
Position	$ - 0	$ - 0	- 0	- 0	- 0	- 0	- 0
Position	$ - 0	$ - 0	- 0	- 0	- 0	- 0	- 0
Position	$ - 0	$ - 0	- 0	- 0	- 0	- 0	- 0
Position	$ - 0	$ - 0	- 0	- 0	- 0	- 0	- 0
Position	$ - 0	$ - 0	- 0	- 0	- 0	- 0	- 0
Position	$ - 0	$ - 0	- 0	- 0	- 0	- 0	- 0
Position	$ - 0	$ - 0	- 0	- 0	- 0	- 0	- 0
Position	$ - 0	$ - 0	- 0	- 0	- 0	- 0	- 0
Position	$ - 0	$ - 0	- 0	- 0	- 0	- 0	- 0
Position	$ - 0	$ - 0	- 0	- 0	- 0	- 0	- 0
Subtotal - Headcount (FTEs)			- 0	- 0	- 0	- 0	- 0

Salaries and Wages
Employee Regular	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Employee Overtime	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Contract Labor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Subtotal - Salaries and Wages	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Payroll Taxes & Employee Benefits
All Payroll Taxes / Workers Comp	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Employee Benefits
Pension (Employer Match)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Medical / Health Care	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Dental	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Vision	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Uniforms	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Subtotal - Payroll Taxes & Employee Benefits	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Purchased Services
Partnership/Subcontracting	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Response Time Monitoring Services	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Subtotal - Purchased Services	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Description	Year 1	Year 2	Year 3	Year 4	Year 5	Comment / Explanation
General & Administrative
Professional services / consulting fees	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Rent / leases	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Utilities and telephone	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Office supplies / equipment	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Billing and collection expense	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
General and Auto Liability Insurance	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Performance Security expense	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other Overhead expense	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Corporate / Regional allocations	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Depreciation	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Subtotal - General & Administrative	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Vehicles
Vehicle Lease	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Gas, oil, tires	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Repairs and maintenance	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Depreciation	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Subtotal - Vehicles	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Medical Supplies / Equipment
Equipment Lease	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Medical Supplies	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Repairs and maintenance	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Depreciation	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Subtotal - Medical Supplies / Equipment	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other Operating Expenses
Information Technology expenses	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Training / QI expenses	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Community Education expenses	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other dispatch/communication expense	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Depreciation	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Subtotal - Other Operating Expenses	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Interest Expense	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Operating Expenses	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Additional Calculations	Year 1	Year 2	Year 3	Year 4	Year 5	Comment / Explanation

&F &"-,Bold"&A

Page &P of &N

Output

Description	Year 1			Year 2			Year 3			Year 4			Year 5
	# of trips	Gross Revenue	Net Collections	# of trips	Gross Revenue	Net Collections	# of trips	Gross Revenue	Net Collections	# of trips	Gross Revenue	Net Collections	# of trips	Gross Revenue	Net Collections
All Patient Charges
Medicare	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0
Medicaid	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0
Commercial Insurance	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0
Private Pay & Other	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0
Subtotal - All Patient Charges	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0

Other Revenues
Revenue	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0
All Other Revenue	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0
Subtotal - Other Revenues	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0	- 0	$ - 0	$ - 0
Total Net Revenues			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
Operating Expenses:
Salaries and Wages			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0

Payroll Taxes & Employee Benefits $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Purchased Services
Partnership/Subcontracting	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Subtotal - Purchased Services	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
General & Administrative	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Vehicles	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Medical Supplies / Equipment	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other Operating Expenses	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Interest Expense	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Operating Expenses	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Income from Operations	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

&F &"-,Bold"&A

Page &P of &N

File details come from the government source that posted it. Updated Aug 30, 2025.