Click cell B$5,$ and then use Goal Seek to change the period of the loan $($of the original data$)$ so that the payment is $6250$ Then, in cell A$13,$ type Option #$2$Increase YearsFormat the cell the same as cell A$7.$ Copy the range A$2$:B$5,$ and then Paste the Values & Number Formatting to cell A$14.$ Display the value in cell B$15$ with two decimal places, and then in cell B$3,$ type $10$ to restore the original value. If necessary, press ESC to cancel the moving border. Click cell A$1,$ and then Save your workbook.