10-year cashflow model
Year-by-year operating model covering occupancy and ADR assumptions, expenses, NOI, debt service, cashflow, and DSCR trajectory.
Metadata
- Type
- Note
- Entity Type
- Standard
- Status
- Active
Links
Notes
Source Summary
Year,Occupancy %,ADR ($),Booked nights,Gross lodging revenue ($),Mgmt fee ($),Platform fee ($),Property tax ($),HOA ($),Insurance ($),Utilities ($),Maintenance reserve ($),Supplies/admin ($),Total operating expense ($),NOI (before debt) ($),Debt service (P&I) ($),Cash flow after debt ($),DSCR 1,0. 33,275.
Imported Context
Year,Occupancy %,ADR ($),Booked nights,Gross lodging revenue ($),Mgmt fee ($),Platform fee ($),Property tax ($),HOA ($),Insurance ($),Utilities ($),Maintenance reserve ($),Supplies/admin ($),Total operating expense ($),NOI (before debt) ($),Debt service (P&I) ($),Cash flow after debt ($),DSCR 1,0.33,275.0,120.45,33123.75,3974.85,993.7125,2566.0,2148.0,1500.0,3600.0,3000.0,800.0,18582.5625,14541.1875,18149.90168895322,-3608.7141889532213,0.8011716949877677 2,0.35,283.25,127.74999999999999,36185.18749999999,4342.222499999999,1085.5556249999997,2617.32,2190.96,1530.0,3672.0,3060.0,816.0,19314.058125,16871.129374999993,18149.90168895322,-1278.7723139532281,0.9295438434946708 3,0.4,291.7475,146.0,42595.135,5111.4162,1277.85405,2669.6664,2234.7792,1560.6,3745.44,3121.2,832.3199999999999,20553.27585,22041.85915,18149.90168895322,3891.957461046779,1.2144340794647712 4,0.4,300.499925,146.0,43872.989050000004,5264.758686,1316.1896715,2723.059728,2279.4747840000005,1591.8120000000001,3820.3488000000007,3183.6240000000003,848.9664000000001,21028.234069500002,22844.7549805,18149.90168895322,4694.85329154678,1.2586710039539366 5,0.4,309.51492275000004,146.0,45189.17872150001,5422.70144658,1355.675361645,2777.52092256,2325.06427968,1623.64824,3896.755776,3247.29648,865.945728,21514.608234465002,23674.570487035005,18149.90168895322,5524.668798081784,1.3043911142198816 6,0.4,318.8003704325,146.0,46544.854083145,5585.3824899774,1396.34562249435,2833.0713410112,2371.5655652736,1656.1212048,3974.69089152,3312.2424096,883.26464256,22012.684167236548,24532.169915908453,18149.90168895322,6382.2682269552315,1.3516420273967513 7,0.4,328.36438154547506,146.0,47941.19970563936,5752.943964676723,1438.2359911691808,2889.732767831424,2418.9968765790723,1689.243628896,4054.1847093504,3378.487257792,900.9299354112001,22522.755131706002,25418.444573933357,18149.90168895322,7268.542884980136,1.4004728515639326 8,0.4,338.2153129918393,146.0,49379.43569680854,5925.532283617024,1481.383070904256,2947.5274231880526,2467.3768141106534,1723.02850147392,4135.268403537408,3446.05700294784,918.948534119424,23045.12203389858,26334.31366290996,18149.90168895322,8184.4119739567395,1.4509342317230352 9,0.4,348.3617723815945,146.0,50860.8187677128,6103.298252125536,1525.824563031384,3006.4779716518137,2516.7243503928667,1757.4890715033987,4217.973771608156,3514.9781430067974,937.3275048018126,23580.093628121766,27280.725139591035,18149.90168895322,9130.823450637814,1.5030783971791544 10,0.4,358.8126255530423,146.0,52386.64333074418,6286.397199689301,1571.5992999223251,3066.60753108485,2567.0588374007243,1792.6388529334665,4302.33324704032,3585.277705866933,956.0740548978489,24127.98672883577,28258.656601908406,18149.90168895322,10108.754912955184,1.556959210369045
Provenance
- Source file:
tmp/projects/Masthope/04_10yr_Cashflow_Model.csv - Source URL: tmp/projects/Masthope/04_10yr_Cashflow_Model.csv
Source Extracts
- excerpt-1
Year,Occupancy %,ADR ($),Booked nights,Gross lodging revenue ($),Mgmt fee ($),Platform fee ($),Property tax ($),HOA ($),Insurance ($),Utilities ($),Maintenance reserve ($),Supplies/admin ($),Total operating expense ($),NOI (before debt) ($),Debt service (P&I) ($),Cash flow after debt ($),DSCR 1,0.33,275.0,120.45,33123.75,3974.85,993.7125,2566.0,2148.0,1500.0,3600.0,3000.0,800.0,18582.5625,14541.1875,18149.90168895322,-3608.7141889532213,0.8011716949877677 2,0.35,283.25,127.74999999999999,36185.1...
Path: tmp/projects/Masthope/04_10yr_Cashflow_Model.csv