Overview

In this publication I will explain:

 

- how to build trends and why commonly used CAGR rarely gives reliable future estimates

- how to analyze and forecast  seasonalities based on monthly, quarterly or weekly data

- how to measure historic volatilities and translate them into model scenarios with a desired level of confidence

- how to tie volatilities to a timeline, measure standard error and set up scenarios based on that data

Share
Reviews Add a review
No reviews yet

More From Andrei Okhlopkov

Browse our top rated business templates. See All
Analysing sensitivities with indifference curves (unlocked)
70
0
This is an unlocked version of the same utility published on my page. In this version you can access and…
Analysing sensitivities with indifference curves
72
7
Indifference curves depict sensitivity of an output to the two inputs. Each curve corresponds to a fixed output amount and…
Variance Analysis & Portfolio Statistics
422
1
The attached template provides the basis for product portfolio analysis. The template performs the following types of analysis: - key…
financial model templates dashboard Dates and Timelines in Financial Modelling
225
30
Financial models use dates extensively. We will look at:   a) Extending or shortening time schedules b) Modelling interest expense c)…
financial model templates dashboard How to change scenarios or inputs from any worksheet
369
53
A typical model consists of several worksheets - Inputs, Revenues, Opex, Capex etc. Imagine as well your model has three…
financial model templates dashboard Monte Carlo analysis without macros
387
51
The Monte Carlo method tests a large number (several hundreds or thousands) of "scenarios" in which the inputs are random…