Form 10-355B Offeror Financial Projections - COMPLEX

National Park Service Leasing Program -- 36 CFR 18

Form 10-355B Offeror Financial Projections.xlsx

Offeror Financial Projections - COMPLEX

OMB: 1024-0233

Document [xlsx]
Download: xlsx | pdf

Overview

Investments Form
Notices
Investments Assumptions
Income Statement Form
Income Statement Assumptions
Operating Assumptions Form
Cash Flow Statement Form
Cash Flow Statement Assumptions
Recapture of Investment Form
Recapture of Inv Assumptions


Sheet 1: 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.









Possessory Interest/Leasehold Surrender Interest Value



Real Property (not within the Park)



Personal Property



Inventory and Supplies



Other (describe)









Subtotal 0





Planned Asset Acquisition



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









Possessory Interest/Leasehold Surrender Interest Value



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




Sheet 2: 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 Leasing program allowing for residential and 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 residential and/or commercial uses within a unit of the National Park System; (3) to track applicants and holders of leases 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 lease 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 lease 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) Leasing Program allowing for residential and/or commercial uses within a unit of the NPS, 2) monitor resources that are or may be affected by the authorized residential and/or 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 10 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.























































































































































Sheet 3: 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.

Sheet 4: 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)









Other (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 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 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 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.










Sheet 5: 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.

Sheet 6: 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.












Sheet 7: 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)














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.















Sheet 8: 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.

Sheet 9: 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)


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.



Sheet 10: 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.
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy