See attached file, cell P48. I developed a spreadsheet for my personal use so it was easy to hardwire it for my own information. But, several friends want copies so I am trying to automate it. My primary problem is how to automate Goal Seek. Basically, I am trying to determine how much money to set aside for Medicare and Long Term Care costs. I do this by listing all the withdrawals, and an investment return on the balances, etc. The actual amount is the result of a Goal Seek. I have reached an impasse in my thinking. So, all help is appreciated. THANKS!
29.5 KB Views: 11