I need to calculate daily compound interest and I tried the following formula

Column A (no of days) | Column B
1 | 3000
2 | =FVSCHEDULE(B1,0.05974/365)
3 | =FVSCHEDULE(B1,0.05974/365)
And so forth

However, this doesnt work so well if the number of days gets larger, e.g
5000 days. Is there a better way to calculate daily compound interest?

Thank you.