projection

  1. Y

    Forecasting using past and current year

    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...
  2. D

    Calculate collection date for different customers based on established payment behaviours

    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...
  3. S

    VBA to Delete rows with Zero values Loop

    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...
  4. C

    Forecasting - changing data for creating different forecasts

    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...
  5. J

    Assistance needed with 5 year sales projection for manufacturing company

    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...
  6. P

    Help With Creating a Projection/Forecasting Workbook

    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...
  7. C

    Calculating a mileage forecast

    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
  8. M

    Daily projection based on historical percentages

    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 - ...
  9. T

    Forecast Revenue Data After Invoice Month

    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...
  10. M

    forecasting remaining months of seasonal sales - with four years of history

    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...
  11. E

    Forecasting

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

    Actual GDP vs. Projected Budgets

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top