RE: For the spreadsheet jockeys3 Apr 2021 18:09
@Tradecraft, it occurred to me it might be possible to estimate the 58%, 62% & 65% quantities in the stockpiles if we assume the first 2 years in your spreadsheet are from the 1.39Mt stockpiles and the 62% is sold for $61/t and the 65% for $80/t as in later years.
Dollar revenues from your spreadsheet:
58% = 8,710 * 2 = $17,420k
62% = 23,516 * 2 = $47,032k
65% = 15,231 * 2 = $30,462k
62% quantity = $47,032k / $61/t = 771.016kt
65% quantity = $30,462k / $80/t = 380.775kt
Therefore 58% quantity is 1,390kt - 771.016kt - 380.775kt = 238.209kt
Which means that by this estimation the price per tonne of the 58% Sinter used in the JRP is:
$17,420,000 / 238,209t = $73.13/t
call it $73/t, not that it matters much, but you did ask ;-)
What's probably more important is now that we know the split between the different types it's possible to get an improved estimate of the value of the stockpiles using today's spot:
http://www.custeel.com/en/csi.jsp
===[
Date Seaborne index 62% Fe fines Seaborne index 65% Fe concentrates premium Seaborne index 65% Fe fines
2021-04-02 166.50 7.80 196.50
]===
We don't know the sale prices for each type, but I'm happy to use the following in my estimation:
62% Spiral = $166.5/t
65% Pellet Feed = $196.5/t + $7.80 = $204.3/t
58% Sinter (Estimate halfway between the two) = $185/t
Going with these broad estimates the revenues from each type in the stockpiles would be:
58%: $185/t * 238.209kt = $44,068k
62%: 166.5/t * 771.016kt = $128,374k
65%: $204.3/t * 380.775kt = $77,792kt
Totalling $250,234k call it $250m. Compared with $82m using the, what has now transpired to be conservative, prices in the JRP. :-)))
Just my own estimates. Please let me know if there are any logic or calculator errors! ;-)
Ob.