Forum Discussion
Get loan outstanding amounts
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.
4 Replies
- parry2k
Super User
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?
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!
- 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.
v-henryk-mstfCommunity Support
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.
