Excel 模型:可调利率抵押贷款 (ARM) 计算器

标题: Adjustable Rate Mortgage (ARM) Calculator

 描述:

 

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.

 

  • 贷款信息: 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.
  • 摊销计划: Breakdown of each payment, including payment date, interest rate, payment due, interest, principal, balance, and cumulative totals.

 

来源: 自定义计算器

单击以下图标可在新选项卡中打开完整的工作簿查看器,让您轻松编辑和保存。

单击以下图标下载电子表格,您可以将文件与编辑内容一起保存在计算机上。

发表评论