ࡱ> 8:7 bjbjcTcT .>> UUUUUiiii uit:RTTTTTTm ~U|"UUUURR:,)i  >0R   U |T(  : PERSONAL BUDGET EXCEL ASSIGNMENT Excel can be a very helpful tool for planning personal finances. Your assignment is to create a template for planning a personal budget for yourself. Your budget will be based on a real job that you hope to have and realistic costs of living in this area. Therefore, you will begin by choosing an entry level job that you see yourself having in the future. This can be a job right out of high school or a job that you will obtain after graduating from college. Some sites that may be helpful are  HYPERLINK "http://www.monster.com" www.monster.com,  HYPERLINK "http://www.careerbuilder.com" www.careerbuilder.com, and  HYPERLINK "http://www.snagajob.com" www.snagajob.com. Once you have found the job of your choice you will begin creating your template. Your template should include appropriate formulas and formatting. When you template is complete, you must get it approved by Mr. K before moving on. Once you have received approval on your template, you must create a budget worksheet for the first year after you graduated from High School or College (starting in July of the year you graduate). The yearly worksheet should go from July to June. Label the worksheet with the year that it is for (i.e. the worksheet for July 2012 to June 2013 would be called 12-13) The template will include your Monthly Income. Assume that you will be working at least 40 hours a week. You must also include at least the following Yearly Expenses broken down by Month. Remember some months certain expenses may be higher than other months. Housing (Rent/Mortgage) - $12,347.89 Water - $604.32 Electric/Power - $723.76 Cell Phone - $689.24 Food - $5080 Personal Items (Soap, Toothpaste, etc.) - $1236.53 Car Payment - $3509.21 Gas - $960 Entertainment (movies, going out, etc.) what do you think you will spend? Clothes - what do you think you will spend? You should also include any savings that you will want to generate. Your template must also include (at least) the following Totals: Total Income for Each Month/Year Total for Each Type of Expense for Each Year (i.e. $$ spent on Food in 2012 to 2013) Total of All Expenses for Each Month/Year (i.e. $$ spent during 2012 to 2013) Total Savings for Each Month/Year Total Excess Income for Each Month/Year Finally, you must create a Cone Chart based on the Yearly Budget worksheet. This chart will compare your spending on each type of expense over the year included in your workbook. Your Cone Chart should include proper labeling of the X and Y Axis. The title of the chart should be created in Word Art. Your chart should also contain a text box containing helpful info and an arrow. Use the Cone Chart to determine where your spending should be cut back or where you may be able to spend or save more. Type your suggestions in comment box on the Long-term Budget Worksheet. Make sure your comment is placed in the appropriate cell(s) of the worksheet. $  ? @ A P Q S T ~   * V d 2<KQ/:h~35OJQJ\^JhBYwOJQJ^J!jh~3OJQJU^J!jh~3OJQJU^Jh~30JOJQJ^J!jh~3OJQJU^Jjh~3OJQJU^Jh~3OJQJ^Jh~3,#$gh 6 7 ?@euR & F(} & F,1h/ =!"#$% DyK www.monster.comyK 0http://www.monster.com/DyK www.careerbuilder.comyK <http://www.careerbuilder.com/DyK www.snagajob.comyK 2http://www.snagajob.com/^ 666666666vvvvvvvvv666666>6666666666666666666666666666666666666666666666666hH6666666666666666666666666666666666666666666666666666666666666666662 0@P`p2( 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p8XV~_HmH nH sH tH @`@ NormalCJ_HaJmH sH tH Z@Z  Heading 1$<@&5CJ KH OJQJ\^JaJ DA`D Default Paragraph FontViV 0 Table Normal :V 44 la (k ( 0No List 6U@6  Hyperlink >*B*phPK![Content_Types].xmlj0Eжr(΢Iw},-j4 wP-t#bΙ{UTU^hd}㨫)*1P' ^W0)T9<l#$yi};~@(Hu* Dנz/0ǰ $ X3aZ,D0j~3߶b~i>3\`?/[G\!-Rk.sԻ..a濭?PK!֧6 _rels/.relsj0 }Q%v/C/}(h"O = C?hv=Ʌ%[xp{۵_Pѣ<1H0ORBdJE4b$q_6LR7`0̞O,En7Lib/SeеPK!kytheme/theme/themeManager.xml M @}w7c(EbˮCAǠҟ7՛K Y, e.|,H,lxɴIsQ}#Ր ֵ+!,^$j=GW)E+& 8PK!Ptheme/theme/theme1.xmlYOo6w toc'vuر-MniP@I}úama[إ4:lЯGRX^6؊>$ !)O^rC$y@/yH*񄴽)޵߻UDb`}"qۋJחX^)I`nEp)liV[]1M<OP6r=zgbIguSebORD۫qu gZo~ٺlAplxpT0+[}`jzAV2Fi@qv֬5\|ʜ̭NleXdsjcs7f W+Ն7`g ȘJj|h(KD- dXiJ؇(x$( :;˹! I_TS 1?E??ZBΪmU/?~xY'y5g&΋/ɋ>GMGeD3Vq%'#q$8K)fw9:ĵ x}rxwr:\TZaG*y8IjbRc|XŻǿI u3KGnD1NIBs RuK>V.EL+M2#'fi ~V vl{u8zH *:(W☕ ~JTe\O*tHGHY}KNP*ݾ˦TѼ9/#A7qZ$*c?qUnwN%Oi4 =3ڗP 1Pm \\9Mؓ2aD];Yt\[x]}Wr|]g- eW )6-rCSj id DЇAΜIqbJ#x꺃 6k#ASh&ʌt(Q%p%m&]caSl=X\P1Mh9MVdDAaVB[݈fJíP|8 քAV^f Hn- "d>znNJ ة>b&2vKyϼD:,AGm\nziÙ.uχYC6OMf3or$5NHT[XF64T,ќM0E)`#5XY`פ;%1U٥m;R>QD DcpU'&LE/pm%]8firS4d 7y\`JnίI R3U~7+׸#m qBiDi*L69mY&iHE=(K&N!V.KeLDĕ{D vEꦚdeNƟe(MN9ߜR6&3(a/DUz<{ˊYȳV)9Z[4^n5!J?Q3eBoCM m<.vpIYfZY_p[=al-Y}Nc͙ŋ4vfavl'SA8|*u{-ߟ0%M07%<ҍPK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 +_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!Ptheme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK]   @PS XXX8@0(  B S  ?  ]^*e .3qsy{    K Q s%oaؾLwrh ^`OJQJo(h ^`OJQJo(oh pp^p`OJQJo(h @ @ ^@ `OJQJo(h ^`OJQJo(oh ^`OJQJo(h ^`OJQJo(h ^`OJQJo(oh PP^P`OJQJo(h ^`OJQJo(h ^`OJQJo(oh pp^p`OJQJo(h @ @ ^@ `OJQJo(h ^`OJQJo(oh ^`OJQJo(h ^`OJQJo(h ^`OJQJo(oh PP^P`OJQJo(s%oaLw                  BYw~3 @   @UnknownG* Times New Roman5Symbol3. * Arial?= * Courier New;WingdingsA BCambria Math&h]"]"zF&  !r0d a2QHP $P~32!xx"PERSONAL BUDGET  EXCEL ASSIGNMENTLCPSLCPS  Oh+'0 $0 P \ h t$PERSONAL BUDGET EXCEL ASSIGNMENTLCPS Normal.dotmLCPS2Microsoft Office Word@dN@bp@L)@L) ՜.+,D՜.+,l( hp   Loudoun County Public Schools  #PERSONAL BUDGET EXCEL ASSIGNMENT Title 8@ _PID_HLINKSA@_Yhttp://www.snagajob.com/Lhttp://www.careerbuilder.com/h http://www.monster.com/  !"#$%&()*+,-.01234569Root Entry F);Data 1Table WordDocument.SummaryInformation('DocumentSummaryInformation8/CompObjy  F'Microsoft Office Word 97-2003 Document MSWordDocWord.Document.89q