Goal Funding Gap Calculator · Calculation guide

Compare projected investments with a future target amount.

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.

Gap=max(0,T−B); Surplus=max(0,B−T)

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

InputValue
Target1,000,000
Initial100,000
Contribution5,000
Expected effective annual return12%
Years10
Additional annual fee0%
TimingEnd of period
Inflation4%

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

ResultValue
Funding gap0
Projected value1,420,235.02759
Target1,000,000
Surplus420,235.02759
Value in today’s money959,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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Target1,000,0001,100,000Target1,000,0001,100,000
Initial100,000110,000Projected value1,420,235.027591,451,293.509673
Contribution5,0005,500Projected value1,420,235.027591,531,200.048266
Expected effective annual return12%13%Projected value1,420,235.027591,509,039.525513
Years1011Projected value1,420,235.027591,653,895.720443
Additional annual fee0%1%Projected value1,420,235.027591,327,244.433977
TimingEnd of periodStart of periodProjected value1,420,235.027591,430,764.268632
Inflation4%5%Value in today’s money959,459.895951871,901.10658
Goal Funding Gap Calculator →