Each student will select a publicly traded company $($or a private company that you

work for if you have data and are authorized to use it$)$ and develop an accurate

forecast of the company$$s Free Cash Flow. You will be using $30$ observations

for estimation. Students must submit their forecast and the spreadsheet file of all

calculations. The report must include an introduction of the company chosen and

an explanation of which method provides the best forecast and why for your data.

Note: make sure that you order your data from the oldest to the most recent

observation $($sorted in time$).$

$$ Collect $34$ historical observations $($yearly$/$quarterly$)$ for Sales $($Revenues$)$

and Free Cash Flows and use the first $30$ observations to calculate the

following:

$$ Measures of location: mean, median, mode

$$ Measures of variability $$ range, sample variance, sample standard deviation,

standard error

$$ Moving average forecast $$ both $3$ and $4$

$$ Exponential smoothing forecast $$ at least $3$ different alphas $(0\mathrm{.}6$; $0\mathrm{.}8$; $0\mathrm{.}9)$

$$ Mean$-$absolute deviation $($MAD$)$ MA$,$ ES

$$ Linear regression forecast $($using $30$ observations$)$

$$ Selection $($and justification$)$ of $$best$$ forecast