All articles with 'Forecast' Tag

Recently in the Chandoo.org Forums, MR06 asked the question, “I am trying to create a sensitivity table that tells me what amount of equity I need to include in a deal in order to get a fixed IRR as the year 3 sales price changes.” MR06 was using Goal Seek to change the equity input […]
Continue »CP036: How to do trend analysis using Excel?

Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 36th session of Chandoo.org podcast, Let’s follow the trend.
What is in this session?
In this podcast,
- A quick trip to down under
- What is trend analysis
- 4 types of common trends
- linear
- curve
- cyclical
- strange
- Doing trend analysis in Excel – the process
- How to use trend analysis results
- Conclusions

Today, Formula Forensics examines 3 techniques to determine an interpolated value along a curve.
Continue »
Does your data hold hidden secrets?
In Part 2 of Are You Trendy? we will examine the Excel functions that assist us in Trend Analysis.