Special Needs Funding Worksheet

PROTECTING YOUR INFORMATION

Client:
Special Needs Funding (Lines 1–16)

Dual Rate of Return comparison from line 6 onward. Factor tables referenced externally. Live gap/monthly/lump math where inputs allow.

1. Goal Needing Special Funding
2. Number of Years to Invest
3. Total Funds Needed for Goal
4. Future Value of $1000 (Table One)
5. Future Value of Goal (Line 3/$1000) × Line 4
Rate of Return #1
Rate of Return #2
6. Assumed Rate of Return %
7. Accumulation To Date Toward Goal
8. Future Value of a $1000 (Table Two)
9. Future Value of Accumulation to Date (Line 7/$1000) × Line 8
10. Special Needs Funding Gap (Line 5 − Line 9)
11. Factor: Funding Needed in $1,000 Increments (Table Three)
12. Monthly Investment Required to Fund Goal (Line 10/$1000 × Line 11)
13. Current Monthly Investment Toward Funding Goal
14. Additional Monthly Investment Needed (Line 12 − Line 13)
15. Factor: Present Value of a Lump Sum in $1000 Increments (Table Four)
16. Lump Sum Needed Today to Fund Special Needs Goal (Line 10/$1000 × Line 15)

PROTECTING YOUR INFORMATION

Fillable HTML worksheet with live math where applicable. Click Submit to send to the FI FORMS Teams channel (SQL when webhook is configured).