To calculate continuous interest use the formula where FV is the future value of the investment PV is the present value e is Eulers number the constant 271828 i is the interest rate and t is the time in years. Choose Your Compounding Interval. Launch your preferred spreadsheet such as Microsoft Excel.
T number of days between the date your last payment is received and the date your current payment is received is counted in this method.
To calculate continuous interest use the formula where FV is the future value of the investment PV is the present value e is Eulers number the constant 271828 i is the interest rate and t is the time in years. Principal P How much money you initially deposit into the account Interest rate r What percentage youre earning interest at Compounding periods n How many times interest is calculated per year. For daily compounding the interest rate will be divided by 365 and n will be multiplied by 365 assuming 365 days in a year. For example 7 is entered as 7 - do not enter 07.