You are here: Home › Financial Spreadsheets

Financial Spreadsheets

Currently downloads are not available. I have run into issues with my digital download plugin and will restore digital downloads once this has been resolved.

4 Responses to "Financial Spreadsheets"

Madeleine says:

March 18, 2018 at 10:29 am

Hey, I’m glad I found your blog! We’re in a similar situation financially and I appreciate you putting out what you’ve learned for others in the same boat!

I’m playing with the sheets and on the Tax Planning 2018 sheet, I think there may be a formula error? On “Married Joint” on D39, it looks to be using =SUM(D36:D38) when it should be using =SUM(D33:D38).

Also, I’m a bit confused on the Retirement Planning Income Goal page. With a larger withdrawal percentage, wouldn’t you need a larger retirement goal? I’m not sure what this page is trying to show.

Reply
1. John C says:
  
  March 18, 2018 at 9:00 pm
  
  Oops! Thank you for letting me know about the calc. error. I will get that changed shortly. On the retirement planning spreadsheet the ‘Income Goal’ sheet is designed to show how much total savings you need based on what percent of the total you are withdrawing per year. The larger withdrawal rate you take the higher the risk is that your portfolio may end up running out at some point, or not grow as large. With a larger withdrawal percentage you will need a smaller nest egg to meet the same desired income stream. As an example, if you want to withdrawal $50,000 per year using a 5% withdrawal rate you would need $1 million. If you were using a 10% withdrawal rate, taking out 10% of the initial balance per year, you would only need $500,000, however your risk of running out of money would increase substantially.
  
  Reply
Diane taber says:

May 6, 2020 at 10:28 am

Hi we just really need some spreadsheets for to start budgeting and getting our finances together and under control.

Reply
1. John C says:
  
  May 6, 2020 at 4:59 pm
  
  Hi Diane, Here’s a link to a really good budgeting spreadsheet. https://www.savvyspreadsheets.com/ Alternatively check out Dave Ramsey’s Everydollar app.
  
  Reply

Leave a Reply Cancel reply