{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Notices","Investments Form","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"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":63,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Notices","index":0,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[[6,0,6,9],[7,0,7,9],[8,0,8,9],[9,0,9,9],[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,9],[4,0,4,9],[5,0,5,9]]}
["NOTICES"]
[]
["PRIVACY ACT"]
["Authority: The authority to collect information on the attached form is derived from 54 U.S.C. 1019, Concessions and Commercial Use Authorizations.\n\nPurpose: The purposes of the system are to assist NPS employees in managing the National Park Service 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 and to evaluate offerors who desire to conduct or are conducting business within units of the National Park System.\n\nRoutine 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 the National Park Service as a routine use pursuant to 5 U.S.C. 552a(b)(3) to other Federal, State, territorial, local, tribal, or foreign agencies and other authorized organizations and individuals 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 INTERIOR/NPS-15, Concessions Management Files 48 FR 51696 (November 10, 1983); Modification published 73 FR 63992 (October 28, 2008) and 86 FR 50156 (September 7, 2021). This notice can be found at https://www.doi.gov/privacy/sorn. \n\nDisclosure: Providing your information is voluntary, however, failure to provide the requested information may impede the evaluation of your proposal in response to available concession opportunities."]
[]
["PAPERWORK REDUCTION ACT STATEMENT"]
["We collect this information under the authority of Title IV of the National Parks Omnibus Management Act of 1998 (Pub. L. 105–391).  We use this information to evaluate a concession proposal.  Your response is required to obtain or retain a benefit.  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-0029."]
[]
["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":"Investments Form","index":1,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
["INITIAL INVESTMENTS AND START-UP EXPENSES FORM"]
[]
["Grey Cells Are Input Cells"]
[]
["Name of Offeror"]
[]
["CONCID","CC-LAKE017-26"]
[]
["Assets "]
["Existing Assets"]
["Assets necessary to the operation of the Concession, already owned by the Offeror, that will be allocated to the "]
["operation of the Draft Contract."]
[]
[null,"Leasehold Surrender Interest Value"]
[null,"Real Property (not within the Park)"]
[null,"Personal  Property"]
[null,"Inventory and Supplies"]
[null,"Other (describe)"]
[]
[null,null,"Subtotal",{"$f":"SUM(D14:D18)","v":0}]
[]
["Planned Asset Acquisition"]
["Assets necessary to Operate the Concession, that will be acquired by the Offeror if awarded the Draft Contract."]
[]
[null,"Leasehold Surrender Interest Value"]
[null,"Real Property (not within the Park)"]
[null,"Personal Property"]
[null,"Inventory and Supplies"]
[null,"Other (describe)"]
[]
[null,null,"Subtotal",{"$f":"SUM(D25:D29)","v":0}]
[]
[null,null,null,"Total",{"$f":"D20+D31","v":0}]
[]
["Other"]
[]
[null,"Start-Up Expenses"]
[null,"Working Capital"]
[null,"Other (describe)"]
[]
[null,null,null,"Total",{"$f":"SUM(D37:D39)","v":0}]
[]
[null,null,null,"Total Initial Investments and Start-up Expenses",{"$f":"+E41+E33","v":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 owened, 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. Exceptions include DM (Years 1-2) and CFIP investment (due no later than 12/31/2029)."]
[]
["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":"Investments Assumptions","index":2,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["INITIAL INVESTMENTS AND START-UP EXPENSES ASSUMPTIONS"]
[]
["Grey Cells Are Input Cells"]
[]
["Name of Offeror"]
[]
["CONCID","CC-LAKE017-26"]
[]
["Assets "]
["Existing Assets"]
["Assets necessary to the operation of the Concession already owned by the Offeror that will be allocated to the operation "]
["of the Draft Contract. "]
[]
["Possessory Interest/Leasehold Surrender Interest Value","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 Offeror if awarded the Draft Contract."]
[]
["Possessory Interest/Leasehold Surrender Interest Value","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. "]

{"sheet":"Income Statement Form","index":3,"n_rows":147,"n_cols":11,"rows_kept":147,"cut":false,"hidden":false,"merged":[]}
["INCOME STATEMENT FORM"]
["Grey Cells Are Input Cells"]
["Name of Offeror"]
["CONCID","CC-LAKE017-26"]
[]
["Prospective Income Statement"]
[]
[null,2026,{"$f":"B8+1","v":2027},2028,2029,2030,2031,2032,2033,2034,2035]
["Revenue"]
["Guided Raft Tours",0,0,0,0,0,0,0,0,0,0]
["Marina"]
["Moorage"]
["Boat Rental & Boat Repair"]
["Total Marina Revenue",{"$f":"+SUM(B12:B13)","v":0},{"$f":"+SUM(C12:C13)","v":0},{"$f":"+SUM(D12:D13)","v":0},{"$f":"+SUM(E12:E13)","v":0},{"$f":"+SUM(F12:F13)","v":0},{"$f":"+SUM(G12:G13)","v":0},{"$f":"+SUM(H12:H13)","v":0},{"$f":"+SUM(I12:I13)","v":0},{"$f":"+SUM(J12:J13)","v":0},{"$f":"+SUM(K12:K13)","v":0}]
["Food and Beverage",0,0,0,0,0,0,0,0,0,0]
["Retail "]
["General Merchandise"]
["Souvenirs and Gifts"]
["Other (Specify)"]
["Total Retail Revenue",{"$f":"SUM(B17:B19)","v":0},{"$f":"SUM(C17:C19)","v":0},{"$f":"SUM(D17:D19)","v":0},{"$f":"SUM(E17:E19)","v":0},{"$f":"SUM(F17:F19)","v":0},{"$f":"SUM(G17:G19)","v":0},{"$f":"SUM(H17:H19)","v":0},{"$f":"SUM(I17:I19)","v":0},{"$f":"SUM(J17:J19)","v":0},{"$f":"SUM(K17:K19)","v":0}]
["Campground",0,0,0,0,0,0,0,0,0,0]
["Fuel"]
["Land Sales"]
["Marina Sales"]
["Total Fuel Revenue",{"$f":"SUM(B23:B24)","v":0},{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"SUM(E23:E24)","v":0},{"$f":"SUM(F23:F24)","v":0},{"$f":"SUM(G23:G24)","v":0},{"$f":"SUM(H23:H24)","v":0},{"$f":"SUM(I23:I24)","v":0},{"$f":"SUM(J23:J24)","v":0},{"$f":"SUM(K23:K24)","v":0}]
["Houseboat Lodging (Floatels)",0,0,0,0,0,0,0,0,0,0]
["Other Revenue"]
["Other (Specify) "]
["Other (Specify) "]
["Other (Specify) "]
["Total Other Revenue",{"$f":"+SUM(B28:B30)","v":0},{"$f":"SUM(C28:C30)","v":0},0,0,0,0,0,0,0,0]
[]
["Total Gross Revenue",{"$f":"SUM(B14,B20,B15,B10,B21,B25,B26,B31)","v":0},{"$f":"SUM(C14,C20,C15,C10,C21,C25,C26,C31)","v":0},{"$f":"SUM(D14,D20,D15,D10,D21,D25,D26,D31)","v":0},{"$f":"SUM(E14,E20,E15,E10,E21,E25,E26,E31)","v":0},{"$f":"SUM(F14,F20,F15,F10,F21,F25,F26,F31)","v":0},{"$f":"SUM(G14,G20,G15,G10,G21,G25,G26,G31)","v":0},{"$f":"SUM(H14,H20,H15,H10,H21,H25,H26,H31)","v":0},{"$f":"SUM(I14,I20,I15,I10,I21,I25,I26,I31)","v":0},{"$f":"SUM(J14,J20,J15,J10,J21,J25,J26,J31)","v":0},{"$f":"SUM(K14,K20,K15,K10,K21,K25,K26,K31)","v":0}]
["Total Deductions"]
["Total Gross Receipts (if Different)",{"$f":"B33-B34","v":0},{"$f":"C33-C34","v":0},0,0,0,0,0,0,0,0]
[]
["Cost of Sales"]
["Marina"]
["Food and Beverage"]
["Retail "]
["Campground"]
["Fuel"]
["Houseboat Lodging (Floatels)"]
["Other"]
["Total Cost of Sales",{"$f":"SUM(B38:B44)","v":0},{"$f":"SUM(C38:C44)","v":0},{"$f":"SUM(D38:D44)","v":0},{"$f":"SUM(E38:E44)","v":0},{"$f":"SUM(F38:F44)","v":0},{"$f":"SUM(G38:G44)","v":0},{"$f":"SUM(H38:H44)","v":0},{"$f":"SUM(I38:I44)","v":0},{"$f":"SUM(J38:J44)","v":0},{"$f":"SUM(K38:K44)","v":0}]
[]
["Gross Profit",{"$f":"B33-B45","v":0},{"$f":"C33-C45","v":0},{"$f":"D33-D45","v":0},{"$f":"E33-E45","v":0},{"$f":"F33-F45","v":0},{"$f":"G33-G45","v":0},{"$f":"H33-H45","v":0},{"$f":"I33-I45","v":0},{"$f":"J33-J45","v":0},{"$f":"K33-K45","v":0}]
["Direct Expenses"]
["Guided Raft Tours"]
["Salaries and Wages"]
["Other Departmental Expenses"]
["Total Guided Raft Tours",{"$f":"+SUM(B50:B51)","v":0},{"$f":"+SUM(C50:C51)","v":0},{"$f":"+SUM(D50:D51)","v":0},{"$f":"+SUM(E50:E51)","v":0},{"$f":"+SUM(F50:F51)","v":0},{"$f":"+SUM(G50:G51)","v":0},{"$f":"+SUM(H50:H51)","v":0},{"$f":"+SUM(I50:I51)","v":0},{"$f":"+SUM(J50:J51)","v":0},{"$f":"+SUM(K50:K51)","v":0}]
[]
["Marina (including moorage, boat rental, boat repair, other)"]
["Salaries and Wages"]
["Other Departmental Expenses"]
["Total Marina Expenses",{"$f":"+SUM(B55:B56)","v":0},{"$f":"+SUM(C55:C56)","v":0},{"$f":"+SUM(D55:D56)","v":0},{"$f":"+SUM(E55:E56)","v":0},{"$f":"+SUM(F55:F56)","v":0},{"$f":"+SUM(G55:G56)","v":0},{"$f":"+SUM(H55:H56)","v":0},{"$f":"+SUM(I55:I56)","v":0},{"$f":"+SUM(J55:J56)","v":0},{"$f":"+SUM(K55:K56)","v":0}]
[]
["Food and Beverage"]
["Salaries and Wages"]
["Other Departmental Expenses"]
["Total Food and Beverage Expenses",{"$f":"+SUM(B60:B61)","v":0},{"$f":"+SUM(C60:C61)","v":0},{"$f":"+SUM(D60:D61)","v":0},{"$f":"+SUM(E60:E61)","v":0},{"$f":"+SUM(F60:F61)","v":0},{"$f":"+SUM(G60:G61)","v":0},{"$f":"+SUM(H60:H61)","v":0},{"$f":"+SUM(I60:I61)","v":0},{"$f":"+SUM(J60:J61)","v":0},{"$f":"+SUM(K60:K61)","v":0}]
[]
["Retail"]
["Salaries and Wages"]
["Other Departmental Expenses"]
["Total Retail Expenses",{"$f":"+SUM(B65:B66)","v":0},{"$f":"+SUM(C65:C66)","v":0},{"$f":"+SUM(D65:D66)","v":0},{"$f":"+SUM(E65:E66)","v":0},{"$f":"+SUM(F65:F66)","v":0},{"$f":"+SUM(G65:G66)","v":0},{"$f":"+SUM(H65:H66)","v":0},{"$f":"+SUM(I65:I66)","v":0},{"$f":"+SUM(J65:J66)","v":0},{"$f":"+SUM(K65:K66)","v":0}]
[]
["Campground"]
["Salaries and Wages"]
["Other Departmental Expenses"]
["Total Campground Expenses",{"$f":"+SUM(B70:B71)","v":0},{"$f":"+SUM(C70:C71)","v":0},{"$f":"+SUM(D70:D71)","v":0},{"$f":"+SUM(E70:E71)","v":0},{"$f":"+SUM(F70:F71)","v":0},{"$f":"+SUM(G70:G71)","v":0},{"$f":"+SUM(H70:H71)","v":0},{"$f":"+SUM(I70:I71)","v":0},{"$f":"+SUM(J70:J71)","v":0},{"$f":"+SUM(K70:K71)","v":0}]
[]
["Fuel"]
["Salaries and Wages"]
["Other Departmental Expenses"]
["Total Fuel Expenses",{"$f":"+SUM(B75:B76)","v":0},{"$f":"+SUM(C75:C76)","v":0},{"$f":"+SUM(D75:D76)","v":0},{"$f":"+SUM(E75:E76)","v":0},{"$f":"+SUM(F75:F76)","v":0},{"$f":"+SUM(G75:G76)","v":0},{"$f":"+SUM(H75:H76)","v":0},{"$f":"+SUM(I75:I76)","v":0},{"$f":"+SUM(J75:J76)","v":0},{"$f":"+SUM(K75:K76)","v":0}]
[]
["Houseboat Lodging (Floatels)"]
["Salaries and Wages"]
["Other Departmental Expenses"]
["Total Other Expenses",{"$f":"+SUM(B80:B81)","v":0},{"$f":"+SUM(C80:C81)","v":0},{"$f":"+SUM(D80:D81)","v":0},{"$f":"+SUM(E80:E81)","v":0},{"$f":"+SUM(F80:F81)","v":0},{"$f":"+SUM(G80:G81)","v":0},{"$f":"+SUM(H80:H81)","v":0},{"$f":"+SUM(I80:I81)","v":0},{"$f":"+SUM(J80:J81)","v":0},{"$f":"+SUM(K80:K81)","v":0}]
[]
["Other Direct Expenses"]
[]
[]
["Total Other Direct Expenses",{"$f":"+SUM(B85:B86)","v":0},{"$f":"+SUM(C85:C86)","v":0},{"$f":"+SUM(D85:D86)","v":0},{"$f":"+SUM(E85:E86)","v":0},{"$f":"+SUM(F85:F86)","v":0},{"$f":"+SUM(G85:G86)","v":0},{"$f":"+SUM(H85:H86)","v":0},{"$f":"+SUM(I85:I86)","v":0},{"$f":"+SUM(J85:J86)","v":0},{"$f":"+SUM(K85:K86)","v":0}]
[]
["Total Direct Expenses",{"$f":"SUM(B52,B57,B62,B67,B72,B77,B82,B87)","v":0},{"$f":"SUM(C52,C57,C62,C67,C72,C77,C82,C87)","v":0},0,0,0,0,0,0,0,0]
[]
["Undistributed Expenses"]
["A&G"]
["Telecommunications (Telephone/Internet, etc)"]
["Marketing"]
["Repair and Maintenance Expense"]
["Utilities"]
["Management / Overhead"]
["Other Undistributed"]
[]
["Total Undistributed Expenses",{"$f":"SUM(B92:B98)","v":0},{"$f":"SUM(C92:C98)","v":0},{"$f":"SUM(D92:D98)","v":0},{"$f":"SUM(E92:E98)","v":0},{"$f":"SUM(F92:F98)","v":0},{"$f":"SUM(G92:G98)","v":0},{"$f":"SUM(H92:H98)","v":0},{"$f":"SUM(I92:I98)","v":0},{"$f":"SUM(J92:J98)","v":0},{"$f":"SUM(K92:K98)","v":0}]
[]
["Fixed Expenses"]
["Rent"]
["Property Taxes"]
["Insurance"]
["Call Center Allocation"]
[]
["Total Fixed Expenses",{"$f":"SUM(B103:B106)","v":0},{"$f":"SUM(C103:C106)","v":0},0,0,0,0,0,0,0,0]
[]
["Total Operating Expenses",{"$f":"B108+B100+B89+B45","v":0},{"$f":"C108+C100+C89+C45","v":0},{"$f":"D108+D100+D89+D45","v":0},{"$f":"E108+E100+E89+E45","v":0},{"$f":"F108+F100+F89+F45","v":0},{"$f":"G108+G100+G89+G45","v":0},{"$f":"H108+H100+H89+H45","v":0},{"$f":"I108+I100+I89+I45","v":0},{"$f":"J108+J100+J89+J45","v":0},{"$f":"K108+K100+K89+K45","v":0}]
[]
["EBITDA Before FF",{"$f":"B33-B110","v":0},{"$f":"C33-C110","v":0},{"$f":"D33-D110","v":0},{"$f":"E33-E110","v":0},{"$f":"F33-F110","v":0},{"$f":"G33-G110","v":0},{"$f":"H33-H110","v":0},{"$f":"I33-I110","v":0},{"$f":"J33-J110","v":0},{"$f":"K33-K110","v":0}]
[]
["Franchise Fee"]
[]
["EBITDA",{"$f":"B112-B114","v":0},{"$f":"C112-C114","v":0},0,0,0,0,0,0,0,0]
[]
["Interest Expense"]
["Depreciation"]
["Amortization"]
[]
["Net Profit Before Taxes",{"$f":"B116-SUM(B118:B120)","v":0},{"$f":"C116-SUM(C118:C120)","v":0},0,0,0,0,0,0,0,{"$f":"K116-SUM(K118:K120)","v":0}]
[]
["Income Tax"]
[]
["Net Income",{"$f":"B122-B124","v":0},{"$f":"C122-C124","v":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."]
[]
["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 contract 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":"Income Statement Assumptions","index":4,"n_rows":54,"n_cols":2,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["INCOME STATEMENT ASSUMPTIONS"]
[]
["Grey Cells Are Input Cells"]
[]
["Name of Offeror"]
[]
["CONCID","CC-LAKE017-26"]
[]
["Revenue"]
["See Operating Assumptions Tab"]
[]
["Cost of Sales (Provide for Each Department)"]
["All Applicable Departments\n","Describe"]
[]
["Direct Expenses (Provide for Each Department)"]
["Labor - Salaries & Wages","Describe"]
["Payroll Taxes & Benefits ","Describe"]
["Other Departmental Expenses","Describe"]
["Undistributed Expenses"]
["A&G","Describe"]
["Telecommunications (Phone/Internet, etc.)","Describe"]
["Marketing","Describe"]
["Management Fee / Overhead","Describe"]
["Repair and Maintenance Expense","Describe"]
["Utilities","Describe"]
["Other Undistributed","Describe"]
["Fixed Expenses"]
["Rent","Describe"]
["Property Taxes","Describe"]
["Insurance","Describe"]
["Call Center Allocation","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."]

{"sheet":"Operating Assumptions Form","index":5,"n_rows":117,"n_cols":13,"rows_kept":117,"cut":false,"hidden":false,"merged":[[74,12,75,12],[81,12,86,12],[95,12,96,12],[34,12,35,12],[25,12,30,12],[69,12,70,12],[100,12,101,12],[59,12,64,12],[10,12,11,12],[47,12,48,12],[90,12,91,12],[52,12,53,12],[14,12,15,12],[19,12,20,12],[41,12,42,12]]}
["OPERATING ASSUMPTIONS"]
[]
["Grey Cells Are Input Cells"]
[]
["Name of Offeror"]
[]
["CONCID","CC-LAKE017-26"]
[]
[null,2026,{"$f":"B9+1","v":2027},2028,2029,2030,{"$f":"F9+1","v":2031},2032,2033,2034,2035]
[]
["Revenue Inflation",null,{"$f":"'Income Statement Form'!C35/'Income Statement Form'!B35-1","v":{"$error":"#DIV/0!"}},{"$f":"'Income Statement Form'!D35/'Income Statement Form'!C35-1","v":{"$error":"#DIV/0!"}},{"$f":"'Income Statement Form'!E35/'Income Statement Form'!D35-1","v":{"$error":"#DIV/0!"}},{"$f":"'Income Statement Form'!F35/'Income Statement Form'!E35-1","v":{"$error":"#DIV/0!"}},{"$f":"'Income Statement Form'!G35/'Income Statement Form'!F35-1","v":{"$error":"#DIV/0!"}},{"$f":"'Income Statement Form'!H35/'Income Statement Form'!G35-1","v":{"$error":"#DIV/0!"}},{"$f":"'Income Statement Form'!I35/'Income Statement Form'!H35-1","v":{"$error":"#DIV/0!"}},{"$f":"'Income Statement Form'!J35/'Income Statement Form'!I35-1","v":{"$error":"#DIV/0!"}},{"$f":"'Income Statement Form'!K35/'Income Statement Form'!J35-1","v":{"$error":"#DIV/0!"}},null,"Additional Description"]
["Expense Inflation",null,{"$f":"'Income Statement Form'!C110/'Income Statement Form'!B110-1","v":{"$error":"#DIV/0!"}},{"$f":"'Income Statement Form'!D110/'Income Statement Form'!C110-1","v":{"$error":"#DIV/0!"}},{"$f":"'Income Statement Form'!E110/'Income Statement Form'!D110-1","v":{"$error":"#DIV/0!"}},{"$f":"'Income Statement Form'!F110/'Income Statement Form'!E110-1","v":{"$error":"#DIV/0!"}},{"$f":"'Income Statement Form'!G110/'Income Statement Form'!F110-1","v":{"$error":"#DIV/0!"}},{"$f":"'Income Statement Form'!H110/'Income Statement Form'!G110-1","v":{"$error":"#DIV/0!"}},{"$f":"'Income Statement Form'!I110/'Income Statement Form'!H110-1","v":{"$error":"#DIV/0!"}},{"$f":"'Income Statement Form'!J110/'Income Statement Form'!I110-1","v":{"$error":"#DIV/0!"}},{"$f":"'Income Statement Form'!K110/'Income Statement Form'!J110-1","v":{"$error":"#DIV/0!"}}]
[]
["Guided Raft Tours"]
["Number of Customers",null,null,null,null,null,null,null,null,null,null,null,"Additional Description"]
["Average Revenue per Customer"]
["Total Guided Raft Tours Revenue",{"$f":"+B15*B16","v":0},{"$f":"+C15*C16","v":0},0,0,0,0,0,0,0,0]
[]
["Watercarft Launch Permits"]
["Number of Customers",null,null,null,null,null,null,null,null,null,null,null,"Additional Description"]
["Average Revenue per Customer"]
["Total Watercraft Launch Permit Revenue",{"$f":"+B20*B21","v":0},{"$f":"+C20*C21","v":0},{"$f":"+D20*D21","v":0},{"$f":"+E20*E21","v":0},{"$f":"+F20*F21","v":0},{"$f":"+G20*G21","v":0},{"$f":"+H20*H21","v":0},{"$f":"+I20*I21","v":0},{"$f":"+J20*J21","v":0},{"$f":"+K20*K21","v":0}]
[]
["Marina"]
["Moorage"]
["Number of Slips",null,null,null,null,null,null,null,null,null,null,null,"Additional Description"]
["Months Open"]
["Available Slip Months"]
["Total Annual Number of Slips Occupied"]
["Occupancy %",{"$f":"+B28/B29","v":{"$error":"#DIV/0!"}},{"$f":"+C28/C29","v":{"$error":"#DIV/0!"}},{"$f":"+D28/D29","v":{"$error":"#DIV/0!"}},{"$f":"+E28/E29","v":{"$error":"#DIV/0!"}},{"$f":"+F28/F29","v":{"$error":"#DIV/0!"}},{"$f":"+G28/G29","v":{"$error":"#DIV/0!"}},{"$f":"+H28/H29","v":{"$error":"#DIV/0!"}},{"$f":"+I28/I29","v":{"$error":"#DIV/0!"}},{"$f":"+J28/J29","v":{"$error":"#DIV/0!"}},{"$f":"+K28/K29","v":{"$error":"#DIV/0!"}}]
["Average Annual Revenue per Occupied Slip"]
["Moorage Revenue",{"$f":"+B29*B31","v":0},{"$f":"+C29*C31","v":0},{"$f":"+D29*D31","v":0},{"$f":"+E29*E31","v":0},{"$f":"+F29*F31","v":0},{"$f":"+G29*G31","v":0},{"$f":"+H29*H31","v":0},{"$f":"+I29*I31","v":0},{"$f":"+J29*J31","v":0},{"$f":"+K29*K31","v":0}]
[]
["Boat Rental & Boat Repair"]
["Total Transactions",null,null,null,null,null,null,null,null,null,null,null,"Additional Description"]
["Average Revenue per Transaction"]
["Boat Rental & Boat Repair Revenue",{"$f":"B35*B36","v":0},{"$f":"C35*C36","v":0},0,0,0,0,0,0,0,0]
[]
["Total Marina Revenue",{"$f":"+B32+B37","v":0},{"$f":"+C32+C37","v":0},0,0,0,0,0,0,0,0]
[]
["Food and Beverage"]
["Total Transactions",null,null,null,null,null,null,null,null,null,null,null,"Additional Description"]
["Average Check"]
["Total Food and Beverage Revenue",{"$f":"+B42*B43","v":0},{"$f":"+C42*C43","v":0},{"$f":"+D42*D43","v":0},{"$f":"+E42*E43","v":0},{"$f":"+F42*F43","v":0},{"$f":"+G42*G43","v":0},{"$f":"+H42*H43","v":0},{"$f":"+I42*I43","v":0},{"$f":"+J42*J43","v":0},{"$f":"+K42*K43","v":0}]
[]
["Retail"]
["General Merchandise"]
["Total Transactions",null,null,null,null,null,null,null,null,null,null,null,"Additional Description"]
["Average Revenue per Transaction"]
["General Merchandise Revenue",{"$f":"B48*B49","v":0},{"$f":"C48*C49","v":0},0,0,0,0,0,0,0,0]
[]
["Souvenirs and Gifts"]
["Total Transactions",null,null,null,null,null,null,null,null,null,null,null,"Additional Description"]
["Average Revenue per Transaction"]
["Souvenirs and Gifts Revenue",{"$f":"B53*B54","v":0},{"$f":"C53*C54","v":0},0,0,0,0,0,0,0,0]
[]
["Total Retail Revenue",{"$f":"+B50+B55","v":0},{"$f":"+C50+C55","v":0},0,0,0,0,0,0,0,0]
[]
["Camping"]
["Number of Available Sites (RV & Tent)",null,null,null,null,null,null,null,null,null,null,null,"Additional Description"]
["Days Open per Season"]
["Available Site Nights"]
["Occupied Site Nights"]
["Occupancy %"]
["Average Daily Rate"]
["Total Camping Revenue",{"$f":"B65*B63","v":0},{"$f":"C65*C63","v":0},0,0,0,0,0,0,0,{"$f":"K65*K63","v":0}]
[]
["Fuel"]
["Land Based Fuel"]
["Number of Gallons Sold",null,null,null,null,null,null,null,null,null,null,null,"Additional Description"]
["Average Price per Gallon"]
["Land Based Fuel Revenue",{"$f":"B70*B71","v":0},{"$f":"C70*C71","v":0},0,0,0,0,0,0,0,0]
[]
["Marina Based Fuel"]
["Number of Gallons Sold",null,null,null,null,null,null,null,null,null,null,null,"Additional Description"]
["Average Price per Gallon"]
["Marina Based Fuel Revenue",{"$f":"B75*B76","v":0},{"$f":"C75*C76","v":0},0,0,0,0,0,0,0,0]
[]
["Total Fuel Revenue",{"$f":"+B72+B77","v":0},{"$f":"+C72+C77","v":0},0,0,0,0,0,0,0,0]
[]
["Houseboat Lodging (Floatels)"]
["Number of Available Rooms",null,null,null,null,null,null,null,null,null,null,null,"Additional Description"]
["Days Open"]
["Available Room Nights"]
["Occupied Room Nights"]
["Occupancy %"]
["Average Daily Rate"]
["Total Houseboat Lodging Revenue",{"$f":"B87*B85","v":0},{"$f":"C87*C85","v":0},0,0,0,0,0,0,0,{"$f":"K87*K85","v":0}]
[]
["Misc. Revenue (Camping Cancellation Fees)"]
["Camping Cancellation Fee Percent of Revenue",null,null,null,null,null,null,null,null,null,null,null,"Additional Description"]
["Camping Revenue"]
["Total Misc. Revenue (Camping Cancellation Fees)",{"$f":"B91*B92","v":0},{"$f":"C91*C92","v":0},0,0,0,0,0,0,0,0]
[]
["Misc. Revenue (Vending)"]
["Vending Revenue per Transaction",null,null,null,null,null,null,null,null,null,null,null,"Additional Description"]
["Estimated Transactions"]
["Total Misc. Revenue (Vending)",{"$f":"B96*B97","v":0},{"$f":"C96*C97","v":0},0,0,0,0,0,0,0,0]
[]
["Other (describe)"]
["Number of Customers",null,null,null,null,null,null,null,null,null,null,null,"Additional Description"]
["Average Revenue per Customer"]
["Other Revenue",{"$f":"B101*B102","v":0},{"$f":"C101*C102","v":0},0,0,0,0,0,0,0,0]
[]
["Notes"]
["1) Please note that revenue projections must be based on rates determined by the approval methods set forth in the draft Operating Plan. "]
[]
["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 authorized services, please clearly identify which service(s) you will offer and use additional rows to describe your revenue buildup for each authorized 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 Contract."]

{"sheet":"Cash Flow Statement Form","index":6,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["CASH FLOW STATEMENT FORM"]
[]
["Grey Cells Are Input Cells"]
[]
["Name of Offeror"]
[]
["CONCID","CC-LAKE017-26"]
[]
["Prospective Cash Flow Statement"]
[]
["Operating Activities","Year Zero",2026,{"$f":"+C11+1","v":2027},{"$f":"D11+1","v":2028},2029,2030,2031,2032,2033,2034,2035]
["Net Income"]
["Depreciation"]
["Amortization"]
["Change in Working Capital"]
["Other (describe)"]
[]
["Net Cash Provided (Used) by Operating Activities",null,{"$f":"+C12+C13+C14+C15+C16","v":0},{"$f":"+D12+D13+D14+D15+D16","v":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",{"$f":"SUM(B21:B24)","v":0},{"$f":"SUM(C21:C24)","v":0},{"$f":"SUM(D21:D24)","v":0},{"$f":"SUM(E21:E24)","v":0},0,0,0,0,0,0,0]
[]
["Investment Activities"]
["Leasehold Surrender Interest"]
["Component Renewal Reserve"]
["Personal Property Replacement"]
["Real Property (not Within Park)"]
["Inventory and Supplies"]
["Start-Up Expenses"]
["Working Capital"]
["Other (describe)"]
["Other (describe)"]
[]
["Net Cash Provided (Used) by Investing Activities",{"$f":"SUM(B29:B37)","v":0},{"$f":"SUM(C29:C37)","v":0},{"$f":"SUM(D29:D37)","v":0},{"$f":"SUM(E29:E37)","v":0},{"$f":"SUM(F29:F37)","v":0},{"$f":"SUM(G29:G37)","v":0},{"$f":"SUM(H29:H37)","v":0},{"$f":"SUM(I29:I37)","v":0},{"$f":"SUM(J29:J37)","v":0},{"$f":"SUM(K29:K37)","v":0},{"$f":"SUM(L29:L37)","v":0}]
[]
["Total Cash Flow",{"$f":"B18+B26+B39","v":0},{"$f":"C18+C26+C39","v":0},{"$f":"D18+D26+D39","v":0},{"$f":"E18+E26+E39","v":0},{"$f":"F18+F26+F39","v":0},{"$f":"G18+G26+G39","v":0},{"$f":"H18+H26+H39","v":0},{"$f":"I18+I26+I39","v":0},{"$f":"J18+J26+J39","v":0},{"$f":"K18+K26+K39","v":0},{"$f":"L18+L26+L39","v":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. "]
[]
["6) Since Repair and Maintenance Reserve (component renewal) activities are considered capital expenditures they should be included on the cash flow statement."]

{"sheet":"Cash Flow Statement Assumptions","index":7,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["CASH FLOW STATEMENT ASSUMPTIONS"]
[]
["Grey Cells Are Input Cells"]
[]
["Name of Offeror"]
[]
["CONCID","CC-LAKE017-26"]
[]
["Investment Activities"]
["Leasehold Surrender Interest","Describe - LSI occurring during the Draft Contract"]
["Component Renewal Reserve","Describe - Component Renewal Reserve expenditures during the Draft Contract"]
["Personal Property Replacement","Describe - Personal property replacement during the Draft Contract "]
["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":" Recapture of Investment Form","index":8,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["RECAPTURE OF INVESTMENT FORM"]
[]
["Grey Cells Are Input Cells"]
[]
["Name of Offeror"]
[]
["CONCID","CC-LAKE017-26"]
[]
["Assets and Other"]
[]
[null,"Leasehold Surrender Interest Value"]
[null,"Real Property (not within the Park)"]
[null,"Personal  Property"]
[null,"Inventory and Supplies"]
[null,"Working Capital"]
[null,"Other (describe)"]
[null,"Other (describe)"]
[]
[null,"Total of Recapture of Investments at the End of the Contract Term",null,{"$f":"SUM(D11:D17)","v":0}]
[]
["Notes"]
["1) The value of ending LSI is only a best guess estimate neither offeror nor the NPS is bound by the number presented above."]
[]
["2) Reference the Draft Contract and exhibits for guidance on Leasehold Surrender Interest and Personal Property."]
[]
["3) Formulas included in this form are provided by the NPS as guidance only. The Offeror is responsible for its financial "]
["projections and their accuracy."]
[]
["4) Yellow cells represent categories that need to be explained on the \"Recapture of Investment Assumptions\" worksheet."]
[]
["5) All Offerors must include their estimate of the ending value of all property and other assets at the end of the Draft Contract."]
[]
["6) Recapture amounts entered into this form should not be included in the proforma income statement. "]
[]
["7) 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":"Recapture of Inv Assumptions","index":9,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["RECAPTURE OF INVESTMENT ASSUMPTIONS"]
[]
["Grey Cells Are Input Cells"]
[]
["Name of Offeror"]
[]
["CONCID","CC-LAKE017-26"]
[]
["Assets and Other"]
["Please describe the method used to determine the values of the planned recoup of investments at the end of the "]
["Draft Contract."]
[]
["Leasehold Surrender Interest Value","Describe"]
["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. "]