Display the Condo Purchase worksheet. In cell B$5,$ insert the PMT function using the data from the range B$2$:B$4-$be sure to divide the interest rate by $12$ multiply the years by $12$ and display the payment as a positive number. The result, $$6,598\mathrm{.}44,$ is larger than the maximum payment of $$6,250.$