I have the following issue:
I need to calculate the daily income of a financial application over a period based on a percentage of a daily financial index. The problem is that for each day, this index has a different value. For example:
Date value Apr-1 0,048089% Apr-2 0,045442% Apr-3 0,041886% and so on... Apr-31 0,035450%
On April 1, the initial value of the investment was $ 1,000. How much will the total be on April 31st?
Is there a way to get the final value using a single formula?
The way I do today, I need to calculate the day-to-day balance.