Fill in the missing information in following table: To find the Monthly Payment, you have to use the Excel function: pmt(rate,nper,-pv) Round all your answers to the nearest dollar. Loan Amount Annual Interest Rate Years $200,000 $200,000 $200,000 $200,000 3.1% 3.1% 4.1% 4.1% 30 15 30 15 Monthly Payment $ Total Amount Paid $ $ Submit Answer Incorrect. Tries 2/99 Previous Tries Submit Arower Incorrect. Thes 1/99 Previous Tres Submit Answer Thes 0/99 $ $ Submit Answer Incorrect, Tries 3/99 Previous Tres Submit Answer Tries 0/99 $ Submit Answer Tries 0/99 $ Submit Answer Tries 0/99 $ Submit Answer Tries 0/99 Submit Answer Tries 0/99 Interest Paid Purdue University Submit Answer Incorrect. Tries 1/99 Previou Submit Arewer Tries 0/99 $ Submit Answer Tries 0/99

To find the Monthly Payment, you have to use the Excel function: pmt(rate,nper,-pv) Round all your answers to the nearest dollar