output (1).xlsx

1. 8/5/2022 and the projection period starts from October 2022. Then the amount will reoccur on 10/1/2022.
2. 8/31/2022 amount will reoccur on 10/31/2022 and next will be 11/30/2022
3. 11/1/2022 amount will reoccur on 12/1/2022 and so on
4. 01/31/2023 amount will reoccur on 2/28/2022 and so on
5. Billing cycle is Monthly, Annually, Bi-annually so need to add values based on that

The recurring amount will be sensitive to (28/30/31) days of the month.