Excel Model: Adjustable Rate Mortgage (ARM) Calculator

Title: Adjustable Rate Mortgage (ARM) Calculator

 Description:

 

This spreadsheet is designed to help users calculate the payments and financial implications of an adjustable-rate mortgage. It includes sections for loan information, rate adjustments, and an amortization schedule.

 

  • Loan Information: Details of the loan, including loan amount, term, starting interest rate, and first payment date.
  • Rate Adjustments: Information about the rate adjustment periods, expected adjustments, and interest rate caps.
  • Amortization Schedule: Breakdown of each payment, including payment date, interest rate, payment due, interest, principal, balance, and cumulative totals.

 

Source: Custom Calculator

Click the following icon to open the full workbook viewer in a new tab, allowing you to easily edit and save.

Click the following icon to download the spreadsheet, allowing you to save the file on your computer along with edits.

Leave a Comment