Bottom line
Seller ask values Canopy at +106% above modeled land + construction cost.
The seller asks PHP 1000M for the sale-and-leaseback portfolio. The five modeled Canopy sites carry PHP 486M of land + construction cost: PHP 188M land and PHP 298M building. Including interest and contingency, modeled total project cost is PHP 490M.
Ask above land + build
PHP 514M
106% premium to modeled land + construction cost
Modeled cost/unit
PHP 1.9M
Across 253 Canopy modeled units
Seller EV/unit
PHP 3.9M
Based on 255 seller units
How this figure is derived
PHP 514M = PHP 1000M seller enterprise value minus PHP 486M modeled land + construction cost. Seller EV is extracted from Acquisition scenario - Sale & Leaseback v7.5cap (1).xlsx, sheet 7.5cap, row 20. Modeled land and construction costs are extracted from 260414 - CanopyOperatingModel - Existing Projects SHORT TERM updated (1).xlsx, sheets BalabacAssumptions, AgutayaAssumptions, GraciaAssumptions, GabongAssumptions, and ColSantosAssumptions, rows 71-72. Premium = PHP 514M / PHP 486M = 106%.
Against total modeled project cost including interest and contingency, the seller ask is PHP 510M higher, or 104% above cost.