The Complete Excel Course with AI Integration
How to build a retirement calculator in Excel
WealthFlow is the most useful project in The Complete Excel Course with AI Integration: an industry-standard retirement simulator, months in the making, that you build yourself and own outright. It gives you a SIP calculator (investing a fixed amount regularly), an SWP calculator (withdrawing one regularly), a lifetime simulator joining the two, and charts, all adjusted for inflation. Every formula is in view and every assumption is yours to change, so you depend on no website, app or other software: only Excel.
Taught by Sagnik Bhattacharya and Virginia Thorn
What you will be able to do
You will be able to:
- See what a monthly investment grows into: build a SIP calculator with FV and a yearly step-up, and check it against the same plan compounded by hand.
- Build an SWP calculator that pays a rising income from a pot each year and shows the year the money would run out.
- Join saving and drawing in one lifetime simulator, from the age you start investing to an end age you choose, with IF putting each year in the right phase.
- Show every result in today's money: real values after inflation, a real rate of return and withdrawals that keep pace with the cost of living.
- Chart the pot against what you paid in, and against what you withdraw, with lines that redraw the moment an input changes.
- Test a plan against a lower return, higher inflation or an earlier retirement in seconds, because every figure follows its inputs.
Projects
What you will build.
The course has 14 industry-standard projects. These two matter most here.
-
Project 10
WealthFlow
A retirement plan that shows how long the money lasts.
The most useful project in the course, and the one that sets you free of other software: SIP, SWP and lifetime sheets you build and own, every input yours to change.
-
Project 01
Personal Budget Tracker
Your first workbook: where the money goes each month.
Built around a personal budget, it ends with the course's first SIP calculator: a monthly amount grown by hand year by year, then with FV, and drawn as the curve compounding makes.
Lessons
The lessons that matter, in course order.
The Complete Excel Course with AI Integration has 186 lessons. This page picks out 18 of them, 1 h 35 min of video. Each lesson keeps its number in the course.
Where to start
Lesson 18 SIP growth calculator in Excel
Start at Lesson 18: one lesson later you have a working SIP calculator with its chart, and WealthFlow follows from Lesson 125. New to formulas? Begin at Lesson 8, or at Lesson 1 if Excel itself is new. After this path, Lesson 135 has Claude add a dashboard sheet, a finish you can equally build by hand. To see where it all leads before you start, ask for the finished WealthFlow workbook: it is free by email from the course page.
18 of 186 lessons · 1 h 35 min
01 Microsoft Excel fundamentals: building a foundation from scratch The formula skills every calculator rests on, practised on a personal budget: arithmetic with brackets in the order Excel works, SUM and AutoSum, dollar signs that keep a formula pointing at its input when copied, and percentages.
- 8 Basic maths in Excel Add, subtract, multiply and divide with formulas 3 min
- 9 SUM and AutoSum in Excel Total income, expenses and savings with MAX 6 min
- 10 Relative vs absolute references in Excel Dollar signs and mixed references 3 min
- 11 Calculating percentages in Excel Each expense as a percentage of income 2 min
02 Project: personal budget tracker Your first SIP calculator in one lesson: a monthly amount at an assumed yearly return, grown year by year by hand and then with FV on a monthly rate, the gap between the two explained, and a line chart of the growth.
- 18 Start here SIP growth calculator in Excel FV function for mutual fund investment growth 7 min
04 Essential formulas and functions (IF, SUMIF and more) TRUE and FALSE tests, then IF, practised on pupils' marks: the same decision later tells each year of your plan whether it saves or draws an income.
- 28 Logical functions in Excel TRUE and FALSE comparisons for beginners 5 min
- 29 The IF function in Excel Pass or fail results with a single condition 3 min
06 Data visualisation: charts and graphs Line charts for change over time, with chart styles and axis titles, practised on monthly sign-ups: the chart type behind every growth line in your simulator.
- 50 Line charts in Excel Show trends over time with a line chart 4 min
13 WealthFlow investment and retirement simulator WealthFlow, the heart of this page: SIPs, lump sums, SWPs and FIRE explained first; then your SIP calculator with an inputs block, a monthly rate, a yearly step-up, FV, real values and charts; your SWP calculator with withdrawals that rise with inflation, a real rate and a stress test; and your lifetime simulator, run from a start age to an end age with IF and read through scenarios.
- 125 SIP and SWP calculators What is an SIP, lump sum and compounding 6 min
- 126 SIP and SWP calculators What is an SWP, inflation and FIRE 6 min
- 127 WealthFlow SIP model in Excel Input assumptions, XIRR and monthly rate 6 min
- 128 WealthFlow SIP model in Excel Step-up SIP table and FV formulas 6 min
- 129 WealthFlow SIP model in Excel Real portfolio value, inflation and charts 7 min
- 130 WealthFlow SWP model in Excel Real rate, corpus and yearly withdrawals 6 min
- 131 WealthFlow SWP model in Excel Real corpus, stress test and SWP chart 5 min
- 132 Retirement simulator in Excel WealthFlow inputs, year and age columns 5 min
- 133 Retirement simulator in Excel SIP, withdrawal and portfolio formulas with IF 7 min
- 134 Retirement simulator in Excel Reading the results and retirement scenarios 5 min
Instructors
Who teaches it.
Instructor, Excel with AI
Virginia Thorn
Emmy Award winner. Teaches Excel with AI at Coding Liquids.
Questions
Asked before starting.
Which Excel course teaches you to build your own retirement calculator?
The Complete Excel Course with AI Integration from Coding Liquids, through WealthFlow, an industry-standard retirement simulator. It was designed after talking with people from many different industries, and you build every sheet of it yourself from a blank workbook: a SIP calculator, an SWP calculator and a lifetime simulator, with inflation built in and charts that redraw the moment an input changes. Every formula is yours to read and every assumption yours to change, so you never again depend on someone else's calculator, app or software. This page is the route there: 18 lessons and 1 hour 35 minutes of video, from the first formulas to reading your results.
Why build a retirement calculator in Excel instead of using one online?
Because the calculator is then yours, and your retirement plan stops depending on anybody's website, app or software. An online calculator hands you a figure and hides the working; the workbook you build with The Complete Excel Course with AI Integration needs nothing but Excel and traces every figure to a formula you can read. Every assumption sits in an input cell you control: the monthly amount and its yearly step-up, the return, inflation, the first withdrawal, how fast it rises and the age it starts. It also does what the basic online calculator leaves out, raising each year's withdrawal with inflation (Lesson 126). The course explains the logic on an online calculator first (Lesson 125), then builds yours from a blank sheet.
What is the Excel formula for a SIP?
FV, Excel's future value function, and The Complete Excel Course with AI Integration has you write it in your first SIP calculator (Lesson 18): the yearly return divided by 12 as the rate, the years times 12 as the number of payments and the monthly amount as the payment, checked against a column you compound by hand. WealthFlow then goes further, turning XIRR, the yearly return you assume, into the exact monthly rate that compounds to it (Lesson 127) and stepping the monthly amount up every year (Lesson 128).
Why does my SIP figure in Excel differ from an online calculator's?
Three settings decide the figure, and The Complete Excel Course with AI Integration teaches each one. Compounding once a year gives a different result from compounding every month (Lesson 18); a monthly rate can be the yearly rate divided by 12 or the rate that compounds to it (Lesson 127); and the last argument of FV puts each payment at the end of the month, or at the start when set to 1, which earns a little more (Lesson 128). Your own sheet shows which choice it made, so a difference is never a mystery.
How do I build an SWP calculator in Excel?
The Complete Excel Course with AI Integration builds one with you on a sheet of its own: a starting pot, an assumed return, inflation, a first year's withdrawal and the rate it rises by each year, then one row per year in which the pot earns its return and pays out that year's withdrawal (Lesson 130). Columns in today's money show what the pot and the income are really worth, a line chart sets the pot against the withdrawals, and lowering the return shows at once the year the money would run out (Lesson 131).
Does this retirement calculator adjust for inflation?
Yes, all the way through. In The Complete Excel Course with AI Integration the SIP calculator shows the pot in today's money beside its value on paper and charts the two (Lesson 129); the SWP calculator works out a real rate of return from the return and inflation and raises every withdrawal by a rate you can match to the cost of living (Lesson 130); and the lifetime simulator carries a real value on every row to the end age. Set the inflation input to the rate where you live and every real figure and chart moves with it.
Can I use Excel as a FIRE calculator?
Yes, and the lifetime simulator you build is exactly that. FIRE means financial independence, retire early, and The Complete Excel Course with AI Integration explains it before the build begins (Lesson 126): set the age you start investing, the age withdrawals begin and an end age, and IF switches each year from saving to drawing. Lesson 134 also stops the contributions early and lets the pot grow untouched until withdrawals begin, the idea behind Coast FIRE. To find your own FIRE number, change the withdrawal or the monthly amount until the pot lasts to your end age.
Can I add my own assumptions to the calculator?
Yes, and that is the reward for building it yourself: nothing in it is closed to you. The simulator in The Complete Excel Course with AI Integration keeps its inputs in one block that every formula reaches through locked references (Lesson 10), and it already takes a starting pot for savings you hold today. A new assumption is one more input cell: a different return for the years after retirement, say, chosen by the same IF on age (Lesson 133). The course teaches the spreadsheet and gives no financial advice, so the plan and every number in it stay yours: test each change as the lessons do, by trying new inputs and watching the whole table answer.
Excel with AI
See the whole course.
The Complete Excel Course with AI Integration: 16 hours of video in 186 lessons, built around 14 industry-standard projects, with lifetime access, a Certificate of Completion and a 14-day money-back guarantee.
The same course
For another job, goal, level, topic or comparison.
By job
Finance and accounting
- Accountants and finance teams
- Bookkeepers and accounts assistants
- FP&A and budget analysts
- Auditors and fraud examiners
- Payroll administrators
- Tax accountants and advisers
- Banking professionals
- Cost and management accountants
- Financial controllers
- Credit control and receivables teams
- Accounts payable teams
- Financial planners and advisers
- Credit analysts and loan officers
- Insurance underwriters
- Insurance claims handlers
- Reconciliation analysts
- Treasury analysts
- Medical billing and coding specialists
- Fund accountants
- Billing administrators
- AML and KYC analysts
- Actuarial analysts
- Insurance agents and brokers
- Retirement planners
HR and office administration
Operations and supply chain
- Operations and project managers
- Procurement and purchasing officers
- Logistics coordinators
- Inventory controllers and storekeepers
- Supply chain analysts
- Warehouse managers and supervisors
- PMO analysts
- Import and export coordinators
- Production planners
- Demand planners
- Fleet and transport managers
- Apparel merchandisers
Data and reporting
Sales, marketing and customer service
Business and management
Engineering, construction and manufacturing
- Quantity surveyors and estimators
- Civil and site engineers
- Quality managers and engineers
- Construction project managers
- Health and safety officers
- Document controllers
- Production managers and supervisors
- Mechanical and electrical engineers
- Industrial engineers
- Planning engineers
- Sustainability and ESG analysts
- Maintenance planners
Retail, property and hospitality
Healthcare and life sciences
Education and careers
Public sector, non-profit and legal
By goal
- Instructor support
- Certificates
- How long it takes
- Is Excel worth learning
- A budget tracker
- A task tracker
- A KPI dashboard
- A budget vs actual report
- A sales goal tracker
- An employee database
- A chart dashboard
- An employee lookup
- A self-refreshing sales report
- A checking macro
- A Power Automate flow
- A compound interest calculator
- A SIP calculator
- An Excel test for a job
- A step-up SIP calculator
- Practice exercises
- Excel skills for a CV