repayments for each month

[kashh83]

Hello everyone,
I hope some of you can help me as I haven’t found a simple way to do what is trying.
I am trying to project for a pitch that has to buy now pay later element …
We are assuming that 75% of the sale value will be given as credit to consumers…
I am trying to calculate the repayment of each month in such a way that they have.
C8 = M1 interest and principal payment – 1st payment
C9 = M1 interest and principal payment – 2nd payment + M2 interest and principal payment – 1st payment
C10 = and so on …
I have used few interest rate calculator but all of them give me individual numbers and it will be very hard and long to have an individual calendar for each month and then copy that data over to the cell … but even when I do that Its more of a series of number than one number that is like accumulative number for x number of months.
Please advise if anyone has any ideas.
Thank you in advance

[josephteh]

Formula for cell C8=PMT($C$2/12,$E$2,-C7)+N(B8)

[kashh83]

Thank you

What does N(b8) represent here... and how can I show 2nd payment of month 1 and 1st payment of month two in D8

[josephteh]

Just pull the formula from cell D8 right all the way to N8. N is to convert text to a number 0, otherwise +B8 will give you an error.