Find how many years it will take to achieve a financial goal under a compound interest savings account using Notion calculations such as : round, divide, and log(10). Most simple equations with a handful of variables are easy to translate into a notion table, especially if each property is manageable. Forecasting the amount of years to reach a compound interest return only needs the following properties:

• Start Date

• Principal $

• Annual Interest Rate

• Compound Frequency (Monthly, Quarterly, Bi-Annually)

• Goal $

Here is the formula we’ll be plugging these properties into:

This Compound interest calculator finds “t” or Years to Goal. The following is where properties plug into the mathematical formula.

• FV = Goal (or Future Value)

• P = Principal

• r = Annual Interest Rate

• n = Compound Frequency

• t = Years to Goal

Formula for Years to Goal:

round(round(log10(prop("Goal") / 5000) / log10(1 + prop("Annual Interest Rate") / prop("Frequency Hide")) / prop("Frequency Hide")))

Formula for Frequency Hide:

if(prop("Compound Frequency") == "Quarterly", 4, if(prop("Compound Frequency") == "Bi-Annually", 2, if(prop("Compound Frequency") == "Monthly", 12, 0))) 

COPY TEMPLATE