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
Dates and Timelines in Excel
147
4
In this post we will look at: a) Extending or shortening time schedules b) Modelling interest expense c) Planning orders,…
Charts and Dashboards in Excel (full version)
252
0
The attached file: - defines key chart elements and explains how to edit them - demonstrates how to deal with…
Charts and Dashboards in Excel (short version)
260
28
This is an introductory part to creating professional charts which:   - defines key chart elements and explains how to…
Analysing sensitivities with indifference curves (unlocked)
241
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
246
27
Indifference curves depict sensitivity of an output to the two inputs. Each curve corresponds to a fixed output amount and…
Variance Analysis & Portfolio Statistics
575
1
The attached template provides the basis for product portfolio analysis. The template performs the following types of analysis: - key…
See All