Calculate interest

[elliot13458]

So I am trying to figure out in calc how to calculate the percentage of the numbers from the dates 3\1 - 3\30\2018. for the coumpound interest. how would I do that?

[RusselB]

The numbers you have on your spreadsheet do not appear to be calculated by any means.
That said, a quick look at the help file makes me think that the CUMIPMT function may work best based on your description.
The function does require the information to be entered in a specific order, however it would keep you from having to generate a multi row sheet (ie: one row per day).

[elliot13458]

nevermind i think i figured it out. take a look for me

[RusselB]

While it looks correct at a quick glance, I noticed that your entries for Daily Interest are manually entered, rather than calculated.
Thus if the interest rate was to change from the 4.08 that you have manually entered for the annual rate, your spreadsheet would no longer be accurate.

[elliot13458]

yes I would have to change the daily rate in their if it changed on the site

[elliot13458]

how would I tell it to take the daily interest and calculate it based on the previous day principle. for example 0.01% of 100 is 0.01 usd, next day 100.01, tell it to calcualte interest based on 100.01 instead of 100