Loan Amortisation

[LiamFoster]

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.

[ScottF]

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.

[LiamFoster]

Knime_Upload_Forum.zip (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.

Thanks,
Liam

[ScottF]

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

Knime_Upload_Forum_SF.knwf (67.4 KB)

[LiamFoster]

Hi Scott, that works perfectly.

Thanks!