ࡱ> @B?a tbjbj͚ 4&I\I\t  DDDDDXXXXl<X < V X X X X X X $u"+%X| D| DD ___.DDh_V __B +"Z 0 b,%M%%D8_| | _ % > : Name: Date: School: Facilitator: 6.05 PMT Function Assignment You have found your dream car. It is available at three different dealerships. Each dealership offers a different payment plan (see below). Use the PMT function ( HYPERLINK \l "_PMT_Function_Instructions" instructions) to determine monthly payments for each, then answer the following questions. Submit your PMT sheet and the answers to the 6.05 PMT Dropbox. DealershipPriceInterest RateLength of loanB16,50063 yearsC15,50074 yearsD16,00055 years 1. Which payment plan will cost you the least total money? Include the total cost. 2. Which payment plan offers the smallest monthly payment? Include the monthly payment in your answer. 3. If you are struggling to meet your bills, which dealership should you select? Explain why. 4. If you are comfortable meeting all monthly payments, which should you select? Explain why. 5. Explain in your own words how you could use the PMT function in your daily life. PMT Function Instructions Open a spreadsheet program (Excel or Open Office) Type the following words in the designated cell (be sure the cell addresses are correct because you will refer to those cells in the function that is provided) In A1, type Loan Payment Calculator Skip Line 2 In A3, type Rate Per Year In A4, type Years of Loan In A5, type Loan Amount In A6, type Monthly Payment In A7, type Total Payment Format and make Column A wider so above is easier to read You will use Column B to enter numbers and the PMT function for dealer 5 Here are your loan details: In B3, type the interest rate (6) *Note: Format B3 as Percentage In B4, type the length of the loan (3) In B5, type the cost of the car (16500) * Format as Currency Now you will type in the PMT function into cell B6this will determine your monthly payment based on the loan information you just entered. Are you ready? Here is how you must type in the PMT function: =PMT(B3/12,B4*12,-B5) Now, we will figure out the total payment for the car by multiplying the monthly payment by the number of months you pay the loan. In cell B7, enter =B4*12*B6. In Column C, enter the loan details for dealer C. Repeat in Column D for dealer D. Remember to format the interest rates in row 3 as Percentages. Remember to format rows 5-7 as currency. Use the fill handle to copy the functions and formulas to the appropriate columns. For bonus, determine the formula you would use to calculate how much extra you pay for the car in interest at each dealer. In A8, type Bonus. Enter the formula in row 8 to show this calculation. Save your spreadsheet, and turn it into 6.05 PMT Function Dropbox. !">?          T k p q : < y >r1YhI$hlhO2hZCJOJQJaJ h5dDh5dDh5dDhZ5\ h5dDhZh5dDhZ5B*\phhZhZ0JjhZUjhZU hlh hlhl hZhZhZ6 !"? $d$Ifa$gd5dDgdZgdZgdZ -$d$Ifa$gd5dDkd$$Ifl\H$Z Z Z Z  t(0644 lap(yt5dD  Mkdm$$Ifl\H$Z Z Z Z t0644 layt5dD$d$Ifa$gd5dD     ^MMMM$d$Ifa$gd5dDkd$$Ifl\H$Z Z Z Z t0644 layt5dD   l m n 6 ^YPPPPPPP^gdZgdZkdW$$Ifl\H$Z Z Z Z t0644 layt5dD 6 7 8  A   + E ] y 2s[^gdl & Fgdl & FgdlgdZ^gdZ[k1t & FgdI$ & FgdI$ & FgdlYrthlhlhl521h:p/ =!"#$% DyK _PMT_Function_Instructions$$If!vh#vZ :V l  t(065Z p(yt5dDs$$If!vh#vZ :V l t065Z yt5dDs$$If!vh#vZ :V l t065Z yt5dDs$$If!vh#vZ :V l t065Z yt5dD s666666666vvvvvvvvv666666>6666666666666666666666666666666666666666666666666hH6666666666666666666666666666666666666666666666666666666666666666662 0@P`p2( 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p8XV~ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ OJPJQJ_HmH nH sH tH J`J Normal dCJ_HaJmH sH tH h@h Z Heading 1$$@&'5B*CJOJPJQJ\^JaJph6_DA D Default Paragraph FontRi@R 0 Table Normal4 l4a (k ( 0No List @@@ l List Paragraph ^m$n>@n ZTitle d,&dPOm$)@B*CJ4KHOJPJQJ^JaJ4ph6]VV Z Title Char)@B*CJ4KHOJPJQJ^JaJ4ph6]\!\ ZHeading 1 Char'5B*CJOJPJQJ\^JaJph6_6U@16 Z0 Hyperlink >*B*phtCt Z Table Grid7:V0 dRRR Z0 Balloon Text dCJOJQJ^JaJNaN Z0Balloon Text CharCJOJQJ^JaJvsv Z Light List:V044j.@j.j.j 2dfdfd25\5\5\5\phPK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭VvnB`2ǃ,!"E3p#9GQd; H xuv 0F[,F᚜K sO'3w #vfSVbsؠyX p5veuw 1z@ l,i!b I jZ2|9L$Z15xl.(zm${d:\@'23œln$^-@^i?D&|#td!6lġB"&63yy@t!HjpU*yeXry3~{s:FXI O5Y[Y!}S˪.7bd|n]671. tn/w/+[t6}PsںsL. J;̊iN $AI)t2 Lmx:(}\-i*xQCJuWl'QyI@ھ m2DBAR4 w¢naQ`ԲɁ W=0#xBdT/.3-F>bYL%׭˓KK 6HhfPQ=h)GBms]_Ԡ'CZѨys v@c])h7Jهic?FS.NP$ e&\Ӏ+I "'%QÕ@c![paAV.9Hd<ӮHVX*%A{Yr Aբ pxSL9":3U5U NC(p%u@;[d`4)]t#9M4W=P5*f̰lk<_X-C wT%Ժ}B% Y,] A̠&oʰŨ; \lc`|,bUvPK! ѐ'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-!R%theme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK] t &Yt    6 [t t XL# @0(  B S  ?_PMT_Function_Instructionsv v 3v lv Tk>>>??OOOSr0 s v t\)l ^`o(.^`.pL^p`L.@ ^@ `.^`.L^`L.^`.^`.PL^P`L.t\)         '!ZA1O25dDlmI$t v __Grammarly_42____i__Grammarly_42___14H4sIAAAAAAAEAKtWckksSQxILCpxzi/NK1GyMqwFAAEhoTITAAAAPH4sIAAAAAAAEAKtWcslP9kxRslIyNDYEAgtTIwNLA0NzCxNLEyUdpeDU4uLM/DyQAsNaAMxvq5YsAAAA@t @UnknownG*Ax Times New Roman5Symbol3. *Cx Arial7.@Calibri7@Cambria5..[`)TahomaA$BCambria Math"1hFF!0o o 3QHP  $Pl2!xx LindaWilliams, Florence Oh+'0`   ( 4@HPXLindaNormalWilliams, Florence2Microsoft Office Word@@a؈@a؈՜.+,D՜.+,, hp|  o   Title 8@ _PID_HLINKSAppO_PMT_Function_Instructions  !"#$%&'()*+,-.012345689:;<=>ARoot Entry F%CData 1Table%WordDocument4&SummaryInformation(/DocumentSummaryInformation87CompObjr  F Microsoft Word 97-2003 Document MSWordDocWord.Document.89q