Excel 模型:固定付款摊销计划

标题: Fixed Payment Amortization Schedule

 描述:

 

This spreadsheet is used to create an amortization schedule for loans with fixed payments. It provides a detailed breakdown of each payment, including how much goes toward interest and principal, and tracks the remaining balance over time.

 

  • Loan Details: Enter loan amount, annual interest rate, loan term, and payment frequency.
  • 摊销计划: A detailed table showing each payment date, payment amount, principal portion, interest portion, and remaining balance.
  • 概括: Provides an overview of total interest paid, total payments, and loan payoff details.

 

来源: 自定义计算器

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

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

发表评论