Great effort X, looking better. But for the hedged periods your calculations are treating all sales as at the hedged price rather than the 45% of production (can see as sales are constant even though spot price is decreasing).
I think the IO price is too high (not asking you to remodel, just an opinion). It's a lower grade than FEX, but would suggest using prices below
https://www.cmegroup.com/markets/metals/ferrous/iron-ore-62pct-fe-cfr-china-tsi-swap-futures.quotes.html#
FEX Valuation, page-325
Add FEX (ASX) to my watchlist
 (20min delay)
|
|||||
|
Last
31.5¢ |
Change
-0.005(1.56%) |
Mkt cap ! $218.8M | |||
| Open | High | Low | Value | Volume |
| 32.0¢ | 32.0¢ | 31.0¢ | $184.0K | 581.7K |
Buyers (Bids)
| No. | Vol. | Price($) |
|---|---|---|
| 7 | 158934 | 31.0¢ |
Sellers (Offers)
| Price($) | Vol. | No. |
|---|---|---|
| 31.5¢ | 8616 | 1 |
View Market Depth
| Last trade - 16.10pm 21/05/2024 (20 minute delay) ? |
|
|||||
|
Last
31.5¢ |
Change
-0.005 ( 1.56 %) |
||||
| Open | High | Low | Volume | ||
| 32.0¢ | 32.0¢ | 31.5¢ | 388999 | ||
| Last updated 15.22pm 21/05/2024 ? | |||||
| FEX (ASX) Chart |