License Renewal Cost Forecast Spreadsheet

I have several hundred employees who each carry one of three licenses. Each license renews on its own cycle—five, ten, or fifteen years—and each carries a different fixed fee. I need a clear, flexible spreadsheet that lets me plug in today’s head-count by license type and instantly see the cash obligations for every quarter across the next fifteen years.

Here is what I have in mind:
• A simple input area where I can update the number of holders for each of the three licenses.
• A built-in schedule that automatically applies the correct renewal period (5-, 10-, or 15-year) and its associated static cost.
• A quarterly timeline that rolls forward for the full fifteen years, summarising total outlay as well as breaking it down by license type.
• At-a-glance totals and, if practical, a small chart so I can spot peak spending periods immediately.

No inflation or future price adjustments are needed right now—the costs stay static. The main focus is accuracy, ease of use, and tidy presentation in Excel or Google Sheets (whichever you prefer). If formulas are protected or macros are required, please comment them clearly so I can maintain the sheet later.

Deliverable: a finished, ready-to-use spreadsheet plus a brief note explaining the key cells and logic.