Form 10-355B Offeror Financial Projections.xlsx

XLSX spreadsheet 662 KB Posted Oct 14, 2022

Attached to: Request for Proposals to Lease a Multi-use Facility at Fort Monroe National Monument
Solicitation number: 20221007_FOMR_RFP
Issued by: Department of the Interior National Park Service National Office

View the file

Other files

File	Type	Posted
Sample Lease for Multi Use Facility at Fort Monroe.pdf	PDF	Oct 14, 2022
Request For Proposals multi use facility at Fort Monroe .pdf	PDF	Oct 14, 2022
Form 10-355A Offeror Financial Statements and Projections (Small Lease).docx	DOCX document	Oct 14, 2022
Attachment-D_Sample-Letter-of-Intent - Copy.pdf	PDF	Oct 7, 2022
Form 10-354 Identification and Credit Information (Corp LLC Part JV).docx	DOCX document	Oct 7, 2022
Form 10-353 Identification and Credit Information (Indiv SP).docx	DOCX document	Oct 7, 2022
Form 10-355 Financial Information for Revenue Producing Uses.docx	DOCX document	Oct 7, 2022
Form 10-352 Identification and Credit Information (Individual).docx	DOCX document	Oct 7, 2022
Attachment-C_Transmittal-Letter - Copy.pdf	PDF	Oct 7, 2022

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Investments Form

INITIAL INVESTMENTS AND START-UP EXPENSES FORM

Grey Cells Are Input Cells

Name of Offeror

Lease ID#

Assets

Existing Assets

Assets necessary to the operation of the Lease, already owned by the Offeror, that will be allocated to the

operation of the Draft Lease.

Real Property (not within the Park)

Personal Property

Inventory and Supplies

Other (describe)

Subtotal 0

Planned Asset Acquisition

Assets necessary to Operate the Leased Property, that will be acquired by the Offeror if awarded the Draft Lease.

Real Property (not within the Park)

Personal Property

Inventory and Supplies

Other (describe)

Subtotal 0

Total 0

Other

Start-Up Expenses

Working Capital

Other (describe)

Total 0

Total Initial Investments and Start-up Expenses 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 "Investments Assumptions" worksheet.

3) All Offerors must include their estimate of the value of all property intended, whether planned for acquisition or currently

owned, for use in the Draft Contract.

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 Draft Contract.

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 Draft Contract.

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 Draft Contract.

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.

Working Capital

Additional funds for working capital current assets such as pre-paid expenses, contingencies, and other necessary cash flow

requirements. This should not be confused with Net Working Capital (current assets-current liabilities).

&"Times New Roman,Regular"&8NPS Form 10-359B (12/2020) National Park Service &G &"Times New Roman,Bold"

&"Arial,Bold"OFFEROR FINANCIAL PROJECTIONS &"Times New Roman,Regular"&8OMB Control No. 1024-0233 Expiration Date ##/##/####&"Arial,Regular"&10 &G

&"Times New Roman,Regular"&8NPS Form 10-355B (Rev. 07/2020) National Park Service &"Times New Roman,Regular"&8OMB Control No. 1024-0233 Expiration Date 10/31/2024

&8RECORDS RETENTION. TEMPORARY. Destroy/Delete 3 years after closure. (NPS Records Schedule, Commercial Visitor Services, (Item 5D) (N1-79-08-4))

Notices

NOTICES

PRIVACY ACT

Authority: Title 54, National Park Service and Related Programs; and the National Environmental Policy Act of 1969.

Purpose: The purpose of the system is to assist, monitor, track and issue leases to individuals and businesses for National Park Service structures and land for activities that are not subject to authorization through a concession contract, commercial use authorization, or similar instrument in federally owned or administered property located within the boundaries of park areas. A leased property must be used for an activity and in a manner that is consistent with the purposes established by law for the park and be compatible with the programs of the National Park Service.

Routine Uses: Records or information contained in this system is not disclosed outside of the Department of the Interior except for those disclosures generally permitted under 5 U.S.C. 552a(b) of the Privacy Act; or other authorized routine use when the disclosure is compatible with the purpose for which the records were compiled.

Disclosure: Voluntary, however, failure to provide the requested information may impede our ability to issue a lease contract to the individual or organization.

PAPERWORK REDUCTION ACT STATEMENT

We collect this information under the authority of 54 U.S.C. 102101 et seq., 54 U.S.C. 306121, and 36 CFR part 18. We use this information to evaluate proposals received in response to leasing opportunities. Your response is required to obtain or retain a benefit. We may not collect or sponsor and you are not required to respond to a collection of information unless it displays a currently valid OMB control number. OMB has approved this collection of information and assigned Control No. 1024-0233.

ESTIMATED BURDEN STATEMENT

We estimate that it will take you 10 hours to complete a standard Request for Proposal, including 2 hours to complete this form, including time to review instructions, gather and maintain data, and complete and review the form. You may send comments on the burden estimate or any aspect of this form to the Information Collection Clearance Officer, National Park Service, 12201 Sunrise Valley Drive, Mail Stop 242, Reston, VA 20192. Please do not send your completed form to this address.

&"Times New Roman,Regular"&8NPS Form 10-359A (Rev. 08/2016) National Park Service &"Times New Roman,Regular"&8OMB Control No. 1024-0029 Expiration Date ##/##/####

Investments Assumptions

INITIAL INVESTMENTS AND START-UP EXPENSES ASSUMPTIONS

Grey Cells Are Input Cells

Name of Offeror

Lease ID#

Assets

Existing Assets

Assets necessary to the operation of the Lease property already owned by the Offeror that will be allocated to the operation

of the Draft Lease.

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 Lease Property that will be acquired by the Offeror if awarded the Draft Lease.

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.

&"Times New Roman,Italic"CC-&KFF0000XXXX000-XX &"Times New Roman,Italic" PROPOSAL PACKAGE FORMS &"Times New Roman,Italic"APPENDIX &KFF0000X

Income Statement Form

INCOME STATEMENT FORM

Grey Cells Are Input Cells

Name of Offeror

Lease ID#

Prospective Income Statement

2016 2017 2018 2019 2020 2021 2022 2023 2024 2025

Revenue

Lodging

Food and Beverage

Retail

Campground

Fuel

Authorized Services (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 Goods Sold

Food and Beverage

Retail

Fuel

Authorized Services (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

Lodging
Labor
Other Departmental Expenses
Total Lodging Expenses	0	0	0	0	0	0	0	0	0	0

Food and Beverage
Labor
Other Departmental Expenses
Total Food and Beverage Expenses	0	0	0	0	0	0	0	0	0	0

Retail
Labor
Other Departmental Expenses
Total Retail Expenses	0	0	0	0	0	0	0	0	0	0

Fuel
Labor
Other Departmental Expenses
Total Fuel 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 (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
Vehicle 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 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 “authorized” under the lease are to be itemized and included in

your prospective statements. Please clearly identify, by service type, all revenues associated with authorized services.

4) The NPS views the treatment of Repair and Maintenance Reserve (component renewal) items as leasehold improvements. It is expected that the cost will be amortized over the shorter of

the useful life of the asset or the Lease term.

Definitions

Gross Receipts

Gross Revenues less any revenues that are exempt in accordance with the Draft Lease.

EBITDA

Earnings Before Interest, Taxes, Depreciation, Amortization.

&"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

Lease ID#

Revenue

See Operating Assumptions Tab

Cost of Sales
All Applicable Departments
Describe
Direct Expenses
Labor	Describe
Utilities	Describe
Repair and Maintenance Expense	Describe
Operating Supplies	Describe
Vehicle 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 Lease.

&"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

Lease ID#

2016 2017 2018 2019 2020 2021 2022 2023 2024 2025

Revenue Inflation	Additional Description
Expense Inflation

Lodging
Number of Available Rooms											Additional Description
Day Open
Available Room Nights
Occupied Room Nights
Occupancy %
Average Daily Rate
Total Revenue	0	0	0	0	0	0	0	0	0	0

Food & Beverage
Total Covers											Additional Description
Average Check
Total Revenue	0	0	0	0	0	0	0	0	0	0

Retail
Total Transactions											Additional Description
Average Revenue Per Transaction
Total Revenue	0	0	0	0	0	0	0	0	0	0

Retail- Genuine Authorized Native Handicrafts
Total Transactions											Additional Description
Average Revenue Per Transaction
Total Revenue	0	0	0	0	0	0	0	0	0	0

Marina
Number of Slips											Additional Description
Months Open
Available Slip Months
Occupancy Slip Months
Occupancy %
Average Monthly Rate
Total Revenue	0	0	0	0	0	0	0	0	0	0

Transportation
Number of Customers											Additional Description
Average Revenue Per Customer
Total Revenue	0	0	0	0	0	0	0	0	0	0

Guided Tours
Number of Customers											Additional Description
Average Revenue Per Customer
Total Revenue	0	0	0	0	0	0	0	0	0	0

Other (describe)
Number of Customers											Additional Description
Average Revenue Per Customer
Total Revenue	0	0	0	0	0	0	0	0	0	0

Other (describe)
Number of Customers											Additional Description
Average Revenue Per Customer
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 additional authorized services under this is Lease, please clearly identify which service(s) you will offer and use additional rows to describe your revenue buildup for each 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 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 Lease.

&"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

Lease ID#

Prospective Cash Flow Statement

Operating Activities	Year Zero	2015	2016	2017	2018	2019	2020	2021	2022	2023	2024
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

Repair and Maintenance Reserve

Personal Property Replacement

Real Property (not Within Park)

Inventory and Supplies

Start-Up Expenses

Working Capital

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 Lease 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 Lease 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.

6) Since Repair and Maintenance Reserve activities are considered capital expenditures they should be included on the cash flow statement.

&"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

Lease ID#
Investment Activities
Repair and Maintenance Reserve	Describe - Repair and Maintenance Reserve expenditures during the Draft Lease
Personal Property Replacement	Describe - Personal property replacement during the Draft Lease
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

Recapture of Investment Form

RECAPTURE OF INVESTMENT FORM

Grey Cells Are Input Cells

Name of Offeror

Lease ID#

Assets and Other

Real Property (not within the Park)

Personal Property

Inventory and Supplies

Working Capital

Other (describe)

Total of Recaptue of Investments at the End of the Lease Term 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 "Recapture of Investment Assumptions" worksheet.

3) All Offerors must include their estimate of the ending value of all property and other assets at the end of the Draft Lease.

4) Recapture amounts entered into this form should not be included in the proforma income statement.

5) Recapture amounts entered in this form should be included in the cash flow proforma as capital recapture in the final year

of the Draft Contract.

&"Times New Roman,Italic"CC-&KFF0000XXXX000-XX &"Times New Roman,Italic" PROPOSAL PACKAGE FORMS &"Times New Roman,Italic"APPENDIX &KFF0000X&K000000

Recapture of Inv Assumptions

RECAPTURE OF INVESTMENT ASSUMPTIONS

Grey Cells Are Input Cells

Name of Offeror

Lease ID#

Assets and Other

Please describe the method used to determine the values of the planned recoup of investments at the end of the

Draft Lease.

Real Property (not within the Park)	Describe
Personal Property	Describe
Inventory and Supplies	Describe
Working Capital	Describe
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 image1.jpeg image2.jpeg

File details come from the government source that posted it. Updated Oct 8, 2023.