EPF Pre-Retirement Planner (2026) — Malaysia Retirement Readiness Workbook

Know what your EPF is really worth. A no-macro Excel workbook that separates future ringgit from today's ringgit, checks you against EPF's official savings tiers, and shows the exact catch-up contribution you need.

RM 1,312,681 sounds like a comfortable retirement. In today's money it's RM 976,758 — and that changes everything.

Most EPF projections quote a big future number and let you assume you're set. But a ringgit in 2036 doesn't buy what a ringgit buys now. That gap is where retirement plans quietly fail.

The EPF Pre-Retirement Planner is a clean, no-macro Excel workbook that does the maths honestly. Type in a handful of numbers and it shows you, in plain ringgit, whether you're on track — in today's money, not inflated future money.

What it does

- Projects your EPF to retirement across three dividend scenarios (conservative, planning, and a recent-rate reference), with a year-by-year accumulation table.

- Translates the result into today's ringgit so you see real purchasing power, not a flattering headline figure.

- Scores you against EPF's official savings tiers — Basic, Adequate, Enhanced — on a like-for-like basis.

- Calculates your personalised target from the lifestyle you actually want, adjusted for inflation and the years you expect to spend in retirement.

- Tells you the exact catch-up contribution — the extra ringgit per month needed to close any gap.

- Models monthly income in retirement (an i-Emas-style level payment) and how long your savings last.

- Checks itself. A built-in validation panel flags impossible inputs, over-cap contributions, and broken assumptions before they mislead you.

What makes it different

- It's honest about inflation. The real-vs-future ringgit comparison is built into the dashboard, not buried. Most planners skip this — it's the single biggest reason people overestimate their readiness.

- Every formula is transparent and editable. No hidden macros, no locked cells, no black box. Change any assumption — dividend rate, salary growth, retirement age, post-60 contribution rates — and watch everything update.

- Malaysia-specific. Built around EPF mechanics, including the contribution step-down for years worked past 60.

- Documented.

A Sources & Checks sheet lists every assumption and where the official figures come from.

What's inside

A single .xlsx workbook with seven sheets:

1. Start Here — how to use it in three steps

2. Inputs — your numbers (only the blue cells)

3. Dashboard — readiness at a glance, real and nominal

4. Projection — year-by-year accumulation

5. i-Emas Planner — monthly-income durability

6. EPF Schemes — reference notes

7. Sources & Checks — assumptions and validation

Who it's for

Malaysians aged roughly 45–60 who contribute to EPF and want a clear, private, one-page answer to "am I on track?" — without handing their data to an app or paying for a full financial plan.

How to use it

1. Open in Excel, Google Sheets, or LibreOffice.

2. Fill in the blue cells on the Inputs sheet.

3. Read your answer on the Dashboard — in today's ringgit.

That's it. No sign-up, no macros, no internet connection needed.

File details (for the "Details" fields)

- Format: Microsoft Excel (`.xlsx`)

- Works in: Excel 2016+, Google Sheets, LibreOffice Calc

- Macros: none

- Size: one workbook, seven sheets

- Language: English

- Region: Malaysia (EPF)

FAQ

Is this financial advice?

No. It's an educational scenario tool. It doesn't recommend products or actions, and it isn't tailored to your circumstances. For decisions, speak to a licensed adviser.

Is this an official EPF / KWSP calculator?

No. It's an independent workbook. Always verify balances and figures in your KWSP i-Akaun.

Do I need to be good at Excel?

No. You only type into the blue cells. Everything else calculates automatically.

Will it work on a Mac or in Google Sheets?

Yes. It uses standard spreadsheet functions only — no macros or add-ins.

Can I change the assumptions?

Yes, all of them. Dividend rates, salary growth, inflation, retirement age, spending target, and post-60 contribution rates are all editable.

Do I get updates?

Yes — minor corrections and 2026 updates are free to existing buyers.

Refund / disclaimer line

Educational tool only — not financial, tax, or legal advice, and not an official EPF calculator. Figures are illustrative and depend on assumptions you control. Verify any decision in KWSP i-Akaun or with a licensed professional. Because this is a digital download, all sales are final unless the file is faulty.