Hi my name is Danielle and I am 16 years old. I am a student and have a part-time job at a local McDonalds restaurant here in Nova Scotia, Canada. I was looking on the Net for information on budgeting and came across your letter.
The thing I have a problem with was the “sum function.” What is that?
Also I was wondering if you had an easier budget plan specifically designed for teenagers with part-time jobs like myself. -Danielle, Concerned money spender
The “sum function” is one of many “functions” (programmed formulas) that are built into spread sheet programs. There are a great many different “functions” (logical, financial, mathematical, statistical, etc.). That’s what spreadsheets are all about.
All of which can be accessed from a menu somewhere depending on which spread sheet program you are using.
The “sum” function gives the sum of values in a row or column of cells. Since it is one of the most frequently used functions, some spreadsheets have made it extra easy by having an icon button in the tool bar with the “sum” symbol (a Greek letter that looks sort of like an uppercase “E”) in it.
This is what I meant by “auto sum” (I use MSWorks 4.0 for Windows 95). You just click on the button and automatically it fills in the formula for the sum of all the cells immediately above or to the left (whatever the case may be). It’s very quick and easy.
I looked in “Quatro Pro,” another spreadsheet program, and there it is called “quick sum.” The syntax is slightly different.
For your budget I would do something very simple:
What is the minimum amount of money (take-home) that you make every week? Use that amount to figure out how much you will make each month from now until school is out. Use the number of paydays each month as the multiplier. Some months will have four paydays, some five.
Ask your boss if he/she will give you more hours for the summer. How many? Factor in time off for a family vacation if that is likely.
Use info from #3 to estimate what you will most likely earn for each of the remaining months until you go back to school in the fall.
If you plan to keep on working part-time in the fall, estimate your earnings, as you did for current work, for the remainder of the year.
Now, in your spread sheet put a title in the first row. Put it in column E or F. You could call it “MY BUDGET FOR 1998”
Leave row 2 blank.
In the third row, put the months of the year in columns B through M. Put “Total” in column N.
In the fourth row, put “INFLOWS” in cell A4.
In the fifth row, cell A5, put “Wages”. In cells B5 through M5 put your earnings estimates for your wages for each month that you figured out above.
Move over to cell N5. Click on the “Auto Sum” button in the tool bar (if you have it) or find the menu through which you can access “function”, click on it for a list, and look for “SUM” (you will need it for the correct syntax).
The parameters to fill in for the “SUM” function will be B5:M5 (automatically filled in with AUTO SUM). Press the enter button after you have keyed it into cell N5.
If you had other sources of income you could do additional rows and sum the column for each month.
Skip a row, and put “OUTFLOWS” in col. A. (I think we’re up to row 7 here). Now you can continue entering in column A category names for things you would like to spend your money on. I would keep it simple.
Giving – to your church, or a charity; 10% suggested
Please note that the sum of each column of OUTFLOWS should not exceed the INFLOW for that column (above it).
If you want to use percentages, as I have suggested in the examples above, you could have the spreadsheet figure out the amounts for you by entering a formula instead of an amount in the appropriate cell.
If your total income for January is the amount you entered in cell B5, for example $100, and the “Giving” category is in row 8, you could put this formula in cell B8: =b5*.10
Press the enter key and now you will see $10 in cell B8 of the spreadsheet.
Note that the formula is still visible in the data entry line at the top of the spreadsheet when that cell is highlighted. You would still need to use the “sum” function at the bottom of the column of monthly expenses to total them, then compare them with the total income for the month on line 5 (or whichever line your total income happens to be on) by entering a formula to represent “total inflows” – “total outflows”.
Hopefully this will yield zero, “0”, if done correctly. Note that the percentages must not exceed 100% of the total.
Don’t forget to total each spending category for the year using the sum function (or auto sum) over in column N.
I hope this all makes sense to you and that I have not overwhelmed you with too much information. The main point I would like to make is that YOU can design your own budget to fit your own situation.
Don’t forget that in order to make a budget work you have to keep good records of everything you earn and everything you spend, whether on the computer with a program like Quicken (probably overkill for someone like you) or on paper (accountantÕs ledger paper, cash journal, or plain notebook).
Then compare it with your written plan (the budget) to see how you are doing.
Good Luck, Karen Jones firstname.lastname@example.org
Karen is a former computer systems analyst programmer, the wife of a minister and an at-home-mother of two teenage daughters. Home management, and especially budgeting are her forte, but she also enjoys sewing, crafts, Girls Scouts, garden club, and volunteering at church and school. If you have specific questions about her budgeting method you can email her at email@example.com.
SITE DISCLAIMER: The self help personal development resources on this site are not intended to be a substitute for therapy or professional advice. While all attempts have been made to verify information provided in this self help personal development publication, neither the author nor the publisher assumes any responsibility for errors, omissions or contrary interpretation of the self help personal development subject matter herein. There is no guarantee of validity of accuracy of any self help content. Any perceived slight of specific people or organizations is unintentional. This self help personal development website and its creators are not responsible for the content of any sites linked to.
The self help contents are solely the opinion of the author and should not be considered as a form of therapy, advice, direction and/or diagnosis or treatment of any kind: medical, spiritual, mental or other. If expert advice or counseling is needed, services of a competent professional should be sought. The author and the Publisher assume no responsibility or liability and specifically disclaim any warranty, express or implied for any self help or otherwise products or self help or otherwise services mentioned, or any self help or otherwise techniques or practices described. The purchaser or reader of this self help personal development publication assumes responsibility for the use of these self help personal development materials and self help personal development articles and information. Neither the self help author nor the self help Publisher assumes any responsibility or liability whatsoever on the behalf of any purchaser or reader of these self help personal development materials.
It's time to join our happy subscribers, like these:
"I wish to express my appreciation and gratitude for this powerful tips you send to me.Thank you so much and may God richly bless all the team working towards this.
Thank you for this. It has been most instructive. Please keep them coming!
With no other words, I simply love these Power Tips - thanks for every email I have received from you - I find there always something that cheers my day up or gives me some more inspiration. Good work, there!
I always read your Power Tips and it has helped me a lot in my life... I would like to thank you a lot for such a nice article at regular intervals.
I am really grateful to you for what you have been doing for me and my growth. I know that I am not alone and hundreds of thousands of people would be feeling the same.
Your Newsletter are always a help. Thanks a tonne.
You are doing so much for the whole mankind and as a matter of fact sometimes even a small thought delivered at the right time can do miracles in someone's life and his whole life can take a turn around.
When the positive seeds through your news letter are falling all over the world, then I am sure some would become tree and bear fruits.