|
|
|
|
Spreadsheets
I chose my career as systems analyst because it is a career I am interested in pursuing. With some help, I was able to predict the amount I would make in this profession. By multiplying the pay per hour by the hours per week, I came up with the gross pay per week. Then the salary was found by multiplying the pay per week by the number of weeks in a year.
From each salary taxes are deducted, and here is a portion of my spreadsheet which shows the tax rate, how much money is taken out for each tax, and the amount of money taken out for each tax over the course of the year. By looking at the chart, it is easy to see approximately how much money is taken out for each tax.
Within this portion of the chart, you can see, once again, the net pay per week. From this amount I took money out as an emergency fund. Also, after all the taxes and other expenses were taken out, the net pay per month shows how much money I have left over.
In this section of the spreadsheet, I divided the individual expenses by the net pay per month to find out what percentage of my salary was going towards housing. In the chart to the right, you can see that the majority of my living expenses goes towards the rent or mortgage.
This section displays the money spent towards my "consumables," such as groceries and gasoline. Also, the percentage of my net pay is shown on the right side of the pay and was found by dividing the cost of the consumable by the net pay. Once again, the information is shown more artistically to the right on the food/maintenance chart.
With every independent life comes loans. Here, I approximated how much I would have to pay in loans per month, and found that percentage of my net pay by dividing the cost by my net pay. In the loan chart, I used cones to show how much is being taken out of my pay.
The miscellaneous items which are deducting money from my pay are listed in this section of the chart. Also, by using the previous procedure, I found the percentages of my total pay. Again, the information is shown in a more creative way at the right.
In this portion of my spreadsheet, you can see how much money I end up with after all the expenses were deducted from my net pay, leaving my with a mere $109.70 for my investments. The extra was found by subtracting the total expenses from the net pay.
Here is the investment section of my spreadsheet in which I simulated putting some of my extra money into the stock market. In the chart you can see how the amount of my money increased with time. Over the course of fifteen years there is a substantial difference, and I am able to see how it would be a good choice to invest as soon as possible.
|
|
Copyright 1999-2000, all rights reserved Please
|
