I am aware that tools such as this one and this one exist to calculate estimated mining profits. I would like to essentially recreate these in Excel (with perhaps a few additional features).

Fileds to use: Hash rate, power, power cost, difficulty, block reward, pool rejects, pool fees, XMR/fiat, and hardware costs.

Ideally, I would then use this information to estimate mining profits in the future (6 months, 1 year, 2 years, 3 years, etc) using the reward curve and projecting a difficulty over time. It would also be cool to mess around with the price of Monero over time, for example assuming the price will increase 5% a month on average or something like that. I want to be able to manipulate the variables to compare profit possibilities.

Does anyone have any thoughts of how to do this? I can make an Excel document, but I do not know what calculations to put into Excel.