Payment Schedule for Loans

[electrox]

Hello Guys!

Good day,

I hope you all are doing fine,

I need help this time for creating a payment schedule for loans on a flat rate with amortized payments, let´s put it this way

[TABLE="width: 1250"]
<colgroup><col><col span="11"></colgroup><tbody>[TR]
[TD][TABLE="width: 700"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]Payment Date[/TD]
[TD]Disbursed @ 6 Months @ Flat 3%[/TD]
[TD]Payments[/TD]
[TD]Disbursed @ 12 Months @ Flat 3%[/TD]
[TD]Payments[/TD]
[TD]Disbursed @ 18 Months @ Flat 3%[/TD]
[TD]Payments[/TD]
[/TR]
[TR]
[TD]11/01/17[/TD]
[TD]$500[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12/01/17[/TD]
[TD]$1000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01/01/18[/TD]
[TD]$1500[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


On column A I will have all the dates from Today till Infinity.
On column B will be the total amount disbursed for that month
On column C has to be equal to the total amount I will receive based on a amortized payment taking into account the amount disbursed in the previous month + the flat rate, for instance on 11/01/17 I disbursed $500 that has to be repaid under 6 months on a monthly flat rate of 3% that means $10 monthly times 6 , the person will have to pay $560 / 6 roughly $93.33 monthly. Therefore on 12/01/17 I will receiving on column C $93.33 for the following 6 months and so on ( on Jan 18 I will be receiving the Second $93.33 payment and the first payment for whatever amount I disbursed on December 17)

Anyone has idea on how to do this? or a different approach?

Thanks[/TD]
[TD][/TD]
[TD]


[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]