Buy Now Pay later ... 6 months term with 5% interest

[kashhh1]

Dear All

My assumptions are that I have a buy now pay later product … where the interest is 5% and the term is 6 months

I have managed to get the monthly payment per month via PMT function but I can't seem to find a way to formulate M2 having the first payment of M2 along with the second payment of M1 in one cell (D5) same way in E5 3rd payment of M1, 2nd payment of M2 and 1st payment of M3 …

Any ideas?

Thank you