on excel

#3. Prire the 1-variable table (Col F&G) for the 2 values (Monthly Payment and Total Payments) Set the Loan Conditions to the following: Down Payment: $1,000 APR: 5.0% Term (in Years): 5 Loan Amount: 30,000 NOW create the 1-variable data table (Col F&G) so as to populate the whole thing and then answer this question: If the APR is 7.00% - the monthly payment is #4. Prime the 1-variable table (Col F&G) for the 2 values (Monthly Payment and Total Payments) Set the Loan Conditions to the following: Down Payment: $2000 APR: 6.0% Term (in Years): 6 Loan Amount: 40,000 NOW create the 1 variable data table (Col F&G) so as to populate the whole thing and then answer this question: If the APR is 7.50% - the monthly payment is 5. Prime the 1-variable table (Col F&G) for the 2 yalues (Monthly Payment and Total Payments) Set the loan Conditions to the following: Down Payment: $1,000 APR: 5.0% Term (in Years): 5 Loan Amount: 30,000 NOW create the 1-variable data table (Col F&G) so as to populate the whole thing and then answer this question: If the APR is 7.00% - the total payments are 6. Prime the 1-variable table (Col F&G) for the 2 values (Monthly Payment and Total Payments) Set the Loan Conditions to the following: Down Payment: $2000 APR: 6.0% Term (in Years): 6 Loan Amount: 40,000 NOW create the 1-variable data table (Col F&G) so as to populate the whole thing and then answer this question: If the APR is 6.25% - the total payments are B D E G H One-Variable Table 1 2 3 4 5 Loan Conditions Down Payment $ 500.00 APR 6.00% Term (Years) 5 Term (Months) 60 Loan $ 3,000.00 Monthly Payment $48.33 Total Amount Paid $2,899.92 6 7 Rates Monthly Payment Total Payments 6.00%