Pro Forma Worksheet.pdf
PDF 70 KB Posted
- Solicitation number
- 003000000088457
- Issued by
- Ohio County, Indiana
About this file
This is a Pro Forma Worksheet template for financial projections prepared for a state agency, the Department of Natural Resources (DNR), covering calendar years 2027 through 2030. The worksheet is designed to project revenues, costs, expenses, and net income across a four-year period, with a proposed payment mechanism to the DNR as a final line item. The document appears to support a contract or concession proposal requiring detailed financial forecasting but does not specify project scope, service descriptions, quantities, timelines, bidder meetings, or award dates.
The worksheet captures three primary revenue categories: merchandise, food, and other income sources. Operating expenses are organized into labor costs (including salaries, wages, and employee benefits), utilities (electricity, gas, water, sewer, telephone, trash, and internet), and other operating costs (maintenance, vehicles, equipment, advertising, professional fees, insurance, and miscellaneous expenses). The template calculates gross profit, total operating expenses, net income before taxes, taxes on income, and net income, with a final deduction for the proposed payment to DNR. No specific pricing terms, set-asides, incumbent information, or funding sources are identified in this template document.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| SOI_PROFESSIONAL_SERVICES_CONTRACT.docx | DOCX document | |
| Proposal.pdf | ||
| RFQ Solicitation Package Event 003000000088457.docx | DOCX document | |
| Event 003000000088457.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 .