Sunday, January 18, 2009

Ascendas Reit: Accounting for recession

Following the previous post, I estimate their yield after adjusting their revenue downwards to account for the recession. Aim is to see if we take assume a conservative scenario, do we still have a margin of saftey.

I get a DPU of 10.9c. At Friday's price of $1.27, this is an 8.6% yield.

If they had not issued the shares, and instead taken out a loan for the 400M at 7% (like Cambridge did) giving an additional 28M interest payments a year (added to the 57M), and we still had the same revenue cuts as below, then their DPU would have been about 10.8c per share. About the same I guess.

Assumptions and calculations for downward revising of revenue are below. Analysts call this a 'stress test'. I call it some 'calculations on the back of an envelope'.

How much should I decrease their revenue by?
  • Firstly, some tenants may go bust. A report by CIMB says that in the 2004 recession, defaults were 1.8%.
  • I'm going to use 4%.
  • Most of their larger tenants are make up 2% of their revenue, so the above represents two tenants going belly up (and AReit being unable to re-rent out their buildings for 1 year).
  • Secondly, rentals may be revised downwards. But most of their tenants are on long leases. See the green bars for the lease expiry as of Mar 08:
  • 16% and 15% of their lease revenue expires in 09/10 respectively (total of 31% over 2 years). I'm going to conservatively assume that to keep their customers, they cut the rent 20% for them. This would mean that by 2010, rend is reduced by 7%.
  • So we have an 11% discount in total (4% + 7%).
What effect does this have on DPU?

Using the final calculations from the previous post:

Revenue: 363 (reduced by 11%)
Interest costs: 45
Non-Interest costs: 135
Profit for distribution: 183 (divided by 1679 shares gives DPU of 10.9c).


nana said...

That's actually really cool!AV,無碼,a片免費看,自拍貼圖,伊莉,微風論壇,成人聊天室,成人電影,成人文學,成人貼圖區,成人網站,一葉情貼圖片區,色情漫畫,言情小說,情色論壇,臺灣情色網,色情影片,色情,成人影城,080視訊聊天室,a片,A漫,h漫,麗的色遊戲,同志色教館,AV女優,SEX,咆哮小老鼠,85cc免費影片,正妹牆,ut聊天室,豆豆聊天室,聊天室,情色小說,aio,成人,微風成人,做愛,成人貼圖,18成人,嘟嘟成人網,aio交友愛情館,情色文學,色情小說,色情網站,情色,A片下載,嘟嘟情人色網,成人影片,成人圖片,成人文章,成人小說,成人漫畫,視訊聊天室,性愛,a片,AV女優,聊天室,情色

吳建豪Alex said...