compound interest

Staking Compound Interest with Weekly Rewards Calculator

By Chadayan | Technical Discussions | 6 Oct 2020


Calculator with Compound Interest

 

I cannot find a calculator for finding the Compound Interest for staking. I am staking some polka dot in kraken with the grow rewards on. In my understanding, they will add the Compound Interest twice weekly (Tuesday and Friday). 

If we turn on the "grow rewards" on the rewards will be compounded, which adds your earned rewards every week back into staking. This means if you continue to leave your funds staked you may earn more than the RPY percent.

As Kraken doesn't have any fees I have not included them.

Now how are we going to calculate that?

I have created an Excel sheet with the formula. There is only two formula in the excel. 

This is the main one:

=B2*(1+B3/B6)^(B6*B7)


a2a4d7fe06360f748532f9531e8868df9698bbd2091142e8e80006b297899678.jpeg

 

Another minor one:

=ROUND(B4*B5,0)

I assume we don't want the decimal palaces for the yearly calculations. 

 

21e34dbf5d3b60a33717beff4244166cf1212481b24f74f1ea2facf09a0d4395.jpeg

 

If anyone wants the excel to play with you can download them here. 

https://github.com/sebing/sharedFiles/blob/main/kraken_rewards_compound_interest_calculator.xlsx

 

Let me know, my calculations are right. If you think I need correction I can change the formula.

How do you rate this article?


0

1

Chadayan
Chadayan

:) I write but who reads?


Technical Discussions
Technical Discussions

My opinion on the technical stuff I am exploring.

Send a $0.01 microtip in crypto to the author, and earn yourself as you read!

20% to author / 80% to me.
We pay the tips from our rewards pool.