About this video
Ellie reads a Tokyo office's technical due diligence, including Japanese reports, and finds the seismic risk the IM understates.
Full description
The information memorandum and engineering report give Project Wisteria a 9.8% earthquake PML, assuming the 2006 retrofit covered the whole building. The Japanese completion report shows braces on floors 1 to 4 only. The buyer's seismic assessment gives 16.4%, above the lender's 15% limit. Strengthening costs ¥318m and brings PML to 9.5%, with the capex and price consequences laid out for the committee.
Key points
- Seismic PML traced back to what the retrofit actually covered
- Japanese completion report read against the English IM
- Loan condition breach found before signing
Transcript
Wisteria is a technical due diligence demo on a 1970s Tokyo office. The seller's memorandum puts 12 years of capital spending at 612 million yen and the probable maximum loss at 9.8%. Carale is bidding for the building and the investment committee meets on Thursday. The data room holds the memorandum, the engineering report, the inspections, the seismic assessment and the term sheet. The question, the technical section of the committee paper from the source documents only.
Ellie maps 11 documents in six folders and which feed each number. Click the 612 million and the engineering report opens on its summary table. The engineering report is 18 months old and found no urgent items. The statutory inspection afterwards found 14 fire shutters that do not close and the remedial quotation prices them at 88 million yen. Neither the defect nor the cost appears anywhere in the seller's memorandum. Then the seismic chain a step at a time.
The memorandum's 9.8% is quoted accurately from the engineering report, but the memorandum left out the condition that report attached. The retrofit calculations were not provided. The team asks Ellie to test that premise against the fund's own seismic assessment and the 2006 drawings. The 2006 retrofit stopped at the fourth floor. The seller's own completion report says so, and the floors above were left alone. The seismic assessment puts probable maximum loss at 16.4%, not 9.8.
The workbook consolidates the five reports into 754 million yen with a duplicate smoke fan counted once. Against the memorandum, it finds 142 million yen more. Then the seismic and loan tests strengthening at 318 million yen would bring the loss down to 9.5%. The dashboard shows where the money falls, 200 million in year 1 against 16. The earthquake premium is the largest number still unknown and Ellie leaves it at zero rather than invent one. The committee note follows the House template and cites every figure to its report and page.
It recommends a price adjustment of 104 million yen for the unpriced statutory works. The brief carries the same analysis for the committee. Click a figure and the page it came from opens alongside in Japanese or English. The seismic finding is the one that reaches the loan. A general model stops where the memorandum matches the engineering report. Ellie also reads the term sheet which caps the loss at 15%. A clean looking schedule becomes a loan condition that has to be priced before the binding offer.
From data room to cited IC memo
Video details
- Roles
- Investor / LP, Lender
- Processes
- Due Diligence, Acquisitions
- Geographies
- APAC
- Markets
- Japan
- Tags
- author-demo-2, technical due diligence, seismic, Japan