Anonymous

18 Sep 2021

∙

Hi, is there a formula or excel template to calculate the withdrawal rate per month for retirement with given portfolio amount, number of years to withdraw and the return on amount not withdrawed?

Excel template to calculate the withdrawal rate per month for retirement with given portfolio amount

5

Discussion (5)

What are your thoughts?

Learn how to style your text

Planner Bee

19 Sep 2021

Though this isnt quite the calculator you are asking for, try this retirement calculator that takes CPF Life payout into account. https://plannerbee.co/calculator-retirement/

Reply

Save

Finney Neo

19 Sep 2021

I recently created an excel template for this purpose, which you can download from my gdrive. Let me know if there are any issues

https://docs.google.com/spreadsheets/d/1FtLY1So...

Reply

Save

Jared Lee

19 Sep 2021

Finance at Murdoch University

There used to be a study done in the 70s using data from 1920s-1970s, and somebody came up with some...

Write your thoughts

Related Posts

How to calculate interest rate for pruflexicash (25year term)? Paying $150 a month. My cash benefit option is selected as accumulation but I did some withdrawal a few years back for my holidays.?

Is there a formula or free excel template to calculate % yield for insurance returns?

I am currently investing $300 per month into ETF STI through DBS. I am a pretty low risk investor. If i carry on contributing this amount per month for the next 30 years (DCA method), will i gain?

How do I calculate with financial calculator the effective annual return rate for an endowment of 10 years tenure with yearly payment of $500 (for 10years) and illustrated yield of $70000 at maturity?

iSwitch ;Chope’ the Rate (24 Months) plan @17.55Cents for 2 years. Clarify service fee $5.297/ month as per factsheet. What is this charge for? Are all vendors charging this service fee each month? ?

Related Posts

How to calculate interest rate for pruflexicash (25year term)? Paying $150 a month. My cash benefit option is selected as accumulation but I did some withdrawal a few years back for my holidays.?

Is there a formula or free excel template to calculate % yield for insurance returns?

I am currently investing $300 per month into ETF STI through DBS. I am a pretty low risk investor. If i carry on contributing this amount per month for the next 30 years (DCA method), will i gain?

How do I calculate with financial calculator the effective annual return rate for an endowment of 10 years tenure with yearly payment of $500 (for 10years) and illustrated yield of $70000 at maturity?

iSwitch ;Chope’ the Rate (24 Months) plan @17.55Cents for 2 years. Clarify service fee $5.297/ month as per factsheet. What is this charge for? Are all vendors charging this service fee each month? ?