Get loan outstanding amounts

[NunoSDCoelho]

Hello,

I have the following sample data on loan notional amounts (each date represents the amout outstanding at that day):

Loan ID	Date	Amount
1	08-05-2018	21,000,000.00
1	08-11-2018	20,300,000.00
1	08-05-2019	19,600,000.00
1	08-11-2019	18,900,000.00
1	08-05-2020	18,200,000.00
2	11-27-2019	18,000,000.00
2	05-27-2020	18,000,000.00
2	11-27-2020	15,000,000.00
2	05-27-2021	15,000,000.00

I need to get the notional amounts for each loan at the end of every month. How should I do that?

Thank you all.

[v-henryk-mstf]

Hi @NunoSDCoelho ,

At present, the sample data you provided does not meet your needs. Can you provide correct data samples and expected output results, so that I can do accurate tests to solve your problem.

Please let me know immediately, looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@NunoSDCoelho it is ok, your sample data don't have even these dates. how easy this all makes if you have the data based on your problem statement, all this just adds a bit more confusion.

[parry2k]

@NunoSDCoelho what is the definition of the end of the month? Are you referring to the most recent transaction since I don't see any end of month date in your sample data?

[NunoSDCoelho]

The end of the month should be the last day of every month, apologies for not being clear in my post.

For this sample, I need to have for loan 1: 21 mln at 31.05.2018, 30.06.2018, 31.07.2018,... ; 20.3 mln at 30.11.2018, 31.12.2018, and so on (the same reasoning applies to other loans).

Thank you for your help!