Exhibit C- Financial Information Submittal Form.xlsx

XLSX spreadsheet 64 KB Posted

Attached to
11690 CONCESSION AND OTHER SERVICES AT SILVER FALLS STATE PARK
Solicitation number
S-63400-00011142
Issued by
Marion County, Oregon

About this file

This document is an Excel file titled "Exhibit C- Financial Information Submittal Form" related to a state and local contract opportunity issued by the Oregon Parks and Recreation Department (OPRD) for concession and other services at Silver Falls State Park.

The document includes forms and instructions for proposers to submit their financial information, including planned investments, income/expense statements, operating assumptions, and cash flow statements. The contract opportunity entails managing various concession operations within the 9,000-acre Silver Falls State Park, which receives over 1.3 million annual day-use visitors. Proposers must submit the completed financial forms as part of their proposal. The contract term is not specified, but the document indicates that one-time capital investments and start-up expenses are expected to be incurred in the year prior to or the first year after the contract start date. The document provides detailed guidance on the information required in each financial form.

View the file

Other files

Show all 18

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

Index

BUSINESS OPPORTUNITY #11690

EXHIBIT C FINANCIAL INFORMATION SUBMITTAL FORM

THIS FORM MUST BE COMPLETED AND SUBMITTED WITH YOUR PROPOSAL
Tab #Tab TitleDescription
1IndexThis first tab provides an index and description of the following tabs in the spreadsheet
2Investments FormRecord the up front initial investments that will be needed for a successful concession operation. This includes assets that you may already have on hand that you purchased during the last year or items that you will need to purchase during the first year of the contract.

This tab also records your estimated "working capital", those cash funds you believe you will need to get the concession off the ground and running. These funds can be sourced from savings, financing, loans, etc.

3Investments AssumptionsThis tab is where you provide a description of the items you listed on the prior tab "Investments Form".
4Inc-Exp Statement FormList here a summary of projected Income and Expenses related to the Concession Operations. Detail supporting the Revenue and Labor/Payroll expenses are requested on a following tab "Operating Assumptions Form".

Administrative and General Management Expenses are meant to collect information of "overhead" costs that are charged to the Concession Operation. This would most likely occur if the Offeror has multiple businesses that are run from a central location and a share of the administrative overhead is charged to the Concession Operation.

5Inc-Exp Statement AssumptionsThis tab is where you provide a description of the items you listed on the prior tab "Inc-Exp Statement Form".
6Operating Assumptions FormThis tab provides detail to support your revenue numbers used on the tab "Inc-Exp Statement Form". Here you will project how many sales of various items you will make and the average value of those sales.
7Cash Flow Statement FormThis tab gives an overview of cash flow during a 3 year period and will determine if your assumptions will generate a positive or negative cash flow. It uses information from the previous tabs, for the most part, but arranges them in an order that focuses on cash flow.
8Cash Flow Statement AssumptionsThis tab gives you the opportunity to describe items on the "Cash Flow Statement Form".

Investments Form

INITIAL INVESTMENTS AND START-UP EXPENSES FORM

Grey Cells Are Input Cells

Name of Proposer

OPRD Number 11690

AssetsNotes:
Existing Assets
Assets necessary to the operation of the concession, already owned by the proposer, that will be used in theSome proposals assume the use of existing assets, equipment and supplies that are owned by the proposer; this section captures the value of those items
operation of the concession. Answers the question: What are you bringing to the table that you already own?
Real Property (land and buildings within the park)Past operations have not required land and buildings in the park that were owned by the concession operator. If that is the case, this cell would be zero. Enter an amount if you believe you need to own land or buildings in the park.
Real Property (land and buildings not within the park)Concession operator may own land or buildings outside of the park that provide support services to the operations within the park.
Personal Property (movable property, not land or buildings)Concession operators may already own equipment/assets to deliver services or rent to customers
Inventory and SuppliesConcession operators may have on hand inventory and supplies that will be used in the operation of the concession.
Other (describe)Anything else that the operator may have on hand that will be used for concession operations.

Subtotal 0

Planned Asset AcquisitionSome proposals assume the need to purchase assets, equipment and supplies in order to have a successful concessions operation; this section captures the value of those items
Assets necessary to operate the concession, that will be acquired by the proposer if awarded the Contract.
Answers the question: What will you need to purchase to make this work?
Real Property (land and buildings within the park)Past operations have not required land and buildings in the park that were owned by the concession operator. If that is the case, this cell would be zero. Enter an amount if you believe you need to own land or buildings in the park.
Real Property (land and buildings not within the park)Concession operator may own land or buildings outside of the park that provide support services to the operations within the park.
Personal Property (movable property, not land or buildings)Purchase of current operators personal property, acquisition of certain OPRD assets to ensure turn-key operation of concession facilities and planned acquistiions for start-up
Inventory and Working CapitalCash made available for day-to-day operations and inventory and supplies that will be used in the operation of the concession.
Other (describe)Anything else that the operator may need to be purchased that will be used for concession operations.

Subtotal 0

Total 0

Other

Start-Up Expenses
Operating Supplies
Other (describe)

Total 0

Total Initial Investments and Start-up Expenses 0

Notes
1) Formulas included in this form are provided by OPRD as guidance only. The proposer is responsible for its financial
projections and their accuracy.

2) Yellow cells represent categories that need to be explained on the "Investments Assumptions" worksheet.

3) All proposers must include their estimate of the value of all property intended, whether planned for acquisition or currently
owned, for use in the Contract, if awarded.
4) The items indicated above are the estimated planned expenditures for initial investment, defined as one-time costs in either
the year prior to or the first year after the start of the Contract, if awarded.
5) Expenditures entered in this form should be in addition to that of typical annual capital investments and operating expenses
of the first year of the Contract, if awarded.

6) Expenditures entered into this form should not be included in the proforma income statement.

7) Expenditures entered in this form should be included in the cash flow proforma as capital expenditures in either the year prior
to or the first year after the start of the Contract, if awarded.

8) Amounts entered into this spreadsheet are asked to be described and explained in the next worksheet tab "Investment Assumptions".

Definitions
Start-up Expenses
One-time expenses incurred prior to the beginning of the Contract, or during the first year of the Contract, if needed, to
implement your Proposal. Typical costs include marketing, labor costs to transition operations, etc.
Working Capital
Additional funds for working capital current assets such as pre-paid expenses, contingencies, and other necessary cash flow
requirements.

Investments Assumptions

INITIAL INVESTMENTS AND START-UP EXPENSES ASSUMPTIONS
(This sheet is to be used to describe or justify the numbers entered into the worksheet tab "Investments Form")
Grey Cells Are Input Cells

Name of Proposer 0

OPRD Number 11690

Assets

Existing Assets
Assets necessary to the operation of the concession, already owned by the proposer, that will be used in the
operation of the concession. Answers the question: What are you bringing to the table that you already own?
Real Property (within the park)Describe
Real Property (not within the park)Describe
Personal PropertyDescribe
Inventory and Working CapitalDescribe
Other (describe)Describe
Planned Asset Acquisition
Assets necessary to operate the concession, that will be acquired by the proposeer if awarded the Contract.
Answers the question: What will you need to purchase to make this work?
Real Property (within the Park)Describe
Real Property (not within the Park)Describe
Personal PropertyDescribe
Inventory, Working CapitalDescribe
Other (describe)Describe

Other

Start-Up ExpensesDescribe
Operating SuppliesDescribe
Other (describe)Describe
Notes
1) In the description sections of this form, please provide an explanation of sufficient detail to allow a reviewer to fully
understand how the estimates were determined.

Inc-Exp Statement Form

INCOME/EXPENSE STATEMENT FORM

Grey Cells Are Input Cells
Name of Proposer0

OPRD Number 11690

Prospective Income Statement

Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10
Notes:
RevenueThese revenue amounts will need to be supported by calculations on the worksheet tab "Operating Assumptions Form".
Rooms Smith Creek Village (SCV)
Food and Beverage (SCV)
Ranches (SCV)
Meeting (SCV)
Banquet/Catering (SCV)
Retail (SCV)
Other (SCV)
Food and Beverage South Falls Café (SFC)
Retail (SFC)
Other (Describe)
Other (Describe)
Total Gross Revenue$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Deductions
Total Gross Receipts (if Different)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Cost of Sales
Rooms Smith Creek Village (SCV)
Food and Beverage (SCV)
Ranches (SCV)
Meeting (SCV)
Banquet/Catering (SCV)
Retail (SCV)
Food and Beverage South Falls Café (SFC)
Other (Describe)
Other (Describe)
Total cost of Sales$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Gross Profit $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Direct Expenses

Rooms Smith Creek Village
Labor
Other Departmental Expenses
Total Lodging Expenses$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Food and Beverage Smith Creek Village
Labor
Other Departmental Expenses
Total Food and Beverage Expenses$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ranches Smith Creek Village
Labor
Other Departmental Expenses
Total Retail Expenses$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Meeting Smith Creek Village
Labor
Other Departmental Expenses
Total Campground Expenses$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Banquet/Catering Smith Creek Village
Labor
Other Departmental Expenses
Total Fuel Expenses$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Retail Smith Creek Village
Labor
Other Departmental Expenses
Total Authorized Services Expenses$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other Smith Creek Village
Labor
Other Departmental Expenses
Total Other (Specify) Expenses$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Food and Beverage South Falls Café
Labor
Other Departmental Expenses
Total Other (Specify) Expenses$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Retail South Falls Café
Labor
Other Departmental Expenses
Total Other (Specify) Expenses$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other (Specify)
Labor
Other Departmental Expenses
Total Other (Specify) Expenses$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other (Specify)
Labor
Other Departmental Expenses
Total Other (Specify) Expenses$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other Direct
Utilities
Repair and Maintenance Expense

Total Other Direct $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Total Direct Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Undistributed Expenses
A&G
Telecommunications
Management Fees
Advertising/Marketing
Maintenance Reserve
Other Undistributed
Other Undistributed

Total Undistributed Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Fixed Expenses
Insurance
Property Taxes
Property Rental
Other (Licenses)

Total Fixed Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Total Operating Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

EBITDA Before FF $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Concession Fees
Concession fee as % of Gross ReceiptsERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!

EBITDA after concession fee $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Interest Expense
Depreciation
Amortization

Net Profit Before Taxes $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Income Tax

Net Income $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Notes
1) Formulas included in this form are provided by OPRD as guidance only. The proposer is responsible for its financial projections and their accuracy.

2) Yellow cells represent categories that need to be explained on the "Income Statement Assumptions" worksheet.

3) Only projected receipts and expenses related to the services required by the Contract and those you choose to operate under authorized services are to be itemized and included in your prospective statements. Please clearly identify, by service type, all revenues associated with authorized services.

Definitions
Gross Receipts
Gross Revenues less any deducted revenues that are proposed to be exempt from concession fee.
EBITDA
Earnings Before Interest, Taxes, Depreciation, Amortization.
Concession Fee
A percentage of gross receipts due to OPRD. Enter the raw number and the percentage is calculated by the spreadsheet

Inc-Exp Statement Assumptions

INCOME/EXPENSE STATEMENT ASSUMPTIONS
(This sheet is to be used to describe or justify the numbers entered into the worksheet tab "Income Statement Form")
Grey Cells Are Input Cells
Name of Proposer0

OPRD Number 11690

Revenue
See "Operating Assumptions Form" Tab
Direct Expenses
Rooms Smith Creek VillageDescribe
Food and Beverage Smith Creek VillageDescribe
Ranches Smith Creek VillageDescribe
Meeting Smith Creek VillageDescribe
Banquet/Catering Smith Creek VillageDescribe
Retail Smith Creek VillageDescribe
Other Smith Creek VillageDescribe
Food and Beverage South Falls CaféDescribe
Retail South Falls CaféDescribe
UtilitiesDescribe
Indirect Expenses
A&GDescribe
TelecommunicationsDescribe
Marketing & AdvertisementDescribe
Repair and MaintenanceDescribe
Maintenance reserveDescribe
Other (Specify)Describe
Fixed Expenses
RentDescribe
Property TaxesDescribe
InsuranceDescribe
Misc LicensesDescribe
Notes
1) In the description sections of this form, please provide an explanation of sufficient detail to allow a reviewer to fully
understand how the estimates were determined.
2) If you are going to offer additional services, please clearly identify which service(s) you will offer and use additional
separate rows for each proposed service department. Labor costs should be supported by appropriate staffing
level descriptions
Expense Assumption Description Example
***The following example does not reflect the above opportunity and is provided for the purpose of clarification only.***
Direct expenses are expected to surpass historical direct expenses, as fuel and insurance prices increase. Studies by
the Department of Commerce indicate that fuel prices will rise at a rate of 10% annually over the next ten years, as
opposed to the historical ten year rate of 4% annually. Additionally, insurance costs, according to a nationwide
insurance broker survey, are expected to rise at 15% annually for the next 10 years, as opposed to the 10 year historical
rate of 2% annually. Accordingly, direct expenses associated with the operation are forecast to increase from an annual
average of 10% of Gross Revenue to an annual average of 20% of Gross Revenues over the life of the Contract.

Operating Assumptions Form

OPERATING ASSUMPTIONS

Grey Cells Are Input Cells

Name of Proposer 0

OPRD Number 11690

Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10

Revenue InflationAdditional Description
Expense Inflation
Rooms Revenue*Specify Type
Smith Creek Village Available RoomsAdditional Description
Annual Occupancy
Average Daily Rate
Smith Creek Village Rooms Revenue$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ranch Nights Available (total annual)
Annual Occupancy
Average Daily Rate
Ranch Rental Revenue$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Revenue$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Food and Beverage at Smith Creek Village (SCV)
Occupied Room NightsAdditional Description
Revenue per Occupied Room Night
Total SCV F&B Revenue$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Meeting Space Revenue
Number of meetingsAdditional Description
Average Revenue Per Meeting
Total Meeting Revenue$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Banquet/Catering
Number of EventsAdditional Description
Revenue Per Event
Catering Revenue$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Number of Attendees
Average Check
Total Event Revenue$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Banquet/Event Revenue$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Retail Revenue (Smith Creek Village)
Occupied Room NightsAdditional Description
Revenue Per Occupied Room
Total Retail Revenue$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other Revenue (Smith Creek Village)
Occupied Room NightsAdditional Description
Revenue Per Occupied Room
Total SCV F&B Revenue$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Food and Beverage at South Falls Café (SFC)
Number of TransactionsAdditional Description
Average Check
Total SCV F&B Revenue$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Retail at South Falls Café (SFC)
Park VisitationAdditional Description
Reveu per visitor
Total SCV F&B Revenue$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other (Describe)
Number of TransactionsAdditional Description
Revenue per Transaction
Total Other$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other (Describe)
Number of TransactionsAdditional Description
Revenue per Transaction
Total Other$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other (Describe)
Number of TransactionsAdditional Description
Revenue per Transaction
Total Other$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Total Revenue 0 0 0 0 0 0 0 0 0 0

Notes
1) Please note that revenue projections must be based on rates determined by the approval methods set forth in the sample Contract.
2) The information on this form should fully explain and document your Gross Revenue build-up. State annual inflation rate assumptions, rate increase assumptions, utilization assumptions and any estimates of real
growth you anticipate. If you have any additional descriptions of your assumptions, please use the "Additional Description" boxes to the right of each revenue department.

3) If you are going to offer additional services, please clearly identify which service(s) you will offer and use additional rows to describe your revenue buildup for each additional service.

Revenue Assumption Description Example
***The following example does not reflect the above opportunity and is provided for the purpose of clarification only.***
Revenue inflation is expected to increase at the same rate as the Consumer Price Index which is predicted to grow at a rate of 2.7% annually, based upon historical growth as reported by the Bureau of Labor Statistics
No real growth is expected to occur, keeping in line with historical revenues at the concession. Therefore, overall revenue growth is forecast to occur at an average annual rate of 2.7% over the life of the Contract.

Page &P of &N

Cash Flow Statement Form

CASH FLOW STATEMENT FORM
Grey Cells Are Input Cells
Name of Proposer0
OPRD Number11690
Prospective Cash Flow StatementNote: These operating activities should come from the "Income Statement Form" tab.
See "Income Statement Form" tab for reference to this line
Operating ActivitiesYear ZeroYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10
Net Income (After concession fees)
Depreciation
Amortization
Other (describe)
Change in working capitalWorking Capital is cash made available for day-to-day operations
Other (describe)
Other (describe)

Net Cash Provided (Used) by Operating Activities 0 0 0 0 0 0 0 0 0 0 0

Financing Activities
Dividend
Sale/Repurchase of Stock
Borrowings/ Repayment of Debt
Other (describe)

Net Cash Provided (Used) by Financing Activities 0 0 0 0 0 0 0 0 0 0 0

Investment Activities
Personal Property Replacement
Real Property (within park)See "Investments Form" tab for further explanation of these property items.
Real Property (not Within park)
Inventory and Working Capital
Start-Up Expenses
Other (describe)
Other (describe)
Other (describe)
Other (describe)

Net Cash Provided (Used) by Investing Activities 0 0 0 0 0 0 0 0 0 0 0

Total Cash Flow 0 0 0 0 0 0 0 0 0 0 0

Notes$ - 0
1) Formulas included in this form are provided by OPRD as guidance only. The proposer is responsible for its financial projections and their accuracy.

2) Yellow cells represent categories that need to be explained on the "Cash Flow Statement Assumptions" worksheet.

3) Investment activities should include entries for one time acquisition and disposal at the beginning and end of the Contract term as well as cyclical or annual capital investments such as replacement.

4) Estimates for capital expenditures in the Cash Flow Statements made prior to or during the first year after the start of the concession operation should be reflective of estimates provided in the Initial Investment and Start-up Costs form.

5) Clearly delineate between personal and real property and define your rationale and assumptions for each category.

Cash Flow Statement Assumptions

CASH FLOW STATEMENT ASSUMPTIONS
Grey Cells Are Input Cells
Name of Proposer0
OPRD Number11690
Investment Activities
Personal Property ReplacementDescribe
Other (describe)Describe
Notes
1) In the description sections of this form, please provide an explanation of sufficient detail to allow a reviewer to fully
understand how the estimates were determined.

File details come from the government source that posted it. Updated .