Excel- what do you have spreadsheets for?

jIM_Ohio · #1 (**permalink**) 02-26-2007, 02:16 PM

In one of the other threads on budgeting software several posters mentioned they use excel, what spreadsheets do you have in excel?

I have a workbook on retirement progress
I have a sheet on tax rates/tax tables
I have a sheet on projected balances of IRAs
I have a sheet on "checkpoints" for IRAs and 401ks (amounts needed to check for at given ages)
I have a sheet for IRA contributions tracking percentages and suggesting % to contribute to rebalance without selling.
I have a sheet with account numbers, web sites, logins
I have a 2-3 sheets on various withdraw strategies (and calculating starting balances)
I have a sheet with plan summary to describe all the other sheets

I have a workbook on our budget
I have our current budget on one sheet
I keep copies of old budgets (not sure why, but I keep everything)
I have a sheet with 1st mortgage ammortization schedule
I have a sheet with 2nd mortgage ammortization schedule
I have a sheet tracking dividend income
I have a sheet tracking interest income

What sheets do you have? Have you made excel do anything clever?

PrincessPerky · #2 (**permalink**) 02-26-2007, 02:29 PM

not particularly clever but I am proud of my color changing budget (pink for over, green for under...)

and I have my calender, budget, bank book, and 'counting chickens' on it.

jIM_Ohio · #3 (**permalink**) 02-26-2007, 02:34 PM

Quote:

Originally Posted by PrincessPerky

not particularly clever but I am proud of my color changing budget (pink for over, green for under...)

and I have my calender, budget, bank book, and 'counting chickens' on it.

what are "counting chickens"?

PrincessPerky · #4 (**permalink**) 02-26-2007, 02:40 PM

reference to one of Aesops fables 'the milk maid'

my chicken counting[/url]

milk maid story

cptacek · #5 (**permalink**) 02-27-2007, 05:34 PM

I have a worksheet for each checking account so I can keep track of money I have to spend...I have three of them and balance them about every 2 weeks. I also have a worksheet for the monthly bills that my roommate and I share, (I enter the amount I paid, and the formula divides it in half in the next column, and then I enter when I paid it) so I can tell her what she owes me at the end of the month. I just started a worksheet to tell me when my bills are due. Previously, I logged in to every account every week or so and paid if it was due, but some of the companies make it look like you still owe even if you already paid it. So, I am keeping track of the due date and if it has been paid.

I have a spreadsheet of all my debts that is a snapshot in time. I enter the current amounts owed and it tells me the differences in principal from the last time I looked at it. Interesting to look back over a few years to see how the balances have fallen.

I have a business loan that I pay part of once a year. (for those of you keeping track, I paid the last one off in January but borrowed more money so I could buy more cows to keep my herd up). The interest is accrued daily, so if I make a principal payment before the yearly amount is due, it decreases the interest owed over the life of the loan. I keep track of that so I can keep inspiring myself to pay it off early.

I have a spreadsheet that tracks the expenses and income I am getting from the cattle. I get paid pretty much once a year when we sell calves but spend money throughout the year, so I keep track of that.