Need help with part C"Complete the second table which computes the total interest paid over the life of each loan using the monthly payments times the total number of payments minus what you borrowed" Information:Loan: 200,000Years:10, 15, 20, 25, 30Interest charges 5%, 6%, 7%, 8%

A B C D E F G H K L M N This problem will compute the monthly payments associated to a $200,000 loan for various rates and terms. Loan: $200,000 3 4 Years Monthly Payments 5% 6% 7% 8% al Complete the first table which computes these monthly payments, and make them pos 6 10 $2,121.31 $2,220.41 $2,322.17 $2,426.55 by multiplying each one by-1. Use an Excel function. 7 15 $1,581.59 $1,687.71 $1,797.66 $1,911.30 8 20 $1,319.91 $1,432.86 $1,550.60 $1,672.88 b.) Create a well labeled line chart displaying the information from this table. 9 25 $1,169.18 $1,288.60 $1,413.56 $1,543.63 10 30 $1,073.64 $1,199.10 $1,330.60 $1,467.53 11 12 13 Years Interest Charged c.) Complete the second table which computes the total interest paid over the life of each loa 14 5% 6% 7% 8% using the monthly payments times the total number of payments minus what you borrowed. 15 10 16 15 17 20 d.) Create a well labeled column chart displaying the information from this second table. 18 25 19 30 20 21 Excel 10 - Payment +