Pro Forma Worksheet 2027-2030.pdf

PDF 70 KB Posted

Attached to
300 SP Concession Opportunity Interlake/RedbirdBid Documents State and local contract opportunity
Solicitation number
003000000088029
Issued by
Porter County, Indiana

About this file

This is a Pro Forma Worksheet for financial projections submitted to the Department of Natural Resources (DNR) covering the calendar years 2027 through 2030. The document is designed to capture projected financial performance across a four-year period, with line items for revenue generation, cost of sales, operating expenses, and net income calculations. Revenue sources are categorized as merchandise, food, and other income streams, with corresponding cost of sales deductions to determine gross profit. The worksheet structure allows for year-by-year comparison of financial metrics across the four-year projection period.

The operating expenses section encompasses labor costs including salaries, wages, workers' compensation insurance, unemployment taxes, FICA and Medicare taxes, health insurance, and other employee-related expenses. Utility costs are itemized separately, covering electricity, gas, water, sewer, telephone, trash removal, internet, and miscellaneous utilities. Additional operating expense categories include postage, linen, uniforms, maintenance, vehicles, equipment, advertising, electronic processing fees, accountant fees, contract services, publications and dues, insurance, and miscellaneous expenses. The worksheet calculates total operating expenses, net income before taxes, income taxes, and final net income, concluding with a line item for proposed payment to DNR, which suggests this financial projection is associated with a concession agreement, licensing arrangement, or similar revenue-sharing arrangement with the state agency.

View the file

Other files for this state and local contract opportunity

Other files attached to 300 SP Concession Opportunity Interlake/RedbirdBid Documents, newest first.
File Type Posted
RFQ_Solicitation Event 003000000088029.docx DOCX document
Addendum RFQ_Solicitation Event 003000000088029.pdf PDF
`UPDATED Solicitation package 2025.docx DOCX document
Proposal Interlake Redbird ORV Rental 2027.pdf PDF
SOI_PROFESSIONAL_SERVICES_CONTRACT.docx DOCX document
Event 003000000088029.pdf 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 .