PressENTERand see theMonthly Lease Payment. Read More:How to Calculate Monthly Payment on a Loan in Excel Method 2 – Using the PMT Function to Calculate Lease Payments in Excel This is the dataset: Steps: Select a cell to see theMonthly Lease Payment. Here,C10. Enter the following formul...