Calculate a loan payment schedule

Use the Mortgage Calculator pipe to work out a loan's payment amount, total interest and full amortization schedule from the amount, rate and term.

  • Verified Nov 17, 2026
  • Classic builder

On this page
  1. Install the pipe
  2. Parameters
  3. What the pipe returns
  4. Use the result
  5. Check that it worked

The Mortgage Calculator pipe takes a loan amount, interest rate and term, and returns the payment amount, the total interest and the full amortization schedule.

Use it on a loans or quotes table to show the schedule on a page, or to save the payment and totals into fields when a record is saved.

Install the pipe #

  1. Open the pipe library In the builder, click Pipes in the icon bar on the left. The All Pipes list opens.
  2. Find the pipe Type Mortgage Calculator in Search..., or use Choose Categories and pick Tadabase Functions.
  3. Install it Click the Mortgage Calculator card, check its call under Available Actions, and click Install.
The Mortgage Calculator pipe in the pipe library, with Calculate Loan Amortization under Available Actions and the Install button

The pipe is Not Configurable: you set the values you send, but you cannot change the call itself. It has no global parameters and needs no outside account.

Parameters #

The pipe has one call, Calculate Loan Amortization. All four parameters are required.

ParameterWhat to sendExample
Loan AmountThe amount borrowed, as a number.250000
Loan Term YearsThe length of the loan in years.30
InterestThe yearly interest rate as a plain number, not a fraction. For 5%, send 5.5.5
Annual PaymentsHow many payments are made each year. The default is 12 (monthly).12

What the pipe returns #

Response valueWhat it holds
Loan Amount, Loan Term Years, Interest, Annual PaymentsThe values you sent, returned as received.
Payment AmountThe amount of each payment.
Total PaymentsThe payment total from the schedule summary.
Total InterestThe total interest paid over the life of the loan.
Schedule (HTML Table)The whole amortization schedule as an HTML table, ready to show on a page or save in a Rich Text field.
Schedule (array)The schedule as a list with one entry per payment. Use it in a custom component, or go through it with a loop in a workflow.

Use the result #

Installing the pipe does nothing on its own. Choose where it runs:

  • Show it on a page. Edit a Table component, open Data Source, then the Pipes tab, and click Add New Pipe. Select Mortgage Calculator and Calculate Loan Amortization, then map each parameter to a Record Value. The response values then appear under Pipe Fields on the Columns tab, where you add them like any other column.
  • Save it in fields. In a workflow, add a Trigger Pipe step, pick Calculate Loan Amortization under Pipe Method, and map the parameters. In a later Update Record step, write Payment Amount, Total Interest or Schedule (HTML Table) into fields of the record. See Run a pipe from a workflow.

For every place a pipe can run, see Using pipes.

Check that it worked #

Open a record with known values, for example a loan of 100000 at 5 interest over 30 years with 12 annual payments, and compare Payment Amount with a loan calculator you trust. If the pipe returns nothing, check that all four parameters are mapped and that the fields they come from hold numbers.

Was this page helpful?

Something wrong or missing on this page? Tell us.