Solve for PMT $1000 dollars of Principal will be paid out over 10 periods at interest rate r. Make a table displaying the different pmt amounts corresponding to different rates r. Use a manual geometric series calculation and match the result with Excel's PMT function. You can use a data table to implement if you want