You want to calculate compound interest directly inside a Notion database without using an external calculator. Notion formulas do not include a built-in compound interest function, but you can build one using exponentiation and repeated multiplication. This article explains the mathematical foundation and provides a working formula template for annual, semi-annual, quarterly, and monthly compounding periods. You will learn how to set up the required properties and write the formula step by step.
Key Takeaways: Building a Compound Interest Formula in Notion
- pow() function: Use pow(1 + rate, periods) to compute the growth factor for any compounding frequency.
- Properties required: Create Number properties for Principal, Annual Rate, Years, and Compounds per Year before writing the formula.
- Formula property type: Set the formula result type to Number and choose a decimal format with two places for clean output.
How the Compound Interest Formula Works in Notion
Compound interest calculates interest on both the initial principal and the accumulated interest from previous periods. The standard formula is A = P (1 + r/n)^(nt), where A is the final amount, P is principal, r is the annual interest rate as a decimal, n is the number of compounding periods per year, and t is the number of years.
Notion formulas support arithmetic operators and the pow() function for exponentiation. You cannot use the caret character (^) for powers; you must use pow(base, exponent). The formula must reference other database properties, so you need to create separate Number properties for each variable. The formula property itself does not store a value; it computes and displays the result based on other property values.
Before writing the formula, ensure your database has at least these Number properties:
- Principal — initial investment amount
- Annual Rate — annual interest rate as a percentage, for example 5 for 5%
- Years — number of years the money is invested
- Compounds per Year — 1 for annual, 2 for semi-annual, 4 for quarterly, 12 for monthly
Steps to Create the Compound Interest Formula
- Add the four Number properties
Open your Notion database and click the + button in the last column header. Select Number as the property type. Create properties named Principal, Annual Rate, Years, and Compounds per Year. Enter sample values such as 1000 for Principal, 5 for Annual Rate, 10 for Years, and 12 for Compounds per Year. - Add a Formula property
Click the + button again and select Formula. Name it Final Amount or Compound Interest. This property will display the computed result. - Enter the compound interest formula
Click inside the formula editor for the new property. Delete the default placeholder text. Type or paste the following formula exactly:prop("Principal") pow(1 + (prop("Annual Rate") / 100) / prop("Compounds per Year"), prop("Compounds per Year") prop("Years"))This formula divides the annual rate by 100 to convert it to a decimal, then divides by the number of compounding periods. The pow() function raises the growth factor to the total number of compounding periods.
- Configure the formula result format
After entering the formula, click the number format dropdown in the formula editor. Select Number, then choose Decimal with 2 places. This ensures your result shows cents for currency values. - Test with a known value
Set Principal to 1000, Annual Rate to 5, Years to 10, and Compounds per Year to 12. The formula should return approximately 1647.01. If you see an error, check that all property names match exactly and that no spaces exist after the property names in the formula.
Common Mistakes and Formula Adjustments
Formula returns “NaN” or empty
This usually happens when one of the referenced properties contains no value or a non-numeric value. Ensure every row has a number in Principal, Annual Rate, Years, and Compounds per Year. Use a default value of 1 for Compounds per Year if you leave it empty.
Result is far too large or small
The most common error is forgetting to divide the annual rate by 100. Notion treats the Annual Rate property as a raw number. If you enter 5 meaning 5%, the formula must convert it to 0.05 before dividing by Compounds per Year. The formula above includes this conversion.
Compounds per Year set to zero
If Compounds per Year is 0, the division by zero causes an error. Add a validation step in the formula using an if() statement. For example:
if(prop("Compounds per Year") == 0, prop("Principal"), prop("Principal") pow(1 + (prop("Annual Rate") / 100) / prop("Compounds per Year"), prop("Compounds per Year") prop("Years")))
This returns the principal unchanged when the compounding frequency is zero.
Displaying only the interest earned
To show the compound interest amount without the principal, create a second Formula property. Enter: prop("Final Amount") - prop("Principal"). Replace Final Amount with the name of your main formula property.
Notion Compound Interest Formula Variations Compared
| Compounding Frequency | Compounds per Year Value | Example Result (1000 at 5% for 10 years) |
|---|---|---|
| Annual | 1 | 1628.89 |
| Semi-annual | 2 | 1638.62 |
| Quarterly | 4 | 1643.62 |
| Monthly | 12 | 1647.01 |
| Daily | 365 | 1648.66 |
The table shows that more frequent compounding produces a slightly higher final amount. You can use any integer for Compounds per Year. For daily compounding, enter 365. For continuous compounding, the formula changes to prop("Principal") exp(prop("Annual Rate") / 100 prop("Years")) using the exp() function, but this is rarely needed for standard business calculations.
You can now calculate compound interest for any investment directly inside your Notion database. Try adding a second Formula property to compute the total interest earned separately. For advanced use, combine this formula with a Rollup property to aggregate compound interest across multiple investment rows in a parent database.