calculate monthly value

[BrutalLogiC]

Hi I hope someone can help me with calculating the monthly values. I have lots of contracts and most are a fixed value for the full year but for some the value changes which makes it complicated for me to track the monthly values.

For part months I am dividing latest annualised total by 365 days.

Original start date

Original annualised value

Original Monthly

Original Daily

Variation 1 start date

V1 annualied value

V1 Monthly

V1 Daily

Variation 2 start date

V2 annualised value

V2 Monthly

V2 Daily

Variation 3 start date

V3 annualised value

V3 Monthly

V3 Daily

End Date

1-Jan-2023

15,000,000

1,250,000

41,096

30-Mar-2024

12,000,000

1,000,000

32,877

30-Jun-2024

13,000,000

1,083,333

35,616

1-Nov-2024

8,500,000

708,333

23,288

15-Dec-2024

so in words the values would be as below but I have been struggling to figure out formula to replace the words below which consider any variations. Appreciate any help!!!

Monthly values​

Jan-24

Feb-24

Mar-24

Apr-24

May-24

Jun-24

Jul-24

Aug-24

Sep-24

Oct-24

Nov-24

Dec-24

2024 total

original monthly value

original monthly value

this would be 29 days at the original daily value and 2 days at V1 value

V1 monthly value

V1 monthly value

this would be 29 days at V1 value and 1 day at V2 value

V2 monthly value

V2 monthly value

V2 monthly value

V2 monthly value

V3 monthly value

V3 15 days only!