projection

I know there's a way but I'm drawing a blank on best approach and method. I have one rolling year of data so say July 2019 to June 2020. However, on the report I'm only showing year to date so January to June. What I'd like to be able to do is from July to December provide a projection based on...

Hi Everyone, I'm working on a cashflow projection and for that I need to determine a realistic date for collections. I have a list of invoices issued to customers, each with corresponding due date. However, many customers disregard the due date and pay according to their established payment...

I have search previous threads and have tried different coding to delete the entire row of data if the value in column M (12) is zero to no avail. Getting very frustrated as this should be pretty simple coding. I must have a syntax error somewhere as it will only delete one row at a time when...

Hi Everyone, I am working on an excel project for my business analysts diploma. I have a worksheet detailing student enrollments and finaces for a number of different colleges, I have historical data for 2015 - 2017 and forecasted data for 2018 - 2020, this shows my forecast based on the...

Hi everyone, I have recently been asked to make changes to a sales forecast. I've never done a task like this before but I would like to make a 5 year sales projection based on historical data from 2010-2016. Every company deals with different items, and so, it becomes difficult to follow...

Good morning everyone, I was hoping to get some input/ideas for a project I am working on to run projections/forecasting for a bunch of medical doctors projecting billing. So I have a bunch of data collaborated together for each medical provider; such as their calendar, number of patients...

Just purchased a new car whose credit agreement is based around monthly miles use. The agreement is over 4 years, with a penalty for over mileage use. Bit stuck as to were to begin other than entering a monthly mileage use. Any ideas excel 365? Trevor

I'm looking to get a formula for end of day projection for order lines based on historical percentages for each of our hourly order pulls. Below is an example: 6am pull - 100 lines (historically 50% of daily volume) 7am pull - 50 lines (historically 25% of daily volume) 8am pull - ...

Hello, and thank you in advance for your help. I'm attempting to actualize invoice data per month (easy part), and then re-forecast the target revenue for the remaining months (I hate this with a fire of a thousand suns). I'm currently able to forecast for the entire advertising campaign based...

I have four years of monthly sales numbers. and 9 months of this years sales. I want to project the remaining months of sales. right now i am using a combo of linest and intercept to project each remaining month, LINEST($C56:K56,$C53:K53)*L53+INTERCEPT($C56:K56,$C53:K53) meaning...

Hi, Is there a quick way or is there a formula to get P on this equation: (P - D) / (P + D + S) = .72

I am trying to graph the actual GDP over the last 30 years, in Canada, versus the Government's 5 year projections. I found a similar graph on the NYtimes website. Their graph is interactive and I need only a static graph. They refer to it as a 'porcupine chart'. You can see it here: Budget...