Is your pipeline tracker showing the right deadline? (EN)

3:25 · 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

Ellie checks a deal pipeline against the latest broker letters and catches a bid deadline brought forward four weeks.

Full description

Marrowstone's US pipeline tracker shows Folsom Corridor final bids due 30 October, a placeholder from a September call. The broker's Round 2 letter of 18 September moved final offers to 5 p.m. PT on Friday 2 October, and the fund's guidelines need approval before a binding offer, so Tuesday 29 September is the last committee.

Key points

  • Tracker dates checked against the broker's letters
  • Guideline approval timing mapped to the new deadline
  • Pipeline dashboard rebuilt from source
Transcript

Marrowstone, an investor based in Tokyo, is buying property in the United States with an investment committee on Tuesday and a $250 million equity allocation. Three live deals take 235.3 million of it, leaving 14.7 million of headroom. The team's pipeline tracker, the broker letters, offering memoranda and seller notes all sit in one data room. Ellie was asked to build the pipeline from the documents and to say where the tracker disagrees with them.

Its first finding changes the agenda, offers close Friday, the 2nd of October. The broker's letter dated the 18th sets 5:00 p.m. Pacific and supersedes any earlier timing. Yet the tracker updated on the 22nd still shows Folsom Corridor in round one with final bids at the end of October. The letter confirms Marrowstone is one of four parties invited to the final round and every final offer must confirm that internal approvals are already held. Approval cannot follow the bid.

So Tuesday is the last scheduled committee before the deadline. Ellie then tests each deal against the guidelines. Folsom yields 6 and 1/4% against a minimum of 5 and 3/4. Halverbrook, the Atlanta distribution center, yields 5.5% at the seller's price. It only fits at about $160.7 million. The pipeline lands as a dashboard. Three live deals and each card opens its figures and sources with Marlo on Marrowstone's own value. Every deadline comes from the latest letter, not the tracker.

The mandate tests sit on their own tab. The allocation shows 14.7 million of headroom and the corrections show where the tracker disagrees with the letters. Behind it is a workbook with live formulas, the pipeline, the deadlines from the letters, 7 days to the final offer, and every tracker correction with the document on each side. And the brief the committee reads, "One decision cannot wait. Approve the Folsom offer and set the ceiling price. Click a figure and its source opens beside it.

The tracker was 4 weeks out on the one date that mattered. A model working from the tracker would have shown a deal 5 weeks away. Ellie read the letter behind it and put the decision before Tuesday's committee, not after Friday's deadline. Every document in one pipeline the committee can act on.

Fifth Dimension for deal teams

From data room to cited IC memo

Video details
Roles
Portfolio Manager, Investor / LP
Processes
Acquisitions, Portfolio Analytics
Geographies
US
Markets
United States
Tags
author-demo-2, pipeline, dashboard, deadlines