Has anyone successfully built an Amortization Schedule for a mortgage or car loan? If building in Excel, the primary formula would be CUMPRINC function as described below.
Much appreciated in advance if you have any experience or an approach that works for Knack for which you can share.
Thank you!
The CUMPRINC function calculates the cumulative principal amount paid over a specified range of time, defined by the start and end periods of a loan. This function is important for financial analysis, particularly in managing loans and amortization schedules. By calculating the principal portion of loan payments over specific periods, the CUMPRINC function provides useful insights into loan dynamics and helps show the trajectory of loan repayment over time. Typical use cases include evaluating the principal repayment structure of mortgages over various durations, analyzing the principal component in different loan offers, or planning financial budgets.
This is where I would start. You can find JS people who do this for a living to help. You would need a table to capture the inputs that feed the CUMPRINC, then consume these values with the Knack REST API, then process through a function like below and then write to the output field. *** Claude MCP (and others) can greatly assist in finding resolution to these types of questions. BUT, if you go that route - always duplicate your Claude APP and run Anthropic against it (the dupe) - never against your Production APP in Knack until you have tested and accept the results. Best, John S.
Mapping to Knack: replace the manual inputs above with the actual field values from a Knack record —
either read them from a Rich Text view via Knack.views\['view_x'\].model.attributes,
or pull them from the Knack REST API (GET /v1/objects/object_x/records/record_id) and pass
record.field_12, record.field_13, etc. into cumprinc() below instead of the form values.
The math itself doesn't care where the numbers come from.
Thank you, sir! Amazing. I’m not sure if I can pull off myself but I greatly appreciate your share and will work to network someone to help. Much appreciated!