Pro Forma Worksheet.pdf
PDF 70 KB Posted
- Attached to
- 300 SP Concession Opportunity Chain O'LakesBid Documents State and local contract opportunity
- Solicitation number
- 075294a69d3a7a71af79ad3b0e7b3e0d
- Issued by
- Marshall County, Indiana
About this file
This is a Pro Forma Worksheet template designed for financial projections submitted to the Department of Natural Resources (DNR), covering a four-year planning period from 2027 through 2030 on a calendar year basis. The worksheet is structured to capture comprehensive financial data across multiple revenue categories, including merchandise, food, and other sources, with corresponding cost of sales calculations to determine gross profit margins. The template requires detailed operating expense documentation across labor costs, utilities, and miscellaneous operational expenses, ultimately projecting net income before and after taxes.
The Pro Forma Worksheet establishes a standardized financial reporting framework that requires itemization of labor expenses including salaries and wages, insurance, payroll taxes, and health benefits; utility costs such as electricity, gas, water, and sewer; and additional operating expenses including maintenance, vehicles, equipment, advertising, professional fees, and insurance. The template concludes with a line item for "Proposed Payment to DNR," indicating that the financial projections are tied to a payment obligation or revenue-sharing arrangement with the state agency. This worksheet appears designed to evaluate the financial viability and sustainability of a proposed operation while ensuring transparency regarding projected income and associated DNR payment obligations over the four-year projection period.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| Proposal.pdf | ||
| SOI_PROFESSIONAL_SERVICES_CONTRACT.docx | DOCX document | |
| RFQ_SolicitationPackage August 2026.docx | DOCX document | |
| Event 003000000088459.pdf |
On GovTribe
Work with this file on GovTribe
- 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 .