Forecast an amount every 'x' periods
I need to take a committed contract amount and forecast it going forward as if the contracts will be renewed for exactly the same amount once the contract expires. Contracts can be month to month, quarterly, annual, or bi-annual. The image below shows a mock-up of committed contracts in green text and how I would need to forecast those amounts going forward (in blue).
How do I accomplish this in Anaplan?
E.g. The $50,000 quarterly contract in Aug 20 will renew in Nov 20 for $50,000, the $300,000 quarterly contract in Sep 20 will renew in Dec 20 for $300,000, and the $33,000,000 annual contract in Aug 20 will renew in Aug 21 for $33,000,000