Unless you are withdrawing the daily interest you are accumulating it will be. The balance after 3. The formula for compound interest on a single deposit is.
To compute the compound interest in Excel for different time periods all you have to do is convert the formula above into a relatable formula in Excel.
Convert the percentage. The rate per period r and number of periods n in the compound interest formula must match how often the account is compounded. The formula used in the compound interest calculator is A P 1rnnt A the future value of the investment P the principal investment amount r the interest. Convert the percentage.