Financial Functions 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 $540,000.00 5.25% 360 Monthly Payment Interest Rate* Number of Payments $3,593.00 5.25% 360 Monthly Payment Loan Amount . Remember to divide the interest rate by 12 to calculate the monthly interest rate) in your function . Remember to divide the interest rate by 12 to calculate the monthly interest rate) in your function Task 3 and 4 Data Task 5 Data Loan Amount Monthly Payment Number of Payments $540,000.00 $3,593.00 360 Monthly Lease Revenue Rate of Return Number of Months -$500.00 10.00% 36 Future Value of Leasing Nominal Interest Rate Effective Interest Rate Remember to multiply the nominal interest rate by 12 to calculate the annual interest ratel Remember to divide the interest rate by 12 to calculate the monthly interest rate) in your function Task 6-8 Data Loan Amount Interest Rate Number of Payments 5.25% Interest Loan $540,000.00 5.25% 360 7% Interest Loan $540,000.00 7.00% 360 Monthly Payment Total Payments (PMT #of PMTS) $0.00 $0.00 The difference between low and high interest rate loans (total payments 7% -total payments 5.25%) * Remember to divide the interest rate by 12 to calculate the monthly interest rate) in your functions