Last version published: 15/12/2019 17:08
Publication number: ELQ-11221-5
View all versions & Certificate
Dates and Timelines in Excel Financial Models
Financial models use dates and timelines very extensively, so it is important to become familiar with relevant functions
Andrei Okhlopkov offers you this Best Practice for free!
download for free
Add to bookmarks
This tool adds flexibility in modelling date and timeline assumptions
Financial models which deal with time schedules, periods, intervals etc.
4.5 / 5 (32 votes)
Write a review
People using this Best Practice also downloaded
Unlocking Full Potential of Excel Data Tables (Part 2)This is a sequel to my 'Unlocking Full Potential of Excel Data Tables (Part 1)' publication999add_shopping_cart
Horizontal Waterfall ChartA smart and efficient chart with detailed step-by-step instructions71add_shopping_cart$7.00by Andrei Okhlopkov
Profit Distribution and Carried Interest WaterfallA template illustrating various setups of profit distribution between the JV partners with a carried interest waterfall541add_shopping_cart$30.00by Andrei Okhlopkov
Price-Volume-Mix AnalysisTools and methods to calculate and depict price-volume-mix effects and other variances475add_shopping_cart$45.00by Andrei Okhlopkov
Cap Table with Investor Returns and ChartsCap table with 5 investment rounds for up to 10 investors106add_shopping_cart
Analyzing Sales and Product PerformanceTools to analyse sales, portfolio performance, seasonal variations, price-volume-mix factors964add_shopping_cart$19.00by Andrei Okhlopkov
Controlling Outlook from Excel (full version)Explains how to programmatically link Excel to Outlook171add_shopping_cart
Interim Budgeting (Reforecasting)Tools to depict the mid-year status, estimate if the outlook looks reasonable and assess the accuracy of past forecasts253add_shopping_cart
Inventory Analysis and ManagementInventory balance movements, days inventory outstanding (DIO), turnover, seasonality, aging analysis, planning orders216add_shopping_cart
A Chart Showing Three Dimensions of DataA professionally-designed chart which can show data in three measurements34add_shopping_cart$5.00by Andrei Okhlopkov
Charts and Dashboards in Excel (full version)Explains the basics of designing professional charts in Excel with practical examples (full version)285add_shopping_cart
VBA Interface Collection (full version)A set of Excel VBA macros aimed at enhancing user interface193add_shopping_cart
Any questions on Dates And Timelines In Excel Financial Models?
The user community and author are here to help. Go ahead!