Use this spreadsheet: Target.csv

1. Deflate the Sales numbers by relevant GDP deflator.

2. Fit Exponential smoothing, ARIMA and Prophet forecasts to the data uptill 2019.

3. Mention the fit indices for all three methods

4. Use the method with best fit indices to forecast the sale of four quarters of 2020.

Data Date	Company	Fiscal Data Year and Quarter	Rev
1/31/2013	TARGET CORP	2012Q4	22726
4/30/2013	TARGET CORP	2013Q1	16620
7/31/2013	TARGET CORP	2013Q2	16841
10/31/2013	TARGET CORP	2013Q3	16925
1/31/2014	TARGET CORP	2013Q4	20893
4/30/2014	TARGET CORP	2014Q1	16657
7/31/2014	TARGET CORP	2014Q2	16957
10/31/2014	TARGET CORP	2014Q3	17253
1/31/2015	TARGET CORP	2014Q4	21751
4/30/2015	TARGET CORP	2015Q1	17119
7/31/2015	TARGET CORP	2015Q2	17427
10/31/2015	TARGET CORP	2015Q3	17613
1/31/2016	TARGET CORP	2015Q4	21626
4/30/2016	TARGET CORP	2016Q1	16196
7/31/2016	TARGET CORP	2016Q2	16168
10/31/2016	TARGET CORP	2016Q3	16441
1/31/2017	TARGET CORP	2016Q4	20690
4/30/2017	TARGET CORP	2017Q1	16223
7/31/2017	TARGET CORP	2017Q2	16634
10/31/2017	TARGET CORP	2017Q3	16874
1/31/2018	TARGET CORP	2017Q4	22983
4/30/2018	TARGET CORP	2018Q1	16781
7/31/2018	TARGET CORP	2018Q2	17777
10/31/2018	TARGET CORP	2018Q3	17821
1/31/2019	TARGET CORP	2018Q4	22977
4/30/2019	TARGET CORP	2019Q1	17627
7/31/2019	TARGET CORP	2019Q2	18422
10/31/2019	TARGET CORP	2019Q3	18664
1/31/2020	TARGET CORP	2019Q4	23399
4/30/2020	TARGET CORP	2020Q1	19615
7/31/2020	TARGET CORP	2020Q2	22975
10/31/2020	TARGET CORP	2020Q3	22632
1/31/2021	TARGET CORP	2020Q4	28339
4/30/2021	TARGET CORP	2021Q1	24197
7/31/2021	TARGET CORP	2021Q2	25160
10/31/2021	TARGET CORP	2021Q3	25652
1/31/2022	TARGET CORP	2021Q4	30996
4/30/2022	TARGET CORP	2022Q1	25170