on excel

#7. Prime the 2 variable table (Cols E-1) for the Monthly Payment amount Set the Loan Conditions to the following: Down Payment: $25,000 APR: 5.25% Term (in Years): 30 Loan Amount: 175,000 NOW create the 2-variable data table (Cols E-1) so as to populate the whole thing and then answer this question: If the APR is 6.75% and the term is 120 (months) - the monthly payment is #8. Using the 3rd tab of the starter file (2-variable data table) complete these steps and answer the question: Prime the 2-variable table (Cols E-l) for the Monthly Payment amount Set the Loan Conditions to the following: Down Payment: $11,000 APR: 4.85% Term (in Years): 20 Loan Amount: 225,000 NOW create the 2-variable data table (Cols E-1) so as to populate the whole thing and then answer this question: If the APR is 8.85% and the term is 360 (months) - the monthly payment is 1 2 able Term (in Months) 120 180 240 360 4 5 6 7 8 9 10 11 12 13 Loan Conditions Down Payment $ APR 6.00% Term (Years) 10 Term (Months) 120 Loan $ 100,000.00 Monthly Payment $1,110.21 Total Payments $133,224.60 APR/S Amounts ??? 6.00% 6.50% 7.00% 7.50% 8.00% 8.50% 9.00% 9.50% 10.00% #9. Prime the 2-variable table (Cols E-1) for the Total Payments amount (cell (9) Set the Loan Conditions to the following: Down Payment: $20,000 APR: 5.50% Term (in Years): 25 Loan Amount: 200,000 NOW create the 2-variable data table (Cols E-1) so as to populate the whole thing and then answer this question (which SHOULD already be there from the previous question you just got) and HINT: If you see all # signs - that means the # is TOO BIG to display so just widen those columns. If the APR is 9.50% and the term is 240 (months) - the total payments made is #10. Prime the 2-variable table (Cols E-1) for the Total Payments amount (cell 09) Set the Loan Conditions to the following: Down Payment: $20,000 APR: 5.50% Term (in Years): 25 Loan Amount: 200,000 NOW create the 2-variable data table (Cols E-1) so as to populate the whole thing and then answer this question (which SHOULD already be there from the previous question you just got) and HINT: If you see all #signs - that means the # is TOO BIG to display so just widen those columns. If the APR is 9.00% and the term is 360 (months) - the total payments made is #7. Prime the 2 variable table (Cols E-1) for the Monthly Payment amount Set the Loan Conditions to the following: Down Payment: $25,000 APR: 5.25% Term (in Years): 30 Loan Amount: 175,000 NOW create the 2-variable data table (Cols E-1) so as to populate the whole thing and then answer this question: If the APR is 6.75% and the term is 120 (months) - the monthly payment is #8. Using the 3rd tab of the starter file (2-variable data table) complete these steps and answer the question: Prime the 2-variable table (Cols E-l) for the Monthly Payment amount Set the Loan Conditions to the following: Down Payment: $11,000 APR: 4.85% Term (in Years): 20 Loan Amount: 225,000 NOW create the 2-variable data table (Cols E-1) so as to populate the whole thing and then answer this question: If the APR is 8.85% and the term is 360 (months) - the monthly payment is 1 2 able Term (in Months) 120 180 240 360 4 5 6 7 8 9 10 11 12 13 Loan Conditions Down Payment $ APR 6.00% Term (Years) 10 Term (Months) 120 Loan $ 100,000.00 Monthly Payment $1,110.21 Total Payments $133,224.60 APR/S Amounts ??? 6.00% 6.50% 7.00% 7.50% 8.00% 8.50% 9.00% 9.50% 10.00% #9. Prime the 2-variable table (Cols E-1) for the Total Payments amount (cell (9) Set the Loan Conditions to the following: Down Payment: $20,000 APR: 5.50% Term (in Years): 25 Loan Amount: 200,000 NOW create the 2-variable data table (Cols E-1) so as to populate the whole thing and then answer this question (which SHOULD already be there from the previous question you just got) and HINT: If you see all # signs - that means the # is TOO BIG to display so just widen those columns. If the APR is 9.50% and the term is 240 (months) - the total payments made is #10. Prime the 2-variable table (Cols E-1) for the Total Payments amount (cell 09) Set the Loan Conditions to the following: Down Payment: $20,000 APR: 5.50% Term (in Years): 25 Loan Amount: 200,000 NOW create the 2-variable data table (Cols E-1) so as to populate the whole thing and then answer this question (which SHOULD already be there from the previous question you just got) and HINT: If you see all #signs - that means the # is TOO BIG to display so just widen those columns. If the APR is 9.00% and the term is 360 (months) - the total payments made is