Pro Forma Worksheet.pdf
PDF 456 KB Posted
- Solicitation number
- 003000000086562
- Issued by
- Floyd County, Indiana
About this file
This is a Pro Forma Worksheet document for financial projections based on calendar years 2026 through 2029, involving the Department of Natural Resources (DNR). The worksheet is designed to project revenues, costs, and net income over a four-year period and includes a line item for proposed payment to DNR. The document serves as a template for forecasting financial performance across multiple revenue categories including merchandise, food, and other income sources.
The worksheet is structured to calculate gross profit by subtracting total cost of sales from gross revenue, then deducting operating expenses across multiple categories including labor costs (salaries, wages, insurance, and taxes), utilities (electricity, gas, water, sewer, telephone, trash removal, internet), and other operating costs (postage, linen, uniforms, maintenance, vehicles, equipment, advertising, processing fees, professional services, insurance, and miscellaneous expenses). The document culminates in a net income before taxes calculation, followed by a deduction for taxes on income to arrive at final net income, with a designated line for the proposed payment amount to DNR. The financial projections appear to support a revenue-sharing or licensing agreement with the state agency.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| sp-brookville-beachsnacks-2026.pdf | ||
| `UPDATED Solicitation package 2025.docx | DOCX document | |
| 003000000086562.pdf | ||
| SOI_PROFESSIONAL_SERVICES_CONTRACT.docx | DOCX document |
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 .