Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
★★★★★
3.59 Rating (160 Votes )
There are 3 Steps involved in it
Step: 1
Model Summary Rsquared 0827 Adjusted Rsquared 8812 Standard error of the estimate 28911 Fstatistic 4...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