In order to properly create a useful bitcoin calculator, you need an Excel spreadsheet that has components like this:
Put the price that you know of under the $ column.
Label the months
Click on the D column, under Difficulty + 10%, and place the same value you put beside the Current difficult in previous step, in this case it's (=B6)
Click under the result (1), type =D2+(D2*($B$7/100)), press enter (2), and double click on the small square (3).
Click under Coins/day (1), and type =$B$9*(86400/(D2*((2^32)/($B$2*1000000000)))) (2) and double click on small square (3). Note: 86400 is the seconds in a day.
Click under revenue/day (1), type =E2*$B$9 before pressing enter, and double click on the square (3).
Click under net/day (1), type =F2-($B$3*($B$4/1000)*24) then enter (2), and double click on the small square (3).
Click under Per month (H) column, type =SUMPRODUCT(--(G2-((G2-G3)/30)*ROW(INDIRECT(1&":"&30)))) (2) and double click on the small square (3).
Click empty cell in column G and write Net Annual (1), then beside it on (H) and type =SUM(H2:H13)-B6 and press enter (2)
Of course this BitCoin mining calculator is valid for AltCoins as well.
Good luck with your mining and HODL. Here you can download free BitCoin Mining Calculator.
Further reading: How to calculate return on investment? Loan amortization in Excel Ethereum Network Difficulty How to pull DeFi data to Excel?