Run loan math in a cell. Returns the monthly payment, total interest and more — Google Sheets or Excel.
It's one of 250+ live sources you reach with a single =VERVE() function — served from APIVerve's production data engine, billed at 2 credits per resolved cell, and refreshed on whatever cadence you set. No API keys to wrangle, no scripts, no exports.
A real example — the input you type, and the values you can pull from it. Click any cell to see the formula behind it.
Drop =VERVE("loanpaymentcalculator", 32000, 8.5, "downpayment") into a cell and your model reads the latest number every refresh — no more pasting figures from a browser tab into a stale sheet.
Fill a column beside your list of tickers or currencies and every row updates together, so a hundred-row watchlist stays current on its own.
Point a chart at the cell =VERVE("loanpaymentcalculator", 32000, 8.5, "downpayment") feeds and the chart re-draws as the data moves — a finance dashboard that's live instead of a Monday-morning snapshot.
The same function works in both apps — install once, sign in with your key, and type it into any cell.
Install from the Workspace Marketplace, then drop the formula into a cell. Autocomplete suggests the source and its fields.
=VERVE("loanpaymentcalculator", 32000, 8.5, "downpayment")Same source, same arguments, same key — in Excel on desktop, the web, or mobile. Excel namespaces it as VERVE.CALL. Drag to fill a whole column.
=VERVE.CALL("loanpaymentcalculator", 32000, 8.5, "downpayment")Tune the result by adding name=value before the field argument — in any order. Leave one out and its default applies.
The loan term in whole years (e.g. 5 or 30). For terms quoted in months, send loanTermMonths instead
=VERVE("loanpaymentcalculator", 32000, 8.5, "downpayment", "loanTerm", "5")The loan term in months (e.g. 36, 60, 72, 75). Overrides loanTerm; use it for auto and personal loans quoted in months, including terms that are not whole years such as 18 or 30
=VERVE("loanpaymentcalculator", 32000, 8.5, "downpayment", "loanTermMonths", "60")Amount paid up front, subtracted from the loan amount before interest is applied
=VERVE("loanpaymentcalculator", 32000, 8.5, "downpayment", "downpayment", "5000")Extra principal paid every month. Adds an extra_payment block with the early payoff month, months saved and interest saved
=VERVE("loanpaymentcalculator", 32000, 8.5, "downpayment", "extraPayment", "100")Loan start date (YYYY-MM-DD), with the first payment one month later. Adds the payoff date
=VERVE("loanpaymentcalculator", 32000, 8.5, "downpayment", "startDate", "2026-12-01")Also price the loan on a biweekly (26 a year) or weekly (52 a year) schedule. Adds a payment_frequency block; monthly figures are unchanged
=VERVE("loanpaymentcalculator", 32000, 8.5, "downpayment", "paymentFrequency", "biweekly")Upfront fees deducted from the amount the borrower receives (origination, closing). Adds the APR including those fees
=VERVE("loanpaymentcalculator", 32000, 8.5, "downpayment", "fees", "800")Add a field name right after the inputs to land just that value in the cell.
=VERVE("loanpaymentcalculator", 32000, 8.5, "monthly_payment")=VERVE("loanpaymentcalculator", 32000, 8.5, "total_interest_paid")=VERVE("loanpaymentcalculator", 32000, 8.5, "total_payment")=VERVE("loanpaymentcalculator", 32000, 8.5, "interestRatio")=VERVE("loanpaymentcalculator", 32000, 8.5, "formatted")=VERVE("loanpaymentcalculator", 32000, 8.5, "formatted.loanAmount")=VERVE("loanpaymentcalculator", 32000, 8.5, "formatted.monthlyPayment")=VERVE("loanpaymentcalculator", 32000, 8.5, "formatted.totalInterestPaid")=VERVE("loanpaymentcalculator", 32000, 8.5, "formatted.totalPayment")=VERVE("loanpaymentcalculator", 32000, 8.5, "amortization_schedule")=VERVE("loanpaymentcalculator", 32000, 8.5, "amortization_schedule.0.month")=VERVE("loanpaymentcalculator", 32000, 8.5, "amortization_schedule.0.interest_payment")Premium marks data included on paid plans. On the Free plan a marked field is withheld and a marked input is ignored — either way the cell reads #PREMIUM(name) instead of a value, so a gated answer can never be mistaken for a real one. Everything unmarked works on every plan. Compare plans
Everything you need to wire it into a sheet.