Please forecast the next 30 entries of the potential earnings of Netflix. Calculate the missingvalues for the FCF. That will be the number you use in your formulas(when called for) instead of NCF.

Then calculate all of these stats(most should be functions within excel):

Measures of location

Measures of variability

Mean-absolute deviation (MAD) - MA, ES

Then those data points can/will be used to do the forecasting methods:

Moving average forecast - both 3 and 4

Exponential smoothing forecast - at least 3 different alphas Linear regression forecast

Then determine which forecasting method you find most likely to be accurate

Date FCF Revenues

3/31/2011 $718,553.00

6/30/2011 $788,610.00

9/30/2011 $821,839.00

12/31/2011 $186,550.00 $875,575.00

3/31/2012 $869,791.00

6/30/2012 $889,163.00

9/30/2012 $905,089.00

12/31/2012 -$58,151.00 $945,239.00

3/31/2013 $1,023,961.00

6/30/2013 $1,069,372.00

9/30/2013 $1,105,999.00

12/31/2013 -$16,300.00 $1,175,230.00

3/31/2014 $1,270,089.00

6/30/2014 $1,340,407.00

9/30/2014 $1,409,432.00

12/31/2014 -$126,699.00 $1,484,728.00

3/31/2015 $1,573,129.00

6/30/2015 $1,644,694.00

9/30/2015 $1,738,355.00

12/31/2015 -$920,557.00 $1,823,333.00

3/31/2016 $1,957,736.00

6/30/2016 $2,105,204.00

9/30/2016 $2,290,188.00

12/31/2016 -$1,473,984.00 $2,477,541.00

3/31/2017 $2,636,635.00

6/30/2017 $2,785,464.00

9/30/2017 $2,984,859.00

12/31/2017 -$1,785,948.00 $3,285,755.00

3/31/2018 $3,700,856.00

6/30/2018 $3,907,270.00

9/30/2018 $3,999,374.00

12/31/2018 $2,680,479.00 $4,186,841.00

3/31/2019

6/30/2019

9/30/2019

12/31/2019

3/31/2020

6/30/2020

9/30/2020

12/31/2020

3/31/2021

6/30/2021

9/30/2021

12/31/2021

3/31/2022

6/30/2022

9/30/2022

12/31/2022

3/31/2023

6/30/2023

9/30/2023

12/31/2023

3/31/2024

6/30/2024

9/30/2024

12/31/2024

3/31/2025

6/30/2025

9/30/2025

12/31/2025

3/31/2026

6/30/2026

9/30/2026

12/31/2026