Loan Amortisation

Hi all,

I have an issue trying to amortise a loan with an interest rate forecast.

I have been able to do this for a fixed interest rate through the use of a recursive loop and rewriting over the columns.

I need to replicate this but read in the interest rates from a separate table.

Any help would be appreciated.

Hi @LiamFoster -

Welcome to the forum. Would you mind posting your existing workflow? Then someone could adapt that, and maybe save some time on both ends.

1 Like (57.4 KB)

Hi Scott,

Here is the existing workflow. The table called interest rate forecast is what I want to read into the loop as the iteration changes.


How about this? New nodes and functionality are highlighted in the yellow annotation box.

Knime_Upload_Forum_SF.knwf (67.4 KB)

1 Like

Hi Scott, that works perfectly.



This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.