Convexity +$20M over two steps: the good side pays 17% more than the bad side costs (+$275M against −$235M).
| A | B | C | D | E | |
| Assumption | Base | Downside | Δ | Basis | |
|---|---|---|---|---|---|
| Income & occupancy | |||||
| 1 | Market rent, building blend | $77.00 | $77.00 | · | CoStar prices the building at $69-85/MG. Struck at the midpoint and tiered by floor. |
| 2 | In-place rent, blended | $68.31 | $68.31 | · | ESRT: $72.89 per occupied SF including reimbursements, shown net of a 6% recovery allowance. Six anchors at disclosed rents; the balance tier-modelled and scaled by k = 0.844 to tie to ESRT. |
| 3 | Rent growth | 2.00% | 0.00% | −200 bp | Submarket asking rent is compounding ~2.0% a year through 2028. |
| 4 | In-place occupancy | 88.7% | 88.7% | · | ESRT: 2,403,091 of 2,709,234 SF commenced at June 30, 2026; 96.7% leased. |
| 5 | Stabilised occupancy | 94% | 88% | −6 pts | Submarket vacancy has fallen 14.0% to 10.8% in four quarters. |
| 6 | Renewal probability | 70% | 50% | −20 pts | Portfolio is 94.8% leased with 17.8% blended positive spreads. |
| 7 | Observatory net income | $55,000,000 | $55,000,000 | · | ESRT 2026 guidance. Carried NET in Other Income and capped at the office rate. |
| 8 | Operating expenses, year 1 | $100,760,696 | $100,760,696 | · | Per-SF estimates; ESRT does not disclose property-level opex. Cross-check: same-store office opex ratio 50.3% of revenue in Q2-26. |
| Capitalisation & return | |||||
| 9 | Going-in capitalisation rate | 6.75% | 6.75% | · | CoStar's modelled market rate 6.00% plus 75 bp. The tape's own clears imply near 10%, but those are value-add assets. |
| 10 | Exit capitalisation rate | 5.75% | 6.75% | +100 bp | Market cap is forecast to tighten to 5.83% by 2027 Q4. |
| 11 | Discount rate | 7.00% | 8.00% | +100 bp | Manhattan trophy, well leased. |
| 12 | Selling costs at exit | 2.0% | 2.0% | · | · |
| Capital, timing & basis | |||||
| 13 | Capital expenditure reserve | $0.75 | $0.85 | +$0.10 | Pre-war tower under modernisation. |
| 14 | Hold period | 10 yrs | 10 yrs | · | · |
| 15 | Office net rentable area | 2,709,234 SF | 2,709,234 SF | · | Of 2,958,981 SF total RBA; the balance is observatory, broadcast and back-of-house. |
LeaseComps!K30RentRoll!K57DCF!C13OpStmt!C8DCF!C29DCF!C15OpStmt!C16OpStmt!C31DirectCap!C9DCF!C21DCF!C20DCF!C22DCF!C14DCF!C24Summary!C17Source: six anchors at ESRT rent, three at CoStar rent, balance tier-modelled, k = 0.844 to ESRT's $174.0MM; opex per SF, Class A norms.
Convexity +$20M over two steps: the good side pays 17% more than the bad side costs (+$275M against −$235M).
Linear: +$241M either way over two steps, no convexity.
Linear: +$198M either way over two steps, no convexity.
Convexity +$29M over two steps: the good side pays 42% more than the bad side costs (+$198M against −$139M).
Linear: +$165M either way over two steps, no convexity.
Convexity +$6M over two steps: the good side pays 10% more than the bad side costs (+$123M against −$112M).
DCF (Base)!C36Lease Comps!K30, the weighted effective rent. Rents by floor tier are the cards above.Lease Comps!I30modelledThe model has no new-lease term input, so the comps carry it. Confirmed by the Fresco desk, 6 Sep 2026.DCF (Base)!C42Lease Comps!M30. Lease-Up!C38 carries $15.4MM in total.DCF (Base)!C44Lease Comps!L30, the weighted concession.DCF (Base)!C43Lease-Up!C35 carries the same rate.Lease-Up!C33The vacant block is absorbed over this period, not on day one.DCF (Base)!C15The downside book renews 50% of expiring SF against 70% in the base.DCF (Base)!C16desk noteModelled as =C42×0.5 in dollars per SF. A desk assumption, not a quoted renewal package.DCF (Base)!C17One third of the new-lease rate in DCF (Base)!C43.DCF (Base)!C18One month against 9.25 on a new lease.Location and asset quality flags are this desk's read of the sheet, confirmed by the Fresco desk, 6 Sep 2026.
Sale tape from the CoStar comparable-sales export, screened before weighting: allocated portfolio prints, partial-interest trades and distressed or land-basis prices are excluded rather than down-weighted.
In-building leases from the CoStar tenant record; starting rents at the floor-tier schedule, no contract rents published.
Turn this analysis into your next presentation.
| Base case proforma | Yr 12026 | Yr 22027 | Yr 32028 | Yr 42029 | Yr 52030 | Yr 62031 | Yr 72032 | Yr 82033 | Yr 92034 | Yr 102035 | Yr 1 to 10total |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Operating metrics | |||||||||||
| Occupancy | 88.7% | 94.0% | 94.0% | 94.0% | 94.0% | 94.0% | 94.0% | 94.0% | 94.0% | 94.0% | · |
| Occupied square feet | 2,403,091 | 2,546,680 | 2,546,680 | 2,546,680 | 2,546,680 | 2,546,680 | 2,546,680 | 2,546,680 | 2,546,680 | 2,546,680 | · |
| In-place rent, $/SF | $68.31 | $69.68 | $71.07 | $72.49 | $73.94 | $75.42 | $76.93 | $78.47 | $80.04 | $81.64 | · |
| Revenue | |||||||||||
| Base rent | $164,158,025 | $177,953,611 | $181,795,455 | $185,549,603 | $189,502,376 | $193,337,063 | $197,258,103 | $201,257,946 | $205,548,017 | $209,778,542 | $1,906,138,741 |
| Expense reimbursements | $9,849,482 | $10,677,217 | $10,907,728 | $11,132,977 | $11,370,143 | $11,600,224 | $11,835,487 | $12,075,477 | $12,332,882 | $12,586,713 | $114,368,330 |
| Other income + net observatory | $65,737,152 | $66,639,486 | $66,890,771 | $67,136,320 | $67,394,860 | $67,645,677 | $67,902,143 | $68,163,762 | $68,444,364 | $68,721,072 | $674,675,607 |
| Commercial EGI + net observatory | $238,103,079 | $253,490,778 | $257,775,999 | $261,963,404 | $266,372,357 | $270,649,594 | $275,023,152 | $279,484,606 | $284,269,784 | $288,988,542 | $2,676,121,294 |
| Operating expenses | |||||||||||
| Variable expenses | $40,242,141 | $43,624,028 | $44,565,828 | $45,486,130 | $46,455,124 | $47,395,169 | $48,356,383 | $49,336,916 | $50,388,595 | $51,425,678 | $467,275,992 |
| Fixed expenses | $55,037,047 | $56,137,788 | $57,260,544 | $58,405,755 | $59,573,870 | $60,765,347 | $61,980,654 | $63,220,267 | $64,484,672 | $65,774,366 | $602,640,309 |
| Management fee | $5,481,508 | $5,942,165 | $6,070,451 | $6,195,808 | $6,327,798 | $6,455,844 | $6,586,774 | $6,720,336 | $6,863,588 | $7,004,853 | $63,649,126 |
| Total operating expenses | $100,760,696 | $105,703,981 | $107,896,823 | $110,087,693 | $112,356,791 | $114,616,360 | $116,923,812 | $119,277,518 | $121,736,856 | $124,204,896 | $1,133,565,427 |
| Operating expense ratio | 42.3% | 41.7% | 41.9% | 42.0% | 42.2% | 42.3% | 42.5% | 42.7% | 42.8% | 43.0% | · |
| Net operating income | $137,342,383 | $147,786,796 | $149,879,176 | $151,875,711 | $154,015,565 | $156,033,234 | $158,099,340 | $160,207,087 | $162,532,927 | $164,783,646 | $1,542,555,867 |
| Capital and leasing | |||||||||||
| Capital expenditure reserve | $2,031,926 | $2,031,926 | $2,031,926 | $2,031,926 | $2,031,926 | $2,031,926 | $2,031,926 | $2,031,926 | $2,031,926 | $2,031,926 | $20,319,255 |
| Leasing capital, TI and commissions | $3,353,031 | $22,466,817 | $24,781,523 | $10,209,989 | $20,572,696 | $3,742,989 | $4,487,142 | $4,453,590 | $21,267,587 | $9,462,095 | $124,797,459 |
| Free rent abatement | $283,145 | $8,261,721 | $5,687,074 | $2,378,012 | $4,862,679 | $897,772 | $1,092,062 | $1,099,726 | $5,327,894 | $2,404,662 | $32,294,746 |
| Net cash flow | $131,674,281 | $115,026,333 | $117,378,654 | $137,255,784 | $126,548,266 | $149,360,548 | $150,488,211 | $152,621,846 | $133,905,521 | $150,884,964 | $1,365,144,407 |
| Reversion at exit, net of selling costs | · | · | · | · | · | · | · | · | · | $2,845,908,393 | $2,845,908,393 |
| Total cash flow for valuation | $131,674,281 | $115,026,333 | $117,378,654 | $137,255,784 | $126,548,266 | $149,360,548 | $150,488,211 | $152,621,846 | $133,905,521 | $2,996,793,357 | $4,211,052,800 |
| Discount rate | 7.00% |
| Exit capitalisation rate | 5.75% |
| Selling costs at exit | 2.0% |
| Hold period | 10 years |
| Rent growth | 2.00% |
| Stabilised occupancy | 94% |
| Terminal value at exit | $2,845,908,393 |
| Downside proforma | Yr 12026 | Yr 22027 | Yr 32028 | Yr 42029 | Yr 52030 | Yr 62031 | Yr 72032 | Yr 82033 | Yr 92034 | Yr 102035 | Yr 1 to 10total |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Operating metrics | |||||||||||
| Occupancy | 88.7% | 88.4% | 88.0% | 88.0% | 88.0% | 88.0% | 88.0% | 88.0% | 88.0% | 88.0% | · |
| Occupied square feet | 2,403,091 | 2,393,608 | 2,384,126 | 2,384,126 | 2,384,126 | 2,384,126 | 2,384,126 | 2,384,126 | 2,384,126 | 2,384,126 | · |
| In-place rent, $/SF | $68.31 | $68.31 | $68.31 | $68.31 | $68.31 | $68.31 | $68.31 | $68.31 | $68.31 | $68.31 | · |
| Revenue | |||||||||||
| Base rent | $164,158,025 | $163,510,261 | $163,283,155 | $163,468,854 | $163,841,134 | $163,908,519 | $163,988,880 | $164,068,217 | $164,445,051 | $164,611,794 | $1,639,283,890 |
| Expense reimbursements | $9,849,482 | $9,810,616 | $9,796,990 | $9,808,132 | $9,830,469 | $9,834,512 | $9,839,333 | $9,844,094 | $9,866,704 | $9,876,708 | $98,357,038 |
| Other income + net observatory | $56,881,152 | $56,838,783 | $56,823,929 | $56,836,075 | $56,860,425 | $56,864,832 | $56,870,089 | $56,875,278 | $56,899,926 | $56,910,832 | $568,661,321 |
| Commercial EGI + net observatory | $229,247,079 | $228,524,559 | $228,271,242 | $228,478,372 | $228,893,617 | $228,968,778 | $229,058,413 | $229,146,907 | $229,567,230 | $229,753,217 | $2,289,909,413 |
| Operating expenses | |||||||||||
| Variable expenses | $40,242,141 | $40,083,346 | $40,027,673 | $40,073,196 | $40,164,458 | $40,180,976 | $40,200,676 | $40,220,125 | $40,312,503 | $40,353,379 | $401,858,474 |
| Fixed expenses | $55,037,047 | $56,688,158 | $58,388,803 | $60,140,467 | $61,944,681 | $63,803,022 | $65,717,112 | $67,688,626 | $69,719,285 | $71,810,863 | $630,938,064 |
| Management fee | $5,481,508 | $5,459,878 | $5,452,295 | $5,458,495 | $5,470,927 | $5,473,177 | $5,475,860 | $5,478,509 | $5,491,092 | $5,496,660 | $54,738,401 |
| Total operating expenses | $100,760,696 | $102,231,383 | $103,868,771 | $105,672,158 | $107,580,065 | $109,457,175 | $111,393,649 | $113,387,260 | $115,522,880 | $117,660,902 | $1,087,534,939 |
| Operating expense ratio | 44.0% | 44.7% | 45.5% | 46.3% | 47.0% | 47.8% | 48.6% | 49.5% | 50.3% | 51.2% | · |
| Net operating income | $128,486,383 | $126,293,176 | $124,402,471 | $122,806,214 | $121,313,552 | $119,511,604 | $117,664,764 | $115,759,646 | $114,044,350 | $112,092,314 | $1,202,374,474 |
| Capital and leasing | |||||||||||
| Capital expenditure reserve | $2,302,849 | $2,302,849 | $2,302,849 | $2,302,849 | $2,302,849 | $2,302,849 | $2,302,849 | $2,302,849 | $2,302,849 | $2,302,849 | $23,028,489 |
| Leasing capital, TI and commissions | $2,395,022 | $264,593 | $27,530,426 | $11,871,112 | $23,798,671 | $4,307,674 | $5,137,171 | $5,071,787 | $24,089,736 | $10,659,340 | $115,125,532 |
| Free rent abatement | $202,247 | $22,343 | $7,577,673 | $3,321,334 | $6,658,460 | $1,205,213 | $1,437,292 | $1,418,999 | $6,739,895 | $2,982,301 | $31,565,757 |
| Net cash flow | $123,586,265 | $123,703,390 | $86,991,524 | $105,310,919 | $88,553,571 | $111,695,868 | $108,787,453 | $106,966,011 | $80,911,870 | $96,147,825 | $1,032,654,696 |
| Reversion at exit, net of selling costs | · | · | · | · | · | · | · | · | · | $1,596,136,722 | $1,596,136,722 |
| Total cash flow for valuation | $123,586,265 | $123,703,390 | $86,991,524 | $105,310,919 | $88,553,571 | $111,695,868 | $108,787,453 | $106,966,011 | $80,911,870 | $1,692,284,547 | $2,628,791,418 |
| Discount rate | 8.00% |
| Exit capitalisation rate | 6.75% |
| Selling costs at exit | 2.0% |
| Hold period | 10 years |
| Rent growth | 0.00% |
| Stabilised occupancy | 88% |
| Terminal value at exit | $1,596,136,722 |
| Underwritten operating statement | Year 1as underwritten | $ / SFon 2,709,234 SF |
|---|---|---|
| Revenue | ||
| Base rent | $164,158,025 | $60.59 |
| Expense reimbursements | $9,849,482 | $3.64 |
| Storage, antenna and broadcast licences | $10,737,152 | $3.96 |
| Other income: observatory, net | $55,000,000 | $20.30 |
| Vacancy and credit loss | ($1,641,580) | ($0.61) |
| Commercial EGI + net observatory | $238,103,079 | $87.89 |
| Operating expenses | ||
| Real estate taxes | $51,782,168 | $19.11 |
| Insurance | $3,254,879 | $1.20 |
| Utilities | $10,060,535 | $3.71 |
| Repairs and maintenance | $7,693,351 | $2.84 |
| Janitorial and cleaning | $6,805,656 | $2.51 |
| Management fee | $5,481,508 | $2.02 |
| Payroll and benefits | $9,172,841 | $3.39 |
| General and administrative | $6,509,758 | $2.40 |
| Total operating expenses | $100,760,696 | $37.19 |
| Operating expense ratio | 42.3% | |
| Net operating income | $137,342,383 | $50.69 |
| Capital expenditure | $2,031,926 | $0.75 |
| Total capital and leasing | $2,031,926 | $0.75 |
| Net cash flow | $135,310,457 | $49.94 |
Observatory net at ESRT 2026 guidance $55.0MM; revenue $128.3MM 2025, $136.4MM 2024; Q2-26 NOI $12.4MM as visits fell 28.5%.
Floors 2 to 79 modelled plates to ESRT office NRA; 80 to 102 per CoStar plan, ESRT pp. 14 and 20; no floor typed mechanical.
| Tenant | Floors | SF | % NRA | Share of building | Base rent | $/SF | Start | Expiry |
|---|---|---|---|---|---|---|---|---|
| 2nd, 3rd, 14th, 15th, 16th, 25th, 26th, | 377,002 | 13.92% | $29,070,624 | $77.11 | Sep-2011 | Aug-2036 | ||
| Centric Brands | 4th, 5th, 6th + floors not disclosed | 252,929 | 9.34% | $14,012,267 | $55.40 | Feb-2017 | Oct-2028 | |
| Coty Inc. | 19th + floors not disclosed | 157,892 | 5.83% | $9,146,684 | $57.93 | Dec-2008 | Jan-2030 | |
| FDIC | 11th, 12th, 13th | 119,226 | 4.40% | $7,004,528 | $58.75 | Mar-2024 | n/d | |
| Shutterstock | 21st + floors not disclosed | 108,937 | 4.02% | $7,396,822 | $67.90 | Aug-2013 | Apr-2029 | |
| HNTB | 56th, 57th, 58th | 78,361 | 2.89% | $5,907,636 | $75.39 | Jan-2016 | Sep-2034 | |
| Human Rights Watch | 33rd, 34th, 35th | 71,056 | 2.62% | $4,237,780 | $59.64 | Jan-1998 | Nov-2026 | |
| Booking.com | 22nd, 66th | 64,563 | 2.38% | $4,835,123 | $74.89 | Feb-2025 | Sep-2035 | |
| Hecker Fink LLP | 62nd, 63rd | 54,383 | 2.01% | $4,340,307 | $79.81 | May-2019 | Apr-2034 | |
| GNY Insurance Companies | 7th | 52,116 | 1.92% | $3,061,815 | $58.75 | May-2024 | May-2041 | |
| STV | 10th | 51,971 | 1.92% | $3,053,296 | $58.75 | Jan-2024 | Jan-2040 | |
| Starbucks | CNCR, GRND, MEZZ, 44th | 47,640 | 1.76% | $3,350,521 | $70.33 | Dec-2020 | Oct-2034 | |
| LinkedIn - 20th floor lease | 20th | 46,542 | 1.72% | $2,942,385 | $63.22 | Oct-2023 | Nov-2033 | |
| Pontera Solutions Inc. | 24th | 40,679 | 1.50% | $2,885,768 | $70.94 | May-2024 | Dec-2034 | |
| VIZIO | 18th | 40,679 | 1.50% | $2,563,591 | $63.02 | Jun-2020 | n/d | |
| JCDecaux North America | 73rd, 74th | 39,530 | 1.46% | $3,378,234 | $85.46 | Oct-2016 | Mar-2031 | |
| Elsberg Baker & Maruri | 38th | 39,237 | 1.45% | $2,551,190 | $65.02 | Jan-2026 | Dec-2032 | |
| Workday | 48th, 49th | 39,069 | 1.44% | $2,738,346 | $70.09 | n/d | n/d | |
| Robert Graham | 6th | 36,089 | 1.33% | $2,102,545 | $58.26 | n/d | n/d | |
| Bulova | 29th | 32,750 | 1.21% | $2,363,568 | $72.17 | Jun-2014 | Apr-2030 | |
| ZS | 51st, 55th | 31,129 | 1.15% | $2,508,997 | $80.60 | Jun-2016 | n/d | |
| Kearney | 78th, 79th | 27,866 | 1.03% | $2,329,598 | $83.60 | Jul-2025 | Jul-2036 | |
| Mott MacDonald | 40th | 25,372 | 0.94% | $1,657,553 | $65.33 | Jul-2025 | Jul-2035 | |
| Skanska | 37th | 25,000 | 0.92% | $1,869,250 | $74.77 | Sep-2008 | n/d | |
| Corgan | 54th | 21,000 | 0.78% | $1,471,890 | $70.09 | n/d | n/d | |
| Aprio | 43rd | 15,311 | 0.57% | $996,899 | $65.11 | Dec-2023 | Nov-2030 | |
| Funaro & Co. | 41st | 14,247 | 0.53% | $1,065,248 | $74.77 | Oct-2008 | n/d | |
| Captivate LLC | 60th | 13,171 | 0.49% | $923,155 | $70.09 | Apr-2026 | n/d | |
| RaySearch Laboratories | 50th | 12,807 | 0.47% | $1,027,634 | $80.24 | Jun-2018 | May-2028 | |
| Resolution Life | 60th | 12,439 | 0.46% | $873,093 | $70.19 | Mar-2023 | Mar-2030 | |
| Marshall & Stevens | 39th | 11,553 | 0.43% | $863,818 | $74.77 | Apr-2016 | n/d | |
| OFS | 59th | 11,038 | 0.41% | $780,276 | $70.69 | Jan-2024 | n/d | |
| Acronym | 65th | 10,441 | 0.39% | $731,810 | $70.09 | n/d | n/d | |
| Fine Sheer Industries | 47th | 9,955 | 0.37% | $752,498 | $75.59 | Jan-2006 | Mar-2046 | |
| Strawberry Frog | 52nd | 9,000 | 0.33% | $722,160 | $80.24 | Apr-2018 | n/d | |
| Swedbank New York | 45th | 7,905 | 0.29% | $530,030 | $67.05 | May-2021 | Feb-2032 | |
| BIG EAST Conference | 45th | 7,882 | 0.29% | $514,931 | $65.33 | Sep-2025 | Sep-2035 | |
| HNTB - 7,850 SF tranche | 56th-58th (tranche) | 7,850 | 0.29% | $591,812 | $75.39 | Jan-2016 | Jun-2027 | |
| Rystad Energy | 47th | 7,668 | 0.28% | $538,217 | $70.19 | Oct-2023 | n/d | |
| Semler Brossy | 59th | 7,668 | 0.28% | $615,280 | $80.24 | Nov-2018 | n/d | |
| Broadriver Asset Management | 31st | 7,166 | 0.26% | $533,365 | $74.43 | Apr-2018 | n/d | |
| Rocket Pharma | 75th | 6,684 | 0.25% | $568,675 | $85.08 | Jul-2018 | n/d | |
| Qlik | 46th | 6,611 | 0.24% | $527,624 | $79.81 | Nov-2019 | n/d | |
| Empire Valuation Consultants | 61st | 6,601 | 0.24% | $424,444 | $64.30 | May-1998 | n/d | |
| Other listed tenants (48) | various | 162,121 | 5.98% | $11,871,795 | $73.23 | n/d | n/d | |
| Occupied office space not individually identified | various | 173,955 | 6.42% | $11,924,943 | $68.55 | n/d | n/d | |
| Signed, not commenced - United Talent Agency | 32nd, 33rd, 34th, 35th | 100,948 | 3.73% | · | · | Jul-2027 | Jun-2043 | |
| Signed, not commenced - Dynamic US | 48th | 4,050 | 0.15% | · | · | Sep-2026 | n/d | |
| Signed, not commenced - balance not identified | various | 111,740 | 4.12% | · | · | n/d | n/d | |
| Vacant - available | various | 89,405 | 3.30% | · | · | n/d | n/d | |
| Total | 2,709,234 | 100.0% | $164,158,025 | $68.31 | 50 lines |
CoStar 112 tenants, 97 rendered; six anchors per ESRT top 20; FDIC and Pontera from CoStar transactions; signed-not-commenced at $0.
| Expiry | Leases | SF expiring | % of NRA | Share | Cumulative | Base rent expiring | % of base rent |
|---|---|---|---|---|---|---|---|
| Expired / MTM | 0 | 0 | 0.0% | 0.0% | $0 | 0.0% | |
| 2026 | 1 | 71,056 | 2.6% | 2.6% | $4,237,780 | 2.6% | |
| 2027 | 1 | 7,850 | 0.3% | 2.9% | $591,812 | 0.4% | |
| 2028 | 2 | 265,736 | 9.8% | 12.7% | $15,039,901 | 9.2% | |
| 2029 | 1 | 108,937 | 4.0% | 16.7% | $7,396,822 | 4.5% | |
| 2030 | 4 | 218,392 | 8.1% | 24.8% | $13,380,244 | 8.2% | |
| 2031 | 1 | 39,530 | 1.5% | 26.3% | $3,378,234 | 2.1% | |
| 2032 | 2 | 47,142 | 1.7% | 28.0% | $3,081,220 | 1.9% | |
| 2033 | 1 | 46,542 | 1.7% | 29.7% | $2,942,385 | 1.8% | |
| 2034 | 4 | 221,063 | 8.2% | 37.9% | $16,484,232 | 10.0% | |
| 2035 | 3 | 97,817 | 3.6% | 41.5% | $7,007,607 | 4.3% | |
| Thereafter | 5 | 518,910 | 19.2% | 60.6% | $38,267,831 | 23.3% | |
| Vacant | 4 | 306,143 | 11.3% | · | $0 | 0.0% | |
| TOTAL | 29 | 1,949,118 | 71.9% | · | $111,808,068 | 68.1% |
Turn this analysis into your next presentation.
Base. fixed entry $2382.3MM · equity $1085.1MM · debt $1310.3MM
at a fixed hypothetical entry of $2,382.3MM; concluded value $2.27B
| Metric | Unlevered | Levered |
|---|---|---|
| Internal rate of return | 7.1% | 7.7% |
| Equity multiple | 1.77x | 1.92x |
| Net present value | $10.3MM | ($239.2MM) |
| Capital at risk | $2382.3MM | $1085.1MM |
| Reversion at exit | $2845.9MM | $1535.6MM |
| Exit year and cap rate | Yr 10 · 5.75% | Yr 10 · 5.75% |
Base case IRR: 7.7%. The 11.00% equity hurdle is an acquisition assumption, separate from the workbook's asset valuation discount rate.
Negative NPV measures the shortfall against the assumed equity hurdle; annual cash flows can still be positive. Purchase price and debt stay fixed.
Source: DCF net cash flows and net sale proceeds; acquisition-assumptions.json price, debt, origination fee and equity_discount_rate.
| −50 bp | −25 bp | Base | +25 bp | +50 bp | |
|---|---|---|---|---|---|
| Rent growth +1% | 11.1% | 10.5% | 9.8% | 9.2% | 8.6% |
| Rent growth base | 9.2% | 8.4% | 7.7% | 7.1% | 6.4% |
| Rent growth −1% | 7.0% | 6.3% | 5.5% | 4.8% | 4.0% |
| −50 bp | −25 bp | Base | +25 bp | +50 bp | |
|---|---|---|---|---|---|
| Rent growth +1% | 2.55x | 2.41x | 2.27x | 2.15x | 2.04x |
| Rent growth base | 2.17x | 2.04x | 1.92x | 1.81x | 1.71x |
| Rent growth −1% | 1.82x | 1.70x | 1.59x | 1.49x | 1.40x |
| −50 bp | −25 bp | Base | +25 bp | +50 bp | |
|---|---|---|---|---|---|
| Rent growth +1% | $11.1MM | ($44.3MM) | ($94.8MM) | ($141.2MM) | ($183.8MM) |
| Rent growth base | ($143.8MM) | ($193.7MM) | ($239.2MM) | ($281.0MM) | ($319.4MM) |
| Rent growth −1% | ($286.9MM) | ($331.7MM) | ($372.7MM) | ($410.3MM) | ($444.8MM) |
Upside. fixed entry $2382.3MM · equity $1085.1MM · debt $1310.3MM
at a fixed hypothetical entry of $2,382.3MM; concluded value $2.27B
| Metric | Unlevered | Levered |
|---|---|---|
| Internal rate of return | 8.5% | 10.5% |
| Equity multiple | 1.98x | 2.39x |
| Net present value | $286.0MM | ($40.9MM) |
| Capital at risk | $2382.3MM | $1085.1MM |
| Reversion at exit | $3284.1MM | $1973.8MM |
| Exit year and cap rate | Yr 10 · 5.25% | Yr 10 · 5.25% |
Upside case IRR: 10.5%. The 11.00% equity hurdle is an acquisition assumption, separate from the workbook's asset valuation discount rate.
Negative NPV measures the shortfall against the assumed equity hurdle; annual cash flows can still be positive. Purchase price and debt stay fixed.
Source: DCF net cash flows and net sale proceeds; acquisition-assumptions.json price, debt, origination fee and equity_discount_rate.
| −50 bp | −25 bp | Base | +25 bp | +50 bp | |
|---|---|---|---|---|---|
| Rent growth +1% | 13.8% | 13.1% | 12.4% | 11.8% | 11.1% |
| Rent growth base | 11.9% | 11.2% | 10.5% | 9.8% | 9.1% |
| Rent growth −1% | 10.0% | 9.2% | 8.4% | 7.7% | 7.0% |
| −50 bp | −25 bp | Base | +25 bp | +50 bp | |
|---|---|---|---|---|---|
| Rent growth +1% | 3.15x | 2.96x | 2.79x | 2.64x | 2.50x |
| Rent growth base | 2.71x | 2.54x | 2.39x | 2.26x | 2.13x |
| Rent growth −1% | 2.31x | 2.16x | 2.02x | 1.90x | 1.79x |
| −50 bp | −25 bp | Base | +25 bp | +50 bp | |
|---|---|---|---|---|---|
| Rent growth +1% | $256.8MM | $185.9MM | $121.7MM | $63.4MM | $10.2MM |
| Rent growth base | $80.9MM | $16.9MM | ($40.9MM) | ($93.5MM) | ($141.5MM) |
| Rent growth −1% | ($81.6MM) | ($139.1MM) | ($191.1MM) | ($238.4MM) | ($281.6MM) |
Downside. fixed entry $2382.3MM · equity $1085.1MM · debt $1310.3MM
at a fixed hypothetical entry of $2,382.3MM; concluded value $2.27B
| Metric | Unlevered | Levered |
|---|---|---|
| Internal rate of return | 1.2% | -9.1% |
| Equity multiple | 1.10x | 0.46x |
| Net present value | ($939.1MM) | ($845.5MM) |
| Capital at risk | $2382.3MM | $1085.1MM |
| Reversion at exit | $1596.1MM | $285.9MM |
| Exit year and cap rate | Yr 10 · 6.75% | Yr 10 · 6.75% |
Downside case IRR: -9.1%. The 11.00% equity hurdle is an acquisition assumption, separate from the workbook's asset valuation discount rate.
Negative NPV measures the shortfall against the assumed equity hurdle; annual cash flows can still be positive. Purchase price and debt stay fixed.
Source: DCF net cash flows and net sale proceeds; acquisition-assumptions.json price, debt, origination fee and equity_discount_rate.
| −50 bp | −25 bp | Base | +25 bp | +50 bp | |
|---|---|---|---|---|---|
| Rent growth +1% | -2.0% | -3.0% | -4.0% | -5.0% | -6.1% |
| Rent growth base | -6.3% | -7.7% | -9.1% | -10.7% | -12.5% |
| Rent growth −1% | -12.8% | -15.3% | -18.4% | -23.0% | -35.8% |
| −50 bp | −25 bp | Base | +25 bp | +50 bp | |
|---|---|---|---|---|---|
| Rent growth +1% | 0.84x | 0.77x | 0.71x | 0.65x | 0.59x |
| Rent growth base | 0.58x | 0.52x | 0.46x | 0.41x | 0.36x |
| Rent growth −1% | 0.34x | 0.29x | 0.24x | 0.19x | 0.15x |
| −50 bp | −25 bp | Base | +25 bp | +50 bp | |
|---|---|---|---|---|---|
| Rent growth +1% | ($692.1MM) | ($718.5MM) | ($743.0MM) | ($765.7MM) | ($786.8MM) |
| Rent growth base | ($800.5MM) | ($823.8MM) | ($845.5MM) | ($865.5MM) | ($884.2MM) |
| Rent growth −1% | ($900.6MM) | ($921.2MM) | ($940.2MM) | ($957.9MM) | ($974.3MM) |
Illustrative JV terms, modelled here from the DCF levered flows; the model has no waterfall sheet. Terms are levers, not facts.
| Figure | Derived from |
|---|---|
| Equity in, loan | Financials/acquisition-assumptions.json:price fixed purchase price $2382.3MM × LTV 55% = loan $1310.3MM; equity including origination fee $1085.1MM |
| Yearly distributable | DCF (Base)!C74:L74 net cash flow less debt service $81.9MM (loan × 6.25%, interest only) |
| Exit proceeds | DCF (Base) reversion in year 10 (row 76 total cash flow less row 74), which is net of selling costs DCF!C22 at 2.0%, less the loan repaid at par $1310.3MM |
| Origination fee | 1.00% of loan = $13.1MM, paid once at entry in the equity vector |
| Upside vector | the Base vector re-run on this page at rent +5% and exit cap −50 bp, as the Upside pane |
| Downside vector | DCF (Down)!C74:L74 and row 76; fixed entry acquisition assumptions $2382.3MM, unchanged loan $1310.3MM and LTV 55%; only post-acquisition cash flows change |
| All tier outputs | modelled in page JS (wf_engine.js) from the rows above on the terms shown; terms illustrative |