posted
In another thread, Steve Shortreed posted: ***We'll need is a really good worksheet. Jeff Cahill includes one in his article. We can use this or expand on his and create one of our own that we can each print out. Anyone interested in looking after this chore?***
Steve, no chore at all. I already have one made up that I use for myself and anyone else that has MS Excel or a Spreadsheet program that can open Excel files can find it on my website for download here - I think I've posted this before.
Now, this worksheet doesnt contain every single itemized expense, there's just too many to list and everyone's is different. I've even added a few fake items and removed my personal stuff cause hey, my finances are MY finances.
If you are sketchy on using Excel and need to add lines to add expense items, simply RIGHT-click on the number on the left (you MUST click on the number!) where you want to add the line and select "Insert" from the menu that pops up. You will have a new line and the other lines below will be moved down, plus Excel updates the cells that perform calculations so you dont have to mess with that.
NOTE: These are all MONTHLY values in this worksheet.
The line towards the bottom labeled "Take Home Pay" needs some clarification. This is how much $$ you want to have left for yourself and your family each month, AFTER ALL THE BILLS are taken care of. Right now it's at $2,000/month, which means after your house payments, insurance, electricity, food, clothes, etc etc are taken care of, you STILL have $2,000/month left! This is IN ADDITION to the $25/hr rate for "Shop Owner" listed in the "Staffing" section! I'm basically treating the owner as an employee for all intents and purposes of this worksheet. You can pay him/her more if you like but there's plenty of $$$$ buffered into this thing elsewhere!
How do you like that? Pay yourself twice (errr.. three times?) PLUS bring in a profit for the shop!
If anyone has any questions about using this worksheet, post them here!
***Edit***: Hey, I just noticed on this worksheet that when your expenses go up, not only does the overhead go up but the Net Profits go up as well! COOL!!
[ February 17, 2003, 02:42 PM: Message edited by: Mike Pipes ]
-------------------- "If I share all my wisdom I won't have any left for myself."
Mike Pipes stickerpimp.com Lake Havasu, AZ mike@stickerpimp.com Posts: 8746 | From: Lake Havasu, AZ USA | Registered: Jun 2000
| IP: Logged |
posted
Mike thanks for sharing this. I downloaded it and will have to sit down and figure it out. I dont work with spread sheets but I'm sure I'll be able to. Thanks again..
-------------------- Bob Stephens Skywatch Signs Zephyrhills, FL
![[Smile]](smile.gif)
Printer-friendly view of this topic