Pro Forma Worksheet.pdf
PDF 456 KB Posted
- Solicitation number
- 003000000086565
- Issued by
- Montgomery County, Indiana
About this file
This is a Pro Forma Worksheet document used for financial projections related to a contract opportunity with the Department of Natural Resources (DNR). The worksheet projects financial performance across four calendar years (2026-2029) and appears to be designed for a revenue-generating operation, likely a food service or retail concession based on the revenue categories listed (merchandise, food, and other sources). The document requires applicants to detail anticipated gross revenues, calculate cost of sales, and project operating expenses across multiple expense categories including labor, utilities, and miscellaneous operational costs.
The Pro Forma Worksheet requests detailed financial modeling with specific line items for salaries and wages, insurance (workers compensation and unemployment), payroll taxes, employee health insurance, utilities (electricity, gas, water, sewer, telephone, internet), and operational expenses such as maintenance, advertising, professional fees, and equipment. Applicants must calculate gross profit, total operating expenses, net income before and after taxes, and propose a payment amount to DNR, suggesting a revenue-sharing or concession fee arrangement. This financial planning tool enables the evaluating agency to assess the financial viability and sustainability of proposed operations while determining the appropriate compensation structure for the contract term.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| sp-mccormickscreek-saddle barn-2026(2).pdf | ||
| Solicitation Package Event 003000000086565.docx | DOCX document | |
| ProForma Worksheet 2026-2029.pdf | ||
| 003000000086565.pdf | ||
| `UPDATED Solicitation package 2025.docx | DOCX document | |
| SOI_PROFESSIONAL_SERVICES_CONTRACT.docx | DOCX document | |
| sp-mccormickscreek-saddle barn-2026(1).pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
REVENUE
List each revenue source / category
Gross Revenue -$ -$ -$ -$
Merchandise
Food
Other
Total Cost of Sales -$ -$ -$ -$
Gross Profit (Gross Revenue minus Total Cost of Sales) -$ -$ -$ -$
Salaries and Wages
Insurance - Workers Comp
Unemployment Taxes
FICA & Medicare Taxes
Health Insurance - Employees
Other Employee/Labor Expenses
Labor Cost Subtotal -$ -$ -$ -$
Electricity
Gas
Water
Sewer
Telephone
Trash Removal
Internet
Other Utilities
COST OF SALES
OPERATING EXPENSES
Pro Forma Worksheet Based on Calendar Year
2026 2027 2028 2029
Pro Forma Worksheet Based on Calendar Year
2026 2027 2028 2029
Utilities Cost Subtotal -$ -$ -$ -$
Postage
Linen
Uniforms
Maintenance
Vehicles
Equipment
Advertising
Electronic Processing Fees
Accountant Fees
Contract Services
Publications and Dues
Insurance
Miscellaneous Expenses
Other Expenses
Operating Other Costs Subtotal -$ -$ -$ -$
Total Operating Expenses -$ -$ -$ -$
Net Income Before Taxes -$ -$ -$ -$
Taxes on Income
NET INCOME -$ -$ -$ -$
PROPOSED PAYMENT TO DNR
File details come from the government source that posted it. Updated .