The attached file includes Facebook's quarterly cash flows September 2013 through September 2020. Your job is...

 

Transcribed Image Text:

The attached file includes Facebook's quarterly cash flows September 2013 through September 2020. Your job is to analyze the firm's free cash flow and build a forecasting model for Facebook's quarterly cash flow. Run a regression that is designed to predict the cash flow by quarter. Explain the regression output and use it to forecast cash flows for the next four quarters. Facebook Cash Flowe 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 7222222222 983 18 19 20 21 23 24 25 26 28 29 30 31 32 33 Quarter Sep-13 $ Dec-13 $ Mar-14 $ Jun-14 $ Sep-14 $ Dec-14 $ Mar-15 $ Jun-15 $ Sep-15 $ Dec-15 $ Free Cash Flow (millions USD) 764.93506 54.86543 135.20409 (17.26755) 15.01502 42.51337 Mar-16 $ Jun-16 $ Sep-16 $ Dec-16 $ Mar-17 $ Jun-17 $ Sep-17 $ Dec-17 $ Mar-18 $ Jun-18 $ Sep-18 $ Dec-18 $ Mar-19 $ Jun-19 $ Sep-19 $ Dec-19 $ Mar-20 $ Jun-20 $ Sep-20 $ 29.93492 52.63762 84.33421 100.28143 54.50751 65.51465 75.77904 137.98595 104.59211 77.75761 76.14827 6.43574 33.29813 (27.52809) (4.94053) (38.66494) (13.07449) 56.02537 8.25313 138.07657 69.62170 (85.95303) 36.47477 The attached file includes Facebook's quarterly cash flows September 2013 through September 2020. Your job is to analyze the firm's free cash flow and build a forecasting model for Facebook's quarterly cash flow. Run a regression that is designed to predict the cash flow by quarter. Explain the regression output and use it to forecast cash flows for the next four quarters. Facebook Cash Flowe 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 7222222222 983 18 19 20 21 23 24 25 26 28 29 30 31 32 33 Quarter Sep-13 $ Dec-13 $ Mar-14 $ Jun-14 $ Sep-14 $ Dec-14 $ Mar-15 $ Jun-15 $ Sep-15 $ Dec-15 $ Free Cash Flow (millions USD) 764.93506 54.86543 135.20409 (17.26755) 15.01502 42.51337 Mar-16 $ Jun-16 $ Sep-16 $ Dec-16 $ Mar-17 $ Jun-17 $ Sep-17 $ Dec-17 $ Mar-18 $ Jun-18 $ Sep-18 $ Dec-18 $ Mar-19 $ Jun-19 $ Sep-19 $ Dec-19 $ Mar-20 $ Jun-20 $ Sep-20 $ 29.93492 52.63762 84.33421 100.28143 54.50751 65.51465 75.77904 137.98595 104.59211 77.75761 76.14827 6.43574 33.29813 (27.52809) (4.94053) (38.66494) (13.07449) 56.02537 8.25313 138.07657 69.62170 (85.95303) 36.47477

Answer rating: 100% (QA)

Model Summary Rsquared 0827 Adjusted Rsquared 8812 Standard error of the estimate 28911 Fstatistic 4... View the full answer