About this video
A fund's deal team keys a broker's data-centre case into its Anaplan pipeline model; Ellie ties every input back to the pack and to the line item, finds the three variances the model inherited and writes the verified case back.
Full description
Sembrook Data Center Partners I screens Cipher Kaki Bukit DC, a 28 MW Singapore colocation data centre offered at S$620m, and its analyst has keyed the broker's case into the fund's Anaplan pipeline model. Ellie runs the Deal Model Tie-Out: every model input rebuilt from the deal pack, IM vs model vs verified side by side with a citation to the page and to the model line item. Ties first, then three variances the model inherited from the pack: power that is not passed through on 7 MW of all-in fees against an 18 per cent tariff reset, a served non-renewal disclosed only in a schedule footnote, and a 5.00 per cent exit cap against a 5.61 per cent entry. The house case reruns to a 12.3 per cent levered IRR, the mandate's first-anniversary yield test binds, and the recommendation is to renegotiate at or below S$515.2m. The IC screening memo lands on the house template and the verified case is written back in UW01's own import layout, a source on every line.
Key points
- Every deal has two versions, the pack and the model; Ellie reconciles them with two citations per figure
- Three variances the model inherited: power recovery, the tariff reset, the served notice in a footnote
- The exit cap does a quarter of the promised return; house convention holds it at entry
- The verified case goes back into the planning model in its own import layout
Transcript
Every deal has two versions. The one in the broker's pack and the one an analyst keyed into the planning model. Nobody reconciles them until the committee asks why the returns moved. Project Graphite, a 28 megawatt colocation data center in Singapore. 620 million asked. The pack is here. The IM, the contract schedule, the T12, the customer contracts, the utilities letter. And so is the model. The fund runs its pipeline in Anaplan. Kavya keyed the broker's case into it last Wednesday.
And this is the screening dashboard. She exported 16.3% levered year 1 NOI equal to stabilized NOI power cost recovery 100% exit cap 5%. Every one of those is the broker's number. One keystroke from being the funds number. Ellie ran the deal model tie out and published the answer as a brief. Every line item in the model rebuilt from the documents and held against the IM. Three columns ties first. Price, load, occupancy, fees, recharges, all tie to source, then the rows that do not.
One, power cost recovery is 73 and a half% not 100. The IM says electricity is a full pass through to customers. Page nine. The contracts say otherwise. Two of them 7 megawatts are all in. The fee is inclusive of electricity capped at 3% a year. No tariff mechanism. The model carries recovery at 100%. It had the number the IM gave it. Two, electricity resets 18% from January. The suppliers renewal offer is in the pack. 26.6 cents a kilowatt hour against the 22 1/2 the whole T12 sits on.
Three Holroyd 2.4 megawatt served notice in July that it will not renew. The IM profiles it as a continuing customer. The schedule discloses it in a footnote clause 3.3 12 months notice served on the 2nd of July. 6 million of fees end in August next year. The model's year 1 equals stabilized and its cash flow grows Holroyd's fee through 2031. That is the number the footnote removes. And the exit cap 5% against a 5.6 entry a quarter of the promised return.
House convention says exit no tighter than entry. So Ellie holds it there. Ines then set the house case relet the suite after a 12-month void at 230 a kilowatt net the tariff against the escalation the fees allow Ellie reran it 12.3% levered at the guide price not 16 the 14% floor clears at 595 million but the mandate tests the yield again on the first anniversary after every disclosed departure that test binds first renegotiate at or below 515 million.
Eight of 10 criteria pass at that basis. Power recovery fails at any price. That is a contract fix before completion not a discount. The whole position is a brief republished as revision two verified yield anniversary yield recovery IRR multiple. And underneath the three-way table, the IM page, the model line item, and the verified figure on every row ties first, then the rows that do not tie. Passing NOI, the IM prints 34.8 million and calls it stabilized.
Page three verified from the schedule and the T12 33.1 million on day 1. 27 after Holroyd leaves. The model carries the IM's number. Power cost recovery. The IM says full pass through. Page nine. The contracts say 73 and a half%. The model says 100 because that is what it was given. The IC screening memo is on the house template for Friday. Every figure carrying two citations, the page it came from and the line item it feeds and the verified case goes back into the model. the way the broker's case came out.
An import file in UW01's own layout. A new version, a source on every line, the broker's version untouched. The model is not the product. The evidence is
From data room to cited IC memo
Video details
- Roles
- Portfolio Manager, Investor / LP
- Processes
- Acquisitions
- Geographies
- APAC
- Markets
- Singapore
- Tags
- sembrook-dc-model-tieout, anaplan, data-centre, briefs, citations, singapore