Build a flexible financial model timeline with dynamic arrays. @thefpandaguy
Build a flexible financial model timeline with dynamic arrays.  @thefpandaguy
Uploaded October 2026 | Updated November 2026, 1 day ago
In this episode of Financial Modeler’s Corner Podcast, host Paul Barnhurst welcomes Diarmuid Early to explore flexible model timelines with co-hosts Giles Male and Ian Schnoor.

A hard-coded value in one period is the kind of inconsistency that raises a red flag during a model review.

Dynamic arrays offer a more consistent approach, and timelines are a practical place to apply them.

The demonstrated setup uses a start date, a number of years, and a number of months per period.

Those inputs let a three-year annual model starting October 1 switch to quarterly periods.

Extending the horizon to 20 years makes the timeline grow, while a shorter horizon makes it shrink.

The setup can also include year, month, and quarter numbers, along with different day-count conventions.

The result is a timeline that adjusts with the inputs rather than requiring a manual rebuild.

🎧 Listen to the full episode on @thefpandaguy

#FinancialModeling #DynamicArrays #Excel #ExcelTips #FPandA #ModelTimelines #CorporateFinance #SpreadsheetModeling #FinancialModels #ModelingBestPractices #FinanceTools #FinancialModelersCorner
Build a flexible financial model timeline with dynamic arrays.One Excel shortcut is all you need.The best technology is the right technology.Stop chasing AI tools. Build workflows.Speed means nothing without certainty.The future belongs to AI orchestrators.Stop presenting every piece of data.Skills transfer further than titles.Humans define the AI advantage.Great demos often create bad decisions.1   Less than 2% of AI built models get fundedAI can build its own rules.
The FP&A Guy |

Build a flexible financial model timeline with dynamic arrays.

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER