CWP 1.43% $4.95 cedar woods properties limited

Hartleys Forecasts, page-20

  1. 1,158 Posts.
    lightbulb Created with Sketch. 593
    Because of the peculiarities of the inventory accounting method CWP uses (the only other developer that ignores capital appreciation is VLW), despite superficial analysis saying that CWP trades at a premium to NTA, this premium is justified given the unbanked capital appreciation that is hidden on the balance sheet. The sentiment about the housing market has caused the current drop in SP, despite the fact that a significant proportion of the next few years' revenue is from Perth (where the market has bottomed), Adelaide (where the market never rose), Brisbane (which has demographic tailwinds) and protected pockets of Melbourne.

    Historically, the returns of CWP can be predicted by looking at the price/NTA ratio. By my reckoning this HY report the ratio will be close to 1.
    Historically, this ratio was 0.89 in 2009 (share price was 1.42) and 12 month return was 73% (+ dividends) and 1.12 in 2016 (share price was 4.35) and 12 month return was 20% (+ dividends). Whilst I can't predict what will happen with the share price with any accuracy whatsoever, this is one of my sleep-easy investments, and I look forward to improving metrics with higher debt in this part of the cycle and of course the first year in a series of dividend upgrades (hopefully!).

    My full spreadsheet below FYI. 

    https://hotcopper.com.au/data/attachments/1449/1449410-eccb8bedadb67765dd3682d9c44c5179.jpg

    30/06/200630/06/200730/06/200830/06/200930/06/201030/06/201130/06/201230/06/201330/06/201430/06/201530/06/201630/06/201730/06/2018
    Revenue80.59081.9107108.4131.8170.5172.8214.5178.6175222.3239.7
    Cash receipts87.898.778.3119.3119.4143.8184.3186.1231.6194190.1239.7265.1
    Net operating cashflow5.2-14.9-7.633.117.8-733.2-14.8-1.88.54.30.6-6.55
    Cash/revenue109%110%96%111%110%109%108%108%108%109%109%108%111%
    EBIT25.931.331.21726.841.553.15356.261.265.667.465.1
    Finance cost2.84.52.23.421.23.81.60.63.43.82.94
    Operating profit before tax23.126.82913.524.740.249.351.455.657.861.864.561.1
    Tax6.98.28.54.37.512.21515.115.315.218.219.118.6
    NPAT16.218.620.59.217.22834.336.340.342.643.645.442.6
    Net margin20%21%25%9%16%21%20%21%19%24%25%20%18%
    Current inventories37.33940.944.636.746.663.576815955.695.1183.1
    Non-current inventories135.7104.3121.9103.4148.1155.8144.8175250251311.5327314.7
    Total inventories173143.3162.8148184.8202.4208.3251331310367.1422.1497.8
    Rev/last inventories
    52%57%66%73%71%84%83%85%54%56%61%57%
    Rev/current inventories
    241%210%262%243%283%269%272%282%220%297%400%252%
    Total assets196.4155.6185162.7205.7233.6238.3301409.9383.3453505.6601.5
    Total liabilities127.983.910169.496.910453.793.3148.397.7145.5175.4248.3
    Equity68.571.78493.3108.8129.5184.6207.7261.6285.6307.2330.2353.2
    Shares on issue54.554.855.158.260.661.872.273.478.378.978.978.979.5
    Share price4.485.222.751.422.4543.565.177.315.264.355.26.2
    Market cap244.2286.1151.582.6148.5247.2257.0379.5572.4415.0343.2410.3492.9
    Price/NTA4.043.981.810.891.361.901.371.832.191.451.121.241.40
    EPS29.733.937.215.828.445.347.549.551.554.055.357.553.6
    DPS151718713232526202828.53030
    EBIT margin32.234.838.115.924.731.531.130.726.234.337.530.327.2
    ROE24262410162219171515141412
    NTA1.111.311.521.61.82.12.62.833.343.623.894.194.44
    Change NTA
    18%16%5%13%17%24%9%18%8%7%8%6%
    Net debt-29-63.7-80.6-47.9-39.7-55-3.8-37.8-32.6-27.9-52-87.3-132.8
    Debt/equity42.388.896.051.336.542.52.118.212.59.816.926.437.6
 
watchlist Created with Sketch. Add CWP (ASX) to my watchlist
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.