Dividend Growth Forum
Retirement Payment Calculator - Printable Version

+- Dividend Growth Forum (http://DividendGrowthForum.com)
+-- Forum: Dividend Growth Investing (http://DividendGrowthForum.com/forumdisplay.php?fid=15)
+--- Forum: Resources for Dividend Growth Investors (http://DividendGrowthForum.com/forumdisplay.php?fid=36)
+--- Thread: Retirement Payment Calculator (/showthread.php?tid=1732)



Retirement Payment Calculator - Robandcindy2 - 01-04-2018

Good Morning and Congratulations on DOW 25,000 (1/4/18) !!

Looking for some Excel experts.

I've been researching what my "number" should be.  This led me to this article and some of the readers comments:
Retirement Numbers Are Hokum

So I dug deeper and put together this calculator.  There is an old joke about Aviators:  "What do you do for a living Rob?   Well, I'm a PealotPilot, Pilate, err, ahh....I fly jets."   That's me in a nutshell when it comes to Excel.

If anyone has a second, would you check my work please?

And if this works, makes sense, and can be used by our group here, please repost this in the most appropriate forum.

Thank you in advance

Rob

[attachment=205]


RE: Retirement Payment Calculator - ChadR - 01-05-2018

The only thing that really throws me is line 5.

Enter 1 for interest paid on 1st, or 1 for interest paid at end of month

Should one of those 1s be a 0?


RE: Retirement Payment Calculator - Robandcindy2 - 01-05-2018

(01-05-2018, 10:10 AM)ChadR Wrote: The only thing that really throws me is line 5.

Enter 1 for interest paid on 1st, or 1 for interest paid at end of month

Should one of those 1s be a 0?

Absolutely.   I'll fix that.  Formula wise it is making the correct calculation?


RE: Retirement Payment Calculator - ChadR - 01-08-2018

I believe that the formula is correct. But like you, I know enough excel to be dangerous.


RE: Retirement Payment Calculator - Jimbo - 01-08-2018

Hmmm, I try to capture it, it says I need to login, Im logged it but it wont open for me. :-(

Jimbo