Pro Forma Worksheet.pdf
PDF 70 KB Posted
- Solicitation number
- FHSP-SADDLE-BARN-2027
- Issued by
- Marion County, Indiana
About this file
This is a Pro Forma Worksheet template designed for financial projections based on a calendar year format (2027-2030) and appears to be associated with the Department of Natural Resources (DNR). The worksheet is structured to capture financial performance across a four-year planning period, with columns allocated for each year to enable comparative analysis and trend forecasting. The document outlines the framework for projecting operational viability and financial sustainability, though no specific project details, response dates, contract terms, or award information are provided in this template.
The Pro Forma Worksheet itemizes three primary revenue sources: merchandise, food, and other income categories, each tracked across the four-year projection period. Operating expenses are organized into four cost categories: cost of sales, labor costs (including salaries, wages, payroll taxes, and benefits), utilities, and other operating expenses (including maintenance, equipment, advertising, professional fees, and insurance). The worksheet culminates in calculations for gross profit, total operating expenses, net income before and after taxes, and a line item designated for "Proposed Payment to DNR," indicating this may be associated with a concession agreement, licensing arrangement, or similar revenue-sharing partnership with the state agency. No specific funding amounts, set-asides, or incumbent information is evident from this template document.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| SOI_PROFESSIONAL_SERVICES_CONTRACT.docx | DOCX document | |
| Proposal.pdf | ||
| RFQ Solicitation Package Event 003000000088455.docx | DOCX document | |
| Event 003000000088455.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
2027 2028 2029 2030
Pro Forma Worksheet Based on Calendar Year
2027 2028 2029 2030
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 .