View Insert Format Tools Data Window Help Excel 1_1_heart_rate.xlsx Excel 1_2_car loan.xlsx 100% Layout Tables Review Home Edt Charts Font 11 2.2. E. SmartArt Formulas Data Alignment A-A- abc Number Format Fi- Wrap Text General Normal 5 Calibri (Body B 7 U Clear % ES Conditional Formatting Paste Normal Merge M34 A P F H 1 O n B APR 6% D t 1 E PMT 5 $ 289.99 M N Review the example given in the chapter involving car payments $ 15,000.00 12 Table Showing Monthly Payments for Different APR's and Terms Number of Years APR 1 a.) Recreate the 10 by 6 table computing the monthly payments for a $15,000 loan for the ten different APR's and six different lengths of time. Be sure to use proper absolute/bed/relative cell references 3% 4% 5X 6 7% 3 4 5 5 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 9% 10% APR Total Interest Paid Over Life of the loan Number of Years (0 15 2% 3x b.) Create another table which computes the total interest paid over the life of the loan fa each of the six 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 sure to use proper absolute/mixed/relative cel referencer 5% 6% 7% 30 9% SON 32 33 c.) Create a well-labeled graph for your table from part Excel 1 heart rate xlsx #4 Car loan Ready Normal View View Insert Format Tools Data Window Help Excel 1_1_heart_rate.xlsx Excel 1_2_car loan.xlsx 100% Layout Tables Review Home Edt Charts Font 11 2.2. E. SmartArt Formulas Data Alignment A-A- abc Number Format Fi- Wrap Text General Normal 5 Calibri (Body B 7 U Clear % ES Conditional Formatting Paste Normal Merge M34 A P F H 1 O n B APR 6% D t 1 E PMT 5 $ 289.99 M N Review the example given in the chapter involving car payments $ 15,000.00 12 Table Showing Monthly Payments for Different APR's and Terms Number of Years APR 1 a.) Recreate the 10 by 6 table computing the monthly payments for a $15,000 loan for the ten different APR's and six different lengths of time. Be sure to use proper absolute/bed/relative cell references 3% 4% 5X 6 7% 3 4 5 5 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 9% 10% APR Total Interest Paid Over Life of the loan Number of Years (0 15 2% 3x b.) Create another table which computes the total interest paid over the life of the loan fa each of the six 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 sure to use proper absolute/mixed/relative cel referencer 5% 6% 7% 30 9% SON 32 33 c.) Create a well-labeled graph for your table from part Excel 1 heart rate xlsx #4 Car loan Ready Normal View
