Excel template
$12
Buy and downloadInstant download. Opens in Excel, Google Sheets and Numbers.
Secure checkout by Gumroad. Not what you expected? See the refund policy.
Details
Calculate mortgage payments, interest, and loan details in one easy spreadsheet.
What you get
- Start Here sheet with instructions
- Main loan calculation table with input cells
- Dropdown lists for loan terms and interest rates
- Automatic formulas for calculations
- Summary sheet with key numbers and bar charts
- Settings sheet for customizing defaults
- Bar chart: Down Payment by Loan Type (updates as you type)
- Bar chart of the key money figures on the Summary sheet
Why you will like it
- Calculate monthly mortgage payments
- Compare different loan terms and interest rates
- Track total interest paid over the loan term
- Estimate total loan cost with different down payments
- Customizable for different loan scenarios
Made for
Homebuyers, real estate investors, and anyone looking to calculate home loan payments.
How it works
- Open the Excel file and go to the 'Start Here' sheet for instructions.
- Enter your loan amount, interest rate, and term in the main table.
- Review the summary sheet for key results and charts.
- Adjust inputs to compare different loan scenarios.
Format: Excel file (.xlsx). Works in Microsoft Excel, Google Sheets and LibreOffice. Instant download after purchase.
Designed by ABDALLAT & CO Enterprises with AI-assisted tools and checked before release. Questions or problems? Email [email protected].
A look inside
