Example . a) What is the trend like for the property value? . b) Conduct a 3-period MA and forecast the PV for the next 2 years. Should you use this model to forecast PV for the next 4 years? Why/Why not? . c) Construct a linear trend model and write the linear trend equation for this model. d) Forecast the PV for the next 3 years according to part c). . e) When do you expect the PV to be equal to $1.5 million? . f) What do you expect the PV to be in 2041? g) Do the forecasts look encouraging for an investment opportunity? Why/why not? Refer to Excel for solution. Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Property Value ($ '000s) 500 520 550 550 600 700 750 850 900 890 1000 30