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
34.0¢ |
Change
0.015(4.62%) |
Mkt cap ! $236.1M | |||
| Open | High | Low | Value | Volume |
| 32.5¢ | 34.0¢ | 32.0¢ | $436.6K | 1.328M |
Buyers (Bids)
| No. | Vol. | Price($) |
|---|---|---|
| 1 | 250124 | 33.0¢ |
Sellers (Offers)
| Price($) | Vol. | No. |
|---|---|---|
| 34.0¢ | 9631 | 1 |
View Market Depth
| Last trade - 16.10pm 14/06/2024 (20 minute delay) ? |
|
|||||
|
Last
33.5¢ |
Change
0.015 ( 4.69 %) |
||||
| Open | High | Low | Volume | ||
| 32.5¢ | 33.5¢ | 32.0¢ | 494100 | ||
| Last updated 15.58pm 14/06/2024 ? | |||||
| FEX (ASX) Chart |