I'm trying to calculate my estimations for a firms next quarterly earnings (as based on historical evidence).

Can someone please recommend a time series model that can help me forecast this? I looked but I couldn't find any models for excel.

Question

I'm trying to calculate my estimations for a firms next quarterly earnings (as based on historical evidence).

Can someone please recommend a time series model that can help me forecast this?  I looked but I couldn't find any models for excel.

anonymous · Answer

you will have to go through some analysis before you can decide on a model. depends on the kind of data available, cyclical trends of the industry, statistical considerations and adjustments etc.

anonymous · Answer

Thanks for your answer, by any chance do you have access to a link (or if you know where) I can find the different models that are available for this (based off of the different inputs)?  I know Professor Damodaran has the spreadsheet section but I wasn't able to find what I was looking for.