15 GLBA0TV Excel Forms for Proposal Package PSF4.xlsx
XLSX spreadsheet 46 KB Posted
- Attached to
- Business Opportunity for Tour Vessel and Related Services within Glacier Bay National Park and Preserve
- Solicitation number
- CC-GLBA0TV-24
About this file
This document package includes financial templates and instructions for a concession contract opportunity within Glacier Bay National Park and Preserve. The templates are for an income statement, cash flow statement, and operating assumptions, to be completed by the offeror as part of their proposal. Instructions provide guidance on completing the templates, including defining revenue and expense categories and requiring explanations of assumptions. The opportunity is to provide tour vessel and related services, with the contract to be awarded under solicitation number CC-GLBA0TV-24. Proposers must use the templates to project financial performance over the 10-year contract term.
View the file
Other files
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
Income Statement Form
INCOME STATEMENT FORM
Grey Cells Are Input Cells
Name of Offeror
CONCID GLBA0TV-24
Prospective Income Statement
2024 2025 2026 2027 2028 2029 2030 2031 2032 2033
| Revenue |
| Tour Vessel Services |
| Authorized Services (Specify) |
| Other (Specify) |
| Other (Specify) |
| 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 |
| Tour Vessel Services |
| Authorized Services (Specify) |
| Other (Specify) |
| Other (Specify) |
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 | ||||||||||
| Tour Vessel Services | ||||||||||
| Labor | ||||||||||
| Interpretive Labor Expenses | ||||||||||
| Other Departmental Expenses | ||||||||||
| Total Tour Vessel Services Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Authorized Services (Specify) | ||||||||||
| Labor | ||||||||||
| Other Departmental Expenses | ||||||||||
| Total Authorized Services 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 | ||||||||||
| Operating Supplies | ||||||||||
| Boat/Vehicle Expense | ||||||||||
| Fuel Expense | ||||||||||
| Other Direct | ||||||||||
| 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 |
| Other Salaries |
| Office Supplies |
| Telephone |
| Management / Overhead |
| Advertising |
| Other Admin |
| Other Undistributed |
Total Undistributed Expenses 0 0 0 0 0 0 0 0 0 0
| Fixed Expenses |
| Insurance |
| Property Taxes |
| Property Rental |
| Other (Specify) |
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
Franchise Fee
| EBITDA | 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 the NPS as guidance only. The Offeror 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 revenues that are exempt from franchise fee. |
| EBITDA FF |
| Earnings Before Interest, Taxes, Depreciation, Amortization, and Franchise Fee. |
| Franchise Fees |
| The per passenger fee due to the National Park Service. |
&"Times New Roman,Italic"CC-&KFF0000XXXX000-XX &"Times New Roman,Italic" PROPOSAL PACKAGE FORMS &"Times New Roman,Italic"APPENDIX &KFF0000X
Income Statement Assumptions
| INCOME STATEMENT ASSUMPTIONS | |
| Grey Cells Are Input Cells | |
| Name of Offeror | 0 |
CONCID GLBA0TV-24
| Revenue |
| See Operating Assumptions Tab |
| Cost of Sales |
| All Applicable Departments |
| Describe |
| Direct Expenses | |
| Labor | Describe |
| Interpretive Labor | Describe whether you will provide your own interpretive program or use the NPS Interpretive Program |
| Utilities | Describe utilities not including fuel |
| Repair and Maintenance Expense | Describe |
| Operating Supplies | Describe |
| Boat/Vehicle Expense | Describe if boats will be leased or owned and total expenses |
| Fuel Expense | Describe |
| Other Direct | Describe |
| Undistributed Expenses | |
| Other Salaries | Describe |
| Office Supplies | Describe |
| Telephone | Describe |
| Management Fee / Overhead | Describe |
| Advertising | Describe |
| Other Admin | Describe |
| Other Undistributed | Describe |
| Other | Describe |
| Fixed Expenses | |
| Insurance | Describe |
| Property Taxes | Describe |
| Property Rental | Describe |
| Other | 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 authorized services, please clearly identify which service(s) you will offer and use |
| additional separate rows for each authorized service department. Labor costs should be supported by a |
| footnote identifying Full Time Equivalents (FTE) occupied for each operating department identified. |
| 3) Clearly describe the composition of each item classified under Undistributed and Fixed Expenses. If the |
| expense item is allocated from or shared with a parent or related entity, please describe the allocation |
| method. In particular, if you intend to assess a Management Fee, or other form of corporate overhead and |
| profit, you must clearly describe what this fee is comprised of (Officer salaries, human resources, |
| accounting, marketing, profit, etc.). |
| 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 to 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 Draft Contract. |
&"Times New Roman,Italic"CC-&KFF0000XXXX000-XX &"Times New Roman,Italic" PROPOSAL PACKAGE FORMS &"Times New Roman,Italic"APPENDIX &KFF0000X
Operating Assumptions Form
OPERATING ASSUMPTIONS
Grey Cells Are Input Cells
Name of Offeror 0
CONCID GLBA0TV-24
2024 2025 2026 2027 2028 2029 2030 2031 2032 2033
| Revenue Inflation | Additional Descriptions |
| Expense Inflation |
| Tour Vessel Services | |||||||||||
| Number of Trips | Additional Descriptions | ||||||||||
| Number of Tour Vessel Entries | |||||||||||
| Average Tour Vessel Entries per Trip | |||||||||||
| Average Length of Trip | |||||||||||
| Total Number of Passengers | |||||||||||
| Passengers per Trip | |||||||||||
| Average Price per Passenger | |||||||||||
| Total Revenue | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Off-Vessel Activities | |||||||||||
| Number of off-vessel activities per trip | Additional Descriptions | ||||||||||
| Number of passengers partaking in off-vessel activities | |||||||||||
| Additional price per passenger for off-vessel activities, if applicable | |||||||||||
| Total Revenue | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Interpretive Program | |||||||||||
| Cost per Tour Vesel Entry for NPS Interpretive Program | Additional Descriptions | ||||||||||
| Concessioner interpreters used per trip | |||||||||||
| Cost per Tour Vessel Entry for Concessioner-provided interpretive program | |||||||||||
| Total Interpretive Guide Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Other (describe) | |||||||||||
| Number of Passengers | Additional Descriptions | ||||||||||
| Average Revenue Per Passenger | |||||||||||
| Total Revenue | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Other (describe) | |||||||||||
| Number of Passengers | Additional Descriptions | ||||||||||
| Average Revenue Per Passenger | |||||||||||
| Total Revenue | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Notes |
| 1) 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. |
| 2) If you are going to offer authorized services, please clearly identify which service(s) you will offer and use additional rows to describe your revenue buildup for each authorized service. |
| Examples |
| 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 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 Draft Contract. |
&"Times New Roman,Italic"CC-&KFF0000XXXX000-XX &"Times New Roman,Italic"PROPOSAL PACKAGE FORMS &"Times New Roman,Italic"APPENDIX &KFF0000X
Cash Flow Statement Form
| CASH FLOW STATEMENT FORM | |
| Grey Cells Are Input Cells | |
| Name of Offeror | 0 |
CONCID GLBA0TV-24
Prospective Cash Flow Statement
| Operating Activities | Year Zero | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 |
| Net Income | |||||||||||
| Depreciation | |||||||||||
| Amortization | |||||||||||
| Change in working capital | |||||||||||
| 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 (incl. Boat) |
| 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Total Cash Flow - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
| Notes |
| 1) Formulas included in this form are provided by the NPS as guidance only. The Offeror 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 Draft 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 Draft Contract should be reflective of estimates |
| provide 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. |
&"Times New Roman,Italic"CC-&KFF0000XXXX000-XX &"Times New Roman,Italic" PROPOSAL PACKAGE FORMS &"Times New Roman,Italic"APPENDIX &KFF0000X
Cash Flow Statement Assumptions
| CASH FLOW STATEMENT ASSUMPTIONS | |
| Grey Cells Are Input Cells | |
| Name of Offeror | 0 |
| CONCID | GLBA0TV-24 |
| Prospective Cash Flow Statement Assumptions |
| Real Property (not within park) | Describe - Real Property not within the park that is used for the Draft Contract |
| Personal Property | Describe - Personal Property expenditures during the Draft Contract, including expenditures for tour boat if purchased |
| Other (describe) | Describe |
| Other (describe) | 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. |
&"Times New Roman,Italic"CC-&KFF0000XXXX000-XX &"Times New Roman,Italic" PROPOSAL PACKAGE FORMS &"Times New Roman,Italic"APPENDIX &KFF0000X
File details come from the government source that posted it. Updated .