The S$85 million footnote (EN)

4:04 · English · Acquisitions

Watch this video

Enter your details to access the library. We'll email you a code to verify your address.

See how we use your data in our Privacy Policy.

About this video

Three deal documents in, every vendor claim rebuilt from source, and the buried break notice caught before the IC meeting instead of in it.

Full description

Treverton Commercial Trust screens Kelverton Tower, a S$400m off-market Singapore office acquisition offered by Halworth Asia Advisory for Carradale Asia Real Estate Fund IV. Ellie's Deal Pack Tie-Out skill rebuilds every IM claim from the tenancy schedule and T-12 with page-level citations, then surfaces three defects the vendor's numbers were hiding: a break notice buried in Appendix C note 7 worth ~S$85m at the vendor's own cap rate, a WALE quoted on an undeclared basis (4.5 years by income, not 5.3), and a levered IRR manufactured by a 25bps exit-cap assumption. The deal is scored against Treverton's mandate (negative leverage flagged) and the IC screening memo is drafted with an indicative offer range, every figure cited to source.

Key points

  • Every IM claim recomputed from source with page-level citations, never quoted from the brochure
  • The Appendix C break notice the headline NPI ignores: yield 2.8 percent, not 3.6
  • WALE by income versus by area surfaced explicitly, against the mandate's basis
  • 267bps of the claimed IRR is a single exit-cap assumption; held flat the return is 10 percent
  • Verdict scored against the buyer's mandate and an IC memo drafted with a revised-basis offer range
Transcript

This is a live deal pack exactly as it arrives from a broker. An investment memorandum, a tenancy schedule, and a trailing 12-month operating statement. Kelverton Tower, gradea office on Anson Road, 400 million Singapore dollars off market. The vendor's headline says 3.6% yield, 96% occupancy, a 5.3year WALE, and a 13.8% levered return. Every acquisition team knows what happens next. Two to three analyst days of retyping and reconciliation before anyone can trust a single number.

Watch what an analyst gets back before their coffee cools. The analyst asks Ellie to run a deal pack tie out. One instruction, one skill. Every vendor claim recomputed from source documents and nothing at any point quoted from the brochure as evidence of itself. First deliverable, the claim versus computed table. Every headline metric from the IM rebuilt from the tenancy schedule and the T12 and every figure cited to its document and page. Occupancy ties, passing rent ties, the gross income ties to the operating statement to the dollar.

The vendor's arithmetic is honest. What matters is what the arithmetic leaves out. Catch one. The IM quotes a WALE of 5.3 years and never states the basis. By floor area, it checks out. Ellie says so. By income, it is four and a half years because the anchor tenant pays $5.50 on 42% of the tower. Income is what pays distributions and income is the basis Treverton's mandate requires. Catch two is the one that ends careers when it is missed. Appendix C, note seven of the tenancy schedule.

Stratomere Cloud served notice on its break in May. The landlord has acknowledged it. The lease determines next June. 25,000 square feet and over 3 million a year still sitting inside the vendor's so-called stabilized NPI. Strip it out and the yield falls from 3.6 to 2.8. At the vendor's own cap rate, that one footnote is worth $85 million. Catch three lives on the returns page. 13.8% levered IRR. Illustrative. Ellie rebuilds the model and finds 267 basis points of that return.

Roughly a fifth of it is manufactured by a single assumption. An exit cap rate 25 basis points tighter than entry. Hold the exit flat at entry and the return is 10%. And underneath sits a sharper finding still on the vendor's own stated inputs. The 13.8 cannot be reproduced at all. A verdict is not a feeling. It is scored against the mandate. Geography passes, lot size passes, tenure passes, yield on verified figures fails, WALE by income fails, and at a 2.7 yield against 3.4% debt, the deal is negatively leveraged from day one, dilutive to distributions from completion.

Ellie's recommendation is judgment, not pedantry. The reversion story is real. So this is not a decline and walk away. Decline at 400, engage at a revised basis. And because the committee will ask, the memo is already drafted. Verdict on the first line. Verified metrics against every mandate test. The leasing risk quantified, including the downside if the broker's own tenancy walks at expiry. An exit cap sensitivity the vendor would rather you did not run.

And an indicative offer range of 315 to 325 million. Every figure cited back to the schedule and the operating statement. The analyst walks into committee holding the answers, not chasing them. Ellie did not kill this deal. She repriced it before the committee met from the documents the vendor supplied. That is the difference between reading a deal pack and tying one out. Two analyst days handed back and the career limiting footnote caught.

Fifth Dimension for deal teams

From data room to cited IC memo

Video details
Roles
Portfolio Manager
Processes
Acquisitions
Geographies
APAC
Markets
Singapore
Tags
treverton-deal-forensics