Ex12.carloan (0) - Saved Home Inser Draw Page Layout Formulas Data Review View Calculate Now Autour city sancial Logical Text Date Loop Mare Time Trg Function etce Precedents Show for gece Dependents Checking - Hemove Anows - Evaluate for Formule Usein Name Manager Create from Selection De Wach Options El Calculate Steel f K M N ..) Recreate the 10 by 6 table computing the monthly payments for a $15,000 loan for the tendifferent APK's and six different lengths of time. Be sure to use proper absolute/ med/relative cell references B D G H Number of Year it) APR IN S 1,256.78 561151 S (23.12 S318925256.41 $ 214.73 2x S 1,23.5$ 638 10 $475 125.435 263 S 22176 3% $ 127.41 $ 644.72 S436.22 S 312.01 209.53 $ 227.91 4x S 1,277.25 S 651.375 442.16 S 38.69 $ 276.25 S 234.68 5X S 1,284.11 $ 60 $ 449.56 S 345.44 S 281.07 24157 6X $ 1,291.00 S 641 456 33 S 3522 S 2.99 $ 248 59 7% S 1,297.90 $ 671.59 $ 46 1.16 159.19 S 97.02 $255.74 AS 1,30483 S 678 41 S 470.05 S 366.19 S 304.15 S 263.00 9X $ 1,311.775 635.27 S 177.00 373.28 $ 311.35 $ 270.38 10% $ 1,318.74 569217 545401S 380445 318.71 S 277.89 APR Total Interest Paid Over Wife of the loan Number of Years 13 23 3% b.) Create another table which comes the total interest paid over these of the loan for each of the sixty monthly payments given in the table. There is a very easy way to do this, simply subtract the loan from the total of all the payments made over the life of the loan. Be sure to use proper absoluta/mbed/relative cell references 5% 63 9% 10% c.) Create a well-labeled graph for your table from part b 4 Car loan Type here to search o II E lije