{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Summary","Assumptions","Monthly_Base","Annual_5Y"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Summary","index":0,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,7],[10,0,10,4],[16,0,16,5],[22,0,24,6],[2,0,2,7],[1,0,1,7]]}
["McKenzie River Luxury Inn - Pro Forma Summary"]
[]
["     Pricing updated to $1,995,000 – Improving investor returns and financing metrics."]
[]
[]
["Year 1 Base Revenue ($)",{"$f":"Annual_5Y!B10","v":344172.86225593742}]
["Year 1 Base NOI ($)",{"$f":"Annual_5Y!B25","v":150370.63184379996}]
["NOI Margin",{"$f":"Annual_5Y!B26","v":0.43690438246110114}]
["Modeled revenue streams","3 suites + flex room + log cabin + 3 RV sites + events"]
[]
["Scenario Summary (Year 1, unlevered)"]
["Scenario","Revenue ($)","OpEx ($)","NOI ($)","NOI Margin"]
["Low",{"$f":"365*Assumptions!$B$20*Assumptions!$C$20*Assumptions!$D$20+365*Assumptions!$B$21*Assumptions!$C$21*Assumptions!$D$21+365*Assumptions!$B$22*Assumptions!$C$22*Assumptions!$D$22+365*Assumptions!$B$23*Assumptions!$C$23*Assumptions!$D$23+Assumptions!$C$25","v":236042.5},{"$f":"B13*Assumptions!$C$30+(365*Assumptions!$B$20*Assumptions!$C$20*Assumptions!$D$20+365*Assumptions!$B$21*Assumptions!$C$21*Assumptions!$D$21+365*Assumptions!$B$22*Assumptions!$C$22*Assumptions!$D$22+365*Assumptions!$B$23*Assumptions!$C$23*Assumptions!$D$23)*Assumptions!$C$31+(365*Assumptions!$B$20*Assumptions!$C$20*Assumptions!$D$20+365*Assumptions!$B$21*Assumptions!$C$21*Assumptions!$D$21+365*Assumptions!$B$22*Assumptions!$C$22*Assumptions!$D$22+365*Assumptions!$B$23*Assumptions!$C$23*Assumptions!$D$23)*Assumptions!$C$32+Assumptions!$C$25*Assumptions!$C$33+B13*Assumptions!$C$34+SUM(Assumptions!$C$35:'Assumptions'!$C$40)","v":166096.15},{"$f":"B13-C13","v":69946.350000000006},{"$f":"D13/B13","v":0.29632947456496184}]
["Base",{"$f":"Annual_5Y!B10","v":344172.86225593742},{"$f":"Annual_5Y!B24","v":193802.23041213746},{"$f":"Annual_5Y!B25","v":150370.63184379996},{"$f":"Annual_5Y!B26","v":0.43690438246110114}]
["High",{"$f":"365*Assumptions!$B$20*Assumptions!$G$20*Assumptions!$H$20+365*Assumptions!$B$21*Assumptions!$G$21*Assumptions!$H$21+365*Assumptions!$B$22*Assumptions!$G$22*Assumptions!$H$22+365*Assumptions!$B$23*Assumptions!$G$23*Assumptions!$H$23+Assumptions!$G$25","v":437664.5},{"$f":"B15*Assumptions!$E$30+(365*Assumptions!$B$20*Assumptions!$G$20*Assumptions!$H$20+365*Assumptions!$B$21*Assumptions!$G$21*Assumptions!$H$21+365*Assumptions!$B$22*Assumptions!$G$22*Assumptions!$H$22+365*Assumptions!$B$23*Assumptions!$G$23*Assumptions!$H$23)*Assumptions!$E$31+(365*Assumptions!$B$20*Assumptions!$G$20*Assumptions!$H$20+365*Assumptions!$B$21*Assumptions!$G$21*Assumptions!$H$21+365*Assumptions!$B$22*Assumptions!$G$22*Assumptions!$H$22+365*Assumptions!$B$23*Assumptions!$G$23*Assumptions!$H$23)*Assumptions!$E$32+Assumptions!$G$25*Assumptions!$E$33+B15*Assumptions!$E$34+SUM(Assumptions!$E$35:'Assumptions'!$E$40)","v":213120.601},{"$f":"B15-C15","v":224543.899},{"$f":"D15/B15","v":0.51305029080494302}]
[]
["Base-Case 5-Year Revenue / NOI"]
["Metric","Year 1","Year 2","Year 3","Year 4","Year 5"]
["Total Revenue",{"$f":"Annual_5Y!B10","v":344172.86225593742},{"$f":"Annual_5Y!C10","v":356218.91243489523},{"$f":"Annual_5Y!D10","v":368686.57437011658},{"$f":"Annual_5Y!E10","v":381590.60447307059},{"$f":"Annual_5Y!F10","v":394946.27562962798}]
["Total OpEx",{"$f":"Annual_5Y!B24","v":193802.23041213746},{"$f":"Annual_5Y!C24","v":199895.30847656229},{"$f":"Annual_5Y!D24","v":206184.39427324195},{"$f":"Annual_5Y!E24","v":212675.91682280542},{"$f":"Annual_5Y!F24","v":219376.51938035357}]
["NOI",{"$f":"Annual_5Y!B25","v":150370.63184379996},{"$f":"Annual_5Y!C25","v":156323.60395833294},{"$f":"Annual_5Y!D25","v":162502.18009687462},{"$f":"Annual_5Y!E25","v":168914.68765026517},{"$f":"Annual_5Y!F25","v":175569.75624927442}]
[]
["Important: this model is a market-based estimate only. It does not use the seller's trailing financials, county tax records, actual insurance quotes, or a restaurant/bar operating budget. It is best used as a decision-support draft and should be refined with booking history, permit review, and a detailed event calendar."]

{"sheet":"Assumptions","index":1,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[50,0,50,6],[66,0,68,6],[0,0,0,6],[2,0,2,6],[17,0,17,9],[27,0,27,6],[43,0,43,5]]}
["McKenzie River Luxury Inn Pro Forma - Assumptions & Comparable Market Data"]
[]
["Comparable Market / Rate Set"]
["Comparable / Market Data","Area","Type","ADR / Nightly Rate ($)","Occupancy","Notes","Source URL"]
["Eagle Rock Lodge (visible room rates)","Vida","Luxury B&B",300,null,"Visible room rates on Eagle Rock pages run from $260 to $325, with most premium rooms at $325.","https://eaglerocklodge.com/"]
["McKenzie Orchards B&B","Springfield","Luxury B&B",225,null,"Luxury riverside B&B near Springfield; standard room rate shown at $225 incl. breakfast.","https://www.mkobb.com/rooms/mkobb_all_2.php"]
["McKenzie River House","McKenzie corridor","Vacation rental",300,null,"3BR/2BA river house listed at $300/night plus cleaning fee.","https://mckenzieriverhouse.com/"]
["McKenzie River Mountain Resort","Blue River","Lodge rooms",122.5,null,"Rebuild plan shows lodge rooms at $95-$150/night.","https://rivermountainresort.com/hotel/"]
["Belknap Hot Springs Lodge","McKenzie Bridge","Lodge rooms",177.5,null,"Belknap FAQ shows lodge rooms at $140-$215/night.","https://www.belknaphotsprings.com/faqs/"]
["Belknap Hot Springs RV","McKenzie Bridge","RV full hookups",50,null,"Belknap RV full hookups listed at $50/night.","https://www.belknaphotsprings.com/r-v-sites/"]
["Springfield STR market (AirROI)","Springfield","STR market",221,0.41499999999999998,"AirROI snippet: $221 ADR, 41.5% occupancy, peak June / lowest January.","https://www.airroi.com/report/world/united-states/oregon/springfield"]
["Walterville STR market (AirDNA)","Walterville","STR market",261,0.37,"AirDNA snippet: $261 ADR, 37% occupancy.","https://www.airdna.co/vacation-rental-data/app/us/oregon/walterville/overview"]
["Vida STR market (AirDNA)","Vida","STR market",287,0.44,"AirDNA snippet: $287 ADR, 44% occupancy.","https://www.airdna.co/vacation-rental-data/app/us/oregon/vida/overview"]
["Blue River STR market (AirDNA)","Blue River","STR market",252,0.48,"AirDNA snippet: $252 ADR, 48% occupancy.","https://www.airdna.co/vacation-rental-data/app/us/oregon/blue-river/overview"]
["Eugene STR market (AirROI)","Eugene","STR market",270,0.43,"AirROI snippet: $270 ADR, 43% occupancy.","https://www.airroi.com/report/world/united-states/oregon/eugene"]
[]
[]
["Subject Operating Assumptions (editable inputs in blue)"]
["Revenue Unit","Units","Low ADR ($)","Low Occ.","Base ADR ($)","Base Occ.","High ADR ($)","High Occ.","Notes","Source / Logic"]
["Luxury Suites",3,275,0.48,295,0.6,325,0.68,"Three primary rentable suites, positioned between McKenzie Orchards and Eagle Rock premium rooms.","Base ADR set slightly above Vida / Blue River STR ADRs and below premium Eagle Rock top rooms."]
["Flex Room (additional lodging)",1,165,0.28000000000000003,185,0.4,205,0.48,"Modeled as extra lodging / bunk / workshop space; lower ADR and occupancy than main suites.","Discounted to main suites because of flexible use and likely more variable demand."]
["1BR / 1.5BA Log Cabin",1,245,0.4,275,0.52,295,0.62,"Standalone luxury cabin in excellent condition; suitable for owner, caretaker or nightly rental.","Anchored to local vacation-rental rates ($250-$300+) and subject's riverfront positioning."]
["RV Full Hookup Sites",3,45,0.18,55,0.27,60,0.35,"Three RV spaces; modeled conservatively because winter season is slow in the corridor.","Belknap full-hookup comp is $50/night; subject modeled slightly above base in base/high cases."]
[]
["Event Revenue (annual)",null,30000,null,45000,null,70000,null,"Includes weddings, retreats, private dinners / workshops. Kitchen / café upside beyond this is not modeled.","Eagle Rock public event listing shows $5,000 wedding pricing; nearby venues span roughly $4k-$10k+."]
[]
[]
["Expense Assumptions (owner-operator, before debt service / depreciation / income tax)"]
["Expense Category","Basis","Low","Base","High","Format","Comment"]
["Payroll & Management","% of total revenue",0.21,0.2,0.19,"%","Owner-operator model with on-site oversight; fully absentee ownership would likely require a higher payroll load."]
["Cleaning / Linen / Guest Supplies","% of lodging + RV revenue",6.5000000000000002E-2,0.06,5.8000000000000003E-2,"%","Includes turnover cleaning, laundry, toiletries, breakfast basics and suite consumables."]
["Marketing / OTA / Merchant Fees","% of lodging + RV revenue",7.4999999999999997E-2,7.0000000000000007E-2,6.5000000000000002E-2,"%","Blended direct booking, OTA commissions and card fees."]
["Event Direct Costs","% of event revenue",0.17,0.15,0.14000000000000001,"%","Venue setup, cleanup, staffing, consumables; catering not fully modeled as a standalone P&L."]
["Reserve for Replacement","% of total revenue",0.03,0.03,2.5000000000000001E-2,"%","FF&E / capital reserve for hospitality property upkeep."]
["Utilities","Annual fixed ($)",18000,16000,15000,"$","Solar and infrastructure reduce utility burden versus a more typical multi-building property."]
["Repairs & Maintenance","Annual fixed ($)",13000,12000,11000,"$","Routine repairs only; major one-time capital items excluded from NOI."]
["Grounds / Jacuzzi / Garden Care","Annual fixed ($)",10000,9000,8500,"$","Reflects large riverfront grounds, Japanese garden, spa and outdoor guest areas."]
["Insurance","Annual fixed ($)",12000,11000,10000,"$","Estimate only; actual quote required."]
["Property Taxes","Annual fixed ($)",15000,14000,13000,"$","Placeholder estimate; verify with county tax records."]
["Admin / Software / Licenses","Annual fixed ($)",7500,7000,6500,"$","Reservation software, bookkeeping, permits and general admin."]
[]
[]
[]
["Multi-Year Growth Assumptions"]
["Metric","Low","Base","High","Format","Comment"]
["Annual revenue growth after Year 1",0.02,3.5000000000000003E-2,0.05,"%","Captures pricing power plus modest operating ramp."]
["Annual fixed expense inflation",2.5000000000000001E-2,2.5000000000000001E-2,0.03,"%","Inflation applied to fixed costs only; variable ratios remain constant."]
[]
[]
[]
["Base-case monthly seasonality (drawn from corridor seasonality: strong Jun-Sep, weak winter)"]
["Month","Days","Suites Occ. Factor","Flex Occ. Factor","Cabin Occ. Factor","RV Occ. Factor","ADR Factor","Event Weight"]
["Jan",31,0.57999999999999996,0.45,0.62,0.3,0.92,0]
["Feb",28,0.56999999999999995,0.48,0.6,0.35,0.92,0]
["Mar",31,0.61,0.55000000000000004,0.65,0.45,0.95,0.03]
["Apr",30,0.63,0.6,0.68,0.6,0.98,0.05]
["May",31,0.96,0.9,0.98,1,1.02,0.1]
["Jun",30,1.49,1.4,1.45,1.6,1.08,0.16]
["Jul",31,1.66,1.7,1.58,1.9,1.1200000000000001,0.16]
["Aug",31,1.6,1.6,1.55,1.85,1.1200000000000001,0.15]
["Sep",30,1.25,1.3,1.25,1.2,1.05,0.15]
["Oct",31,1.1499999999999999,1.1000000000000001,1.1000000000000001,0.7,1,0.1]
["Nov",30,0.79,0.7,0.74,0.4,0.95,0.05]
["Dec",31,0.56999999999999995,0.52,0.6,0.25,0.9,0.05]
["Average / sum check",null,{"$f":"AVERAGE(C53:C64)","v":0.98833333333333329},{"$f":"AVERAGE(D53:D64)","v":0.94166666666666654},{"$f":"AVERAGE(E53:E64)","v":0.98333333333333339},{"$f":"AVERAGE(F53:F64)","v":0.88333333333333319},{"$f":"AVERAGE(G53:G64)","v":1.0008333333333332},{"$f":"SUM(H53:H64)","v":1}]
[]
["Method note: this is a market-based operating model, not a historical reconstruction. It uses public room-rate comps, public STR ADR / occupancy snapshots from nearby markets, and a conservative event model. Debt service, depreciation, income tax and any restaurant / bar / guide-package upside are excluded."]

{"sheet":"Monthly_Base","index":2,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,17]]}
["Year 1 Monthly Base-Case Operating Statement"]
[]
["Month","Days","Suite Occ.","Suite ADR ($)","Suite Revenue ($)","Flex Revenue ($)","Cabin Revenue ($)","RV Revenue ($)","Event Revenue ($)","Total Revenue ($)","Payroll ($)","Cleaning / Guest ($)","Marketing / OTA ($)","Event Direct ($)","Reserve ($)","Fixed OpEx ($)","Total OpEx ($)","NOI ($)"]
["Jan",31,{"$f":"Assumptions!$F$20*Assumptions!$C$53/Assumptions!$C$65","v":0.3521079258010118},{"$f":"Assumptions!$E$20*Assumptions!$G$53/Assumptions!$G$65","v":271.17402164862619},{"$f":"Assumptions!$B$20*B4*C4*D4","v":8879.8745733249289},{"$f":"Assumptions!$B$21*B4*(Assumptions!$F$21*Assumptions!$D$53/Assumptions!$D$65)*(Assumptions!$E$21*Assumptions!$G$53/Assumptions!$G$65)","v":1007.7082077619688},{"$f":"Assumptions!$B$22*B4*(Assumptions!$F$22*Assumptions!$E$53/Assumptions!$E$65)*(Assumptions!$E$22*Assumptions!$G$53/Assumptions!$G$65)","v":2569.2994594899733},{"$f":"Assumptions!$B$23*B4*(Assumptions!$F$23*Assumptions!$F$53/Assumptions!$F$65)*(Assumptions!$E$23*Assumptions!$G$53/Assumptions!$G$65)","v":431.15368639341438},{"$f":"Assumptions!$E$25*Assumptions!$H$53","v":0},{"$f":"SUM(E4:I4)","v":12888.035926970286},{"$f":"J4*Assumptions!$D$30","v":2577.6071853940575},{"$f":"(E4+F4+G4+H4)*Assumptions!$D$31","v":773.28215561821708},{"$f":"(E4+F4+G4+H4)*Assumptions!$D$32","v":902.16251488792011},{"$f":"I4*Assumptions!$D$33","v":0},{"$f":"J4*Assumptions!$D$34","v":386.64107780910854},{"$f":"SUM(Assumptions!$D$35:'Assumptions'!$D$40)/12","v":5750},{"$f":"SUM(K4:P4)","v":10389.692933709302},{"$f":"J4-Q4","v":2498.3429932609833}]
["Feb",28,{"$f":"Assumptions!$F$20*Assumptions!$C$54/Assumptions!$C$65","v":0.34603709949409778},{"$f":"Assumptions!$E$20*Assumptions!$G$54/Assumptions!$G$65","v":271.17402164862619},{"$f":"Assumptions!$B$20*B5*C5*D5","v":7882.2468403929834},{"$f":"Assumptions!$B$21*B5*(Assumptions!$F$21*Assumptions!$D$54/Assumptions!$D$65)*(Assumptions!$E$21*Assumptions!$G$54/Assumptions!$G$65)","v":970.86726253196116},{"$f":"Assumptions!$B$22*B5*(Assumptions!$F$22*Assumptions!$E$54/Assumptions!$E$65)*(Assumptions!$E$22*Assumptions!$G$54/Assumptions!$G$65)","v":2245.7976544969592},{"$f":"Assumptions!$B$23*B5*(Assumptions!$F$23*Assumptions!$F$54/Assumptions!$F$65)*(Assumptions!$E$23*Assumptions!$G$54/Assumptions!$G$65)","v":454.33399211349047},{"$f":"Assumptions!$E$25*Assumptions!$H$54","v":0},11553.245749535394,{"$f":"J5*Assumptions!$D$30","v":2310.6491499070789},{"$f":"(E5+F5+G5+H5)*Assumptions!$D$31","v":693.19474497212354},{"$f":"(E5+F5+G5+H5)*Assumptions!$D$32","v":808.7272024674777},{"$f":"I5*Assumptions!$D$33","v":0},{"$f":"J5*Assumptions!$D$34","v":346.59737248606177},{"$f":"SUM(Assumptions!$D$35:'Assumptions'!$D$40)/12","v":5750},9909.1684698327408,1644.077279702653]
["Mar",31,{"$f":"Assumptions!$F$20*Assumptions!$C$55/Assumptions!$C$65","v":0.37032040472175382},{"$f":"Assumptions!$E$20*Assumptions!$G$55/Assumptions!$G$65","v":280.01665278934223},{"$f":"Assumptions!$B$20*B6*C6*D6","v":9643.7168576495442},{"$f":"Assumptions!$B$21*B6*(Assumptions!$F$21*Assumptions!$D$55/Assumptions!$D$65)*(Assumptions!$E$21*Assumptions!$G$55/Assumptions!$G$65)","v":1271.8056486850933},{"$f":"Assumptions!$B$22*B6*(Assumptions!$F$22*Assumptions!$E$55/Assumptions!$E$65)*(Assumptions!$E$22*Assumptions!$G$55/Assumptions!$G$65)","v":2781.455848939444},{"$f":"Assumptions!$B$23*B6*(Assumptions!$F$23*Assumptions!$F$55/Assumptions!$F$65)*(Assumptions!$E$23*Assumptions!$G$55/Assumptions!$G$65)","v":667.81956859849515},{"$f":"Assumptions!$E$25*Assumptions!$H$55","v":1350},15714.797923872577,{"$f":"J6*Assumptions!$D$30","v":3142.9595847745154},{"$f":"(E6+F6+G6+H6)*Assumptions!$D$31","v":861.88787543235458},{"$f":"(E6+F6+G6+H6)*Assumptions!$D$32","v":1005.5358546710804},{"$f":"I6*Assumptions!$D$33","v":202.5},{"$f":"J6*Assumptions!$D$34","v":471.44393771617729},{"$f":"SUM(Assumptions!$D$35:'Assumptions'!$D$40)/12","v":5750},11434.327252594128,4280.4706712784482]
["Apr",30,{"$f":"Assumptions!$F$20*Assumptions!$C$56/Assumptions!$C$65","v":0.38246205733558181},{"$f":"Assumptions!$E$20*Assumptions!$G$56/Assumptions!$G$65","v":288.85928393005833},{"$f":"Assumptions!$B$20*B7*C7*D7","v":9942.9944411135766},{"$f":"Assumptions!$B$21*B7*(Assumptions!$F$21*Assumptions!$D$56/Assumptions!$D$65)*(Assumptions!$E$21*Assumptions!$G$56/Assumptions!$G$65)","v":1385.0687848621726},{"$f":"Assumptions!$B$22*B7*(Assumptions!$F$22*Assumptions!$E$56/Assumptions!$E$65)*(Assumptions!$E$22*Assumptions!$G$56/Assumptions!$G$65)","v":2904.8904444036757},{"$f":"Assumptions!$B$23*B7*(Assumptions!$F$23*Assumptions!$F$56/Assumptions!$F$65)*(Assumptions!$E$23*Assumptions!$G$56/Assumptions!$G$65)","v":888.91433239595938},{"$f":"Assumptions!$E$25*Assumptions!$H$56","v":2250},17371.868002775387,{"$f":"J7*Assumptions!$D$30","v":3474.3736005550777},{"$f":"(E7+F7+G7+H7)*Assumptions!$D$31","v":907.31208016652306},{"$f":"(E7+F7+G7+H7)*Assumptions!$D$32","v":1058.530760194277},{"$f":"I7*Assumptions!$D$33","v":337.5},{"$f":"J7*Assumptions!$D$34","v":521.15604008326159},{"$f":"SUM(Assumptions!$D$35:'Assumptions'!$D$40)/12","v":5750},12048.87248099914,5322.9955217762472]
["May",31,{"$f":"Assumptions!$F$20*Assumptions!$C$57/Assumptions!$C$65","v":0.58279932546374369},{"$f":"Assumptions!$E$20*Assumptions!$G$57/Assumptions!$G$65","v":300.64945878434639},{"$f":"Assumptions!$B$20*B8*C8*D8","v":16295.302065591773},{"$f":"Assumptions!$B$21*B8*(Assumptions!$F$21*Assumptions!$D$57/Assumptions!$D$65)*(Assumptions!$E$21*Assumptions!$G$57/Assumptions!$G$65)","v":2234.4834172113219},{"$f":"Assumptions!$B$22*B8*(Assumptions!$F$22*Assumptions!$E$57/Assumptions!$E$65)*(Assumptions!$E$22*Assumptions!$G$57/Assumptions!$G$65)","v":4502.5801888256965},{"$f":"Assumptions!$B$23*B8*(Assumptions!$F$23*Assumptions!$F$57/Assumptions!$F$65)*(Assumptions!$E$23*Assumptions!$G$57/Assumptions!$G$65)","v":1593.3940584104446},{"$f":"Assumptions!$E$25*Assumptions!$H$57","v":4500},29125.759730039237,{"$f":"J8*Assumptions!$D$30","v":5825.151946007848},{"$f":"(E8+F8+G8+H8)*Assumptions!$D$31","v":1477.5455838023543},{"$f":"(E8+F8+G8+H8)*Assumptions!$D$32","v":1723.8031811027467},{"$f":"I8*Assumptions!$D$33","v":675},{"$f":"J8*Assumptions!$D$34","v":873.77279190117713},{"$f":"SUM(Assumptions!$D$35:'Assumptions'!$D$40)/12","v":5750},16325.273502814127,12800.48622722511]
["Jun",30,{"$f":"Assumptions!$F$20*Assumptions!$C$58/Assumptions!$C$65","v":0.9045531197301856},{"$f":"Assumptions!$E$20*Assumptions!$G$58/Assumptions!$G$65","v":318.33472106577858},{"$f":"Assumptions!$B$20*B9*C9*D9","v":25915.559855263957},{"$f":"Assumptions!$B$21*B9*(Assumptions!$F$21*Assumptions!$D$58/Assumptions!$D$65)*(Assumptions!$E$21*Assumptions!$G$58/Assumptions!$G$65)","v":3561.6054467884437},{"$f":"Assumptions!$B$22*B9*(Assumptions!$F$22*Assumptions!$E$58/Assumptions!$E$65)*(Assumptions!$E$22*Assumptions!$G$58/Assumptions!$G$65)","v":6826.3181811767026},{"$f":"Assumptions!$B$23*B9*(Assumptions!$F$23*Assumptions!$F$58/Assumptions!$F$65)*(Assumptions!$E$23*Assumptions!$G$58/Assumptions!$G$65)","v":2612.3196707146576},{"$f":"Assumptions!$E$25*Assumptions!$H$58","v":7200},46115.803153943758,{"$f":"J9*Assumptions!$D$30","v":9223.1606307887523},{"$f":"(E9+F9+G9+H9)*Assumptions!$D$31","v":2334.9481892366252},{"$f":"(E9+F9+G9+H9)*Assumptions!$D$32","v":2724.1062207760633},{"$f":"I9*Assumptions!$D$33","v":1080},{"$f":"J9*Assumptions!$D$34","v":1383.4740946183126},{"$f":"SUM(Assumptions!$D$35:'Assumptions'!$D$40)/12","v":5750},22495.689135419754,23620.114018524004]
["Jul",31,{"$f":"Assumptions!$F$20*Assumptions!$C$59/Assumptions!$C$65","v":1.0077571669477234},{"$f":"Assumptions!$E$20*Assumptions!$G$59/Assumptions!$G$65","v":330.12489592006665},{"$f":"Assumptions!$B$20*B10*C10*D10","v":30939.772876172614},{"$f":"Assumptions!$B$21*B10*(Assumptions!$F$21*Assumptions!$D$59/Assumptions!$D$65)*(Assumptions!$E$21*Assumptions!$G$59/Assumptions!$G$65)","v":4634.4841245864445},{"$f":"Assumptions!$B$22*B10*(Assumptions!$F$22*Assumptions!$E$59/Assumptions!$E$65)*(Assumptions!$E$22*Assumptions!$G$59/Assumptions!$G$65)","v":7970.954283859498},{"$f":"Assumptions!$B$23*B10*(Assumptions!$F$23*Assumptions!$F$59/Assumptions!$F$65)*(Assumptions!$E$23*Assumptions!$G$59/Assumptions!$G$65)","v":3324.257408134732},{"$f":"Assumptions!$E$25*Assumptions!$H$59","v":7200},54069.468692753289,{"$f":"J10*Assumptions!$D$30","v":10813.893738550658},{"$f":"(E10+F10+G10+H10)*Assumptions!$D$31","v":2812.1681215651975},{"$f":"(E10+F10+G10+H10)*Assumptions!$D$32","v":3280.8628084927304},{"$f":"I10*Assumptions!$D$33","v":1080},{"$f":"J10*Assumptions!$D$34","v":1622.0840607825987},{"$f":"SUM(Assumptions!$D$35:'Assumptions'!$D$40)/12","v":5750},25359.008729391186,28710.459963362104]
["Aug",31,{"$f":"Assumptions!$F$20*Assumptions!$C$60/Assumptions!$C$65","v":0.97133220910623952},{"$f":"Assumptions!$E$20*Assumptions!$G$60/Assumptions!$G$65","v":330.12489592006665},{"$f":"Assumptions!$B$20*B11*C11*D11","v":29821.467832455535},{"$f":"Assumptions!$B$21*B11*(Assumptions!$F$21*Assumptions!$D$60/Assumptions!$D$65)*(Assumptions!$E$21*Assumptions!$G$60/Assumptions!$G$65)","v":4361.8674113754778},{"$f":"Assumptions!$B$22*B11*(Assumptions!$F$22*Assumptions!$E$60/Assumptions!$E$65)*(Assumptions!$E$22*Assumptions!$G$60/Assumptions!$G$65)","v":7819.6070506216593},{"$f":"Assumptions!$B$23*B11*(Assumptions!$F$23*Assumptions!$F$60/Assumptions!$F$65)*(Assumptions!$E$23*Assumptions!$G$60/Assumptions!$G$65)","v":3236.7769500259237},{"$f":"Assumptions!$E$25*Assumptions!$H$60","v":6750},51989.719244478591,{"$f":"J11*Assumptions!$D$30","v":10397.943848895718},{"$f":"(E11+F11+G11+H11)*Assumptions!$D$31","v":2714.3831546687152},{"$f":"(E11+F11+G11+H11)*Assumptions!$D$32","v":3166.7803471135016},{"$f":"I11*Assumptions!$D$33","v":1012.5},{"$f":"J11*Assumptions!$D$34","v":1559.6915773343576},{"$f":"SUM(Assumptions!$D$35:'Assumptions'!$D$40)/12","v":5750},24601.298928012293,27388.420316466298]
["Sep",30,{"$f":"Assumptions!$F$20*Assumptions!$C$61/Assumptions!$C$65","v":0.75885328836424959},{"$f":"Assumptions!$E$20*Assumptions!$G$61/Assumptions!$G$65","v":309.49208992506249},{"$f":"Assumptions!$B$20*B12*C12*D12","v":21137.318114612193},{"$f":"Assumptions!$B$21*B12*(Assumptions!$F$21*Assumptions!$D$61/Assumptions!$D$65)*(Assumptions!$E$21*Assumptions!$G$61/Assumptions!$G$65)","v":3215.3382505729014},{"$f":"Assumptions!$B$22*B12*(Assumptions!$F$22*Assumptions!$E$61/Assumptions!$E$65)*(Assumptions!$E$22*Assumptions!$G$61/Assumptions!$G$65)","v":5721.2915790513562},{"$f":"Assumptions!$B$23*B12*(Assumptions!$F$23*Assumptions!$F$61/Assumptions!$F$65)*(Assumptions!$E$23*Assumptions!$G$61/Assumptions!$G$65)","v":1904.8164265627704},{"$f":"Assumptions!$E$25*Assumptions!$H$61","v":6750},38728.764370799225,{"$f":"J12*Assumptions!$D$30","v":7745.7528741598453},{"$f":"(E12+F12+G12+H12)*Assumptions!$D$31","v":1918.7258622479535},{"$f":"(E12+F12+G12+H12)*Assumptions!$D$32","v":2238.5135059559461},{"$f":"I12*Assumptions!$D$33","v":1012.5},{"$f":"J12*Assumptions!$D$34","v":1161.8629311239768},{"$f":"SUM(Assumptions!$D$35:'Assumptions'!$D$40)/12","v":5750},19827.355173487718,18901.409197311506]
["Oct",31,{"$f":"Assumptions!$F$20*Assumptions!$C$62/Assumptions!$C$65","v":0.69814502529510958},{"$f":"Assumptions!$E$20*Assumptions!$G$62/Assumptions!$G$65","v":294.75437135720233},{"$f":"Assumptions!$B$20*B13*C13*D13","v":19137.660718372688},{"$f":"Assumptions!$B$21*B13*(Assumptions!$F$21*Assumptions!$D$62/Assumptions!$D$65)*(Assumptions!$E$21*Assumptions!$G$62/Assumptions!$G$65)","v":2677.4855761791437},{"$f":"Assumptions!$B$22*B13*(Assumptions!$F$22*Assumptions!$E$62/Assumptions!$E$65)*(Assumptions!$E$22*Assumptions!$G$62/Assumptions!$G$65)","v":4954.8201357625721},{"$f":"Assumptions!$B$23*B13*(Assumptions!$F$23*Assumptions!$F$62/Assumptions!$F$65)*(Assumptions!$E$23*Assumptions!$G$62/Assumptions!$G$65)","v":1093.5057263601091},{"$f":"Assumptions!$E$25*Assumptions!$H$62","v":4500},32363.472156674514,{"$f":"J13*Assumptions!$D$30","v":6472.6944313349031},{"$f":"(E13+F13+G13+H13)*Assumptions!$D$31","v":1671.8083294004707},{"$f":"(E13+F13+G13+H13)*Assumptions!$D$32","v":1950.4430509672161},{"$f":"I13*Assumptions!$D$33","v":675},{"$f":"J13*Assumptions!$D$34","v":970.90416470023536},{"$f":"SUM(Assumptions!$D$35:'Assumptions'!$D$40)/12","v":5750},17490.849976402824,14872.62218027169]
["Nov",30,{"$f":"Assumptions!$F$20*Assumptions!$C$63/Assumptions!$C$65","v":0.47959527824620574},{"$f":"Assumptions!$E$20*Assumptions!$G$63/Assumptions!$G$65","v":280.01665278934223},{"$f":"Assumptions!$B$20*B14*C14*D14","v":12086.519805726819},{"$f":"Assumptions!$B$21*B14*(Assumptions!$F$21*Assumptions!$D$63/Assumptions!$D$65)*(Assumptions!$E$21*Assumptions!$G$63/Assumptions!$G$65)","v":1566.4468400226949},{"$f":"Assumptions!$B$22*B14*(Assumptions!$F$22*Assumptions!$E$63/Assumptions!$E$65)*(Assumptions!$E$22*Assumptions!$G$63/Assumptions!$G$65)","v":3064.4327467223648},{"$f":"Assumptions!$B$23*B14*(Assumptions!$F$23*Assumptions!$F$63/Assumptions!$F$65)*(Assumptions!$E$23*Assumptions!$G$63/Assumptions!$G$65)","v":574.46844610623248},{"$f":"Assumptions!$E$25*Assumptions!$H$63","v":2250},19541.86783857811,{"$f":"J14*Assumptions!$D$30","v":3908.3735677156219},{"$f":"(E14+F14+G14+H14)*Assumptions!$D$31","v":1037.5120703146865},{"$f":"(E14+F14+G14+H14)*Assumptions!$D$32","v":1210.4307487004678},{"$f":"I14*Assumptions!$D$33","v":337.5},{"$f":"J14*Assumptions!$D$34","v":586.25603515734326},{"$f":"SUM(Assumptions!$D$35:'Assumptions'!$D$40)/12","v":5750},12830.072421888119,6711.7954166899908]
["Dec",31,{"$f":"Assumptions!$F$20*Assumptions!$C$64/Assumptions!$C$65","v":0.34603709949409778},{"$f":"Assumptions!$E$20*Assumptions!$G$64/Assumptions!$G$65","v":265.27893422148213},{"$f":"Assumptions!$B$20*B15*C15*D15","v":8537.0608248045137},{"$f":"Assumptions!$B$21*B15*(Assumptions!$F$21*Assumptions!$D$64/Assumptions!$D$65)*(Assumptions!$E$21*Assumptions!$G$64/Assumptions!$G$65)","v":1139.1484087743993},{"$f":"Assumptions!$B$22*B15*(Assumptions!$F$22*Assumptions!$E$64/Assumptions!$E$65)*(Assumptions!$E$22*Assumptions!$G$64/Assumptions!$G$65)","v":2432.3662484652623},{"$f":"Assumptions!$B$23*B15*(Assumptions!$F$23*Assumptions!$F$64/Assumptions!$F$65)*(Assumptions!$E$23*Assumptions!$G$64/Assumptions!$G$65)","v":351.48398347289219},{"$f":"Assumptions!$E$25*Assumptions!$H$64","v":2250},14710.059465517068,{"$f":"J15*Assumptions!$D$30","v":2942.011893103414},{"$f":"(E15+F15+G15+H15)*Assumptions!$D$31","v":747.60356793102403},{"$f":"(E15+F15+G15+H15)*Assumptions!$D$32","v":872.2041625861948},{"$f":"I15*Assumptions!$D$33","v":337.5},{"$f":"J15*Assumptions!$D$34","v":441.30178396551202},{"$f":"SUM(Assumptions!$D$35:'Assumptions'!$D$40)/12","v":5750},11090.621407586146,3619.4380579309218]
["Year 1 Total",null,null,null,{"$f":"SUM(E4:E15)","v":200219.49480548114},28026.309379352024,53793.813821815158,17133.24424928912,45000,344172.86225593748,68834.572451187487,17950.371735356242,20942.100357915624,6750,10325.185867678121,69000,193802.23041213746,150370.63184379996]

{"sheet":"Annual_5Y","index":3,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Base-Case 5-Year Annual Pro Forma (Unlevered)"]
[]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
["Revenue"]
["Luxury Suites",{"$f":"Monthly_Base!E16","v":200219.49480548114},{"$f":"B5*(1+Assumptions!$C$46)","v":207227.17712367297},{"$f":"C5*(1+Assumptions!$C$46)","v":214480.1283230015},{"$f":"D5*(1+Assumptions!$C$46)","v":221986.93281430652},{"$f":"E5*(1+Assumptions!$C$46)","v":229756.47546280723}]
["Flex Room",{"$f":"Monthly_Base!F16","v":28026.309379352024},{"$f":"B6*(1+Assumptions!$C$46)","v":29007.230207629342},{"$f":"C6*(1+Assumptions!$C$46)","v":30022.483264896367},{"$f":"D6*(1+Assumptions!$C$46)","v":31073.270179167739},{"$f":"E6*(1+Assumptions!$C$46)","v":32160.834635438609}]
["Log Cabin",{"$f":"Monthly_Base!G16","v":53793.813821815158},{"$f":"B7*(1+Assumptions!$C$46)","v":55676.597305578682},{"$f":"C7*(1+Assumptions!$C$46)","v":57625.27821127393},{"$f":"D7*(1+Assumptions!$C$46)","v":59642.162948668512},{"$f":"E7*(1+Assumptions!$C$46)","v":61729.638651871908}]
["RV Sites",{"$f":"Monthly_Base!H16","v":17133.24424928912},{"$f":"B8*(1+Assumptions!$C$46)","v":17732.907798014239},{"$f":"C8*(1+Assumptions!$C$46)","v":18353.559570944737},{"$f":"D8*(1+Assumptions!$C$46)","v":18995.9341559278},{"$f":"E8*(1+Assumptions!$C$46)","v":19660.791851385271}]
["Events",{"$f":"Monthly_Base!I16","v":45000},{"$f":"B9*(1+Assumptions!$C$46)","v":46575},{"$f":"C9*(1+Assumptions!$C$46)","v":48205.124999999993},{"$f":"D9*(1+Assumptions!$C$46)","v":49892.304374999985},{"$f":"E9*(1+Assumptions!$C$46)","v":51638.535028124978}]
["Total Revenue",{"$f":"SUM(B5:B9)","v":344172.86225593742},{"$f":"SUM(C5:C9)","v":356218.91243489523},{"$f":"SUM(D5:D9)","v":368686.57437011658},{"$f":"SUM(E5:E9)","v":381590.60447307059},{"$f":"SUM(F5:F9)","v":394946.27562962798}]
[]
["Expenses"]
["Payroll & Management",{"$f":"B10*Assumptions!$D$30","v":68834.572451187487},{"$f":"C10*Assumptions!$D$30","v":71243.782486979049},{"$f":"D10*Assumptions!$D$30","v":73737.314874023315},{"$f":"E10*Assumptions!$D$30","v":76318.120894614127},{"$f":"F10*Assumptions!$D$30","v":78989.2551259256}]
["Cleaning / Guest",{"$f":"(B5+B6+B7+B8)*Assumptions!$D$31","v":17950.371735356246},{"$f":"(C5+C6+C7+C8)*Assumptions!$D$31","v":18578.634746093714},{"$f":"(D5+D6+D7+D8)*Assumptions!$D$31","v":19228.886962206994},{"$f":"(E5+E6+E7+E8)*Assumptions!$D$31","v":19901.898005884235},{"$f":"(F5+F6+F7+F8)*Assumptions!$D$31","v":20598.46443609018}]
["Marketing / OTA",{"$f":"(B5+B6+B7+B8)*Assumptions!$D$32","v":20942.10035791562},{"$f":"(C5+C6+C7+C8)*Assumptions!$D$32","v":21675.073870442669},{"$f":"(D5+D6+D7+D8)*Assumptions!$D$32","v":22433.701455908162},{"$f":"(E5+E6+E7+E8)*Assumptions!$D$32","v":23218.881006864944},{"$f":"(F5+F6+F7+F8)*Assumptions!$D$32","v":24031.541842105213}]
["Event Direct",{"$f":"B9*Assumptions!$D$33","v":6750},{"$f":"C9*Assumptions!$D$33","v":6986.25},{"$f":"D9*Assumptions!$D$33","v":7230.7687499999984},{"$f":"E9*Assumptions!$D$33","v":7483.8456562499978},{"$f":"F9*Assumptions!$D$33","v":7745.7802542187464}]
["Reserve",{"$f":"B10*Assumptions!$D$34","v":10325.185867678123},{"$f":"C10*Assumptions!$D$34","v":10686.567373046857},{"$f":"D10*Assumptions!$D$34","v":11060.597231103497},{"$f":"E10*Assumptions!$D$34","v":11447.718134192117},{"$f":"F10*Assumptions!$D$34","v":11848.388268888839}]
["Utilities",{"$f":"Assumptions!$D$35","v":16000},{"$f":"B18*(1+Assumptions!$C$47)","v":16400},{"$f":"C18*(1+Assumptions!$C$47)","v":16810},{"$f":"D18*(1+Assumptions!$C$47)","v":17230.25},{"$f":"E18*(1+Assumptions!$C$47)","v":17661.006249999999}]
["Repairs & Maintenance",{"$f":"Assumptions!$D$36","v":12000},{"$f":"B19*(1+Assumptions!$C$47)","v":12299.999999999998},{"$f":"C19*(1+Assumptions!$C$47)","v":12607.499999999996},{"$f":"D19*(1+Assumptions!$C$47)","v":12922.687499999995},{"$f":"E19*(1+Assumptions!$C$47)","v":13245.754687499993}]
["Grounds / Jacuzzi / Garden",{"$f":"Assumptions!$D$37","v":9000},{"$f":"B20*(1+Assumptions!$C$47)","v":9225},{"$f":"C20*(1+Assumptions!$C$47)","v":9455.625},{"$f":"D20*(1+Assumptions!$C$47)","v":9692.015625},{"$f":"E20*(1+Assumptions!$C$47)","v":9934.3160156249996}]
["Insurance",{"$f":"Assumptions!$D$38","v":11000},{"$f":"B21*(1+Assumptions!$C$47)","v":11274.999999999998},{"$f":"C21*(1+Assumptions!$C$47)","v":11556.874999999996},{"$f":"D21*(1+Assumptions!$C$47)","v":11845.796874999995},{"$f":"E21*(1+Assumptions!$C$47)","v":12141.941796874993}]
["Property Taxes",{"$f":"Assumptions!$D$39","v":14000},{"$f":"B22*(1+Assumptions!$C$47)","v":14349.999999999998},{"$f":"C22*(1+Assumptions!$C$47)","v":14708.749999999996},{"$f":"D22*(1+Assumptions!$C$47)","v":15076.468749999995},{"$f":"E22*(1+Assumptions!$C$47)","v":15453.380468749992}]
["Admin / Licenses",{"$f":"Assumptions!$D$40","v":7000},{"$f":"B23*(1+Assumptions!$C$47)","v":7174.9999999999991},{"$f":"C23*(1+Assumptions!$C$47)","v":7354.3749999999982},{"$f":"D23*(1+Assumptions!$C$47)","v":7538.2343749999973},{"$f":"E23*(1+Assumptions!$C$47)","v":7726.6902343749962}]
["Total OpEx",{"$f":"SUM(B13:B23)","v":193802.23041213746},{"$f":"SUM(C13:C23)","v":199895.30847656229},{"$f":"SUM(D13:D23)","v":206184.39427324195},{"$f":"SUM(E13:E23)","v":212675.91682280542},{"$f":"SUM(F13:F23)","v":219376.51938035357}]
["NOI",{"$f":"B10-B24","v":150370.63184379996},{"$f":"C10-C24","v":156323.60395833294},{"$f":"D10-D24","v":162502.18009687462},{"$f":"E10-E24","v":168914.68765026517},{"$f":"F10-F24","v":175569.75624927442}]
["NOI Margin",{"$f":"B25/B10","v":0.43690438246110114},{"$f":"C25/C10","v":0.43884139359642677},{"$f":"D25/D10","v":0.44075968964831941},{"$f":"E25/E10","v":0.442659451438841},{"$f":"F25/F10","v":0.44454085804298077}]