what will be the right Pmt function to calucute the monthly payment for each loan?

File Home Insert Page Layout Formulas Data Review View Help Foxit PDF Acrobat Calibri 12 General ' ' - A. Paste BTU 2 Wrap Text Merge & Center - - ill $ - % 98 99 Conditional Formatting Clipboard Font Alignment Number 013 ! fx + B D G 1 Loani First Name Last Name City Loan Date Amount Interest Rate Term Monthly Payment Type 2 1022 Eileen Cooper Santa Fe 2/28/2013 $200,000.00 7.00% 15 Mortgage 3 1023 Eileen Cooper Santa Fe 3/21/2013 $150,000.00 7.50% 15 Mortgage 4 1024 Eileen Cooper Santa Fe 3/22/2013 $100,000.00 7.00% 30 Mortgage 5 1025 Scott Hunter Taos 3/1/2013 $25,000.00 6.50% 3 Automobile 1026 Scott Hunter Taos 4/1/2013 $10,000.00 7.70% 5 Automobile 7 1027 Ellen Harper Albuquerque 3/11/2013 $200,000.00 6.25% 15 Mortgage 8 1028 Ellen Harper Albuquerque 3/31/2013 $15,000.00 6.50% 3 Other 9 1029 Ellen Harper Albuquerque 4/15/2013 $25,000.00 7.75% 4 Automobile 10 1030 Ellen Harper Albuquerque 5/1/2013 $150,000.00 5.75% 15 Mortgage 11 1031 Max Entermann Santa Fe 1/15/2013 $475,000.00 5.75% 15 Mortgage 12 1032 Max Entermann Santa Fe 1/23/2013 $35,000.00 6.75% 5 Automobile 13 1033 Max Entermann Santa Fe 1/31/2013 $12,000.00 8.25% 10 Other 14 1034 Max Entermann Santa Fe 5/3/2013 $350,000.00 8.00% 30 Mortgage 15 1035 Helen Rayus Albuquerque 1/25/2013 $10,000.00 5.50% 3 Automobile 16 1036 Helen Rayus Albuquerque 3/1/2013 $20,000.00 7.5096 5 Other 17 1037 Ted Myerson Santa Fe 2/8/2013 $525,000.00 6.50% 30 Mortgage 18 1038 Peter Sanger Albuquerque 2/12/2013 $10,500.00 6.8896 5 Other 19 1039 Peter Sanger Albuquerque 5/8/2013 $275,000.00 6.00% 15 Mortgage 20 1040 Rose Budnick Taos 2/20/2013 $250,000.00 5.75% 30 Mortgage 21 1041 Rose Budnick Taos 2/21/2013 $5,000.00 8.75% 3 Other 22 1042 Rose Budnick Taos 4/18/2013 $41,000.00 7.50% 4 Automobile 23 1043 Austin Powers Albuquerque 3/3/2013 $50,000.00 7.25% 5 Automobile 24 1044 Barbara Ringer Taos 2/15/2013 $35,000.00 6.00% 5 Other Documentation Loans 4.) To the left of the Type column, insert a new column named "Monthly Payment". Use the monthly payment function (PMT) to calculate the monthly payment for each loan. Adjust the formula so that each loan is displayed as a positive amount