Savings growth: Input · Value · Start amount · 5000 EUR · Monthly saving · 200 EUR · Yearly return · 5% · Year · Balance · Interest earned · 1 · = B2 * (1 +…
| A | B | C |
|---|---|---|
| Input | Value | |
| Start amount | 5000 EUR | |
| Monthly saving | 200 EUR | |
| Yearly return | 5% | |
| Year | Balance | Interest earned |
| 1 | = B2 * (1 + B4) + B3 * 12 | = B7 - B2 - B3 * 12 |
| 2 | = B7 * (1 + B4) + B3 * 12 | = B8 - B7 - B3 * 12 |
| 3 | = B8 * (1 + B4) + B3 * 12 | = B9 - B8 - B3 * 12 |
| 4 | = B9 * (1 + B4) + B3 * 12 | = B10 - B9 - B3 * 12 |
| 5 | = B10 * (1 + B4) + B3 * 12 | = B11 - B10 - B3 * 12 |
| 10 | = B2 * (1 + B4) ^ 10 + B3 * 12 * ((1 + B4) ^ 10 - 1) / B4 |