Skip to main content
Foundations

The math, gently

Pomegra Learn

The math, gently

Behind every compounding problem is a formula. But formulas don't have to be scary. In this chapter, we use algebra—not calculus—to solve real problems: How much will your money grow? How much do you need to save today to hit a future number? What return rate do you need? How long will it take?

The mathematics of compounding is a closed door only if you refuse to open it. Once you do, you find that the central formula is elegant and manageable. We'll work through examples with real numbers, walk through spreadsheet implementations, and show you how to rearrange the formula to solve for any unknown.

The key insight is that compound-interest math is fundamentally algebra. You're solving for one unknown variable given the others. If you know how much you're saving, how long you're saving for, and your expected return rate, you can calculate your final balance. If you know the final balance and the time horizon, you can calculate the required return rate. If you know the rate and time, you can work backward to find out how much you need to save today. This flexibility is what makes the formula powerful. It's not locked in one direction; you can rearrange it to answer almost any financial question.

The big three formulas​

Every compounding calculation boils down to a few relationships. First: how does a lump sum grow over time? This is the simplest case—you invest money today, earn returns, and those returns compound. Second: how does a stream of contributions grow? Most people invest regularly, not as a lump sum, so this formula matters more for real life. Third: what happens when you introduce continuous compounding, inflation, or irregular cash flows? These extensions handle the complications that real-world investments present.

We'll derive each formula from first principles—showing you why it works, not just asking you to memorize it. Then we'll deploy them on real scenarios: calculating retirement savings, figuring out how much to contribute monthly to hit a goal, determining the effective rate you're actually earning given different compounding frequencies.

Beyond the formula​

Knowing the math is one thing. Using it correctly is another. We'll explore the mistakes: rounding errors that accumulate, confusing APR with APY (nominal rate versus effective rate), mixing up time-weighted returns with money-weighted returns, and why your spreadsheet might be giving you the wrong answer even though the formula is right.

We'll also cover the tools that implement these formulas: Excel functions like FV, PV, RATE, and NPER. These functions are powerful once you understand what they're computing, but they can be dangerous if you misuse them. An incorrect sign convention (positive versus negative) or a misunderstood parameter can give you plausible-looking wrong answers. We'll show you how to use them correctly.

Articles in this chapter​