Back to Resources

College is rarely the only major financial goal a family is planning for. Parents may be weighing the cost of two children’s education while also trying to save for retirement, pay down a mortgage, or prepare for other expenses. The questions quickly multiply:

  • Which schools are realistic?
  • How much might financial aid cover?
  • Should they save more, use existing assets, or borrow?
  • How much can they commit without jeopardizing other goals?

These decisions deserve more than a tuition estimate and a savings calculator. The College Funding planner in Penny lets advisors build an education funding strategy around individual students, realistic education costs, existing resources, and alternative funding choices. It also makes it easier to evaluate the education plan alongside the household’s retirement and other financial goals.

While allowing advisors to have a great conversation about balancing these needs, the College Funding planner also gives clear, understandable answers to common questions like, “How much should we save each year for our kids’ college?” and “How will funding work?”

Start with realistic education costs

Families rarely know the exact school a child will attend years in advance. Income Lab supports both broad cost estimates and institution-specific analysis, so the advisor can refine the plan as a student gets closer to enrollment.

For an earlier-stage plan, Cost Tier uses average costs for public or private four-year colleges or two-year community colleges. This gives families a useful starting point before they have a shortlist of schools.

When the family has specific schools in mind, the advisor can search institution-level cost data from the College Scorecard/IPEDS dataset. For public schools, the estimate can reflect in-state or out-of-state tuition. Housing options include on campus, off campus, and living at home, which can have a major impact on total cost and feasibility. The advisor can include or exclude tuition and fees, housing and food, books and supplies, and transportation and personal expenses, as well as enter a custom cost when needed. The tool also links to each school’s net price calculator for a more individualized estimate of institutional aid and allows the advisor to specify the portion of costs eligible for 529 or Coverdell distributions.

Graduate education can be included, with options such as medical, law, and dental school. (Graduate programs use average-cost estimates rather than institution-specific graduate program costs, with program classifications used in the aid and loan modeling.)

Input area What the advisor controls
College plan Cost Tier or Specific School; residency and housing; four cost line items; 529/Coverdell eligibility share; graduate programs
College savings Per-student 529 and taxable accounts; age-based Glidepath, static asset mix, or flat expected return
Household accounts Client investment accounts available to fund any student
Financial aid Federal grant aid (Pell and similar) from per-student SAI estimates; estimated merit and non-federal aid; simple or per-year mode
Loans Federal student loans and Parent PLUS; per-student annual caps and an overall maximum
Other settings Coverage limits (percent of cost, annual household cap, per-student cap); surplus-529 sibling transfer
Post-education reserves A provision for 529-to-Roth conversions at the end of the plan

Model aid and borrowing explicitly

Financial aid can change the amount a family needs to save substantially, but the result is uncertain until an actual award arrives. Income Lab estimates federal grant aid using a Student Aid Index (SAI) estimate for each student. Advisors can also include expected merit or other non-federal aid and use the separate SAI tool to examine the calculation. These assumptions remain adjustable as family circumstances and school choices change.

Aid can be estimated with consistent inputs across the school years or with year-by-year assumptions. When an Income Lab financial plan is selected, the planner can pull relevant projected future-year values from that plan. This is especially useful when income and other circumstances are likely to change during the years children attend college and it completely eliminates the need to key in many years of complex AGI and earnings information, while still refining the plan.

Borrowing can also be part of the funding strategy. The planner models federal student loans and Parent PLUS loans, including annual per-student limits and an overall borrowing cap set for the plan. Advisors can show families the savings required under different assumptions about aid and acceptable debt.

Plan how savings and other assets will be used

A funding strategy needs to account for the resources the family already has, including balances dedicated to particular children and assets that might be available to support more than one student.

The planner provides 529, Coverdell, and taxable savings accounts for each student, with the ability to change balances and add or remove accounts. Expected returns can be modeled using an age-based investment glidepath, a static asset allocation, or a flat return assumption. Advisors can also designate household investment accounts as possible funding sources for any student.

Several settings help address common family planning decisions.

  • If one child has money left in a 529 account, the planner can allow that surplus to support a sibling’s education. This option is on by default and can be turned off to compare the effect on required savings (which usually goes up if 529 transfers and changes are not allowed). The resulting analysis shows when funds move between students.
  • The advisor can also reserve money in a 529 account for a possible post-education rollover to a Roth IRA. Federal law imposes a $35,000 lifetime limit per beneficiary, along with account-age, contribution-timing, annual Roth IRA limit, and other requirements. The planner’s setting provides for a potential remaining balance; it does not determine whether a particular future rollover will qualify.

See the funding sources and remaining gap

Once the assumptions are entered, the planner shows how education costs would be covered for each student and how much the family still needs to save or supply from outside the modeled funding plan.

Advisors can express the needed contribution as monthly savings, annual savings, or a lump sum. A timeline shows how education assets are projected to grow and be spent as different children enter and leave school. The results break funding down by existing balances, additional savings, loans, and aid, with detail for each student. Any unfunded amount is visible. The advisor can also produce a PDF report with selected elements for client discussions.

The resulting savings target is an input to the wider planning conversation. If college requires an additional $1,500 a month for the next eight years, the advisor can evaluate that commitment against the household’s retirement and other goals in the main plan. The College Funding planner supplies the education analysis; the advisor considers the tradeoffs across the household’s full financial picture.

How families use the planner: 2 scenarios

The level of detail can change with the student’s age, the family’s available resources, and the decisions they need to make.

Two children, different planning horizons

Consider a couple in their early fifties with children ages 15 and 12. The older child has begun considering specific in-state schools, while the younger child has no particular school in mind. The advisor can use a Specific School estimate for the older child and a Cost Tier estimate for the younger one. Separate assumptions for savings, aid, and loans show the likely sources of funding for each. The advisor can explore whether any surplus in the older child’s 529 could support the younger child and assess the resulting savings commitment alongside the parents’ retirement goals.

A late start with several school options

A parent with a 17-year-old and $40,000 in 529 savings may be making a more immediate decision among schools. The advisor can compare institution-specific costs, residency, and living arrangements, then test different aid and borrowing assumptions. The plan shows the funding shortfall and how much additional family support would be needed. That information can inform the school choice before the family commits to an expense it cannot comfortably fund.

In either case, varying uncertain assumptions is useful. An advisor might compare expected aid with a lower-aid scenario, or compare the savings required with and without sharing surplus 529 assets between siblings. This helps the family understand which decisions and uncertainties have the greatest impact.

Frequently asked questions

What is the College Funding planner?

The College Funding planner is a tool within Penny’s Education planning focus. It estimates education costs and models how those costs might be covered through existing savings, additional contributions, financial aid, loans, and other household resources. It also includes settings for sibling use of surplus 529 funds and potential post-education 529-to-Roth rollovers.

Where do the school cost figures come from?

Specific-school cost information comes from the College Scorecard/IPEDS dataset. The tool reflects institution-reported costs, with options for residency, housing, and expense categories. Broad cost tiers and manually entered estimates are also available.

Does it calculate actual financial aid awards?

No. Federal grant aid estimates use student-specific SAI assumptions, and the advisor can add projected merit and non-federal aid. Actual awards depend on the relevant school and aid programs. A school’s own net price calculator can provide an additional point of comparison.

Can it plan for graduate school?

Yes. The planner includes graduate program categories such as medical, law, and dental school. It uses average cost assumptions for these programs rather than school-by-school graduate program pricing.

What happens to leftover 529 money?

The planner can model the use of surplus 529 money for another student and can provide for a remaining balance intended for a possible 529-to-Roth rollover. Actual rollovers are subject to statutory eligibility rules and limits.

Does the college plan connect to the retirement plan?

The College Funding planner can use projected future-year values from a selected Income Lab plan for relevant calculations. It can also consider household investment accounts as sources of college funding. The advisor should then evaluate the proposed savings and spending commitments in the broader financial plan and, if desired, have the Ask Penny AI agent help prep for changes to the financial plan, such as added savings goals and future expenses.

Sources

All trademarks are property of their respective owners.

Justin Fitzpatrick, PhD, CFA, CFP - President and Co-Founder of Income Lab

Justin Fitzpatrick is President and Co-Founder of Income Lab, comprehensive financial planning software used by thousands of financial advisors. He developed Income Lab's risk-based guardrails approach to retirement income after a decade in financial services at Jackson and seven years in academia at MIT, Harvard, and UCLA. His research on adjustment-based planning has been published on Kitces.com, ThinkAdvisor, AdvisorPerspectives, and FinancialPlanning Magazine.

Ready to see this in action?

Watch how Income Lab helps advisors answer clients' toughest retirement income questions with guardrails-based planning.

Book a Walkthrough Start Free Trial