1. Using Minitab or equivalent software, fit an ARIMA(0,1, 0)(0,1,1)12 model to the data in Table 9-22....

Question:

1. Using Minitab or equivalent software, fit an ARIMA(0,1, 0)(0,1,1)12 model to the data in Table 9-22. Do you think a constant term is required in the model? Explain.

2. Is the model suggested in Question 1 adequate? Discuss with reference to residual plots, residual autocorrelations, and the Ljung-Box chi-square statistics. If the model is not adequate, modify and refit the initial model until you feel you have achieved a satisfactory model.
3. Using the model you have developed in Question 2, generate forecasts for the funding requirements for the next 12 months.
The Air Finance Division is one of several divisions within United Parcel Service Financial Corporation, a wholly owned subsidiary of United Parcel Service (UPS). The Air Finance Division has the responsibility of providing financial services to the company as a whole with respect to all jet aircraft acquisitions. In addition, this division provides financing to independent outside entities for aviation purchases as a separate and distinct operation. Historically, the non-UPS financing segment of the Air Finance Division has provided a higher rate of return and greater fee income than the UPS segment; however, it is more costly to pursue.