Answered step by step
Verified Expert Solution
Link Copied!

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

student submitted image, transcription available below

student submitted image, transcription available below 

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Financial Statements

Authors: Lyn Fraser, Aileen Ormiston

11th edition

133874036, 978-0133874037

More Books

Students also viewed these Finance questions

Question

Why were JPCs discredited in the eyes of workers?

Answered: 1 week ago