Question: Please find the following using data from the following table: Measures of location Measures of variability Mean-absolute deviation (MAD) - MA, ES Exponential smoothing forecast

Please find the following using data from the following table:

  • Measures of location
  • Measures of variability
  • Mean-absolute deviation (MAD) - MA, ES
  • Exponential smoothing forecast - at least 3 different alphas
  • Linear regression forecast

Prediction Absolute At-1+(1-)Ft-1 Prediction Absolute

Quarter FCF Revenues MA-3 Error Value Alpha =0.2 Error Value

3/31/2011 $138,473.34 $718,553.00

6/30/2011 $111,259.84 $788,610.00

9/30/2011 $213,220.00 $821,839.00

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

3/31/2012 $14,340.00 $869,791.00 $814,873.60

6/30/2012 $30,390.00 $889,163.00 $848,995.60

9/30/2012 $16,660.00 $905,089.00 $872,291.40

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

3/31/2013 -$24,370.00 $1,023,961.00 $926,648.60

6/30/2013 $1,490.00 $1,069,372.00 $966,564.80

9/30/2013 $25,350.00 $1,105,999.00 $1,009,932.00

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

3/31/2014 $23,030.00 $1,270,089.00 $1,128,930.20

6/30/2014 $59,180.00 $1,340,407.00 $1,192,219.40

9/30/2014 $71,000.00 $1,409,432.00 $1,260,231.40

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

3/31/2015 -$140,420.00 $1,573,129.00 $1,415,557.00

6/30/2015 -$349,300.00 $1,644,694.00 $1,490,478.00

9/30/2015 -$583,090.00 $1,738,355.00 $1,570,067.60

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

3/31/2016 -$237,020.00 $1,957,736.00 $1,747,449.40

6/30/2016 -$474,120.00 $2,105,204.00 $1,853,864.40

9/30/2016 -$963,430.00 $2,290,188.00 $1,982,963.20

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

3/31/2017 -$396,380.00 $2,636,635.00 $2,293,460.80

6/30/2017 -$996,140.00 $2,785,464.00 $2,459,006.40

9/30/2017 -$1,449,710.00 $2,984,859.00 $2,634,937.40

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

3/31/2018 -$273,390.00 $3,700,856.00 $3,078,713.80

6/30/2018 -$819,490.00 $3,907,270.00 $3,332,840.80

9/30/2018 -$1,549,230.00 $3,999,374.00 $3,575,622.80

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

3/31/2019 $3,948,585.25

6/30/2019 $4,031,161.67

9/30/2019 $4,093,107.50

12/31/2019 $1,868,447.22

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!