Amortization
Builds a full month-by-month loan schedule from a principal, an annual rate, and a payment count. It computes the fixed monthly payment, then produces a table with one row per month showing Payment, Principal, Interest, and the remaining Balance, with the final row adjusted so the balance lands exactly on zero. Enter the rate as an annual decimal; the node handles the monthly conversion.
Inputs
| Input | Accepts | Required |
|---|---|---|
Principal | Value (a single number) | Yes |
Rate | Value (a single number) | Yes |
Periods | Value (a single number) | Yes |
Outputs
| Output | Produces |
|---|---|
Result | Table |
Settings
Typed in on the node or set by the assistant, not wired.
| Setting | Default | Notes |
|---|---|---|
Principal | 100000 | The starting loan balance in dollars. Default 100000. |
Rate | 0.06 | Annual interest rate as a decimal: 0.06 for 6%. The node divides by 12 internally to get the monthly rate. |
Periods | 360 | Total number of monthly payments: 360 for a 30-year loan, 120 for 10 years. Default 360. |
Example
A $2,000,000 equipment loan at 6% over 10 years: set Principal to 2000000, Rate to 0.06, and Periods to 120. The payment works out to about $22,204 a month. Month 1 splits into $10,000 of interest and $12,204 of principal; by month 120 the balance column reaches $0. The 120-row schedule appears as a table you can chart or filter; for instance, a Filter on Period <= 12 gives the first year's payments.
Tips
For irregular paydown (mandatory amortization plus a cash sweep from operating cash flow), use DebtSchedule instead. If you only need the payment amount and not the schedule, TimeValue in PMT mode is lighter.