Pro Forma Worksheet.pdf

PDF 456 KB Posted

Attached to
300 SP Concession Opportunity Interlake/RedbirdBid Documents
Solicitation number
003000000086564
Issued by
Porter County, Indiana

About this file

This is a Pro Forma Worksheet document for financial planning purposes with projections based on calendar years 2026 through 2029, likely associated with a Department of Natural Resources (DNR) contract or concession agreement. The worksheet is designed to project revenues and expenses for a business operation, with revenue categories including merchandise, food, and other sources tracked across the four-year projection period. The document does not specify response dates, due dates, site visits, bidder meetings, award dates, or contract terms within its content.

The Pro Forma Worksheet outlines a comprehensive financial model including gross revenue projections, cost of sales, and detailed operating expense categories such as labor costs (salaries, wages, insurance, and payroll 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, and miscellaneous expenses). The worksheet calculates net income before and after taxes for each projection year and includes a line item for "Proposed Payment to DNR," indicating this financial model supports a proposal for a revenue-sharing or licensing arrangement with the Department of Natural Resources. Specific dollar amounts and funding sources are not populated in the provided document.

View the file

Other files

File Type Posted
SOI_PROFESSIONAL_SERVICES_CONTRACT.docx DOCX document
`UPDATED Solicitation package 2025.docx DOCX document
003000000086564.pdf PDF
sp-interlake-redbird-orvrentals-2026.pdf 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

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 .