Forums » General » Calculation of the periodic loan payment

drakus
Avatar

I have to calculate in the table the payment of principal and interest according to the given schedule. This is very easy to do in excel because there is a PMT/PMT/PMT formula. Tableau doesn't have these financial options, and it's hard for me to get them. Please help me.

soniabailey
Avatar

See attached workbook. I've added a parameter for number of payments they plan to pay the loan off over, plus various calculations prefixed with an underscore. I have a few small rounding.

In reply to drakus
soniabailey
Avatar

I'm just "lucky" I've come across similar calculations before and been through the pain of digging out how to reproduce them. Anyway I'm glad it helped.

In reply to soniabailey
vanessawalsh
Avatar

This is my salvation, you really are a genius. I've been tormented with this question for a very long time and I was offered very complex and inconvenient solutions. The client took a loan from https://www.yhdistalaina.com/jarjestelylaina/ , and I was in big trouble with him. There are no complaints about the bank, everything was done at the highest level. But the client was disgusting. I couldn't say anything, it was my job. But I haven't had such a misunderstanding in a long time. In general, thank you for your knowledge.

In reply to soniabailey
n_bates
Avatar

Oh, I know this bank, it's excellent and very convenient.

In reply to vanessawalsh