ࡱ> ikh%` ^ibjbj"x"x .j@@3 , -,- - - - - - -$.h@1--9--f-A!A!A!.-A!-A!A!V(@S) .) *|-0-#)0@2 $@2S)S)@2g)A!----7! -          Chapter 8 TI-Nspire"! Activity - Amortization Schedule Student Worksheet Suppose that you take out a loan for $15 000 to help with the expenses for your first year at college. The interest rate quoted by the bank is 6% per annum, compounded monthly. You ve decided to pay this off over a ten year period. Create an amortization schedule for one year to show the period, principal, payment, interest, principal reduction and revised balance for each month in the first year. Use your TI-Nspire"! CAS to find the payment in the Finance Solver (found in the Algebra menu of the Calculator application) and then use the Lists & Spreadsheet application to construct the payment schedule. When you are finished, your spreadsheet should look like the one below. PeriodPrincipalInterestPaymentPrincipal ReductionRevised Principal1$15,000.00$75.00$166.53$91.53$14,908.472$14,908.47$74.54$166.53$91.99$14,816.483$14,816.48$74.08$166.53$92.45$14,724.034$14,724.03$73.62$166.53$92.91$14,631.125$14,631.12$73.16$166.53$93.38$14,537.756$14,537.75$72.69$166.53$93.84$14,443.907$14,443.90$72.22$166.53$94.31$14,349.598$14,349.59$71.75$166.53$94.78$14,254.819$14,254.81$71.27$166.53$95.26$14,159.5510$14,159.55$70.80$166.53$95.73$14,063.8211$14,063.82$70.32$166.53$96.21$13,967.6112$13,967.61$69.84$166.53$96.69$13,870.92. Follow these instructions in the construction of your spreadsheet. The words that are bolded and italicized are column titles. Open a new document and choose the Calculator application. From the menu, select 8:Finance, and then, choose Finance Solver. Enter 120 for N, 6 for I, 15000 for PV, and 12 for both Ppy and Cpy. Calculate the monthly payment. On the Calculator page, assign the interest rate from the Finance Solver to variable i. To do this, the annual rate of 6% is divided by 1200 to get the monthly interest rate. Explain why. Assign the monthly payment from the Finance Solver to variable p. Open a Lists & Spreadsheet page. In order to round off values to the nearest cent, choose Fix 2 from the Document Settings. Column A is to hold the month number. Use the title period for the column. Type the number 1 in cell A1 and use a formula in A2 to increase this value by 1 for each row. Do not fill this down yet. Write the formula in the space below. Column B is to hold the principal at the beginning of each month. Initially, this is 15 000 but it will change in row 2 to hold a revised value. Enter the value 15 000 in cell B1. Leave the remainder of the column for the time being. Column C is to hold the interest charged each month. Enter a formula which determines the product of the principal from column B and the monthly interest rate. As before, leave the remainder of the column blank for the time being. Write the formula you used in the space below. Column D is to hold the month payment. This can be copied from the list of variables created in the TVM Solver. As before, leave the remainder of the column blank for the time being. Column E is to hold the principal reduction. This is the difference between the payment and the interest charged. This column should also be left blank for the time being. Write the formula you used in the space below. Column F is to hold the revised principal for the end of the month. After the reduction is found, the principal is revised by subtracting the reduction amount from the principal at the beginning of the month. Write the formula you used in the space below. Highlight the cells C1 through F1 and copy the formulas in these cells to the second row. Move to cell B2 for the principal at the beginning of the month. This should be equal to the revised principal from the end of the previous month. Write your formula in the space below and explain why the calculation of principal in the second month (and all remaining months) is different than for the first month. Highlight the cells A2 through F2 and copy the formulas down to the twelfth row. How much money is owed at the end of the first year? What is the total of the payments of the first year? How much of this was principal and how much was interest? Does this surprise you? What would you change to show the schedule for the entire ten years? How would you modify the schedule if the interest rate for the second year changed to 7% per annum compounded monthly? Assume that we will use the original interest of 6% per annum compounded monthly for this question. If $15 000 were borrowed at the beginning of your first year, interest will accrue for the four years that you are in college before you begin to repay the loan. How much would you owe after graduation four years later? How would this change the repayment schedule? If you borrowed $15 000 at the beginning of second year, how much would you owe at graduation three years later? If you borrowed $15 000 at the beginning of your third year, how much would you owe at graduation two years later? If you borrowed $ln d   , @ W  " , 4 > ? ǼyycMcMc>huh!VqCJaJmH sH +h_6%hxPE5CJOJQJ^JaJmH sH +h_6%h!Vq5CJOJQJ^JaJmH sH huh"TmH sH huhvs mH sH ha]h!Vq5mH sH huhemH sH huh!VqmH sH huh/mH sH huh:mH sH huh=CJaJmH sH ha]CJaJmH sH ha]hX5CJaJmH sH h_6%5CJaJmH sH lnd    , > $$Ifa$gd_6%gd!Vq$a$gda]^i> ? kd$$Iflֈ Z t'''s'']'0=644 la]p<? A L S [ b m $$Ifa$? m n )*XYEFuvx%BIR^es ƻƯƧƯƓƈ|ha]h5mH sH huhmH sH huh BmH sH ha]5mH sH ha]mH sH ha]h,~ 5mH sH huh(RmH sH huh,~ mH sH huh!VqmH sH huh!VqCJaJmH sH (huh!VqCJOJQJ^JaJmH sH ,m n kd8$$Iflֈ Z t'''s'']'0=644 la]p<n p { $$Ifa$ kdp$$Iflֈ Z t'''s'']'0=644 la]p< $$Ifa$ kd$$Iflֈ Z t'''s'']'0=644 la]p< $$Ifa$ kd$$Iflֈ Z t'''s'']'0=644 la]p< ) $$Ifa$)*kd$$Iflֈ Z t'''s'']'0=644 la]p<*,7>FMX $$Ifa$XYkdP$$Iflֈ Z t'''s'']'0=644 la]p<Y[fmu| $$Ifa$kd$$Iflֈ Z t'''s'']'0=644 la]p< $$Ifa$kd $$Iflֈ Z t'''s'']'0=644 la]p< $$Ifa$kd $$Iflֈ Z t'''s'']'0=644 la]p<  $$Ifa$kd0 $$Iflֈ Z t'''s'']'0=644 la]p<$+3:E $$Ifa$EFkdh $$Iflֈ Z t'''s'']'0=644 la]p<FIT[cju $$Ifa$uvxkd$$Iflֈ Z t'''s'']'0=644 la]p<xy3uY[FGHI3IJKLgdxPE^gda]h^hgdxPE & Fgd,~  & Fgd_6% "#/0f7<FWZEFGIajKSy޻ގރǃumuhumH sH huh(R56mH sH huh(RmH sH huh56mH sH ha]mH sH huh.mH sH ha]h.5mH sH ha]h5mH sH huh|mH sH huh6mH sH huhmH sH ha]hxPE5mH sH huhxPEmH sH *HILjq&/>?@{|}~T]ɾ곫곣zhuh?mH sH h+mH sH huh|mH sH huhJ(mH sH hwNmH sH h.mH sH huh.mH sH huhwNmH sH hCrmH sH huhCr56mH sH huh(RmH sH huhxPEmH sH huhCrmH sH /?@|~  gd.gdJ(gdxPE & Fgd,~ ^gdwNYZ[\]^_eE & Fgd$gd$ & Fgd+gd( & Fgd.gd.XY_(fh]i^iɮɦɜUh?mH sH h$mH sH h+mH sH huh?mH sH hmH sH huh$mH sH huhJ(mH sH huh|mH sH huh.mH sH huh(mH sH EFGHIJKbhchdhehfhghhh^i & Fgd$gd$15 000 at the beginning of your third year, how much would you owe at graduation two years later? At graduation, how much would you owe from the four loans? Change your payment schedule using this value as the initial Principal and build a new spreadsheet using the same interest rate. Assume that you will take ten years to pay this loan off. ,1h/ =!"#$% 6$$If]!vh555555#v#v#v#v#v#v:V l0=6,555s55]59a]p<6$$If]!vh555555#v#v#v#v#v#v:V l0=6,555s55]59a]p<6$$If]!vh555555#v#v#v#v#v#v:V l0=6,555s55]59a]p<6$$If]!vh555555#v#v#v#v#v#v:V l0=6,555s55]59a]p<6$$If]!vh555555#v#v#v#v#v#v:V l0=6,555s55]59a]p<6$$If]!vh555555#v#v#v#v#v#v:V l0=6,555s55]59a]p<6$$If]!vh555555#v#v#v#v#v#v:V l0=6,555s55]59a]p<6$$If]!vh555555#v#v#v#v#v#v:V l0=6,555s55]59a]p<6$$If]!vh555555#v#v#v#v#v#v:V l0=6,555s55]59a]p<6$$If]!vh555555#v#v#v#v#v#v:V l0=6,555s55]59a]p<6$$If]!vh555555#v#v#v#v#v#v:V l0=6,555s55]59a]p<6$$If]!vh555555#v#v#v#v#v#v:V l0=6,555s55]59a]p<6$$If]!vh555555#v#v#v#v#v#v:V l0=6,555s55]59a]p<@@@ NormalCJ_HaJmH sH tH DAD Default Paragraph FontRi@R  Table Normal4 l4a (k@(No List DZ@D !Vq Plain TextCJOJQJ^JaJB'B  jComment ReferenceCJaJ<@<  j Comment TextCJaJ@j@@  jComment Subject5\H@2H  j Balloon TextCJOJQJ^JaJ3j67IJ2,>?ALS[bmnp{)*,7>FMXY[fmu| $+3:EFIT[cjuvxy3uY[F G H I 3 I J K L   ?@|~  YZ[\]^_eEFGHIJK789:;<=500000000000 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 0 0 0d0 0 0 0 0 0 00 0 0 0 0 0 00 0 0 0 0 0 00 0 0 0 0 0 00 0 0 0 0 0 00 0 0 0 0 0 00 0 0 0 0 0 00 0 0 0 0 0 00 0 0 0 0 0 00 0 0 0 0 0 0000 0 0 0 000000 0 00 0000 0 0000 0 0 0 000 0 000 0 0 0 0 0000000 0000000 0000000 0000000 0 0_0000 0_00 0_000000 0_000000 0_000000 0_? ^i-.1> ? m n )*XYEFuxE^i !"#$%&'()*+,/02^i8@0(  B S  ? 5JR5333 67<<B^WZ 2 2 3 4 I I     >?|}T]KK==255zwRTe}F$=( ^`o(. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.^`56o(hH. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.^`56o(hH.^`56o(hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.F$=zwTel%2Yq2       )&Di%$vs ,~ $=u:(RK B_6%J(xPEwN"TXa]e j!Vq)x+/?.x*(<&h/.CrGIy/7y|,>?ALS[bmnp{)*,7>FMXY[fmu| $+3:EFIT[cjuv53@66|V6643pp p@p@UnknownGz Times New Roman5Symbol3& z Arial?5 z Courier New5& zaTahoma"qhY[rF2*  &*  &!24d))2QHX)?y/21Amortization Schedule  Step-by-Step Instructions,Frederick Ferneyhough;OS1.6 Update R. Meisellaura_resendes   Oh+'00 HT t  4Amortization Schedule Step-by-Step Instructions0Frederick Ferneyhough;OS1.6 Update R. Meisel Normal.dotlaura_resendes6Microsoft Office Word@#@qʺ@h* ՜.+,08 hp  $Fletcher's Meadow Secondary School& )' 2Amortization Schedule Step-by-Step Instructions Title  !"#$%&'()*+,-./012345789:;<=?@ABCDEFGHIJKLMNOPQRSTUVWYZ[\]^_abcdefgjRoot Entry F@vɅlData 61Table>X2WordDocument.jSummaryInformation(XDocumentSummaryInformation8`CompObjq  FMicrosoft Office Word Document MSWordDocWord.Document.89q