Use the following cash flow data to estimate cash forecast using various techniques. Net Cash Flow...

 

Transcribed Image Text:

Use the following cash flow data to estimate cash forecast using various techniques. Net Cash Flow Period Net Cash Flow 722 16 725 Period 1 2 3 4 S 6 7 8 9 10 11 12 13 14 15 355 314 709 800 350 744 541 834 938 586 840 433 476 525 PASSEI~ZAHS28 17 18 19 20 21 22 23 24 25 26 27 29 30 521 174 737 833 365 807 788 304 350 793 665 1090 678 485 a. Compare a 3-day moving average forecast to a 5-day moving average forecast. Which is better? (Hint: Period 4 will be the first possible forecast for the 3-day and period 6 will be the first possible for the 5- day) b. Graph a scatter plot of the data. Does it appear to have a linear relation? c. Use regression analysis to develop the linear trend equation. Statistically speaking, would this be a good forecast equation? Why or why not? (Output the regression results to a separate tab in the current file) c. "Back" Test the equation from part c. by using to estimating forecast for periods 1-30. Is it better than either of the methods in part a. e. Produce the Descriptive Statistics for Net Cash Flow. Use the following cash flow data to estimate cash forecast using various techniques. Net Cash Flow Period Net Cash Flow 722 16 725 Period 1 2 3 4 S 6 7 8 9 10 11 12 13 14 15 355 314 709 800 350 744 541 834 938 586 840 433 476 525 PASSEI~ZAHS28 17 18 19 20 21 22 23 24 25 26 27 29 30 521 174 737 833 365 807 788 304 350 793 665 1090 678 485 a. Compare a 3-day moving average forecast to a 5-day moving average forecast. Which is better? (Hint: Period 4 will be the first possible forecast for the 3-day and period 6 will be the first possible for the 5- day) b. Graph a scatter plot of the data. Does it appear to have a linear relation? c. Use regression analysis to develop the linear trend equation. Statistically speaking, would this be a good forecast equation? Why or why not? (Output the regression results to a separate tab in the current file) c. "Back" Test the equation from part c. by using to estimating forecast for periods 1-30. Is it better than either of the methods in part a. e. Produce the Descriptive Statistics for Net Cash Flow.

Answer rating: 100% (QA)

To analyze the cash flow data and perform the requested calculations well need to use a spreadsheet software like Microsoft Excel or Google Sheets Her... View the full answer