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
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










