Periods Per Year Annual Interest Rate Duraion in Years Penodic Payment Loan 1 6 4.50% 4.6 (3,000) Loan 2 5.18% 10 (5,499) Loan 3 12 7.40% (1,200) Loan 4 4 5.50% (3,427) Loan 5 2 8.50% (8,613) Imagine that your company has decided to upgrade hardware and software in your department. You have been given the loan information in the table above, but notice that each one is missing suitable loan. The loan objective is to minimize interest even if it means a slightly higher periodi Complete the table above to include the missing values using financial functions and formulas