Excel Pension Planning Calculator

hellojohn8doe7

Hello

Can someone please share their Excel based Pension Planning Calculator or Forecast Generator? I know there are a few online based, however I like to see how the formulas are working...

I decided to make one for myself (as below) but it didn't work out:

(All figures are assumed and the ones marked in bold are calculated)

Inflation = 2%
Current Age = 35
Retirement Age = 65
Years to Retirement = 30 (subtraction of above 2 rows)
Investment Growth = 5%
Monthly Contribution = M
Monthly Contribution Growth = 0% (the calculator does not use this row)
Current Pension Pot Value = C
Pension Pot at Retirement Age =FV (5%/12, 12*30, -M, -C)
Pension Pot in Today's Term =PV (2%/12, 12*30, 0, -ABOVE_ROW)
Pension Pot for Annuity = 0.75 * ABOVE
Withdrawal Rate = 4%
Platform Charge = 0% (this calculator does not use this row)
Investment Fund Charge= 0% (this calculator does not use this row)
Pension Income = Pension Pot for Annuity * Withdrawal Rate

I don't know if the above is correct - therefore, I will appreciate any comments, feedback and guidance. Thanks a lot for your help.

ggmf

There a numerous videos on YouTube that can give the basis of building your own spreadsheet, maybe look Lars Kroijer "Build your own Financial Planning Spreadsheet" series Here's No. 1 of 10 - https://www.youtube.com/watch?v=1LUIQa5hgMg