POH 0.00% 0.0¢ progress 2023-2 trust

TP - still not correct.  The last column is out by a factor of...

  1. 729 Posts.
    lightbulb Created with Sketch. 81
    TP - still not correct.  The last column is out by a factor of 10 and the scaling is incorrect.  Suppose on your spreadsheet the Award Amount is in US$ and the Converted Award is in AUD (seems to be how it works).  Also suppose that the Converted Award is in column G, then the formula for the return to Shareholders (also in AUD) needs to be something like

    =if(Gn<=50000000, 0.3 * Gn, If(Gn > 100000000, 0.7 * (Gn - 100000000) + 40000000, 15000000 + (Gn - 50000000) * 0.5))

 
watchlist Created with Sketch. Add POH (ASX) to my watchlist
(20min delay)
Last
0.0¢
Change
0.000(0.00%)
Mkt cap ! n/a
Open High Low Value Volume
0.0¢ 0.0¢ 0.0¢ $0 0
POH (ASX) Chart
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.