Base Dates, Review Dates and Index Lags
This lesson is part of the course
In this lesson
You work out which index month a clause points to with EOMONTH, pull the base and review index values from a fictional monthly index table with XLOOKUP and calculate the index change for six contracts with different lags.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- The Adjustment Formula: Fixed, Material and Labour Shares Locked
- Base Dates, Review Dates and Index Lags Locked
- Caps, Floors and Collars – Per Year and Cumulative Locked
- Thresholds and Sharing Bands Locked
- Surcharge Tables and Pass-Through Amounts Locked
- Fixed Escalation vs Index-Linked: Which Is Cheaper? Locked
- Checking a Supplier's Price Claim Locked
- Portfolio Impact: Budget Effect by Category and a Chart Locked