Skip to main content
Question

Compounding Interest

  • November 2, 2023
  • 0 replies
  • 97 views

Forum|alt.badge.img+2

Does anyone have a formula for compounding interest (semi-annual) for loans?



------------------------------
Jesse Edsell-Vetter
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

Since Excel is more ubiquitous than Quickbase there should be google-able formulas out there for Excel.

Here was one hit I got.

https://zebrabi.com/guide/how-to-calculate-compound-interest-in-excel/#:~:text=There%20are%20two%20basic%20formulas,as%20in%20the%20first%20formula.

The first formula is =P*(1+r/n)^(n*t), where P is the principal amount, r is the interest rate, n is the compounding period, and t is the term.

If you have an example with Principle and Interest Rate and Term and compounding period, I could help you with the exact formula.



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------