Calculation guide
For people checking a money question using their own amounts and assumptions.
Use a consistent monthly basis except where a different period is explicitly entered. Allocation percentages must total 100%; rounded shares reconcile to the total. Ratios and reserve targets are editable assumptions rather than recommendations. A sinking fund must cover the earliest due date, not just an annual average. Runway reports no depletion under the assumptions when cash does not decline.
Inputs
Target
Amount you want to have at the future target date, stated in future money.
Initial
Money already invested or available at the beginning of this calculation.
Contribution
Amount added each month; contribution timing controls when it starts earning.
Expected effective annual return
Expected effective yearly growth before the additional fee.
Years
Duration in years. Monthly projections use twelve periods per year.
Additional annual fee
Extra proportional yearly investment fee. Use zero if your return already includes this cost.
Timing
Start adds the payment before growth; end adds it after growth. For withdrawals this selects when money leaves.
Inflation
Assumed yearly rise in prices. It changes purchasing power, not the nominal balance.
Worked example
| Input | Value |
|---|---|
| Target | 1,000,000 |
| Initial | 100,000 |
| Contribution | 5,000 |
| Expected effective annual return | 12% |
| Years | 10 |
| Additional annual fee | 0% |
| Timing | End of period |
| Inflation | 4% |
Formula:
Gap=max(0,T−B); Surplus=max(0,B−T)
Funding gap = 0.00000000000000
Year = 1.00000000000000; Contributions = 160000.000000000; Growth = 15232.4895417660; Balance = 175232.489541766; Today value = 168492.778405544
Year = 10.0000000000000; Contributions = 700000.000000000; Growth = 720235.027590027; Balance = 1420235.02759003; Today value = 959459.895951142
Today value: Balance ÷ (1 + 4 / 100)^t
| Result | Value |
|---|---|
| Funding gap | 0 |
| Projected value | 1,420,235.02759 |
| Target | 1,000,000 |
| Surplus | 420,235.02759 |
| Value in today’s money | 959,459.895951 |
Interpreting the result
Amount still needed: target minus available or projected money, never below zero.
Balance at the end after the modeled deposits, growth, withdrawals or charges.
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Target | 1,000,000 | 1,100,000 | Target | 1,000,000 | 1,100,000 |
| Initial | 100,000 | 110,000 | Projected value | 1,420,235.02759 | 1,451,293.509673 |
| Contribution | 5,000 | 5,500 | Projected value | 1,420,235.02759 | 1,531,200.048266 |
| Expected effective annual return | 12% | 13% | Projected value | 1,420,235.02759 | 1,509,039.525513 |
| Years | 10 | 11 | Projected value | 1,420,235.02759 | 1,653,895.720443 |
| Additional annual fee | 0% | 1% | Projected value | 1,420,235.02759 | 1,327,244.433977 |
| Timing | End of period | Start of period | Projected value | 1,420,235.02759 | 1,430,764.268632 |
| Inflation | 4% | 5% | Value in today’s money | 959,459.895951 | 871,901.10658 |
