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))
TP - still not correct. The last column is out by a factor of...
-
- There are more pages in this discussion • 127 more messages in this thread...
You’re viewing a single post only. To view the entire thread just sign in or Join Now (FREE)
Add AVE (ASX) to my watchlist
 (20min delay)
|
|||||
|
Last
0.3¢ |
Change
0.000(0.00%) |
Mkt cap ! $9.507M | |||
| Open | High | Low | Value | Volume |
| 0.0¢ | 0.0¢ | 0.0¢ | $0 | 0 |
Buyers (Bids)
| No. | Vol. | Price($) |
|---|---|---|
| 49 | 87977619 | 0.2¢ |
Sellers (Offers)
| Price($) | Vol. | No. |
|---|---|---|
| 0.3¢ | 60194641 | 22 |
View Market Depth
| Last trade - 09.59am 22/08/2024 (20 minute delay) ? |
| AVE (ASX) Chart |
Day chart unavailable