tcs11705 wrote:These are really great, thank you, I'm overwhelmed by so many responses to my first post.
What I neglected to mention is that my rent is going up on average $500/yr. So as that increases, principal decreases, and there's no way to know for certain how many CD's will have to be broken.
I looked at Excel, it looked very complicated, I'll take another look. Maybe OfficeLibre is easier.
I have never used it but you can use the spread sheet in Google docs I believe for free rather than exel if you want. Spread sheets are very good for these things, I recommend you give that a try if you can, but if they intimidate you don't worry. Just do it by hand. If you do it yearly by hand is not very hard. Likely way faster than learning spread sheets.
If you want, just make two types of expenses, just like having two types of income (SS and interest). One would be rent and one would be "other". Other goes up with inflation of say 3% and rent you can have go up by $500K, or by 5% or whatever you want. Add them to get your estimated expense for the year.