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.