WAK 1.96% 5.0¢ wa kaolin limited

Wolfgang I created a new model that is simpler, and more...

ANNOUNCEMENT SPONSORED BY PLUS500
ANNOUNCEMENT SPONSORED BY PLUS500
CFD TRADING PLATFORM
CFD Service. Your Capital is at risk
CFD TRADING PLATFORM CFD Service. Your Capital is at risk
ANNOUNCEMENT SPONSORED BY PLUS500
CFD TRADING PLATFORM CFD Service. Your Capital is at risk
  1. 4,240 Posts.
    lightbulb Created with Sketch. 1233
    Wolfgang

    I created a new model that is simpler, and more flexible. The effect of different tonnages sold is date driven, and the focus is on tonnage capacity expressed in tonnes per annum (tpa) assumed to apply at nominated dates, which need not be at nameplate capacity. The model does not consider plant numbers, or their nameplate capacity, or their used capacity.

    Because I use an EBIT multiple to derive share value, I need an the EBIT. Breakaway mooted $19.1m EBIT for 380,000tpa in FY25. However, that EBIT must be based on a CIF of $92.2/.380 to suggests revenue uses $242.63 a tonne, whereas the report mentions $310 per tonne as a recent CIF price. A crude assumption that all metrics increase in the ratio of 310/242.63 suggests that the $19.1m EBIT be increased to ($19.1)*(310/($92.2/.380)) to be $64.22 a tonne. This is a topic that may elicit debate.

    The EPS is diluted by all the options and issues, which tallies to 567,824,315.

    In the example below I inserted 600,000 tonnes twice, each with a different capacity-used date. The model's Present Value calculation explains the lower estimated Share Value for the later date. The dates can be any date, so reaching a tonnage-sold rate expressed in years (tpa) is unconstrained. It takes about nine months to build a plant, and one must assume how long it then takes to be producing at the pace of tonnage nominated, which need not be in 200,000 mta steps. The model does not consider the number of plants actually used to produce the tonnage chosen. The 600,000 tpa in the sample model as at 31/12/2027 could be spread over more than three 200,000 tpa plants, so conceptually at 31/12/2027, or any specified date, there could four plants, with the total nameplate capacity exceeding the tonnage specified.

    Row 15 shows the logic used for "Row 9, which must be cut and pasted for rows for different tonnages. Logic for Excel should be similar.

    We can assume that WAK is aiming to produce a million tonnes a year, because Management has opined that. We know the rail link will be reconnected circa mid-2026, because the Minister has stated a vague "in 2025". We know that Management is keen on entering the paper-grade kaolin field, which requires an add-on step plannedto be done at the Wedin rail siding. We know that grade of kaolin,K99P, attracts a premium price. My model would need to be changed to handle these things, so I suggest selecting a tonnage sold between 400,000 tpa and 600,000 tpa. One could go beyond 600,000 tpa later,but as the model stands, one would have to use standard kaolin (K99S) as a proxy for whatever tonnage and grade is sold in future.

    My model now looks like the following.

    Column 1 Column 2 Column 3 Column 4 Column 5 Column 6 Column 7 Column 8
    1 {colgroup}              
    2 {col=86x@}{/col}{col=86x@}{/col}{col=86x@}{/col}{col=86x@}{/col}{col=86x@}{/col}{col=86x@}{/col}{col=86x@}{/col}{col=86x@}{/col}              
    3 {/colgroup}              
    4 Current date 16/01/23            
    5 Interest PV 7.00%   Breakaway Adjusted      
    6 EBIT a tonne $64.22   50.263 64.219      
    7 EBIT multiple 8            
    8 Shares 567824315            
    9                
    10                
    11 TPA At capacity Days hence Interest used EBIT $m EBIT PV $m EBIT PV per shr Shr value
    12 200000 31/12/23 349 6.6831% 12.844 11.986 $0.021 $0.17
    13 400000 31/12/24 715 14.1721% 25.688 22.047 $0.039 $0.31
    14 600000 31/12/26 1445 30.7156% 38.532 26.697 $0.047 $0.38
    15                
    16 600000 31/12/27 1810 39.8657% 38.532 23.171 $0.041 $0.33
    17                
    18 Row 9 logic   B9-B$1 (1+B$2)^(C9/365)-1 B$3*A9/1000000 E9-D9*E9 F9*1000000/B$5 B$4*G9
    Last edited by Pioupiou: 16/01/23
 
watchlist Created with Sketch. Add WAK (ASX) to my watchlist
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.