In this video, the instructor discusses using Excel to forecast employee behavior and financial performance.
- [Narrator] We've got an emergency.…Jack has just discovered some suspicious cash shortages…at a company outlet store.…He was in the process of beginning his sales forecasting…when he discovered we've got some missing cash.…In fact, theft and cash handling are major issues…at many firms, so Jack is not alone here.…But, the key question he's coming up with is…could an employee be stealing from the firm?…Let's find out.…I'm in the 03_02 folder in the file labeled…Begin_EmployeeTheft.…
What we've done is gone through and gathered data…that Jack put together for us that covers various…cash shortages that have occurred over the last year.…And, in fact, Jack has found 41 days over the last year…where there was either a cash shortage or a cash overage.…There are eight different employees and three different…managers who work in this particular outlet store.…What we need to figure out is…are one or more of these people stealing from the company?…Even if we don't think they're stealing,…perhaps it's just careless cash handling,…
Join Professor Michael McDonald and discover how to use predictive analytics to forecast key performance indicators of interest, such as quarterly sales, projected cash flow, or even optimized product pricing. All you need is Microsoft Excel. Michael uses the built-in formulas, functions, and calculations to perform regression analysis, calculate confidence intervals, and stress test your results. You'll walk away from the course able to immediately begin creating forecasts for your own business needs.
- Understanding big data and predictive analytics
- Gathering financial data
- Cleaning up your data
- Calculating key financial metrics
- Using regression analysis for business-specific forecasts
- Performing scenario analysis
- Calculating confidence intervals
- Stress testing