Last version published: 25/06/2019 06:43
Publication number: ELQ-11221-2
View all versions & Certificate
Dates and Timelines in Excel Financial Models
The tool shows how to work with dates & timelines in financial modelling.
Andrei Okhlopkov offers you this business tool 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.
People using this tool also downloaded
Sensitivity Analysis Excel Model - using Data Tables (full version)This is an extended version of my 'Analysing sensitivities with data tables' file with significant enhancements118$15.00 by Andrei Okhlopkov
Sensitivity analysis Excel Model with indifference curves (unlocked)An Excel utility (unlocked) to draw indifference curves for two inputs in a financial model28$10.00 by Andrei Okhlopkov
Variance Analysis & Portfolio Statistics Calculation Excel TemplateA template to analyse variances between two scenarios (e.g. budget vs. actual) and calculate key portfolio statistics291$12.00 by Andrei Okhlopkov
Sensitivity Analysis Excel Model - using Data Tables (short version)The model explains how to show models outputs under different scenarios simultaneously.475
Monte Carlo Analysis (without macros) Excel ModelThis post explains how to run full Monte Carlo in Excel without macros253
How to change model scenarios or inputs from any worksheetThe attached techniques show how to change inputs and scenarios from any sheet of the financial model without macros.181
Guiding principles of Financial ModellingThe file explains the general principles of building financial models and will give a few practical examples.111
Sensitivity analysis Excel Model with indifference curvesAn Excel utility to draw indifference curves for two inputs in a financial model104
Analysing data in ExcelA set of techniques for working with data in Excel62
Descriptive statistics for grouped (weighted) dataCalculating key statistics measures (average, median, standard deviation, skewness etc.) for grouped or weighted data30
How to create a macro state (on/off) indicatorExplains how to add an indicator to Excel VBA files showing whether the file was opened with macros enabled or disabled.31
Any questions on Dates And Timelines In Excel Financial Models?
The user community and author are here to help. Go ahead!