please include formulas

C11 Complete each task by inserting the appropriate function, referencing the appropriate cells in the task data, in the specified cells. Task 1 Data Task 2 Data Loan Amount Interest Rate Number of Payments -$47,500.00 2.25% 60 Monthly Payment Interest Rate Number of Payments -S95242 2.25% 60 Monthly Payment Loan Amount Remember to divide the interest me by 2 to calculate the monthly interest in your function Remember to divide the interest rate by 12 to oscute the monthly interest in your function Task 3 and 4 Data Task 5 and 6 Data Loan Amount Monthly Payment Number of Payments -554,000.00 $952.42 2.25% Interest Loan $54,000.00 2.2596 60 Loan Amount Interest Rate" Number of Payments 2.0% Interest Loan -554,000.00 3.50% 601 Nominal Interest Rate Effective Interest Rate Monthly Payment Total Payments (PMT # of PMTS) $0.00 $0.00 Remember to multiply the nominal interest rate by 12 to calculate the annual interest rate The difference between low and high interest rate loans (total payments 3.5% total payments 2.25%) Remember to divide the interest rate by 2 to calculate the monthly interest ratejinyou functions PivottableData prouestions PT PT2 PT P TA Financials LookupAnd Conditional