Video summary

Freefincal Robo Advisor Video Guide July 2025

Main summary

Key takeaways

Product Review

Freefincal Robo Advisor (Tool v9, Jul 2025) — Subtitle Summary

What it is

  • A retirement + goal-planning “robo advisor” spreadsheet tool by Freefincal.
  • Version: 9 (last modified July 2025).

Main setup & usability (how the tool works)

  • Macros must be enabled to use the Excel edition (the tool is recorded using Mac Excel).
  • The Excel edition doesn’t work in “web Excel.”
  • For browser/cloud usage, use the Google Sheets edition:
    • Computations/features are effectively the same.
    • Running scripts may take slightly extra time in Google Sheets.
    • In Google Sheets, you must grant permission for scripts.
  • A large README sheet appears first:
    • Accept the terms pop-up.
    • The presenter warns not to navigate left/right—use sheets sequentially and step-by-step.
    • Expect a learning curve due to its size.

Key features described

Front-end workflow (step-by-step planning)

Step 1 (inputs)

  • Inputs include:
    • Age
    • Relationship status
    • Spouse age
  • If spouses are included:
    • Specify younger spouse age
    • Specify older spouse age

Step 2 (financial inputs)

  • Input details include:
    • Current monthly expenses
    • Any annual expenses
    • Desired retirement age
    • Expected annual increase to monthly investments (plus other return-related assumptions)
    • Expected returns assumptions (adjustable via settings; example mentions changing C7 in Settings)
    • Current investments (equity, EPF/PPF, fixed income, etc.)
    • Post-retirement income assumptions (rent/dividends/pension), growth rate, start/stop age
    • Maturity benefits at retirement

Step 3 (run macro + outputs)

  • Outputs include a summary of assumptions, for example:
    • Inflation before retirement default set to 6% (change via Settings C3)
  • Retirement horizon is calculated until the younger spouse reaches age 90.
  • Calculates:
    • Gross corpus required (example shown: ~₹4.99 crore)
    • Net corpus (lower if existing investments are entered)
    • Monthly investment required
  • Provides an automated asset allocation schedule over time:
    • Default example described:
      • Equity starts around 60%
      • Tapers to ~35% by retirement time

Handling “income flooring” (optional)

  • Option: Income flooring
    • Lets part of first-year retirement expenses be covered via pension/annuity-like income.
    • Choose a percentage from 0% to 100%.
    • Presenter recommends starting with 0 for the example shown.

Other goals beyond retirement

  • Step 4A: one-time future goals
    • Example goal types: education, marriage
    • Total example: six goals
  • Step 4B: recurring goals
    • Example: holidays every 2–3 years
  • Cash flow planning (Step 6A):
    • Independent portfolio approach (presenter’s preference):
      • Separate portfolios per goal (e.g., retirement vs children’s education).
      • Still supports planning for goals after retirement.
    • Unified portfolio approach:
      • One portfolio covers multiple goals; money is “pulled away” as each goal date approaches.
      • Limitation mentioned: in unified mode, the final goal is assumed to be retirement.

Backend retirement strategy (“bucket” system)

  • Main retirement computation happens in “Low Stress Buckets” sheet.

Strategy concept

  • Create an income bucket (inflation-indexed) for early retirement years.
  • Distribute remaining corpus into low / medium / high risk buckets with auto-calculated allocations (editable in settings).

Bucket structure & timing (as described)

  • Income bucket: 15 years (no equity)
  • Low risk: 11 years
  • Medium risk: 9 years
  • High risk: 10 years
  • Emergency bucket:
    • 5–10% of corpus allocated (user-adjustable)

Return/income assumptions (qualitative examples)

  • Income bucket
    • Generates about 6% after-tax income
  • Low risk bucket
    • ~5% income
    • Bucket grows with ~7.8% expected return while invested
  • Medium risk bucket
    • ~5% income
    • Bucket grows with ~8.6% expected return while invested

How buckets are deployed (two styles described)

  1. More practical / less sequential
    • Start with 15 years of income “guaranteed,” then shift gradually into the income bucket based on market conditions from low/medium/high buckets.
    • Presenter notes the macro doesn’t explicitly project this “market-dependent shift.”
  2. Sequential buckets
    • Income bucket → low risk → medium risk → high risk in order.
    • Example described:
      • Income bucket covers retirement years 16–26 in that scenario
      • Next buckets follow sequentially (details included in pre-calculation)

Newer option: Equity glide path per bucket

  • Equity allocation within each bucket tapers down to zero as it becomes income.
  • Affects outputs/returns; user can switch glide path on/off.
  • Visual behavior (qualitative):
    • High-risk bucket starts with higher equity and tapers down
    • Low-risk bucket starts around 40% equity and eventually goes to 0%
    • Total equity across buckets starts around ~35%, rises to ~45%, then declines again.

Income flooring advanced alternatives

  • Annuality lading concept:
    • Instead of buckets, buy multiple annuities over time (e.g., retirement age and later ages).
    • Intended to keep pension income above inflation-adjusted expenses for life.
    • Presenter notes it requires a significantly larger corpus and is advanced (not for everyone).

Output example for someone near retirement

  • Presenter changes retirement age to 35 to simulate near retirement.
  • Tool outputs “health of retirement corpus,” e.g.:
    • If current corpus is ~₹40 lakhs, tool says they need ~₹1 crore → not enough
    • Increasing to ₹2.5 crore still “not enough” in the example
    • Increasing to ~₹3 crore makes retirement “sufficient”
  • Tool also provides:
    • Suggested low-risk vs high-risk allocations
    • If glide path is enabled: guidance on where/how to follow the glide path recommendations
  • Repeated warning:
    • Example numbers are illustrative, not exact.

Pros (as implied by the guide)

  • Step-by-step workflow designed to prevent overwhelming users (when followed sequentially).
  • Open-source / editable:
    • Settings and formulas can be modified (Excel/Google Sheets).
  • Bucket-based retirement logic with options:
    • Income bucket
    • Low/medium/high buckets
    • Emergency bucket
    • Optional income flooring
    • Optional equity glide paths
  • Supports multiple goals (one-time + recurring) and cash flow planning:
    • Independent or unified portfolio approaches.

Cons / cautions (explicitly mentioned)

  • Requires macros/scripts:
    • Excel web/online won’t work.
    • Google Sheets requires script permission.
  • Tool is large and easy to get confused:
    • Presenter recommends sequential navigation only.
  • Changing too many preset values may produce “very weird results”.
  • Advanced backend settings should be modified only by experienced users.
  • Glide path option affects returns:
    • Turning it off changes results—users should “play with this” only after understanding.

Comparisons made (within the tool)

  • Excel vs Google Sheets edition
    • Same computations/features; Google may run scripts slower.
  • Independent vs Unified cash-flow approaches
    • Presenter prefers independent portfolio for clearer risk/reward separation and flexibility.
    • Unified mode is simpler but assumes the final goal is retirement.
  • Bucket strategy vs annuity lading
    • Annuality lading uses laddered annuities but needs much larger corpus and is advanced.

Unique points mentioned (consolidated)

  1. Guide for Freefincal Robo Advisor tool v9 (Jul 2025).
  2. Enable macros in Excel; tool won’t work in web Excel.
  3. Google Sheets version works; needs script permission; may run scripts slower.
  4. First sheet is a README: accept terms and navigate step-by-step.
  5. Step 1: age, married status, spouse age; younger/older spouse ages.
  6. Step 2: monthly/annual expenses, retirement age, investment increase %, returns assumptions (editable in settings), current investments, post-retirement income, growth/start/stop, maturity benefits.
  7. Avoid changing presets too much initially; edits can cause odd outputs.
  8. Step 3 includes assumption summary; default inflation is 6% before/after retirement.
  9. Planning continues until younger spouse reaches age 90.
  10. Shows gross vs net corpus (net accounts for future value of existing investments).
  11. Shows required monthly investment.
  12. Automated allocation schedule: - Starts ~60% equity - Tapers to ~35% equity at retirement.
  13. Warns alternative allocation changes aren’t recommended (research/sequence-of-returns robustness).
  14. Backend uses “Low Stress Buckets.”
  15. Bucket timing: - Income 15 years (no equity) - Low 11 years - Medium 9 years - High 10 years
  16. Bucket income/return examples: - Income bucket: ~6% after-tax income - Low: ~5% income and ~7.8% expected return while invested - Medium: ~5% income and ~8.6% expected return while invested
  17. Emergency bucket: 5–10% corpus (adjustable).
  18. Two deployment approaches: - Gradual shifts based on market conditions (described as more practical) - Sequential bucket usage (pre-calculated)
  19. New option: equity glide path per bucket; equity tapers toward zero near income deployment.
  20. Glide path affects expected returns; can be toggled.
  21. Glide path behavior example: - Total equity ~35% → ~45% → decline
  22. Income flooring: choose 0–100% of first-year retirement expenses as pension-like annuity income.
  23. Other goals: - Six one-time goal slots (Step 4A) - Recurring goals (Step 4B)
  24. Cash flow (Step 6A): - Independent vs unified; independent allows goals after retirement.
  25. Annuality lading: advanced; laddered annuities maintain inflation-adjusted income and need a larger corpus.
  26. Near-retirement example: - ~₹40L corpus → need ~₹1Cr (not enough) - ₹2.5Cr still not enough (in example) - ~₹3Cr can be sufficient (illustrative)
  27. Recommendation: understand bucket strategy and follow step-by-step to avoid overwhelm.

Speakers / perspectives

  • Only one speaker appears in the subtitles (Pat from Freefincal), covering setup and rationale (including preference for independent portfolio and guidance not to change presets early on).

Overall verdict / recommendation

  • Recommended for users who want a structured, research-backed bucket-based retirement planning spreadsheet and are willing to follow the step-by-step workflow.
  • Best fit:
    • Users comfortable enabling macros/scripts (or using Google Sheets) and sticking to presets initially.
  • Not ideal for:
    • Casual users who avoid spreadsheet complexity or don’t want to handle macro/script permissions.

Original video