Projection/Forecast Analysis

For one of my grad school classes I am working on a projection/forecast analysis. The data includes projected year-end balances. These balances are projected every month of the fiscal year (starting in July and ending in June) to see how much approximately is the Y-T-D amount going to be. I'd like to analyze the projected balances vs. the actual Y-T-D balance.

I'd like to find a way to estimate at which month we are comfortable at saying that this is approximately what the Y-T-D amount is going to be. How can I forecast most accurately what the Y-T-D balance is going to be? Any ideas on how to approach this? I'd like to use statistics such as confidence interval, normal distribution, forecasting, etc. I'd appreciate any help. Thank you!

P.S. I attached an example of this data.

Hi Irambouskova,

I think this is an issue about forecasting, not excel, hence, this is not the best place the search for an answer to this issue

Hi Mayda89,

Yea I know... I just wasn't sure where and who to ask this question. Any ideas?? Any help would be much appreciated. Thank you.

Well, I'm not an expert on this topic so, unfortunately nope