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

A B C D F G H Payment Date Disbursed @ 6 Months @ Flat 3% Payments Disbursed @ 12 Months @ Flat 3% Payments Disbursed @ 18 Months @ Flat 3% Payments 11/01/17 $500 12/01/17 $1000 01/01/18 $1500 <tbody> </tbody> 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

<colgroup><col><col span="11"></colgroup><tbody>
</tbody>