I am working on running a model for the retail industry. I'm trying to determine the number of jobs a project is going to create of the next five years. I'm using industry average sales figures for the first year of stabilization and then adding a 3% increase in sales for each additional year. When I change the Event Year for 2012, this increases the jobs by 3, but when I change the Event Year for 2013 the jobs increase by 151 jobs for the 3% increase and same with 2014. Can you please let me know why there is such a drastic change for these event years and how I can get a more accurate number?
Please sign in to leave a comment.