The table below shows the total quarterly fee income for your bank in your count
ID: 2933432 • Letter: T
Question
The table below shows the total quarterly fee income for your bank in your country for the last three years.
($’000)
Q 1
Q 2
Q 3
Q 4
Year 2014
200
260
285
450
Year 2015
280
315
333
492
Year 2016
329
375
406
521
Calculate a four-quarter moving average to identify the trend of the fee income for the three year period. [5 Marks]
Calculate the seasonal factors and use these to seasonally adjust the original fee income data. What is the seasonal index for each quarter? [5 Marks]
Plot both the original fee income data and the seasonally adjusted data obtained in question (1.b) above. [3 Marks]
Comment on the findings of your analysis in a, b, and c above. [3 Marks]
Q 1
Q 2
Q 3
Q 4
Year 2014
200
260
285
450
Year 2015
280
315
333
492
Year 2016
329
375
406
521
Explanation / Answer
a)
Adjustment = Grand Average with opposite sign.
Weeks Income 4-Quartely Moving Total Moving total of pairs Moving Average year 2014 200 2 260 1195 3 285 2470 308.75 1275 4 450 2605 325.625 1330 Nov-01 280 2708 338.5 1378 2 315 2798 349.75 1420 3 333 2889 361.125 1469 4 492 2998 374.75 1529 year 2015 329 3131 391.375 1602 2 375 3233 404.125 1631 3 406 4 521Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.