Core office pro forma: market rent at exit is 27% below contract

An acquisitions analyst tests an office building leased to one rated public company at its latest appraised value. Compound builds the ten-year model from the property's CMBS filings, sets the renewal probability from the tenant's 10-K, and solves for the exit cap rate that earns the target.

Compound Research · Updated Nov 15, 2026 · 14 min read

Short answer

A core office pro forma projects contract rent from a credit tenant and tests the return against the exit price. In Compound's model of an office building bought at its 2024 appraised value of $446.0 million, the levered IRR is 3.4%, because the sale is priced on market rent 27% below the contract rent.

Try it now
On this page (14)
  1. 1. What a core office pro forma tests
  2. 2. The subject property: what the CMBS filings report
  3. 3. The tenant roster: Visa pays 97.5% of the rent
  4. 4. Renewal probability, read from Visa's 10-K and earnings call
  5. 5. Market rent and leasing costs, checked against office REIT 10-Ks
  6. 6. Price per square foot against Schedule III, and the cap rate against the Treasury
  7. 7. The 10-year cash flow: contract rent, recoveries and costs
  8. 8. New fixed-rate debt beside the loan on the property
  9. 9. The exit: rents marked to market, and the cap rate that earns the target
  10. 10. Sensitivity: exit cap rate, market rent and leasing cost
  11. 11. The flags: four of five tests are on
  12. 12. What the public data cannot tell you
  13. 13. Our view: what this model says about the deal
  14. 14. FAQ

The model on this page prices the 2036 sale of the San Francisco office building that CMBS filings name Visa Global HQ on market rent, and its market rent at Visa’s 2038 lease expiration is 27% below the contract rent. That takes the NOI behind the sale price from $36,473,201 to $26,636,192. A buyer who pays the latest appraised value of $446.0 million, from a July 2024 appraisal, earns a levered IRR of 3.4% against a target of 8.0%.

How far the exit is from the target depends on which NOI you measure it on. On the marked NOI, the sale price that earns 8.0% is a 4.76% cap rate, 118 basis points below the 5.94% cap rate at purchase. On the contract NOI, the same price is a 6.52% cap rate, 58 basis points above the purchase rate (our arithmetic). The market rent, the price and the target are assumptions, and the lease, the income and the loan are from filings.

You are on the acquisitions team of an institutional investor, and a building like this is the core office case: built in 2023, 97.7% occupied, and leased until 2038 to a public company with investment-grade ratings. The rent rises 3.0% a year under contract. The open question is the sale price when the hold ends, 15 months before that lease does. We asked Compound to build the model from public filings. It ran on November 15, 2026 and returned one Excel workbook.

What the workbook shows:

  • The purchase price is an assumption set by the request. It is the latest appraised value in the CMBS filing, $446,000,000 or $1,388 per square foot, from an appraisal dated July 11, 2024. The model’s return follows from that assumption. It is a worked example on public data and does not say what the property would trade for.
  • The going-in cap rate is 5.94%, which is 79 basis points over the 10-year Treasury yield of 5.15%. The request asked for a flag below 150.
  • New debt costs more than the building yields. The Treasury yield plus a 1.65% spread gives a 6.80% fixed rate. Debt service coverage is 1.72x in Year 1, and cash-on-cash is 4.6%.
  • One tenant pays 97.5% of the base rent. The filing gives Visa Inc. a lease expiration of March 31, 2038, inside the three years after the sale that the request asked to flag.
  • The sale is priced on market rent. The gross sale price is $413,702,556, which is a 6.44% cap rate on the marked NOI and an 8.82% cap rate on the contract NOI (our arithmetic).

Each input on the Assumptions sheet names where it came from. Property, tenant and loan facts come from the CMBS loan-level filings on SEC EDGAR: a Form ABS-EE for BANK 2025-BNK49 filed on October 29, 2026, and the collateral term sheet for BANK 2025-BNK50, filed on May 21, 2025. The 10-year yield is from the Daily Treasury Par Yield Curve at the close of November 13, 2026. Leasing benchmarks come from the fiscal 2025 10-Ks of Kilroy Realty and Hudson Pacific Properties, and the carrying amounts of ten San Francisco office buildings come from Kilroy’s Schedule III. The tenant’s figures come from Visa’s fiscal 2026 10-K and its earnings call of October 27, 2026. The transfer tax rate is from SF.gov, by web search. Every other input is marked “Analyst assumption” and carries the reason for its value.

Prompt to try

“I am reviewing a stabilized office building leased long-term to a strong-credit tenant and want a core office pro forma that tells me whether it meets our return target over ten years, and at what exit cap rate. From the CMBS loan-level filings, pick one U.S. office property where one to three tenants lease at least 80% of the area, the largest tenant is a public company with an investment-grade credit rating and a lease that runs at least seven more years, and the latest report names the tenants with their square feet and lease expiration dates and gives net rentable area, occupancy, revenue, operating expenses, net operating income, appraised value and the loan terms. Use it as the subject and its latest appraised value as the purchase price. Build the tenant roster from the named tenants as filed, with square feet, in-place rent, escalations, expiration, credit rating and renewal probability. Read the largest tenant's latest 10-K and earnings call for its lease obligations, headcount, office footprint plans, debt and rating, and set its renewal probability from that with a note. Set market rent at rollover and renewal leasing costs and free rent as analyst assumptions, checked against what public office REITs report for that market in their latest 10-K. Compare the price per square foot with what public office REITs carry buildings at in the same state (Schedule III), and the going-in cap rate with today's 10-year Treasury yield. Use fixed-rate debt priced off that yield, and show it next to the loan the property has now. Build: a 10-year annual cash flow with contractual rent and escalations, expense recoveries over each lease's base year, and leasing costs charged in the year each lease expires; rents marked to market at the end of the hold; annual DSCR; levered IRR, equity multiple and cash-on-cash by year; weighted average lease term; and sensitivity tables of levered IRR to exit cap rate at 25, 50 and 75 basis points above the going-in rate, market rent at rollover, and leasing cost. Flag a lease that expires inside the hold or within three years after it, one tenant above 50% of rent, and a going-in cap rate less than 150 basis points above the Treasury yield. Use the stored public data wherever it has the figure, and web search only for what it lacks. Put every input on an Assumptions sheet with one column that says where it came from: a cited source, or "analyst assumption" for a figure I would set myself, with the reason for the value you chose. Every output must be a live formula that traces back to the Assumptions sheet. Add a Sources sheet listing each data source, what it gave and its date. Deliver one Excel workbook and a short summary of the result, the flags, and what I would need from the seller to firm it up. Cite every sourced figure.”

Try this prompt free →

That is the request as we sent it, without its closing line, which asks that no name or email be put in the workbook.

What a core office pro forma tests

A core office pro forma takes rent that is already under contract with a strong tenant and asks what return it produces at a given price. Most of the uncertainty sits in three places: the price paid, the cost of debt, and the value of the building when the hold ends.

In this workbook one triple-net lease produces nearly all of the rent, and no large lease expires during the hold. The model is therefore annual and has two calculation sheets, Rent Roll and Cash Flow, between Assumptions and Summary.

The work is in five tests around that income: the tenant’s reasons to stay, read from its own filings; market rent and leasing costs against what office REITs report; price per square foot against REIT carrying amounts; the cap rate against the Treasury yield; and the exit cap rate that the return target needs.

A building with many tenants needs a different model. The office lease-by-lease cash flow posts every lease event in its month over 120 months and runs a case where the largest tenant leaves. The office lease rollover analysis is a one-sheet first pass. A due diligence review starts from the seller’s documents. This page uses public filings only and underwrites the tenant from them.

The subject property: what the CMBS filings report

The October 2026 filing reports a 321,355 square foot building, built in 2023 and 97.7% occupied, with first-quarter 2026 NOI of $6,119,681. It names the three largest tenants with their square feet and lease expiration dates, and the term sheet adds the Visa lease terms and the loan.

Compound screened its CMBS loan-level data for U.S. office properties that met the request’s tenant, lease-term and reporting tests. It chose the property the term sheet calls VISA Global HQ, at 300 Toni Stone Crossing in San Francisco.

The Form ABS-EE for BANK 2025-BNK49 covers the period that ended on October 13, 2026. For January 1 to March 31, 2026 it reports revenue of $9,877,062, operating expenses of $3,757,381 and NOI of $6,119,681. The Assumptions sheet multiplies the quarter by 4.0x to annualize it.

The term sheet for BANK 2025-BNK50 gives what the periodic report does not: Visa’s rent of $79.31 per square foot with 3.0% annual steps, a triple-net structure, underwritten NOI of $27,302,500 and the terms of the loan. Two inputs follow from the request. The purchase price equals the appraised value, and the hold is ten years. The closing date of December 31, 2026 is an analyst assumption, chosen so that Year 1 is calendar 2027. The 8.0% target is also an analyst assumption, and the source cell gives the reason: “no target given in the request”.

The tenant roster: Visa pays 97.5% of the rent

Visa Inc. leases 303,629 of the building’s 321,355 square feet and pays 97.5% of Year 1 base rent. The weighted average lease term is 11.3 years, and two of the three leases are flagged for when they expire.

Visa_Global_HQ_Core_Office_ProForma.xlsx
I94fx=IF(E94=0,"Vacant",IF(H94<=Assumptions!$D$12,"FLAG: in hold",IF(H94<=EDATE(Assumptions!$D$12,12*Assumptions!$D$99),"FLAG: <="&Assumptions!$D$99&"y after","OK")))
BDEFGHIJ
93TenantLeased SFYr 1 base rentRent shareTerm left (yrs)Lease expirationRollover flagConcentration flag
94Visa Inc.303,62926,576,89597.5%11.203/31/2038FLAG: <=3y afterFLAG: >50%
95CTMR LLC (Cinque Terre / Che Fico)8,316529,3471.9%13.709/29/2040OKOK
96Blue Bottle Coffee, LLC2,069159,8300.6%9.101/31/2036FLAG: in holdOK
97Vacant retail7,34100.0%0.012/31/2026VacantOK
98Total / weighted average321,35527,266,072100.0%
SummaryAssumptionsRent RollCash FlowSources
The lease summary at closing from Compound's Rent Roll tab, rows 93 to 98. Tenant names, square feet and expiration dates are as the CMBS filing gives them. The values are as Compound wrote them, shown to the sheet's precision.

The filing names three tenants. Visa Inc. has the office space. CTMR LLC, which the workbook identifies with the Cinque Terre (Che Fico) lease in the term sheet, has 8,316 square feet of ground-floor retail until September 29, 2040. Blue Bottle Coffee, LLC has 2,069 square feet until January 31, 2036. The remaining 7,341 square feet is the net rentable area less the three named tenants, and the model treats it as vacant retail that leases up in Year 1.

The rent inputs are split between sourced and assumed. Visa’s $79.31 and the Cinque Terre rent of $60.00 are from the term sheet. Blue Bottle’s $75.00 is an analyst assumption, because its rent is not disclosed, and the source cell says it was set inside the $60 to $80 range of retail rents in the term sheet. Visa’s 3.0% escalation is from the term sheet. The month of the step, September, is an analyst assumption that follows the anniversary of rent commencement.

The rollover flag in the formula bar reads each lease expiration against the sale date and against a date three years after it. The concentration flag compares each tenant’s share of base rent with a 50% threshold.

Renewal probability, read from Visa’s 10-K and earnings call

The model gives Visa a 75% renewal probability, and the Assumptions sheet records the evidence in one note. The figure is the agent’s judgment, marked as an analyst assumption, and the facts under it are from the term sheet and Visa’s own filings.

From the term sheet: the ratings shown for Visa are AA- from S&P and Aa3 from Moody’s. The building serves as Visa’s global headquarters for up to 1,500 employees. Visa put about $83 million of its own capital into the space, or $273 per square foot, on top of a landlord allowance of about $37 million, or $122 per square foot. The lease has two fair-market-value renewal options and no termination option.

From Visa’s 10-K for the fiscal year that ended September 30, 2026: about 34,800 employees, operating lease liabilities of $884 million, undiscounted lease payments of $1,085 million, a weighted-average remaining lease term of 9 years, and total debt principal of $22.6 billion. From the earnings call: fiscal 2026 net revenue rose 15% to $46 billion.

The note then records the offset: the contract rent at expiry is above the model’s market rent. Against these the workbook sets a benchmark from the other direction. Kilroy’s 10-K reports a 2025 retention rate of 34%. The Summary sheet shows the two figures side by side.

Visa’s lease runs past the ten-year hold, so the renewal probability changes no year of cash flow. It sets the blended leasing cost credited to the next buyer at the sale.

Market rent and leasing costs, checked against office REIT 10-Ks

Office market rent is $65.00 per square foot, triple net, in 2026 dollars, an analyst assumption that sits inside five public benchmarks from $57.00 to $70.00. The leasing cost assumptions are above what the two REITs reported for 2025.

Visa_Global_HQ_Core_Office_ProForma.xlsx
D63fx=Assumptions!$D$51+Assumptions!$D$52
BDEF
57ItemModelBenchmarkBenchmark source
58Office market rent, $/SF NNN65.0070.002024 appraisal (term sheet)
59Office market rent, $/SF NNN65.0066.00OpenAI comparable lease, Mission Bay
60Office market rent, $/SF NNN65.0057.00Cisco comparable lease, Mission Bay
61Office market rent, $/SF65.0062.55Kilroy 10-K: SF Bay Area 2026 expirations ABR
62Office market rent, $/SF65.0066.49HPP 10-K: Rincon Center ABR
63Renewal TI + LC, office, $/SF30.0022.67HPP 10-K: 2025 renewals
64New-lease TI + LC, office, $/SF100.0085.85HPP 10-K: 2025 new leases
65New-lease TI + LC, office, $/SF100.0059.76Kilroy 10-K: 2025 second-generation leases
66Visa renewal probability vs REIT retention75%34%Kilroy 10-K: 2025 retention rate
SummaryAssumptionsRent RollCash FlowSources
The benchmark check from Compound's Summary tab, rows 57 to 66, with the empty column C left out. The Model column holds analyst assumptions. The Benchmark column holds figures from the term sheet and from the Kilroy Realty and Hudson Pacific Properties (HPP) 10-Ks for fiscal 2025.

The appraisal in the term sheet concluded to $70.00 for office space in Mission Bay. The term sheet’s comparable leases include two in Mission Bay signed in 2024, at $66.00 and $57.00. Kilroy’s 10-K gives $62.55 as the annualized base rent on its San Francisco Bay Area leases expiring in 2026, and Hudson Pacific’s gives $66.49 at Rincon Center.

The workbook explains why $65.00 is below the appraisal: Kilroy reported that rents on its 2025 second-generation leases fell 9.3% on a GAAP basis. Market rent grows at 2.5% a year, below the appraisal’s 3.0%, and the reason given is Kilroy’s San Francisco Bay Area occupancy of 86.2%.

Leasing costs are set in 2026 dollars. A renewal costs $30.00 per square foot in tenant improvements and commissions, against $22.67 for Hudson Pacific’s 2025 renewals. A new lease costs $100.00, against $85.85 at Hudson Pacific and $59.76 for Kilroy’s second-generation leases. Free rent is 3 months on an office renewal and 9 months on a new office lease, with 12 months of downtime before a new tenant. Neither REIT’s 10-K reports free rent for San Francisco, so those inputs have no public check.

Price per square foot against Schedule III, and the cap rate against the Treasury

The purchase price is $1,388 per square foot. Kilroy carries ten San Francisco office buildings at a gross $553 per square foot, so the price is a 151% premium to that figure.

Visa_Global_HQ_Core_Office_ProForma.xlsx
G118fx=D118/F118
BDEFG
107PropertyGross carrying amountAccumulated depreciationRentable SFGross $/SF
108100 First St.266,803,000125,428,000480,457555
109100 Hooper St.275,598,00041,819,000417,914659
110201 Third St.189,134,000109,440,000355,960531
111360 Third St.217,147,00087,745,000436,357498
112250 Brannan St.41,197,00017,628,000100,850408
113301 Brannan St.46,177,00019,487,00082,834557
114333 Brannan St.99,330,00023,730,000185,602535
115345 Brannan St.143,942,00023,665,000110,0501,308
116303 Second St.341,438,000159,024,000784,658435
117350 Mission St.265,721,00064,520,000455,340584
118Kilroy San Francisco total / weighted1,886,487,000672,486,0003,410,022553
119Kilroy San Francisco net of depreciation356
SummaryAssumptionsRent RollCash FlowSources
The Schedule III benchmark from Compound's Assumptions tab, rows 107 to 119, without the unit and source columns. Carrying amounts are as of December 31, 2025 from Kilroy Realty's 10-K, which reports them in thousands. The source column, left out here, cites the 10-K on every property row.

Schedule III is the table in a REIT’s 10-K that lists each property’s cost and accumulated depreciation. It is historical cost, with no adjustment for today’s value, so the comparison is a reference point and the buildings are not comparable sales. Net of depreciation the Kilroy figure is $356 per square foot. The building closest to the subject’s price is 345 Brannan St., at $1,308.

The agent’s answer says the property sits on a ground lease that runs to 2095. The price here buys a leasehold interest, which is a second reason to treat the Schedule III figures as a reference point only. The model’s expenses have no separate line for ground rent, so the ground lease is among the first documents to ask the seller for.

Price per square foot: the subject against REIT carrying amounts

The purchase price is the 2024 appraised value. The two sale prices are model outputs for 2036

Sale price needed for the 8.0% target$1,741Purchase price (2024 appraised value)$1,388Sale price in the model, 2036$1,287Kilroy San Francisco office, gross$553Kilroy San Francisco office, net$356

Compound's Summary tab, rows 14 and 19 to 21, and Cash Flow tab, row 36. Carrying amounts: Kilroy Realty 10-K for fiscal 2025, Schedule III, ten San Francisco office buildings. Appraised value: SEC Form ABS-EE for BANK 2025-BNK49, filed October 29, 2026.

The second pricing test is the cap rate. Year 1 NOI in the model is $26,485,659, which is 5.94% of the price. The workbook also shows the cap rate on the latest reported NOI, the first quarter of 2026 annualized, at 5.49%. Year 1 NOI is 8.2% above that annualized quarter (our arithmetic). In the model the difference comes from Visa’s 3.0% rent steps and the lease-up of the vacant retail space, and the seller’s rent schedule would confirm both. The 10-year Treasury closed at 5.15% on November 13, 2026. The spread on the model’s Year 1 figure is 79 basis points.

The 10-year cash flow: contract rent, recoveries and costs

NOI grows from $26,485,659 in Year 1 to $35,324,243 in Year 10, and leasing costs over the ten years are two small retail items. Cash-on-cash starts at 4.6% and reaches 8.6%.

Visa_Global_HQ_Core_Office_ProForma.xlsx
E15fx=E13+E14
BEFGINO
4Year12351011
5Period ending202720282029203120362037
8Base rent, contractual27,266,07228,084,05428,926,57630,688,20535,384,87636,428,523
9Base rent, re-leased space-348,762478,966508,135660,577748,593
10Expense recoveries14,910,88315,625,92816,094,70517,074,87319,756,22420,388,291
11Gross revenue ($)42,176,95644,058,74445,500,24848,271,21355,801,67857,565,407
12Less: general vacancy and credit loss(210,885)(220,294)(227,501)(241,356)(279,008)(287,827)
13Effective gross income ($)41,966,07143,838,45045,272,74648,029,85755,522,67057,277,580
14Operating expenses(15,480,412)(15,944,824)(16,423,169)(17,423,340)(20,198,426)(20,804,379)
15Net operating income ($)26,485,65927,893,62628,849,57830,606,51735,324,24336,473,201
18Capital reserve(49,649)(51,139)(52,673)(55,881)(64,781)(66,725)
19Leasing costs (TI and LC)(451,471)---(87,400)-
20Cash flow before debt service ($)25,984,53827,842,48728,796,90530,550,63635,172,06236,406,477
43Debt service ($)(15,374,611)(15,374,611)(15,374,611)(15,374,611)(15,374,611)
46Levered cash flow from operations10,609,92712,467,87613,422,29415,176,02519,797,451
48DSCR (NOI / debt service)1.72x1.81x1.88x1.99x2.30x
50Cash-on-cash return4.6%5.4%5.9%6.6%8.6%
SummaryAssumptionsRent RollCash FlowSources
Seventeen rows of Compound's Cash Flow tab for Years 1, 2, 3, 5, 10 and 11, new-loan case. Year 11 is on the sheet only to set the NOI at exit, so its debt rows are empty. The values are as Compound wrote them.

Year 1 gross revenue is $42,176,956: contractual base rent of $27,266,072 and expense recoveries of $14,910,883. The leases are triple net, so recoveries follow expenses. Operating expenses start from the annualized first quarter of 2026, $15,029,526, and grow 3.0% a year. The model treats 2.0% of them as non-recoverable, an analyst assumption for costs that are not billed under triple-net leases.

Three lines are small by design. General vacancy and credit loss is 0.5% of revenue, and the source cell gives the reason: “low for an AA- anchor tenant”. The capital reserve is $0.15 per square foot, the figure underwritten in the term sheet. Leasing costs are $451,471 in Year 1, when the vacant retail space leases, and $87,400 in Year 10, when the Blue Bottle lease expires.

Cash-on-cash return by year, new-loan case

Levered cash flow from operations over equity at closing of $229,132,500

20274.6%20285.4%20295.9%20306.2%20316.6%20327.0%20337.4%20347.9%20358.3%20368.6%

Compound's Cash Flow tab, row 50. Property figures: SEC Form ABS-EE for BANK 2025-BNK49 and the BANK 2025-BNK50 term sheet. Debt terms are analyst assumptions on the Assumptions tab, priced off the 10-year Treasury yield of November 13, 2026.

The average over the ten years is 6.8%. No year reaches the 8.0% target from operations until Year 9, at 8.3%, so the return depends on the sale.

New fixed-rate debt beside the loan on the property

The new loan is $223,000,000 at 6.80%, and the loan now on the property is the same amount at 5.506%. Assuming the loan in place lifts the levered IRR from 3.4% to 4.5%.

Visa_Global_HQ_Core_Office_ProForma.xlsx
E37fx='Cash Flow'!E15/Assumptions!$D$82
BDE
30New loanIn-place loan
31Loan amount223,000,000223,000,000
32Interest rate (fixed)6.800%5.506%
33Loan-to-value at purchase price50.0%50.0%
34Year 1 debt service15,374,61112,448,913
35Year 1 DSCR1.72x2.13x
36Minimum DSCR over the hold1.72x2.13x
37Year 1 debt yield11.9%11.9%
38Repayment date (new: exit; in-place: ARD)12/31/203609/06/2034
39Levered IRR3.4%4.5%
40Equity invested at closing229,132,500229,690,000
SummaryAssumptionsRent RollCash FlowSources
The debt comparison from Compound's Summary tab, rows 30 to 40, with the empty column C left out. The in-place loan terms are from the BANK 2025-BNK50 term sheet. The new loan's spread, loan-to-value and interest-only term are analyst assumptions.

The request asked for fixed-rate debt priced off the 10-year Treasury. Compound took the spread from the property’s own loan. The term sheet gives that loan a 5.506% rate, and the 10-year Treasury was 3.87% on its note date of August 29, 2024, so the spread at origination was 1.64%. The model uses 1.65% over today’s 5.15%. The loan-to-value of 50.0% and the ten-year interest-only term also match the loan in place. The origination fee is 0.75%.

A 6.80% rate on a 5.94% cap rate is negative leverage: each borrowed dollar costs more than the property earns on it in Year 1. Coverage is still wide. The Year 1 DSCR is 1.72x, the lowest of the hold, and the Year 1 debt yield is 11.9%.

The term sheet describes the loan in place as six pari passu notes totaling $223.0 million, interest-only, with an anticipated repayment date of September 6, 2034 and a final maturity of March 6, 2038. After the anticipated repayment date the rate steps up by 4.00%. That date falls inside the hold, so the assumed-loan case refinances the balance then at the new-loan rate, with a 1.00% assumption fee at closing. In that case the Year 1 DSCR is 2.13x, the equity multiple is 1.39x, and the levered IRR of 4.5% is still below the target. The term sheet also describes a $72,000,000 mezzanine loan at 8.25%. The workbook shows it for reference and assumes it is repaid at closing.

The exit: rents marked to market, and the cap rate that earns the target

The base case sells at a 6.44% cap rate on NOI of $26,636,192, for $413,702,556. An 8.0% levered IRR needs a gross sale price of $559,539,400, which is a 4.76% cap rate on the same NOI and a 6.52% cap rate on the contract NOI of $36,473,201 (our arithmetic).

Visa_Global_HQ_Core_Office_ProForma.xlsx
D80fx=(D79+N42-N30)/(1-Assumptions!$D$96-Assumptions!$D$97)
BDN
23Going-in cap rate (Year 1 NOI / price)5.94%
24Exit cap rate (going-in + spread)6.44%
25NTM NOI at exit, contractual rents (memo)36,473,201
26NTM NOI at exit, rents marked to market26,636,192
27Gross sale price413,702,556
28Broker and closing costs(4,137,026)
29San Francisco transfer tax(24,822,153)
30Buyer credit for rollover within window after exit(19,396,494)
31Net sale proceeds ($)365,346,883
36Gross sale price per SF1,287
76Target levered IRR8.0%
77Base case meets target?No
78PV at target IRR of Years 1-10 levered cash flow from operations100,457,642
79Equity proceeds needed at sale to earn the target277,975,148
80Gross sale price needed559,539,400
81Breakeven exit cap rate for the target IRR4.76%
82Breakeven exit cap rate less going-in cap rate (bps)(118)
83Gross sale price needed per SF1,741
SummaryAssumptionsRent RollCash FlowSources
The exit block (rows 23 to 36) and the return-target block (rows 76 to 83) of Compound's Cash Flow tab. Column D holds rates and present values, column N holds Year 10 amounts. The values are as Compound wrote them.

The request asked for rents marked to market at the end of the hold. The buyer in 2036 gets a lease with 15 months left, by the agent’s count, and prices the building on what the space rents for after that. The model’s office market rent, grown at 2.5%, is $87.42 in 2038. The Summary sheet puts that 27% below Visa’s contract rent at expiry.

NOI in the model: contract rents and market rents at exit

Year 11 NOI sets the sale price. The model prices the sale on the market-rent figure

Year 1 NOI (2027)$26.5MYear 10 NOI (2036)$35.3MYear 11 NOI, contract rents$36.5MYear 11 NOI, rents at market$26.6M

Compound's Cash Flow tab, rows 15, 25 and 26. Market rent of $65.00 per square foot in 2026 dollars and its 2.5% growth are analyst assumptions on the Assumptions tab.

Three deductions come off the gross price. Broker and closing costs are 1.00%. San Francisco’s transfer tax is 6.00% at this value, from SF.gov, and the model assumes the seller pays it. The third is a credit of $19,396,494 to the next buyer for Visa’s rollover: a blended $47.50 per square foot of tenant improvements and commissions in 2026 dollars, weighted by the 75% renewal probability and grown to 2038. Net sale proceeds are $365,346,883.

The sale price works out to $1,287 per square foot, below the $1,388 paid. The unlevered IRR is 5.3% and the unlevered multiple 1.50x. With the new loan the levered multiple is 1.30x.

The return-target block works backward. It discounts ten years of levered cash flow from operations at 8.0%, finds the equity proceeds a sale must deliver, $277,975,148, and adds back the loan repayment, the rollover credit and the selling costs. The breakeven exit cap rate of 4.76% is 118 basis points below the going-in rate. Both of those rates use NOI marked to market. On the contract NOI the required price is 58 basis points above the going-in rate (our arithmetic), so the size of the gap depends on how a buyer in 2036 values the contract rent that remains.

Sensitivity: exit cap rate, market rent and leasing cost

No cell in the three sensitivity tables reaches the 8.0% target. The highest is 6.2%, with a 25 basis point exit spread and $75 market rent.

The Assumptions sheet holds three live Excel data tables. The first crosses the exit cap rate spread with office market rent at rollover:

Exit cap rate (spread over going-in)$55$60$65$70$75
6.19% (+25 bps)1.4%2.8%4.1%5.2%6.2%
6.44% (+50 bps)0.7%2.2%3.4%4.6%5.6%
6.69% (+75 bps)(0.0%)1.5%2.8%4.0%5.0%

Market rent moves the result more than the exit cap rate does. Along the base row, the IRR runs from 0.7% at $55 to 5.6% at $75. Down the base column, at $65, it runs from 4.1% to 2.8% as the exit spread goes from 25 to 75 basis points.

Levered IRR by office market rent at rollover

Exit cap rate held at the base case, 50 basis points over the going-in rate. Market rent in 2026 dollars, triple net

$55 office market rent0.7%$60 office market rent2.2%$65 office market rent3.4%$70 office market rent4.6%$75 office market rent5.6%Target levered IRR8.0%

Compound's Assumptions tab, row 156 (data table 1) and cell D14. Market rent values on the axis are the agent's sensitivity choices. The target is an analyst assumption.

The second table crosses the exit cap rate with a scale on all leasing costs:

Exit cap rate (spread over going-in)50%75%100%125%150%
6.19% (+25 bps)4.5%4.3%4.1%3.9%3.7%
6.44% (+50 bps)3.9%3.7%3.4%3.2%3.0%
6.69% (+75 bps)3.3%3.0%2.8%2.6%2.4%

Leasing cost matters least, because the only large leasing cost in the model is the credit at exit. At the base exit cap rate, halving it moves the IRR from 3.4% to 3.9%, and raising it by half moves it to 3.0%. The third table, market rent against leasing cost, is in the workbook.

The flags: four of five tests are on

The request named three conditions to flag, and the Summary sheet tests them in five rows. Four rows show a flag: two leases for rollover timing, one tenant for concentration, and the cap rate spread.

  • Visa Inc.: “FLAG: <=3y after”. The lease ends inside the three-year window after the sale.
  • Blue Bottle Coffee, LLC: “FLAG: in hold”. It is 0.6% of Year 1 base rent.
  • CTMR LLC: OK.
  • Single tenant above 50% of base rent: “FLAG: >50%”, at 97.5%.
  • Cap rate spread over the Treasury: “FLAG: spread below 150 bps”, at 79.

What the public data cannot tell you

CMBS filings and 10-Ks give the tenants, the income and the loan. They do not give the lease itself, the retail rents or the terms on which the loan could be assumed, and the agent’s answer lists what a buyer would ask the seller for.

  • The Visa lease and its amendments. The rent schedule and step dates, the triple-net terms, the notice dates and fair-market-value mechanics of the renewal options, any expansion or give-back rights, any sublease activity, and an estoppel. The model assumes the rent steps each September.
  • The retail leases. Blue Bottle’s rent is assumed at $75.00. The seller’s rent roll would also settle the status of the 7,341 square feet the model treats as vacant. The agent notes that other trusts holding the same loan list a different third tenant, with 690 square feet, and that the latest report it used names Blue Bottle.
  • Operating statements. The trailing twelve months, recovery reconciliations and the 2027 budget would replace one annualized quarter. The agent’s answer also lists the property tax reassessment at a sale.
  • The ground lease. The term sheet covers a ground lease, which the agent’s answer says runs to 2095. A buyer needs the transfer consent terms and any rent that participates in a sale.
  • The loan documents. The defeasance and assumption terms decide whether the 5.506% loan can stay in place, and the mezzanine loan needs a payoff figure.
  • A current appraisal. The agent’s answer points out that the $446 million is a July 2024 value “upon stabilization”, and that the same term sheet gives an as-is value of $409 million as of April 11, 2024. Neither is a price for late 2026.

Our view: what this model says about the deal

At the 2024 appraised value, contract rent from a rated tenant produces a 3.4% levered IRR in this model, and the gap to 8.0% comes from an exit priced on assumed market rent. The useful output is the list of inputs that would have to change, and by how much.

We would read the workbook in this order.

First, operations are steady and the sale is where the return is lost. Cash-on-cash averages 6.8%. The sale price is below the purchase price, because the next buyer pays for market rent and the model’s market rent in 2038 is below what Visa pays.

Second, market rent in 2038 is the input to test hardest. It is an analyst assumption about a year twelve years away, and it moves the IRR from 0.7% to 5.6% at the base exit cap rate. The appraisal’s $70.00 and the model’s $65.00 both sit inside the range of the REIT figures. Neither closes the gap.

Third, two inputs carry Visa’s 2038 expiration into the 2036 sale price: the mark-to-market switch that the request asked for, and the three-year rollover window that sets the credit to the next buyer. The contract NOI for the year after the sale is $9,837,010 above the marked figure (our arithmetic). Over the 15 months left on the lease that is about $12.3 million before discounting (our arithmetic), which the model’s sale price leaves out, and the $19,396,494 rollover credit is deducted as well. If you think a buyer in 2036 would pay for the remaining contract rent, change them and the sale price recalculates.

Fourth, keeping the 5.506% loan gives 4.5% against 3.4%. Whether it can be kept is a question for the loan documents.

Fifth, the price is the input the request fixed. A buyer who needs 8.0% would solve for the price that earns it, with a goal seek on the purchase price cell.

None of this is a view on what the building is worth or on whether anyone should buy or sell it. It is what one set of public filings and stated assumptions produce.

Visa Global HQ core office pro forma (Excel)Compound’s workbook from this run: Summary with the flags and benchmark checks, Assumptions with a source for every input and three live sensitivity tables, Rent Roll, Cash Flow with both loan cases and the breakeven exit cap rate, and Sources.Download · Free

FAQ

What is a core office pro forma?

It is a multi-year projection of income, debt service and sale proceeds for a stabilized office building with long leases to strong tenants. Because the rent is under contract, the pro forma’s main tests are the purchase price, the cost of debt and the exit value.

What exit cap rate should a core office pro forma use?

The common convention is the going-in cap rate plus a spread for the building’s age at sale. This model uses 50 basis points in the base case and shows 25 and 75. It also solves for the exit cap rate that earns the target return, so you can judge whether that rate is plausible.

What does marking rents to market at exit mean?

It means the sale price is set on the NOI the building would earn if every lease paid market rent, in place of the contract rent in the final year. When a lease pays above market and expires soon after the sale, the marked NOI is lower and so is the sale price.

How do you set a renewal probability for a single credit tenant?

Start from what the tenant has said and spent: its own capital in the space, its lease term and options, its headcount and its lease liabilities in the 10-K. Then weigh the contract rent against market rent at expiry. State the figure as an assumption and show a benchmark, such as a REIT’s reported retention rate, beside it.

Why compare the going-in cap rate with the 10-year Treasury yield?

The spread between them is what the buyer earns for taking real estate risk over a government bond of similar term. It also shows whether fixed-rate debt, which is priced off the same yield, will cost more than the property yields.

What is negative leverage in a real estate pro forma?

Negative leverage is when the interest rate on the loan is above the property’s cap rate. Borrowing then lowers the cash-on-cash return in the early years, and the levered return depends on NOI growth and the sale price to make up the difference.

CoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix ResearchCoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix ResearchCoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix Research

See this workflow on your own deal

Try it now