Daily interest compound calculations of formula in Numbers

Question

Daily interest compound calculations of formula in Numbers

Hi, does anyone know how to create a daily compound formula that would calculate gains and losses of a given percentage?

For example:

I start with £100

Day 1: I earn 10% (Compound calculation is £100 + 10% = £110)

Day 2: I earn 10% (Compound calculation is £110 + 10% = £121)

etc etc

I would like it to understand when 10% is also lost too so it doesn't just keep adding whatever number I have in the column.

Day 1: I earn 10% (Compound calculation is £100 + 10% = £110)

Day 2: I lose 10% (Compound calculation is £110 - 10% = £100)

This calculator is great but if I can get it to work in my own Numbers spreadsheet that would be amazing.

Thank you!

Posted on Jun 27, 2022 1:05 AM

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

37,532 points

Jun 27, 2022 2:54 AM in response to Community User

tensionintheflat wrote:

I would like it to understand when 10% is also lost too so it doesn't just keep adding whatever number I have in the column.

If you have losses too (like most of us!) then you can consider doing something simple like this:

I entered the 100 (or whatever starting number) in C2.

The formula in C3, filled down, is:

=C2*(B3+1)

The formula in D3, filled down, is:

=C3/C$2−1

Extend the table as many rows as you like to estimate a possible balance and cumulative return so many days in the future.

SG

Reply

Answer 2

Ralf-F

Level 4

2,741 points

Jun 27, 2022 1:35 AM in response to Community User

You could use this.

Please compare the results with the online calculation.

Based on your region the , or the ; will be used to separate the different sections of a formula. If you write one thousand as 1,000.00 then the , is used as your formula separator. If you write one thousand as 1.000,00 then the ; is used as your formula separator.

Hope this will solve your question, please let me know if this worked for you or if something in unclear.

Ralf

Reply