buy now pay later payment formula for three months

Dear All,
I am trying to create a model for buy now pay in 3 months for a client.
There is no interest payment, whatever any given customer is borrowing they pay that in 3 equal installments.
So far the only way I have figured out to calculate is to simply divide each month’s amount and divide by 3 …
C5 = C$4/3
I am then dragging that to the next two months…
F6 = F$4/3 and so on …
Is there a way to make it a little more presentable where all the monthly repayments are shown in one cell month to a month basis… like D5 will have 2nd payment of M1 and 1st payment of M2 and E5 will have 3rd payment of M1+2nd payment of M2 and 1st payment of M3 henceforth …
I have tried many ways but so far none has really worked.
Any suggestion would be appreciated.
Thank you in advance

Hello Kashh83,

Try putting this in cell C5, tested with your data and is working.

Formula:

Please Login or Register  to view this content.

Thank you, that was quite simple actually ....