Spreadsheet programs, such as Microsoft Excel and Google Sheets, include a payment function that can calculate the principal and interest on a mortgage. Let's say you buy a condo priced at $250,000.