buy now pay in three months calculation formula

[kashhh1]

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 month …

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

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: buy now pay later payment formula for three months
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[kashhh1]

Okay, apologies willdo.