Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-16-2020, 06:56 AM
DJ0691 DJ0691 is offline Draft - Retirement Calculator Windows 10 Draft - Retirement Calculator Office 2013
Novice
Draft - Retirement Calculator
 
Join Date: Jan 2020
Posts: 18
DJ0691 is on a distinguished road
Default Draft - Retirement Calculator

Hello Excel Gurus,



I've seen a number of different retirement calculators but not many allow a quick overview of income by withdraw percentage rates without typing each one in separately. I took a shot at making one of my own and perhaps benefit others as well. See the attached. Questions:

1) Have I used the NPER and FV functions correctly? These calc how long the funds will last and what the future values will be.

2) I tried to take into account the fees associated with a financial advisor. These fees are typically based on overall funds managed and may decrease or increase over time as the funds balance changes - how would you account for that?

3) Any value with incorporating the marginal tax rate - if so, how would you do that?

Thanks!
Attached Files
File Type: xlsx Retirement Calculator.xlsx (15.6 KB, 9 views)
Reply With Quote
Reply

Tags
retirement

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Retirement macropod Forum Support 2 05-30-2021 11:23 PM
Draft - Retirement Calculator How to compare old draft to current draft? Dave92F1 Word 1 06-18-2019 03:52 PM
Draft - Retirement Calculator Calculator in word Zhibek Word 2 08-17-2018 12:07 AM
Draft - Retirement Calculator Result Calculator Raza Excel Programming 7 01-26-2015 11:35 PM
Excel Calculator Mandusin Excel 6 12-25-2010 07:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft