Cool. And thanks for sharing. Keith should make it a permanent element of the site. The same variables plugged into a popular on-line calculator would have given a royalty figure of $5,317 in the first year for a 10MM well and $7,976 for a 15MM. A 67% differential. The on-line calculators just aren't configured to account for the HS decline.
So if i read this right you are saying in your first example the first year would produce a total royalty of $5332.00 for one acre? And if that is what you are saying all you would have to do is multiply that by the amount of acres that you have?
Since old dog has recalculated the royalty estimation in this discussion topic post, I'll change my comment above. Your figures are close to what most of the on-line calculators would give. Therefore, I believe it is high by ~67%.
High by ~ 67% ? What do you mean? When I compare the result of 1 acre in 640 acre section at 25% royalty on 10MM/day well in the online calculator to the result in my spreadsheet, the spreadsheet is high by $15 the first year, is this what you mean? For each following year, I subtract 85% and so on for yearly figures. I show my decline as starting the second year, should I subtract the 85% from the first year?