85 3 1 2 D L 1 M Interest rates can make a big difference in payments On this page, please place all answers in the blue cells. Let's see what used car with a higher interest rate would cost and compare to a new car with a smaller interest rate We plan to spread the car loan payment out for 5 years - how many months will this becalculate with multiplication in cells **Note- there are no cells in this particular formula-months in a year ayers of the loan 1 7 2011 Honda Accord w/100,000 miles 10% interest rate We can purchase the car for $12,000 2020 Honda Accord w/1.000 miles and 36,000 mile warranty 1% interest rate We can purchase the car for $27,000 **Be sure to place an apostrophe before the qualit 9 10 11 12 13 14 15 16 17 TA Show the function incl33 Place the correct elements in the cells in Column 12,000 27,000 $ $ 5 5 $ Sticker Price Down Payment Loan Amount Interest Rate Term Mant Payment Malthe 10% show as positive will be Sticker Price Down Payment Loan Amount interest Rate Tem Maithal Payment 27,000 Mhe the pot 1 shows positive 60 it will help 20 21 **Never get in the habit of only seeing if you can make the payment but also check to see the total amount you are paying Multiply the payment amount times the number of payments in cells and again in to see the total amount at themd of the loan. "Multiply 021 85 **Multiply 1215 21 24 25 26 27 28 29 30 5 Now atract the foot paid from the purchase price to the mount of more you are provine **wore than amount from the Same Call but use the appropriate amount we will actually pay for the car itwe w tre Milamount of months if we don't preow Which would you choose and why? Anwerin Type over the words. This is your choice. No wongan 7 N91751762, section 2010 14 35 36 27 Interest rates can make a big difference in payments. On this page, please place Let's see what a used car with a higher interest rate would cost and compare to a new car with a smaller interest rate. We plan to spread the car loan payment out for 5 years - how many months will this be?-calculate with multiplication in cell BS **Note there are no cells in this particular formula-months in a year Ayears of the loan 2013 Honda Accord w/100,000 miles 10% interest rate We can purchase the car for $12,000 2020 Honda Accord w/1,000 miles and 36,000 mile warranty 1% interest rate We can purchase the car for $27,000 **Be sure to place an apostrophe before the equal sign! Show the PMT function in cell13 Place the correct elements in the cells in Column 3 Sticker Price Down Payment Loan Amount Interest Rate Term (Months) Payment $ 12,000 $ Make the pot 10% show as positive it will help with 85 Sticker Price Down Payment Loan Amount Interest Rate Term (Months) Payment $ 27,000 S $ 27,000 Make the pit 1% show as positive 60 it will help with 4&5 **Never get in the habit of only seeing if you can make the payment but also check to see the total amount you are paying Multiply the payment amount times the number of payments in cells B5 and again in HS to see the total amount at the end of the loan. **Multiply 021 85 **Multiply J21 85 Now subtract the total amount paid from the purchase price to see the amount of interest you are paying ** Subtract the loan amount from the Same as C28 but use the appropriate cells. amount we will actually pay for the car if we pay the full amount of months if we don't prepay) Which car would you choose and why? Answer in cell H30 Type over these words. This is your choice. No wrong answer. 85 3 1 2 D L 1 M Interest rates can make a big difference in payments On this page, please place all answers in the blue cells. Let's see what used car with a higher interest rate would cost and compare to a new car with a smaller interest rate We plan to spread the car loan payment out for 5 years - how many months will this becalculate with multiplication in cells **Note- there are no cells in this particular formula-months in a year ayers of the loan 1 7 2011 Honda Accord w/100,000 miles 10% interest rate We can purchase the car for $12,000 2020 Honda Accord w/1.000 miles and 36,000 mile warranty 1% interest rate We can purchase the car for $27,000 **Be sure to place an apostrophe before the qualit 9 10 11 12 13 14 15 16 17 TA Show the function incl33 Place the correct elements in the cells in Column 12,000 27,000 $ $ 5 5 $ Sticker Price Down Payment Loan Amount Interest Rate Term Mant Payment Malthe 10% show as positive will be Sticker Price Down Payment Loan Amount interest Rate Tem Maithal Payment 27,000 Mhe the pot 1 shows positive 60 it will help 20 21 **Never get in the habit of only seeing if you can make the payment but also check to see the total amount you are paying Multiply the payment amount times the number of payments in cells and again in to see the total amount at themd of the loan. "Multiply 021 85 **Multiply 1215 21 24 25 26 27 28 29 30 5 Now atract the foot paid from the purchase price to the mount of more you are provine **wore than amount from the Same Call but use the appropriate amount we will actually pay for the car itwe w tre Milamount of months if we don't preow Which would you choose and why? Anwerin Type over the words. This is your choice. No wongan 7 N91751762, section 2010 14 35 36 27 Interest rates can make a big difference in payments. On this page, please place Let's see what a used car with a higher interest rate would cost and compare to a new car with a smaller interest rate. We plan to spread the car loan payment out for 5 years - how many months will this be?-calculate with multiplication in cell BS **Note there are no cells in this particular formula-months in a year Ayears of the loan 2013 Honda Accord w/100,000 miles 10% interest rate We can purchase the car for $12,000 2020 Honda Accord w/1,000 miles and 36,000 mile warranty 1% interest rate We can purchase the car for $27,000 **Be sure to place an apostrophe before the equal sign! Show the PMT function in cell13 Place the correct elements in the cells in Column 3 Sticker Price Down Payment Loan Amount Interest Rate Term (Months) Payment $ 12,000 $ Make the pot 10% show as positive it will help with 85 Sticker Price Down Payment Loan Amount Interest Rate Term (Months) Payment $ 27,000 S $ 27,000 Make the pit 1% show as positive 60 it will help with 4&5 **Never get in the habit of only seeing if you can make the payment but also check to see the total amount you are paying Multiply the payment amount times the number of payments in cells B5 and again in HS to see the total amount at the end of the loan. **Multiply 021 85 **Multiply J21 85 Now subtract the total amount paid from the purchase price to see the amount of interest you are paying ** Subtract the loan amount from the Same as C28 but use the appropriate cells. amount we will actually pay for the car if we pay the full amount of months if we don't prepay) Which car would you choose and why? Answer in cell H30 Type over these words. This is your choice. No wrong