ࡱ> lnk Ubjbj! ! 4rCfCfUttT6 #BBBBBH#J#J#J#J#J#J#$%(|n#n#BB#BBH#H#V!@"B A;ݺH3^ " 4##0#,"x))")"n#n#3#)t : Budgeting Assignment In this assignment you will be creating a monthly budget for yourself based on your new salary, $50,000. -The average starting salary for a college graduate, class of 2014 was $48,707 Part One: Research and input all of the following expenses on your budget handout. Some expenses you will need to research and some of the budget information is given. First, calculate your TAKE HOME/NET PAY: Firstly, you will deduct your 401K contributions. You must contribute 3%. Next you will calculate your FICA and federal income tax from your salary. You will use a federal income worksheet first & then a separate worksheet to deduct your FICA taxes. Next you will calculate your state tax. If you plan to live in NYC there is also a city tax! Then, deduct $150/month for health insurance, dental insurance and any other employee sponsored fund or insurance. You now have your monthly net income Next, calculate your BASIC LIVING EXPENSES (needs): After deciding upon your state, use the internet to identify a specific property that you wish to rent. Check to make sure it offers heat and hot water. You must include THE COMPLETE ADDRESS OF YOUR RENTAL UNIT on the budget handout. Rentals.com Online newspapers Apartments.com Research the cost of cable, cell phone and internet Go to Verizon, Comcast or some other provider and find the cost of these 21st century needs. Given Expenses You Must Add: -Rental Insurance - $20/month -Electricity - $20/monthI feel like this should be more Then, calculate your ADDITIONAL LIVING EXPENSES: Research a car and add your car payment or a mass transit option. You must include your CAR DESCRIPTION OR TRANSPORTATION DESCRIPTION on your budget sheet When calculating mass transit costs you must remember to and from work as well as weekend outings Calculate gas costs. Check the current gas price per gallon, the mileage on your car and then assume you commute 10 miles to work. Calculate car maintenance costs. Assume an oil change/tire rotation every 4 months. Check local auto-body shops and chains for costs. Do the necessary math to make it a monthly amount you put aside. Research a grocery store budget: Calculate estimated food costs for a week with grocery circular * This portion should be itemized for one single week and then multiplied by 4 as a monthly cost. ONCE YOU CALCULATE YOUR MONTHLY BUDGET ADD $50 FOR TOILETRIES, PAPER PRODUCTS, CLEANING PRODUCTS, ET CETERA. Go to Stop and Shop or Shoprite and create a grocery cart of your desired items. Research your anticipated purchased food expenses. buying coffee in the morning; buying lunch?; take out? Per week and then multiple that by 4 for the monthly bill. GIVEN EXPENSES YOU MUST ADD: Car Insurance: $200/month Finally, calculate your expenses that include WANTS: Add an entertainment budget * Restaurants, night time events, movies, bowling, day trips to the beach, museums, et cetera. On your budget worksheet indicate how you came to your total. Add a vacation fund. Assume it will cost you $2000/trip. Either divide $2000 by 12 and add that amount to your budget as the monthly cost of a vacation OR if you want to go on more than 1 trip per year do the math! *Add miscellaneous and/or personal health/maintenance fund * Haircuts, highlights, nails Gym memberships Presents: birthdays and holidays (assume $20-$100/gift per person for every birthday and holiday) Clothes budget per year/12 months Other: weddings? Other big events that cost a lot of money! (assume $100/big event) PART TWO: Take all of your data from the budget worksheet and input that data into excel. When you are done, share your spreadsheet with both teachers. Due Dates: -Your apartment and car must be chosen before class on Monday, January 11th -Your budget worksheet must be done before class on Tuesday, January 12th (YOU MUST BRING YOUR COMPLETED WORKSHEET TO CLASS ON TUESDAY) -Your excel sheet must be completed and SHARED with both teachers before class on Wednesday, January 13th -You must bring your budget worksheet to class on Wednesday, January 14th. You will share your budget with the class and then submit your worksheet at the end of class. Name:__________________________________ Mods:_______________ CategoryPrice*Description/Breakdown if applicable Gross IncomeNet IncomeMonthly IncomeBasic Living Expenses Rent* Renters InsuranceCable*Internet*Cell Phone*Electricity Living Expenses Car/ Mass Transit*Car InsuranceGasCar Maintenance*Grocery Store (do not forget to add $50 to the monthly bill)* Purchased Food Expenses *Wants Entertainment* Vacation Miscellaneous/Personal Health* Total All Expenses________________________From your excel spreadsheetTotal Savings Net Income -Total Expenses _______________________From your excel spreadsheet (t~w y ʾʥ~q~aUIU9 *h?h(`CJOJQJaJh/'8CJOJQJaJhmCJOJQJaJh(`hoZ5CJOJQJaJh|e5CJOJQJaJhoZ5CJOJQJaJh/'85CJOJQJaJh$C5CJOJQJaJh(`5CJOJQJaJh1 CJOJQJaJh,CJOJQJaJh(`CJOJQJaJh(`h(`CJOJQJaJh"CJOJQJaJhdh(`CJ$OJQJaJ4x y : q  y  & Fgdy & Fgd*xgdoZ & FgdoZ & Fgd/'8 & Fgd(` & Fgd? & Fgd?gd(`$a$gd(`   $ & 8   * , < = p ǻrbrVFVFV *h?h?CJOJQJaJhyCJOJQJaJ *h/'8hCJOJQJaJh/'8hCJOJQJaJh/'8CJOJQJaJ *h/'8h/'8CJOJQJaJh/'8h/'8CJOJQJaJh?h?CJOJQJaJh?CJOJQJaJh(`CJOJQJaJ *h?h(`CJOJQJaJh*xCJOJQJaJ *h?h*xCJOJQJaJp q 3 d v    e g z ⿲znznn^nNhG5hy5CJOJQJaJhyhyCJH*OJQJaJhyCJOJQJaJh*xCJOJQJaJh(`CJOJQJaJhG5hoZ5CJOJQJaJhG5h.Me5CJOJQJaJhy5CJOJQJaJh$ChoZ5CJOJQJaJ%hh$C56>*CJOJQJaJ"hh$C56CJOJQJaJhoZCJOJQJaJy z #f#o%% & Fgdhgdne+gdh & Fgdy & Fgdy & Fgdd6 & Fgd(`gdoZgd*x^gdy  #?JPcef|-6.nowyz˻廯wwh\L *hyhyCJOJQJaJh*xCJOJQJaJhG5h.MeCJOJQJaJ *hd6hd6CJOJQJaJhyCJOJQJaJhd6CJOJQJaJ *hoZh(`CJOJQJaJh(`CJOJQJaJh$ChoZ5CJOJQJaJhne+5CJOJQJaJhoZ5CJOJQJaJhy5CJOJQJaJh.Me5CJOJQJaJ12Y` #%[ дд|l\OB\O\|hh5CJOJQJaJhne+5CJOJQJaJhne+hne+5CJOJQJaJhhhh5CJOJQJaJhhCJOJQJaJhCJOJQJaJ *hhhyCJOJQJaJ *hyhyCJOJQJaJhyCJOJQJaJhyhd65CJOJQJaJhd6CJOJQJaJh*xCJOJQJaJhne+CJOJQJaJhPCJOJQJaJ "$%%ef̤ẍl]llNl]hSChne+CJOJQJaJhSChSCCJOJQJaJhSCCJOJQJaJ *h$Chd6CJOJQJaJh$CCJOJQJaJ *h$Ch$CCJOJQJaJ *h$CCJOJQJaJhd6hd6CJOJQJaJhhCJOJQJaJhd6CJOJQJaJhne+CJOJQJaJ *hd6h(`CJOJQJaJh(`CJOJQJaJfxyznopqrs$Ifgd|egd(`^gd" & FgdSC & Fgd$C & Fgdd6wz  mrs 6ննննȩr`N"h$h$5>*CJOJQJaJ"h$Ch*x5>*CJOJQJaJh$C5CJOJQJaJhh*x5CJOJQJaJh|e5>*OJQJaJh|e5CJOJQJaJhP5CJOJQJaJ"hhhh5CJH*OJQJaJhne+5CJOJQJaJhh5CJOJQJaJhZ5CJOJQJaJh"h"5CJOJQJaJ^XXX$Ifkd$$IflF ,*   t0-6    44 la^pyt$^XXX$Ifkd$$IflF ,*   t0-6    44 la^pyt$ ^XXX$Ifkdx$$IflF ,*   t0-6    44 la^pyt$^XXX$Ifkd4$$IflF ,*   t0-6    44 la^pyt$678^XXX$Ifkd$$IflF ,*   t0-6    44 la^pyt$89@AB^UOO$If $Ifgdhkd$$IflF ,*   t0-6    44 la^pyt$69=>?Y^_klp{&'()+,-ߵߖҖvi\h$5CJOJQJaJh*x5CJOJQJaJhhGF"5CJOJQJaJhh"5CJOJQJaJh"5CJOJQJaJ"h$h$5>*CJOJQJaJhh$C5CJOJQJaJh$C5CJOJQJaJhh5CJOJQJaJhh*x5CJOJQJaJhh$5CJOJQJaJ BCVWX^UOO$If $Ifgdhkdh$$IflF ,*   t0-6    44 la^pyt$XY`ab^XXX$Ifkd$$$IflF ,*   t0-6    44 la^pyt$bcmno^XXX$Ifkd$$IflF ,*   t0-6    44 la^pyt$op|}~^XXX$Ifkd$$IflF ,*   t0-6    44 la^pyt$~^XXX$IfkdX$$IflF ,*   t0-6    44 la^pyt$\SMM$If $Ifgddkd$$IflCF ,*   t0-6    44 la^pyt$\SMM$If $Ifgddkd$$IflCF ,*   t0-6    44 la^pyt$\VVV$Ifkd $$IflCF ,*   t0-6    44 la^pyt$\VVV$IfkdT $$IflCF ,*   t0-6    44 la^pyt$\VVV$Ifkd $$IflCF ,*   t0-6    44 la^pyt$\VVV$Ifkd $$IflCF ,*   t0-6    44 la^pyt$'()*+,\VVVVVV$Ifkd $$IflCF ,*   t0-6    44 la^pyt$,-GHI\VVV$IfkdT $$IflCF ,*   t0-6    44 la^pyt$-FGJKNUXefhijksuvwxϹϊ}m`m}m`m}m`mJ+h$h$56B*CJOJQJaJphh*x5CJOJQJaJhh*x5CJOJQJaJh|e5CJOJQJaJh"5CJOJQJaJ"h$h$5>*CJOJQJaJhhGF"5CJOJQJaJ+h$hGF"56B*CJOJQJaJphhh$5CJOJQJaJhhh$5CJOJQJaJhhhh5CJOJQJaJIJKLM\VVV$Ifkd$$IflCF ,*   t0-6    44 la^pyt$MNUVW\SMM$If $Ifgd|ekd$$IflCF ,*   t0-6    44 la^pyt$WXghij\VVVV$Ifkd$$IflCF ,*   t0-6    44 la^pyt$jktuvw\VVVV$IfkdT$$IflCF ,*   t0-6    44 la^pyt$wx\VVVV$Ifkd$$IflCF ,*   t0-6    44 la^pyt$\VVV$Ifkd$$IflCF ,*   t0-6    44 la^pyt$\VVV$Ifkd$$IflCF ,*   t0-6    44 la^pyt$\SMM$If $Ifgd$kdT$$IflCF ,*   t0-6    44 la^pyt$  67RTUðviviYviGY7h(`h(`5CJOJQJaJ" *h|eh|e5CJOJQJaJhh|e5CJOJQJaJh|e5CJOJQJaJh$5CJOJQJaJhh$5CJOJQJaJhh"5CJOJQJaJhG55CJOJQJaJ% *h|eh"5>*CJOJQJaJ *h|e5>*CJOJQJaJ+ *h|eh"5B* CJOJQJaJph+ *h|eh|e5B* CJOJQJaJph\SMM$If $IfgdGF"kd$$IflCF ,*   t0-6    44 la^pyt$ 7\SJJDDD$If $Ifgd|e $IfgdGF"kd$$IflCF ,*   t0-6    44 la^pyt$7STUVTkd$$IflCF ,*   t0-6    44 la^pyt$$If21h:p$C/ =!"#$% $$If^!vh#v* #v #v:V l t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V l t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V l t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V l t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V l t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V l t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V l t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V l t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V l t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V l t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V l t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V lC t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V lC t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V lC t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V lC t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V lC t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V lC t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V lC t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V lC t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V lC t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V lC t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V lC t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V lC t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V lC t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V lC t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V lC t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V lC t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V lC t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V lC t0-65* 5 5a^pyt$$$If^!vh#v* #v #v:V lC t0-65* 5 5a^pyt$^ 2 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 DA D Default Paragraph FontRi@R  Table Normal4 l4a (k (No List H@H (` Balloon TextCJOJQJ^JaJjj *x Table Grid7:V0@@ oZ List Paragraph ^PK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭V$ !)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 =3N)cbJ uV4(Tn 7_?m-ٛ{UBwznʜ"Z xJZp; {/<P;,)''KQk5qpN8KGbe Sd̛\17 pa>SR! 3K4'+rzQ TTIIvt]Kc⫲K#v5+|D~O@%\w_nN[L9KqgVhn R!y+Un;*&/HrT >>\ t=.Tġ S; Z~!P9giCڧ!# B,;X=ۻ,I2UWV9$lk=Aj;{AP79|s*Y;̠[MCۿhf]o{oY=1kyVV5E8Vk+֜\80X4D)!!?*|fv u"xA@T_q64)kڬuV7 t '%;i9s9x,ڎ-45xd8?ǘd/Y|t &LILJ`& -Gt/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 0_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!0C)theme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK] Ur p  6-U,5y 8BXbo~,IMWjw7U !"#$%&'()*+-./012346788@0(  B S  ?GRW=A % +   wy7SW333333.n  mr=>KK^_klp{&-FSSefksx67RW.n  mr=>KK^_klp{&-FSSefksx67RTWQ,UzW^`OJPJQJ^Jo(-^`OJQJ^Jo(hHop^p`OJQJo(hH@ ^@ `OJQJo(hH^`OJQJ^Jo(hHo^`OJQJo(hH^`OJQJo(hH^`OJQJ^Jo(hHoP^P`OJQJo(hH^`OJPJQJ^Jo(-^`OJQJ^Jo(hHop^p`OJQJo(hH@ ^@ `OJQJo(hH^`OJQJ^Jo(hHo^`OJQJo(hH^`OJQJo(hH^`OJQJ^Jo(hHoP^P`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHzWUQ;2        x+@                 "y$,GF"(+ne+d6/'8oZ(`q`d.Mehjn*x1 Zf|emPSCG5$C_?UW@RRRR,U@Unknown G*Ax Times New Roman5Symbol3. *Cx Arial7^  Stencil;. Agency FB5. .[`)Tahoma?= *Cx Courier New;WingdingsA$BCambria Math"h3Ag3AgnGs #s #!24LL3QHX ?(`2!xx Budgeting AssignmentkmurphyLuberto,Pamela   Oh+'0\    $ 0<DLTBudgeting AssignmentkmurphyNormalLuberto,Pamela2Microsoft Office Word@@$L@xH@xHs՜.+,0 hp  CWCBOE# L Budgeting Assignment Title  !"#$%&'()*+,-./0123456789;<=>?@ABCDEGHIJKLMNOPQRSTUVWXYZ\]^_`abdefghijmRoot Entry F<ݺHoData :T1TableF-)WordDocument4rSummaryInformation([DocumentSummaryInformation8cCompObjr  F Microsoft Word 97-2003 Document MSWordDocWord.Document.89q