BrutalLogiC
Active Member
- Joined
- Feb 26, 2006
- Messages
- 273
- Office Version
- 365
- Platform
- Windows
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.
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!!!
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! |
