$12.99
Document provided by...
pagosspreadsheetzone
www.spreadsheetzone.com
(Learn more...)
About This Document
This file is prepared for creating and analyzing personal budgets easily. The budget may be prepared for 3 months. Firstly, the desired months is determined by the user and a weekly calendar is created automatically. 9 most common expense titles are used in this file. However, the titles may be edited easily (instructions on Readme sheet). The expenses incurred are recorded over the 3 months. The totals of expense titles, total income and the final balance of the user are calculated. Also, a Pareto analysis is carried out with a Pareto Chart. This analysis is used for pointing out the expenses that has the greatest impact on the budget. Commonly this analysis is carried out for 80% (expenses covering the 80% of the total expenses are searched).
Stats
Type:
Excel Spreadsheet
Size:
43 kb
Pages:
11
Views:
631
Posted:
08/02/09
Categories
DocStore > Templates > Spreadsheets
Tags
make a personal budget, personal budget worksheet, to set up a personal budget, personal budget template, make personal budget, creating a personal budget

Weekly Personal Budget- 3 Months

View, download, and print this entire document by purchasing it for only $12.99
WEEKLY PERSONAL BUDGET O Week Friday the 5th Friday the 12th Friday the 19th Friday the 26th Fixed Weekly Income 375 375 375 375 Extra Weekly Income Rent Gas Electricity 50 100 100 40 June July Friday the 3rd Friday the 10th Friday the 17th Friday the 24th Friday the 31th Friday the 7th Friday the 14th Friday the 21th Friday the 28th 375 375 375 375 375 375 375 375 375 August Totals of 13 weeks: #### 100% 4,875 3,640 100 50 100 40 Final Balance: Pareto Analysis of Ex 90% 80% 70% 60% 50% 40% 30% 20% 10% 0% Inusrance Food C.Card Paym. Phone SONAL BUDGET OF 3 MONTHS Expenses Electricity Water Food Phone Inusrance C.Card Paym. Others Balance -100 260 225 265 40 10 75 75 75 75 50 40 35 60 150 300 200 640 1,015 1,390 1,765 2,140 2,515 2,890 3,265 3,640 40 10 300 185 350 300 0 to Analysis of Expenses Gas Rent Electricity Water Others Nb 0.001 0.002 0.003 0.004 0.005 0.006 0.007 0.008 0.009 0 0 3.75% 1 2 3 4 5 6 7 8 9 0 1 Rank ReRank 6 6.001 5 5.002 7 7.003 8 8.004 2 2.005 4 4.006 1 1.007 2 2.008 9 9.009 0 0 7.49% 0 13 0 OrderNb 1 2 3 4 5 6 7 8 9 0 7 5 8 6 2 1 3 4 9 0 Exp Inusrance Food C.Card Paym. Phone Gas Rent Electricity Water Others 0 3.00% 0.75% Cexp 26% 49% 71% 85% 93% 96% 99% #### #### 0 Exp 0.26 0.22 0.22 0.14 0.07 0.04 0.03 0.01 0 ReRank 1.007 ReRank 2.008 ReRank 5.002 ReRank 7.003 ReRank 9.009 ReRank 2.005 ReRank 4.006 ReRank 6.001 ReRank 8.004 ReRank >1,007 ReRank >2,008 ReRank >5,002 ReRank >7,003 ReRank >2,005 ReRank >4,006 ReRank >6,001 ReRank >8,004 22.47% 13.86% 26.22% 22.47% 0.00% Weekly Personal Budget (3 Months) >> This t