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 […]

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.

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.