Keep the tenant, or find one who pays more? (EN)

3:34 · English · Asset Management

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

Strand's warehouse lease at Tuas South ends in a year, and a new tenant would pay more. Ellie shows why keeping Strand earns S$563k more.

Full description

A logistics trust's leasing team has 61 leases across Singapore, Japan and China and a rent roll per market. Ellie reconciles the rent rolls against the signed leases and amendments, finds the renewal notice date the diary has wrong and six break rights no system records, then models renew against relet in Excel on the committee's own assumptions: keeping Strand earns about S$563k more over 36 months, a new tenant only wins if the unit is empty for under 1.64 months, and Strand's 800 kVA need against the 780 kVA certified is flagged before anything is priced. Fictional data.

Key points

  • The rent roll says 31 March 2027; the signed amendment says 31 December 2026, so a rent-roll reminder fires after the option has lapsed
  • Empty months, rent-free and fees eat the higher rent: keep Strand, +S$563k over 36 months
  • Break-even void of 1.64 months, tested in a separate scenario workbook
  • Every figure clicks back to its page and Excel cell
Transcript

One logistics trust, eight parks and 61 leases across Singapore, Japan and China. Three decisions sit at the bottom of this tree. The first is Strand Logistics in unit A1 at Tuas South. Does Strand stay? This is the leasing team's workspace. Three markets, three languages, 61 leases, and a rent roll for each market that the property manager exports every month. The question on the table is strand, keep them at $24, find a new tenant at 240 or move them to block B.

Before deciding anything, Ellie reconciles the rent rolls against the signed leases and amendments. 26 places where they disagree across 23 leases. The one that matters is here. The rent roll says Strand's renewal notice is due at the end of March 2027. The signed amendment says the end of December 2026. Open the citation and the amendment is on screen. Clause 4.1 received and countersigned. Set your reminder from the rent roll and it fires 59 days after the option has lapsed.

Time is of the essence in this lease. The option simply goes. Six tenant break rights appear in no system at all. This one lets Marstone leave at the end of 2027 on 6 months notice and the register's break column is blank. Now the decision. Ellie builds it in Excel on the leasing committee's own assumptions. 36 months of undiscounted rent, four months empty, two rent free works and fees. Keeping strand earns $563,000 more than releting at the higher rent.

The break even void is 1.64 months. Find a new tenant faster than that and releting wins. Nobody in this market does. Kunshan is the same question in another currency. Accept Marrfield's offer. Holding out needs 93% confidence that they stay. Then the condition nobody put in the model. Strand needs 800 KVA. The lease certifies 780. Open the lease and the figure is on the page. Block B's 900 is not certified and the survey contradicts itself. Ellie flags it as the open point and prices nothing she cannot evidence a one-mon void instead of four.

Ellie keeps the base model untouched and builds the scenario in a separate workbook. Releting now leads by 153,000 but 240 is an asking rent. At every rent actually signed nearby renewal still wins. The committee's own instructions set the void and rent-free assumptions. Open them and the figures Ellie used are the figures on the page. The final brief opens with a map of the evidence and the decisions it feeds. Change the void. The answer flips. Every term is labeled executed, proposed or assumed, and every number opens the page it came from. Renew strand once the power gap has a price except Marrfield. Leave block B open.

Fifth Dimension for asset managers

Asset performance, always current

Video details
Roles
Asset Manager, Portfolio Manager
Processes
Asset Management, Lease Abstraction
Geographies
APAC
Markets
Singapore
Tags
author-demo, logistics, leasing, Singapore