ProForma Worksheet 2027-2030.pdf
PDF 472 KB Posted
- Solicitation number
- 88049
- Issued by
- Johnson County, Indiana
About this file
This is a Pro Forma Worksheet prepared for the Department of Natural Resources (DNR) covering the calendar years 2027 through 2030. The document outlines a comprehensive financial projection template designed to forecast revenues, costs, and net income over a four-year period. The worksheet is structured to capture gross revenue from multiple sources including merchandise, food, and other categories, with corresponding cost of sales calculations to determine gross profit. The document accounts for all major operating expense categories essential to business planning, including labor costs (salaries, wages, insurance, taxes, and employee benefits), utilities (electricity, gas, water, sewer, telephone, trash removal, and internet), and other operational expenses (postage, linen, uniforms, maintenance, vehicles, equipment, advertising, professional fees, and miscellaneous costs).
The pro forma template calculates total operating expenses against gross profit to project net income before taxes, with a designated line item for income taxes and resulting net income for each year. A specific line item labeled "Proposed Payment to DNR" appears at the bottom of the worksheet, indicating that a portion of projected net income is allocated as payment or revenue sharing to the Department of Natural Resources. The worksheet serves as a financial planning and forecasting tool, likely required as part of a bid submission or contract proposal to demonstrate the applicant's financial viability and projected ability to meet financial obligations to the state agency over the specified four-year contract term.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Addendum RFQ_Solicitation Event 003000000088049.pdf | ||
| UPDATED RFQ 88049 - Atterbury FWA Shooting Range Concession Bid.pdf | ||
| RFQ 88049 - Atterbury FWA Shooting Range Concession Bid.pdf | ||
| Exhibit A Consession Requirements.docx | DOCX document | |
| TEMPLATE SOI_PROFESSIONAL_SERVICES_CONTRACT.docx | DOCX document | |
| Exhibit E SOP.docx | DOCX document | |
| Exhibit C Lawn.docx | DOCX document | |
| Exhibit D Scope of Work.docx | DOCX document | |
| Exhibit B Shooting Range Map.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
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 .