ࡱ> Z\Y  y*bjbjhZhZ ;D 0_ 0_/"I 8<U,5^H,tE5G5G5G5G5G5G5$h8;Rk5k55!!!E5!E5!!2)4D&)315505=3p;p;()4p;)4!k5k5!5p; : MAP 4CI : Cumulative Project Creating a Financial Plan In this project you will use the mathematical tools developed during this course to develop a financial plan and budget for yourself. Some of the mathematical tools that you will use include: Analyzing and interpreting data (create pie charts) Exponential growth (compound interest, annuities) Financial analysis, budget analysis Part 1 Determine a job and starting income and start your budget spreadsheet Part 2 Determine transportation expenses, and housing expenses (mortgage calculations). Part 3 Complete your budget spreadsheet, identify major spend categories, add remaining fixed and variable expenses, predict the amount of money you will have to retire on. Your final hand-in will include your completed budget spreadsheet, and a document file with a description of your job, a description of how you calculated your mortgage payments, calculations for your vehicle payment and your analysis of your retirement funding, etc., as described below. Part 1 A. Research and identify a job that you want to have after high-school or college/university. Imagine the job you want to have when you turn 25. Describe the job and identify any educational requirements try the following website:  HYPERLINK "http://www.careercruising.com" www.careercruising.com Username: waterloo Password:47520. Research the starting salary (gross income) and any other benefits of your chosen profession Determine your net annual income google net pay calculator Ontario Canada and select the website  HYPERLINK "https://www.icalculator.info/canada/tax-calculator/annual/2020/Ontario.html" https://www.icalculator.info/canada/tax-calculator/annual/2020/Ontario.html and enter your gross annual income to determine your net annual income. B. Create your budget spreadsheet (you may use the provided template as a starting point.) Enter your gross salary and net salary. Make sure your monthly salary is calculated properly. There is a sample budget on the website for you to use as a guide but that one is meant as a sample only it is not a thorough assignment. **SAVE your work if you are using word and excel rather than sheets and docs!!! Part 2 A. Transportation Costs Based on your personal needs (i.e. vehicle for work, occasional trips etc.) identify your transportation choice (car, truck, bike etc.) and identify the purchase price. In your word or docs report, describe the vehicle you plan to purchase. State whether you will buy or lease the vehicle. Determine how you plan on paying for this vehicle and determine your monthly payments using an online payment calculator (Google fn calculator and select TVM Calculator). Enter the amount you plan to borrow as PV, be sure to state in your word or docs file the cost of the vehicle, the interest rate, the length of time you plan to take paying off your loan. You may find it easier to use a bank car loan calculator -- or google CIBC car loan calculator. Identify and estimate any other vehicle expenses to be included in your monthly budget (insurance, licence sticker, gas, maintenance, etc.). B. Housing Costs Based on your salary determine the maximum mortgage you can afford and the monthly payments. Use the following website  HYPERLINK "https://www.ratehub.ca/mortgage-affordability-calculator" https://www.ratehub.ca/mortgage-affordability-calculator to help estimate the maximum mortgage. Include the cost of your car loan as your monthly debt payments. Allow the computer to estimate the other fees. Record your Maximum Mortgage Value, maximum mortgage monthly payment, and the mortgage rate in your docs file. Go shopping for a home on-line that would fit your budget. If you cannot afford to buy a home, you may double up -- assuming that you are married or purchasing a home with someone else so all your housing costs will be cut in half. Include a description of your home and the total cost of your home in your word file. To calculate your mortgage payments once you find a home to buy, use the mortgage rate from your mortgage affordability calculation, assume you have a $25,000 down payment and that you are amortizing the mortgage over a 25-year period. The following website will calculate this for you.  HYPERLINK "https://www.cmhc-schl.gc.ca/en/finance-and-investing/mortgage-loan-insurance/homebuying-calculators/mortgage-calculator" https://www.cmhc-schl.gc.ca/en/finance-and-investing/mortgage-loan-insurance/homebuying-calculators/mortgage-calculator State the amount of the monthly mortgage payments in your word file and whether you are buying the home alone or splitting the costs in half. Record your monthly mortgage payment in your budget spreadsheet. Using the internet or by interviewing adults who own a home, research other costs (property taxes, heating, hydro, water, life insurance on mortgage, home insurance, etc.) associated with accommodations; add these costs into your budget spreadsheet. You may need to add rows or columns to your spreadsheet as you enter more expense categories. In Excel, Click on a row then from the home menu choose the down arrow beside insert then click on sheet rows, in Sheets, put curser where you want to insert a row, then click on insert, and choose insert row above or insert row below. Rent Mortgage, property taxes, life Insurance, home insurance Tenant Insurance Utilities Heat, Hydro, Water Phone Satellite/cable Internet Netflix Spotify Groceries Dining Out Pet food, toys, vet, grooming Cleaning dish soap, laundry detergent, bathroom, kitchen, floor cleaners, dustings supplies, etc. Coin Laundry Entertainment movies, theatre, flights to sports games, sports, books, concerts, hobbies, gaming Gifts Clothing Vices lottery, alcohol, cigarettes, Charitable Donations Medical (prescriptions most free until age 25, eye care, dental) Tylenol, other medications Personal care haircuts, massage, physio, Cosmetics shampoo (stuff for hair), soap, make up, toilet tissue, Kleenex, paper towels Savings short term (less than one year), long term Transportation car loan, insurance, licence, gas, maintenance, repairs, parking, tickets (or bus) Vacation Part 3 A. This is the final part of your summative. In this part, you must complete your budget spreadsheet, by adding other expenses into your excel or sheets budget sheet. Key items to include are listed at the end of part 2. Ensure your budget is balanced (total expenses equal net income) any budget surplus should be put into savings. More marks will be awarded for realistic values and thoroughly considering all expenses. B. Identify the key expense categories Auto expenses (lease or loan, licence sticker, insurance, gas, repairs, maintenance, etc.) Housing (mortgage, property taxes, life insurance, home insurance, heating, hydro, water, repairs, etc.) Food Recreation Savings Other -- Remember to include items such as shampoo, other cosmetics, toilet tissue, cleaning supplies, vices, etc. Create a pie chart to illustrate where the percent of monthly expenses are being spent. All transportation costs should be combined in your pie graph, all housing costs should be combined, etc., (Use the grouping categories stated above.) C. Using a TVM calculator (Google fn calculator then choose the TVM calculator then choose the advanced version)  HYPERLINK "http://www.fncalculator.com/financialcalculator?type=tvmAdvancedCalculator" http://www.fncalculator.com/financialcalculator?type=tvmAdvancedCalculator determine how much your monthly savings (or surplus) will grow to if you start saving at age 25 until 55. For your savings plan, assume you will get a rate of 3.5%/a, compounded monthly. State the total future value from the TVM calculator. State whether you think your total savings will be enough money to retire with or if additional funds would be required. Final Hand-In Your final hand-in should include the following: Description of career and starting salary (Part 1) Description of house (Part 2) Description of car (Part 2) Completed budget spreadsheet including pie chart (Part 3) Analysis of savings and discussion on retirement (Part 3) Hand in a print out of your written report and your spreadsheet OR share your Docs and Sheets files with Linda Behnke OR email your Word and Excel files as attachments Linda Behnke Compare the marking rubric to your assignment to ensure that you did not forget anything. The absolute Final date to hand in your Report (including Parts 1,2 & 3) is posted on Mrs. Behnkes web-site. If your project is not handed in at that point, your exam will weight the full 30% of the summative portion of your exam.     MAP 4CI : Cumulative Project -- Creating a Financial Plan 7  , - . 4 8 ? @ E W Y x     ! " 8 9 _ "毝ynh!hc}OJQJhp(&hc}0JOJQJhV[hc}OJQJjhc}OJQJU"hshc}5>*CJOJQJaJhc}5>*CJOJQJaJhk%hc}CJOJQJaJhk%hc}OJQJhk%hc}5>*OJQJhc}OJQJ"hX$hc}5>*CJOJQJaJ'78- _ .   _ \gdX$^gdc} & Fgdc} $dNgds & Fgdc}gdc}$a$gdc}"#/z|}\^cTUvjbVvVbKbh]hWKOJQJhH8hWK>*OJQJhWKOJQJh+hWK>*OJQJhWK>*OJQJh8hWKOJQJhWK5>*CJOJQJaJ"hhWK5>*CJOJQJaJhX$hWK5hhTqhc}5 hc}5hc}OJQJh!hc}OJQJhuhs0JOJQJhshsOJQJhsOJQJjhsOJQJUMN_abU3Dciygdr-gd0gdWKPRl]")13CDMO_hs XYZ8VZ賫||||h0OJQJh,^h,^OJQJh,^h,^0JOJQJjh,^OJQJUh,^OJQJjh,^OJQJUhH8hWK>*OJQJh+hWK>*OJQJhWK>*OJQJhyOJQJhWKOJQJhc}OJQJhZ=OJQJ/KLMU} ?CDj"2cĵؘ̨蠐舁}vkhc}hr-mH sH hc}hc}hc} hc}hr-hr-OJQJh\ZFOJQJhTOJQJhc}OJQJhX6PhX6P0JOJQJjhX6POJQJUhX6POJQJjhX6POJQJUh7-3OJQJhdOJQJhWKOJQJh0OJQJhA{cOJQJ*+8Ec l m n w !V!!""#"K""# & Fgd.?gdWKgdX$gdvgd.?gdr-*djF G I R l m n o t u v w !!4!T!V!k!{!!!!!!"""#"J"0####}}q}}}fh.?h.?OJQJh.?h@>*OJQJh@OJQJh.?OJQJhWKOJQJh8hWKOJQJhWK5>*CJOJQJaJ"hhWK5>*CJOJQJaJhX$5>*CJOJQJaJ"hhWK5>*CJ$OJQJaJ$hv5>*CJ$OJQJaJ$hdh.? hc}hr-'###'##$$$%`&&'!'R'''''3((F)/*1*2*4*$a$gdWK & FgdWK $dNgdWKgdWK & Fgd.?#X$$$$$$ %T%V%W%%%%%%_&`&f&&'' '3(4(O(q((((F)R)Y)n))Լ衏wk\k\ *h{^hWK56OJQJ *hv56OJQJhmcOJQJhvOJQJh@OJQJ"hvhWK5>*CJOJQJaJhX$5>*CJOJQJaJhvhWK>*OJQJhuhd0JOJQJhdhdOJQJjhdOJQJUhdOJQJhWKOJQJh.?OJQJhTOJQJ"))-*.*/*0*2*3*5*6*8*9*;*W*[*u*v*x*y*ǿhX$hX$CJaJhX$5>*CJOJQJaJ"hX$hX$5>*CJOJQJaJh&'jh&'Uh@hWK56OJQJ(jthqeGh&'<CJOJQJU^Jhv56OJQJh.?56OJQJ4*5*7*8*:*;*u*v*w*x*y*$a$gdWK$a$gdX$ 9 0&P1h:pX$/ =!"#$% DyK yK https://www.ratehub.ca/mortgage-affordability-calculatoryX;H,]ą'cyDyK yK https://www.cmhc-schl.gc.ca/en/finance-and-investing/mortgage-loan-insurance/homebuying-calculators/mortgage-calculatoryX;H,]ą'cDdb  C 0Acp_DManager"@@bԱ;,{O n&(73zP$PNG  IHDR DPLTE3f3333f333ff3fffff3f3f̙3f3333f3333333333f3333333f3f33ff3f3f3f3333f3333333f3̙333333f333ff3ffffff3f33f3ff3f3f3ffff3fffffffffff3fffffff3fff̙ffff3fffff3f̙3333f33̙3ff3ffff̙f3f̙3f̙̙3f̙3f3333f333ff3fffff̙̙3̙f̙̙̙3f̙3f3f3333f333ff3fffff3f3f̙3f$aJtRNSAbKGDH cmPPJCmp0712HshIDAT8OSKn0 ͮ^w7"dfHf'=N TE?y!1&?75S8IiӴ@lpRPOher{dΔe]R灛LM3LmD!K[B9<CWŐWqb`RoM:4k 1s B d DqPk{He@{@+uU}i]K)kRA6m0ElYQlO}u &7J \ "E  ]f^b%7r`o]"BFyC{cP$Xq: zoڐ Yp.液.vw<\jIENDB`"w6866666662 0@P`p2( 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p(8HX`~8XV~ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@_HmH nH sH tH @`@ NormalCJ_HaJmH sH tH ZZ  Heading 1$<@&5CJ KH OJQJ\^JaJ NN  Heading 5 <@&56CJ\]aJDA`D Default Paragraph FontViV  Table Normal :V 44 la (k (No List f0f List Bullet,List Bullet BLM  & F CJOJQJ4@4 Header  !F^F Normal (Web)dd[$\$tH *W !* Strong5\r!2r LessonTitle 8@^`(>*B*CJOJQJ^JaJmH phsH t!Bt KeyIdeas$ & F /8@/^/`%B*CJOJQJ^JaJmH phsH <AR< LessonInc  & F56JbJ day$a$"5CJOJQJ\^JaJmH sH HrH H2$a$"5CJOJQJ\^JaJmH sH HH H3$a$"5CJOJQJ\^JaJmH sH HH H4  CJKHOJQJ^JaJmH sH NQN H5 $"6CJOJQJ]^JaJmH sH 4 4 Footer  !HH  Balloon TextCJOJQJ^JaJjj ]P Table Grid7:V06U`6 8 Hyperlink >*B*phFV F  FollowedHyperlink >*B* ph:/: WK Header Char CJaJtH RvR sUnresolved MentionB*ph`^\q PK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭VGRU1a$N% ʣꂣKЛjVkUDRKQj/dR*SxMPsʧJ5$4vq^WCʽ D{>̳`3REB=꽻Ut Qy@֐\.X7<:+& 0h @>nƭBVqu ѡ{5kP?O&Cנ Aw0kPo۵(h[5($=CVs]mY2zw`nKDC]j%KXK 'P@$I=Y%C%gx'$!V(ekڤք'Qt!x7xbJ7 o߼W_y|nʒ;Fido/_1z/L?>o_;9:33`=—S,FĔ觑@)R8elmEv|!ո/,Ә%qh|'1:`ij.̳u'k CZ^WcK0'E8S߱sˮdΙ`K}A"NșM1I/AeހQתGF@A~eh-QR9C 5 ~d"9 0exp<^!͸~J7䒜t L䈝c\)Ic8E&]Sf~@Aw?'r3Ȱ&2@7k}̬naWJ}N1XGVh`L%Z`=`VKb*X=z%"sI<&n| .qc:?7/N<Z*`]u-]e|aѸ¾|mH{m3CԚ .ÕnAr)[;-ݑ$$`:Ʊ>NVl%kv:Ns _OuCX=mO4m's߸d|0n;pt2e}:zOrgI( 'B='8\L`"Ǚ 4F+8JI$rՑVLvVxNN";fVYx-,JfV<+k>hP!aLfh:HHX WQXt,:JU{,Z BpB)sֻڙӇiE4(=U\.O. +x"aMB[F7x"ytѫиK-zz>F>75eo5C9Z%c7ܼ%6M2ˊ 9B" N "1(IzZ~>Yr]H+9pd\4n(Kg\V$=]B,lוDA=eX)Ly5ot e㈮bW3gp : j$/g*QjZTa!e9#i5*j5ö fE`514g{7vnO(^ ,j~V9;kvv"adV݊oTAn7jah+y^@ARhW.GMuO "/e5[s󿬅`Z'WfPt~f}kA'0z|>ܙ|Uw{@՘tAm'`4T֠2j ۣhvWwA9 ZNU+Awvhv36V`^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-!g theme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK] y""D HHHHHK"#)y* #4*y*!!8"|  X LVy"XXXXX8@0(  B S  ? _Hlt29454044 _Hlt29454045 _Hlt29454086 _Hlt29454237_PictureBullets3 -"z"@@@@4 ."z"u w sx!!-"."/"1"2"4"5"7"8":";"w"z"7!!"IRmmno-"."/"W"["z" !!" Y IRlmno!."/"1"2"4"5"7"8":";"w"z" !!" Y IRlmno!."/"W"["z": `C `eOjIVkpV)(B;(y< Q^lL^`LCJOJQJaJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJ QJ o(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJ QJ o(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJ QJ o(hH^`OJQJo(hH^`OJQJo(hHpp^p`OJQJo(hH@ @ ^@ `OJQJo(hH^`OJQJo(hH^`OJQJo(hH^`OJQJo(hH^`OJQJo(hHPP^P`OJQJo(hH^`OJPJQJ^Jo(-^`OJQJ^Jo(hHop^p`OJ QJ o(hH@ ^@ `OJQJo(hH^`OJQJ^Jo(hHo^`OJ QJ o(hH^`OJQJo(hH^`OJQJ^Jo(hHoP^P`OJ QJ o(hHhh^h`OJQJo(hHh8^8`OJQJ^Jo(hHoh^`OJ QJ o(hHh ^ `OJQJo(hHh ^ `OJQJ^Jo(hHohx^x`OJ QJ o(hHhH^H`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJ QJ o(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJ QJ o(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJ QJ o(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJ QJ o(hH^`OJQJo(hH^`OJQJo(hHpp^p`OJQJo(hH@ @ ^@ `OJQJo(hH^`OJQJo(hH^`OJQJo(hH^`OJQJo(hH^`OJQJo(hHPP^P`OJQJo(hHy< Q`ejkpVB;`C         @y^0&vyl(|,bR˜6/"                          d 08^rxjNR05r\&P<;q,^ k%[o@"X$'&'v(7-3"4C&<e<Z=^HA.|E\ZFWKL-MX6P]PV[Q\mcA{cud>Qx4"" 3qHP ?-"$V2! xx$ DayWRDSB Linda Behnke(       Oh+'0t  $ 0 < HT\dl'DayWRDSB Normal.dotmLinda Behnke3Microsoft Office Word@vA@+@*i@B ՜.+,D՜.+,< hp  'Hewlett-Packard>" Day Title$ 8@ _PID_HLINKS'Aty Khttp://www.fncalculator.com/financialcalculator?type=tvmAdvancedCalculatorgw xhttps://www.cmhc-schl.gc.ca/en/finance-and-investing/mortgage-loan-insurance/homebuying-calculators/mortgage-calculator9https://www.ratehub.ca/mortgage-affordability-calculator33Lhttps://www.icalculator.info/canada/tax-calculator/annual/2020/Ontario.html=:http://www.careercruising.com/  !"$%&'()*,-./0123456789:;<=>?@ABCDEFGHJKLMNOPRSTUVWX[Root Entry FD]Data #1Table+;WordDocument;DSummaryInformation(IDocumentSummaryInformation8QCompObjr  F Microsoft Word 97-2003 Document MSWordDocWord.Document.89q