About this video
Ellie checks the basis of every vacancy figure and re-ranks a fund's Tokyo submarket shortlist before the committee votes.
Full description
Halverstone's Asia fund draft strategy ranks Osaki first on 2.4% vacancy, but that is the five central wards' figure. Ellie finds Osaki's own 6.9% in the market report, a 38,000-tsubo 2027 supply wave (3.3 years of take-up) and six months rent-free in a Japanese leasing memo, which she quotes and translates. Re-scored on the paper's own weights, Osaki falls from first to fourth and Nihonbashi leads.
Key points
- Every vacancy rate stated with publisher, numerator and universe
- Japanese source quoted and translated
- Ranking corrected on the fund's own weights
Transcript
Halverstone is a research demo about a Tokyo office allocation for the firm's fourth fund and whether the draft ranking behind it holds. The draft strategy paper ranks five submarkets for the committee on the 8th of October with Osaki first. The data room holds that paper, the funds guidelines, a leasing memo in Japanese, and the research, a market report, a yield survey, a capital flows note, and the submarket data. The analyst works through it with Ellie, one step at a time.
First, what is in the room? Then the paper's five submarkets and the weights behind them. Ellie traces the papers 2.4% vacancy for Osaki. Osaki sits outside the five central wards in Shinagawa. 2.4 is the rate for the five central wards. on page four of the market report. On the same basis, the report's own submarket table puts Osaki at 6.9%. The paper is 4 and a half points out and it is rising for a sixth consecutive quarter, the only one of 15 submarkets where vacancy rose. occupiers are moving into new buildings completing in 2027.
38,000 tsubo of them. The leasing memo in Japanese says the same thing from the street and Ellie translates it. 6 months rent-free is now the standard offer on both new and existing buildings. The shortest terms are in Nihonbashi. The study lands as a scorecard workbook. Vacancy by publisher and definition side by side. Supply against takeup rents in yen per tsubo excluding service charge. Rescored on the papers weights with only vacancy corrected.
Osaki falls from first to fourth and Nihonbashi leads. The dashboard the ranking before and after the vacancy basis for each submarket. the supply wave by year and the rents and yields behind each score, each with its source. Then the committee paper on the funds template. It recommends Nihonbashi as the lead with Shibuya as the alternative. It records each correction including a Shibuya rent quoted with service charge. Its basis table gives the publisher and definition behind every figure.
This is the finding a general model is likely to miss. Every figure in the paper comes from a real report. The error is in the basis, a headline for one group of wards read as the rate for a submarket outside it. The weights stay fixed. Each input goes back to its published source. Before the committee votes, not after the fund buys. One data room in, one defensible allocation out.
From data room to cited IC memo
Video details
- Roles
- Portfolio Manager, Investor / LP
- Processes
- Acquisitions, Portfolio Analytics
- Geographies
- APAC
- Markets
- Japan
- Tags
- author-demo-2, market research, Japan, submarkets