Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Quarter Sep-13 $ Free Cash Flow (millions USD) 764.93506 YouTube Maps > Apple Bing G Google >>> All Bookmark: Dec-13 $ Mar-14 $ 54.86543
Quarter Sep-13 $ Free Cash Flow (millions USD) 764.93506 YouTube Maps > Apple Bing G Google >>> All Bookmark: Dec-13 $ Mar-14 $ 54.86543 135.20409 Jun-14 $ Sep-14 $ (17.26755) 15.01502 Details Dec-14 $ 42.51337 Mar-15 $ 29.93492 Jun-15 $ 52.63762 Sep-15 $ 84.33421 Dec-15 $ 100.28143 2 Mar-16 $ Jun-16 $ Sep-16 $ 54.50751 65.51465 75.77904 5 Dec-16 $ 137.98595 6 Mar-17 $ 104.59211 7 Jun-17 $ 77.75761 8 Sep-17 $ 76.14827 9 Dec-17 $ 6.43574 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. 0 Mar-18 $ 33.29813 1 Jun-18 $ (27.52809) 2 Sep-18 $ (4.94053) 23 Dec-18 $ (38.66494) 24 Mar-19 $ (13.07449) 25 Jun-19 $ 56.02537 26 Sep-19 $ 8.25313 Attachments Facebook Cash Flow.xlsx 27 Dec-19 $ 138.07657 28 Mar-20 $ 29 Jun-20 $ 69.62170 (85.95303) 30 Sep-20 $ 36.47477
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started