I'm having a lot of trouble figuring out how to calculate future total mining using historical difficulty in my excel sheet. I assumed that if difficulty increases 10%, I would mine 10% less... But this does not seem to be correct, seems if I use average historical monthly difficulty increase to predict the future with a 1 to 1 ratio on bitcoin mined, it decreases too quickly. Please let me know how I should calculate this.
My assumption:
Last month I mined 1 BTC. This month difficulty has increased 10%. How many BTC will I mine this month?
Answer: 0.9 BTC