Applying Integrated Excel: Computing periodic payments using PMT Compute the amount of the periodic payments for each of the following loans: Required: Part 1) A 30-year, $400,000 mortgage with monthly payments and varying interest rates. Part 2) A 30-year, $350,000 loan with semiannual payments and varying interest rates. Part 3) A $50,000 car loan with monthly payments and varying terms. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to ret Connect