return amount/value under specific cell(month) based on calculation and frequency - VBA or EXCEL

  • Hello,


    i need an expert in VBA or Excel help.


    i would like to return the amount (this will be coupon payment) to its due month based on start date and end date and frequency of payment.


    i want to see when how much coupon payments are collected based on the timeline (monthly)


    i have attached this excel for your understanding


    Thank you in advance.