Pension Lump Sum vs Annuity: Present Value, Break-Even Age & Risk Trade-offs
Value a pension offer the way an analyst would: PV at different discount rates, the annuity's implied return with RATE, break-even ages, mortality-weighted expected value, COLA vs fixed payments in real dollars, a drawdown path, the probability of running out and joint-and-survivor options: 8 graded labs on one fictional retiree. Illustrative rates and life table, not financial advice.
- One-time payment
- 14-day money-back guarantee
- Secure checkout with Stripe
What you'll build
What you will be able to do
Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.
- Value Maya's pension annuity of $1,850 a month as a lump-sum equivalent at six discount rates and see at which rates the annuity or the $310,000 lump sum looks better.
- Turn the choice around: what return does the annuity pay on the $310,000 if Maya lives to 75, 80 … 100, and from which age does it beat a safe 4 % return?
- Track 30 years of annuity payments, cumulative and discounted, and find the age at which Maya has received more than the lump sum, without and with the time value of money.
- Value the lifetime annuity properly: each year's payment times the probability that Maya is alive to receive it, discounted, summed to the expected present value and compared with the lump sum.
- Compare a fixed $22,200 a year with a lower annuity that rises 2.5 % a year (COLA), both in nominal and in today's dollars at 3 % inflation, and chart the buying power over 30 years.
- Take the lump sum instead, withdraw the same $22,200 a year and earn 4.5 %: a year-by-year balance path, the age when the pot is empty, the years of full income and a chart of the balance.
- Test the drawdown plan against six return scenarios with probabilities: the balance left at 90 in each, which ones run dry, the probability of running out and the probability-weighted balance.
- Compare Maya's single-life pension with 50 %, 75 % and 100 % joint-and-survivor options for her husband Daniel: the reduction for each, two annuity factors from survival probabilities and the expected value for the household.
About this course
Choosing between a one-off lump sum and a lifelong pension is one of the biggest financial decisions many people face, and it cannot be undone. This course gives you the tools to compare the options on equal terms. You discount a level annuity at several rates, find the return it implies depending on age at death and calculate the break-even age at which cumulative payments overtake the lump sum. Survival probabilities produce a mortality-weighted value, and you compare inflation-linked and fixed payments in real terms. On the lump-sum side you model a drawdown balance and run-out age, then estimate the probability of running out across return scenarios. A final lab values joint and survivor options. Educational only, not financial advice.
Curriculum
Course content
8 lessons · 8 labs · 2.1 h · final exam
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Final exam
Certificate
Finish with a certificate you can verify
Complete every lesson and pass the final exam to receive a certificate of completion for this course, with a unique credential ID and a public verification page.
- Names the course, your score and the date of issue
- A verification link for your CV or LinkedIn profile
- 12 questions, 75% to pass, unlimited retries.
A Tutorvo certificate confirms that you completed a course. It is not an official or professional qualification.
Before you buy
Questions about this course
Is this a subscription?
No. You pay $9.99 once for this course. There is no subscription and nothing renews automatically. Prices are in US dollars; taxes may be added where required.
What exactly do I get?
All lessons and labs of this course, the final exam and the certificate, including later updates to the course, for as long as Tutorvo offers it. Access is personal and tied to your account.
Can I get a refund?
Yes. If you are not satisfied, email hello@tutorvo.com within 14 days of buying and we refund the course in full via Stripe. The guarantee does not apply once a certificate for the course has been issued to you, or where there are signs of abuse.
When can I start?
Right after payment. Access starts immediately at your request; for consumers in the EU/EEA the statutory right of withdrawal therefore ends once access has begun, while our 14-day money-back guarantee applies regardless.
Do I need Excel or other software?
No. The labs run in a spreadsheet inside your browser on a laptop, tablet or phone. Function names and syntax follow Excel.
Is the certificate an official qualification?
No. It confirms that you completed all lessons of the course and passed its final exam. It is not an official, state-recognised or professional qualification. The name is taken from your profile when the certificate is issued.
Full details are in our Terms · hello@tutorvo.com
