Attachment C_Financial Information Submittal Form.xlsx
XLSX spreadsheet 56 KB Posted
- Attached to
- 9200 Business Opportunity for Concession and Other Services at Frenchglen Hotel State Heritage Site
- Solicitation number
- S-63400-00006796
- Issued by
- Harney County, Oregon
About this file
This document is an attachment to a state and local contract opportunity related to concession services at the Frenchglen Hotel State Heritage Site in Harney County, Oregon. The attachment includes forms for proposers to submit financial information, investments, income and expense statements, operating assumptions, and cash flow statements. The opportunity is for a concession contract to provide various services such as rentals, retail, and other services at the site. Proposers must complete and submit the required financial forms with their proposals. The contract term is not specified, but may include renewal options.
The financial forms require proposers to detail their existing assets, planned asset acquisitions, start-up expenses, projected income and expenses, operating assumptions, and cash flow over a 3-year period. Proposers must describe and justify the assumptions used in their financial projections. The contract will likely be awarded based on the financial viability and projections submitted by proposers. No information is provided on pricing terms, set asides, incumbents, funding sources, or award amounts.
View the file
Other files
Show all 11
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
| Opportunity 9200 ATTACHMENT C FINANCIAL INFORMATION SUMBITTAL FORM | ||
| THIS FORM MUST BE COMPLETED AND SUBMITTED WITH YOUR PROPOSAL | ||
| Tab # | Tab Title | Description |
| 1 | Index | This first tab provides an index and description of the following tabs in the spreadsheet |
| 2 | Investments Form | Record 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.
| 3 | Investments Assumptions | This tab is where you provide a description of the items you listed on the prior tab "Investments Form". |
| 4 | Inc-Exp Statement Form | List 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.
| 5 | Inc-Exp Statement Assumptions | This tab is where you provide a description of the items you listed on the prior tab "Inc-Exp Statement Form". |
| 6 | Operating Assumptions Form | This 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. |
| 7 | Cash Flow Statement Form | This 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. |
| 8 | Cash Flow Statement Assumptions | This 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 Opportunity Number 9200
| Assets | Notes: |
| Existing Assets | |
| Assets necessary to the operation of the concession, already owned by the proposer, that will be used in the | Some 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 Supplies | Concession 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 Acquisition | Some 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) | Concession operators frequently plan to purchase equipment/assets to deliver services or rent to customers | |
| Inventory and Supplies | Concession 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 need to be purchased that will be used for concession operations. |
Subtotal 0
Total 0
Other
| Start-Up Expenses | |
| Working Capital | Working Capital is cash made available for day-to-day operations |
| 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 Opportunity Number 9200
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 Property | Describe |
| Inventory and Supplies | Describe |
| 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 Property | Describe |
| Inventory and Supplies | Describe |
| Other (describe) | Describe |
Other
| Start-Up Expenses | Describe |
| Working Capital | Describe |
| 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 Proposer | 0 |
OPRD Opportunity Number 9200
Prospective Income Statement
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||
| Notes: | ||||||
| Revenue | These revenue amounts will need to be supported by calculations on the worksheet tab "Operating Assumptions Form". | |||||
| Rentals | ||||||
| Retail | ||||||
| Other (Specify) | ||||||
| Other (Specify) | ||||||
| Total Gross Revenue | 0 | 0 | 0 | 0 | 0 | |
| Total Deductions | ||||||
| Total Gross Receipts (if Different) | 0 | 0 | 0 | 0 | 0 |
| Direct Expenses | |||||
| Labor / Payroll | |||||
| Rental Equipment | |||||
| Store/Retail inventory | |||||
| Utilities | |||||
| Repair and Maintenance | |||||
| Other (Specify) | |||||
| Other (Specify) | |||||
| Total Direct Expenses | 0 | 0 | 0 | 0 | 0 |
| Administrative and General (A&G) Management Expenses | |||||
| Labor / Payroll | |||||
| Management Fee / Overhead | |||||
| Marketing & Advertisement | |||||
| Other (Specify) | |||||
| Other (Specify) | |||||
| Other (Specify) | |||||
| Total A&G Expenses | 0 | 0 | 0 | 0 | 0 |
| Fixed Expenses | |||||
| Insurance | |||||
| Property Rental | |||||
| Other (Specify) | |||||
| Other (Specify) | |||||
| Total Fixed Expenses | 0 | 0 | 0 | 0 | 0 |
Total Operating Expenses 0 0 0 0 0
Earnings Before ITDA (Gross Receipts less Total Operating Expenses)* 0 0 0 0 0
| Concession Fee* | |||||
| Concession fee as % of Gross Receipts | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| EBITDA after Concession Fee | 0 | 0 | 0 | 0 | 0 |
| Interest Expense | |||||
| Depreciation | |||||
| Amortization | |||||
| Net Profit Before Taxes | 0 | 0 | 0 | 0 | 0 |
Estimated Income Tax
Net Income 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. |
| Earnings Before ITDA |
| Earnings Before interest, taxes, depreciation, amortization, and concession fee. |
| 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 Proposer | 0 |
OPRD Opportunity Number 9200
| Revenue |
| See "Operating Assumptions Form" Tab |
| Direct Expenses | |
| Labor / Payroll | Describe |
| Rental Equipment | Describe |
| Store/Retail inventory | Describe |
| Utilities | Describe |
| Repair and Maintenance | Describe |
| Other (Specify | Describe |
| Other (Specify | Describe |
| Administratvie and General (A&G) Management Expenses | |
| Labor / Payroll | Describe |
| Management Fee / Overhead | Describe |
| Marketing & Advertisement | Describe |
| Other (Specify) | Describe |
| Other (Specify) | Describe |
| Other (Specify) | Describe |
| Fixed Expenses | |
| Insurance | Describe |
| Property Rental | Describe |
| Other (Specify) | Describe |
| Other (Specify) | 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. |
| 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 Opportunity Number 9200
Year 1 Year 2 Year 3
| Revenue Inflation | Additional Description |
| Expense Inflation |
| Rental Equipment Sales | *Specify Type | Additional Description | ||
| Type (1) Rentals | ||||
| Average Rent Collected per Type(1) | ||||
| Type (2) Rentals | ||||
| Average Rent Collected per Type(2) | ||||
| Type (2) Rentals | ||||
| Average Rent Collected per Type(2) | ||||
| Other Rentals | ||||
| Average Rent Collected per Other Rental | ||||
| Total Revenue | 0 | 0 | 0 |
| Retail Sales | Additional Description | |||
| Transactions | ||||
| Average Revenue Per Transaction | ||||
| Total Revenue | 0 | 0 | 0 |
| Other Service Sales #1 | Additional Description | |||
| Number of Customers | ||||
| Average Revenue Per Customer | ||||
| Total Revenue | 0 | 0 | 0 |
| Other Service Sales #2 | Additional Description | |||
| Number of Customers | ||||
| Average Revenue Per Customer | ||||
| Total Revenue | 0 | 0 | 0 |
| Staffing | Number of Staff (1.0) or part time staff (.4) by Department | Wage or Salary by Staff Member | Additional Description | ||
| Administrative | |||||
| Rentals | |||||
| Retail | |||||
| Other | |||||
| Total Staff | 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 Proposer | 0 |
| OPRD Opportunity Number | 9200 |
| Prospective Cash Flow Statement |
| Operating Activities | Year Zero | Year 1 | Year 2 | Year 3 | Note: These operating activities should come from the "Income Statement Form" tab. |
| EBITDA After Concession Fee | See "Income Statement Form" tab for reference to this line | ||||
| Interest Expense | |||||
| Depreciation | |||||
| Amortization | |||||
| Estimated Income Tax | |||||
| Changes in Working Capital | Working Capital is cash made available for day-to-day operations | ||||
| Other (describe) |
Net Cash Provided (Used) by Operating Activities 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
| 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 Supplies | |
| Start-Up Expenses | |
| Working Capital | |
| Other (describe) | |
| Other (describe) | |
| Other (describe) |
Net Cash Provided (Used) by Investing Activities 0 0 0 0
Total Cash Flow 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 "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.
6) EBITDA means earnings before interest, taxes, depreciation, amortization, and concession fee.
Cash Flow Statement Assumptions
| CASH FLOW STATEMENT ASSUMPTIONS | |
| Grey Cells Are Input Cells | |
| Name of Proposer | 0 |
| OPRD Opportunity Number | 9200 |
| Investment Activities | |
| Personal Property Replacement | Describe - Personal property replacement during the Contract period. |
| 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 .