#04 · Workflow · AL-17 · AL-32 · AL-12 · AL-05 · AL-13 · College Financial Planning

College Financial Planning Suite

From FAFSA aid estimation through parent ROI, scholarship pipeline, 529 savings, and loan payoff — the complete college planning arc for families.

🔒 All inputs are processed locally in your browser. Nothing is transmitted, stored, or logged. Inputs disappear when you close the tab.
→ → → →
1 ✓
Step 1 · AL-17 · Financial Aid Estimator
FAFSA Student Aid Index (SAI) & Pell Grant Eligibility
Full tool: AL-17 ↗
›
$
$
Aid Estimation Results
0
Student Aid Index
Lower = more aid eligible
$0
Pell Grant (est.)
2024–25 max $7,395
$0
Subsidized Loan Max
If SAI < 8,000
$0
Total Aid Package Est.
Pell + subsidized loans
→ SAI of 0 and aid estimate of $0/yr will pre-fill college ROI modeling in Step 2.
2 ✓
Step 2 · AL-32 · Parent College ROI Planner
Total College Cost & 20-Year Degree ROI
Full tool: AL-32 ↗
›
$
College Cost & ROI
$0
Annual Cost
Tuition + room + board
$0
4-Year Total Cost
Before aid
$0
Net Cost (After Aid)
Total − aid − parent contrib
$0
Expected Starting Salary
Median for major
$0
20-Year NPV
vs. HS diploma baseline
→ Net cost of $0 and starting salary of $0 will carry into scholarship and savings planning.
3 ✓
Step 3 · AL-12 · Scholarship Pipeline Builder
Application Campaign Value & ROI per Hour
Full tool: AL-12 ↗
›
20
Pipeline Projection
0
Expected Awards Won
Based on win rate + volume
$0
Total Pipeline Value
Expected scholarship dollars
0 hrs
Time Invested
Total application hours
$0/hr
ROI per Hour
Expected $/hr of effort
→ Scholarship pipeline of $0 will reduce the 529 savings gap in Step 4.
4 ✓
Step 4 · AL-05 · 529 College Savings Projector
529 Plan Growth & Enrollment Coverage
Full tool: AL-05 ↗
›
$
$
%
529 Projection at Enrollment
$0
Projected 529 Balance
At age 18 enrollment
$0
State Tax Savings
Estimated over savings period
0%
Net Cost Coverage
529 balance ÷ net cost
$0/mo
Recommended Monthly
To fully cover net cost
→ Projected 529 balance of $0 will determine remaining loan gap in Step 5.
5 ✓
Step 5 · AL-13 · Student Loan Repayment Planner
Repayment Plans, Monthly Payments & Full Planning Summary
Full tool: AL-13 ↗
›
$
%
$
Repayment Plan Results
$0
Monthly Payment
Selected plan
$0
Total Paid
Principal + interest over term
$0
Total Interest
Cost of borrowing
0%
Debt-to-Income Ratio
Monthly payment ÷ gross monthly
Plan Comparison
Plan Monthly Total Paid Total Interest
Explore the full tools used in this demo
AL-17 Financial Aid Estimator → AL-32 Parent College ROI Planner → AL-12 Scholarship Pipeline Builder → AL-05 529 College Savings Projector → AL-13 Student Loan Repayment Planner →