Copy the free Google Sheets Mortgage Calculator by Lido.app here. A new tab or window will open, asking you to copy the template. Click Make a copy.
The Free Google Sheets Mortgage Calculator has a single sheet, containing the input with their sample values and the resulting mortgage per month.
The required inputs for the sheet to work are the following:
For our example, here are the inputs:
The base monthly mortgage will be automatically calculated as you input the values.
Often additional costs are added to the resulting monthly payment such as additional payment per month (that goes straight to the principal), mortgage insurance, and escrow. Add them in the additional fields.
If you want to itemize more costs, you have three additional fields to use. Replace the label with the label for the specific cost then add its value.
Once you’re done, the resulting mortgage is automatically calculated! It’s that simple to use. If you want to use our mortgage calculator, copy it again by clicking the link below.