Reply To: How to use AI to create retirement projections that include side income (beginner-friendly)

Quick win: You can build a realistic retirement projection that includes side income this afternoon — no finance degree required. AI can do the heavy lifting once you give it simple inputs.

Why this matters: side income (consulting, rental, gig work) changes the math. Counting it turns a tight picture into a comfortable one — or shows where you still need to save.

What you’ll need

• Current age and planned retirement age
• Current retirement savings and annual contributions
• Expected annual investment return (use conservative 4–6% for planning)
• Current annual side income and expected growth rate (0–10%)
• Estimated annual retirement spending (today’s dollars) and an inflation assumption
• Spreadsheet (Excel or Google Sheets) or an AI chatbot you can prompt

Step-by-step

1. Open a spreadsheet and create columns: Year, Age, Starting Balance, Contribution, Investment Return, Side Income, Ending Balance.
2. Enter today’s balance in Starting Balance for Year 0. For each year: Contribution adds, then apply return, then add side income to get Ending Balance. Copy forward Ending to next year’s Starting.
3. Run the projection to retirement. At retirement, switch contributions to withdrawals (or use a safe withdrawal rate scenario).
4. Use AI to accelerate: ask a chatbot to build the table, run scenarios (conservative/base/optimistic), and summarize outcomes.

Simple example (illustrative)

• Age now: 55. Retirement age: 65
• Current savings: $200,000. Annual contribution: $10,000. Return: 6%.
• Side income now: $5,000/yr, growing 5%/yr until retirement.
• Result: run the spreadsheet and you’ll see how side income adds to ending balance each year and reduces how much you must withdraw later.

Common mistakes & fixes

• Ignoring taxes or inflation — fix: model net amounts and a 2–3% inflation assumption.
• Using overly optimistic returns — fix: run 4%, 6%, 8% scenarios.
• Treating side income as certain — fix: model best/base/worst cases and include a safety buffer.

Copy-paste AI prompt

Use this in your AI chatbot to get a ready-made table and scenario analysis:

“Create a 10-year retirement projection table. Inputs: current age 55, retirement age 65, current savings $200,000, annual contribution $10,000, annual return 6%, side income $5,000 growing 5% annually. Show Year, Age, Starting Balance, Contribution, Return amount, Side Income, Ending Balance. Then provide a summary of balances at retirement and run two more scenarios: return 4% and side income growth 0%.”

Action plan — get it done this weekend

1. Collect the inputs listed above (30 minutes).
2. Paste the AI prompt into a chatbot or build the spreadsheet with the columns suggested (45–90 minutes).
3. Run three scenarios (conservative/base/optimistic) and save the results.
4. Adjust contributions or retirement date if any scenario falls short.
5. Review annually or when side income changes.

Reminder: start simple, iterate fast. The goal is clarity — not perfection. Use AI to speed the math, then decide with confidence.