Attachment-E-NPS-Form-10-355B-Offeror-Financial-Projections-Revised (6).xlsx

NPS Form XLSX spreadsheet 664 KB Posted

Attached to
National Park Service Request for Proposals (RFP) for the Rock Creek Tennis Center in Washington, DC
Solicitation number
ROCR-002-2025
Issued by

About this file

This file is a comprehensive financial projection spreadsheet for a National Park Service lease opportunity for the Rock Creek Tennis Center in Washington, DC. The Excel document contains multiple interconnected worksheets including Initial Investments and Start-Up Expenses, Income Statement, Operating Assumptions, Cash Flow Statement, and Recapture of Investment forms. The financial templates are designed for potential offerors to detail their projected revenues, expenses, investments, and financial performance over a 10-year lease term (2026-2035), with specific sections for itemizing revenue streams, cost structures, capital expenditures, and investment recapture strategies. The forms require detailed assumptions and descriptions to support financial projections, with guidance notes emphasizing the offeror's responsibility for accuracy and comprehensive financial planning for the proposed lease of the Rock Creek Tennis Center property.

View the file

Who attaches NPS Form 10-355B

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

Investments Form

INITIAL INVESTMENTS AND START-UP EXPENSES FORM

Grey Cells Are Input Cells

Name of Offeror

Lease ID# L-ROCR002-2025

Assets
Existing Assets
Assets necessary to the operation of the property, 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 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 Lease.
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 Lease.
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 Lease.

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 Lease.
Definitions
Start-up Expenses
One-time expenses incurred prior to the beginning of the lease, 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 (07/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 12/31/2025&"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 12/31/2025

&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: 54 U.S. Code Chapter 1021—Privileges and Leases; 54 U.S. Code § 306121—Lease or exchange.

Purpose: The purposes of the system are (1) to assist NPS employees in managing the NPS Commercial Services program allowing commercial uses within a unit of the National Park System to ensure that business activities are conducted in a manner that complies with Federal laws and regulations; (2) to monitor resources that are or may be affected by the authorized commercial uses within a unit of the National Park System; (3) to track applicants and holders of commercial use authorizations who are planning to conduct or are conducting business within units of the National Park System; and (4) to provide to the public the description and contact information for businesses that provide services in national parks.

Routine Uses: In addition to those disclosures generally permitted under 5 U.S.C.552a(b) of the Privacy Act, records or information contained in this system may be disclosed outside DOI as a routine use pursuant to 5 U.S.C. 552a(b)(3) to other Federal, state and local governments, tribal organizations, and members of the general public upon request for names, addresses and phone numbers of Commercial Use Authorizations (CUA) holders conducting business within units of the National Park System for the purpose of informing the public of the availability of the services offered by the CUA holder. In addition, records or information contained in this system may be disclosed outside DOI based on an authorized routine use when the disclosure is compatible with the purpose for which the records were compiled as described under the system of records notice for this system.

Disclosure: Voluntary, however, failure to provide the requested information may impede our ability to 1) manage the National Park Service (NPS) Commercial Services Program allowing commercial uses within a unit of the NPS, 2) monitor resources that are or may be affected by the authorized commercial uses, and 3) provide the public the description and contact information for businesses that provide services in national parks.

PAPERWORK REDUCTION ACT STATEMENT
We collect this information under the authority of 54 U.S.C Chapter 1021. We use this information to evaluate a lease proposal. 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 25 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, 1201 Oakridge Drive, Fort Collins, CO 80550. 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# L-ROCR002-2025

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 PropertyDescribe
Inventory and SuppliesDescribe
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 PropertyDescribe
Inventory and SuppliesDescribe
Other (describe)Describe

Other

Start-Up ExpensesDescribe
Working CapitalDescribe
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# L-ROCR002-2025

Prospective Income Statement

2026 2027 2028 2029 2030 2031 2032 2033 2034 2035

Revenue
Lodging
Food and Beverage
Retail
Campground
Fuel
Authorized Services (Specify)
Other (Specify)
Other (Specify)
Other (Specify)
Other (Specify)
Total Gross Revenue0000000000
Total Deductions
Total Gross Receipts (if Different)0000000000
Cost of Goods Sold
Food and Beverage
Retail
Fuel
Authorized Services (Specify)
Other (Specify)
Other (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

Lodging
Labor
Other Departmental Expenses
Total Lodging Expenses0000000000
Food and Beverage
Labor
Other Departmental Expenses
Total Food and Beverage Expenses0000000000
Retail
Labor
Other Departmental Expenses
Total Retail Expenses0000000000
Fuel
Labor
Other Departmental Expenses
Total Fuel Expenses0000000000
Authorized Services (Specify)
Labor
Other Departmental Expenses
Total Authorized Services Expenses0000000000
Other (Specify)
Labor
Other Departmental Expenses
Total Other (Specify) Expenses0000000000
Other (Specify)
Labor
Other Departmental Expenses
Total Other (Specify) Expenses0000000000
Other (Specify)
Labor
Other Departmental Expenses
Total Other (Specify) Expenses0000000000
Other (Specify)
Labor
Other Departmental Expenses
Total Other (Specify) Expenses0000000000
Other Direct
Utilities
Repair and Maintenance Expense
Operating Supplies
Vehicle Expense
Other Direct
Total Other Direct0000000000

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 from franchise fee.
EBITDA Before FF
Earnings Before Interest, Taxes, Depreciation, Amortization, and Franchise Fee.
Franchise Fee
A percentage of gross receipts 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

Lease ID# L-ROCR002-2025

Revenue
See Operating Assumptions Tab
Cost of Sales
All Applicable Departments
Describe
Direct Expenses
LaborDescribe
UtilitiesDescribe
Repair and Maintenance ExpenseDescribe
Operating SuppliesDescribe
Vehicle ExpenseDescribe
Other DirectDescribe
Undistributed Expenses
Other SalariesDescribe
Office SuppliesDescribe
TelephoneDescribe
Management Fee / OverheadDescribe
AdvertisingDescribe
Other AdminDescribe
Other UndistributedDescribe
OtherDescribe
Fixed Expenses
InsuranceDescribe
Property TaxesDescribe
Property RentalDescribe
OtherDescribe
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# L-ROCR002-2025

2026 2027 2028 2029 2030 2031 2032 2033 2034 2035

Revenue InflationAdditional Description
Expense Inflation
Lodging
Number of Available RoomsAdditional Description
Day Open
Available Room Nights
Occupied Room Nights
Occupancy %
Average Daily Rate
Total Revenue0000000000
Food & Beverage
Total CoversAdditional Description
Average Check
Total Revenue0000000000
Retail
Total TransactionsAdditional Description
Average Revenue Per Transaction
Total Revenue0000000000
Retail- Genuine Authorized Native Handicrafts
Total TransactionsAdditional Description
Average Revenue Per Transaction
Total Revenue0000000000
Marina
Number of SlipsAdditional Description
Months Open
Available Slip Months
Occupancy Slip Months
Occupancy %
Average Monthly Rate
Total Revenue0000000000
Transportation
Number of CustomersAdditional Description
Average Revenue Per Customer
Total Revenue0000000000
Guided Tours
Number of CustomersAdditional Description
Average Revenue Per Customer
Total Revenue0000000000
Other (describe)
Number of CustomersAdditional Description
Average Revenue Per Customer
Total Revenue0000000000
Other (describe)
Number of CustomersAdditional Description
Average Revenue Per Customer
Total Revenue0000000000
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#L-ROCR002-2025
Prospective Cash Flow Statement
Operating ActivitiesYear Zero2026202720282029203020312032203320342035
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)
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 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#L-ROCR002-2025
Investment Activities
Repair and Maintenance ReserveDescribe - Repair and Maintenance Reserve expenditures during the Draft Lease
Personal Property ReplacementDescribe - 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# L-ROCR002-2025

Assets and Other

Real Property (not within the Park)
Personal Property
Inventory and Supplies
Working Capital
Other (describe)
Other (describe)
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# L-ROCR002-2025

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 PropertyDescribe
Inventory and SuppliesDescribe
Working CapitalDescribe
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 .