How to: Annual Repeating Value shown with Monthly phasing (rents etc)
I needed to take an Annual contract value, and model the payments by month at different frequencies and came up with a solution I thought others might find useful.
Here's the finished dashboard.
For each Site, you select a Payment Schedule. Input the Annual Contract Value and tick which months to allocate the payment to. The output uses the divides the amount using the payment schedule and the phasing for each site in each year.
I added some basic conditional formatting to highlight if more months than expected were ticked.
Blueprint views and lists below.
Hopefully this can help if you have a similar problem to solve, or could I have done this better?!