Question

Amazon Quarterly Revenue (Millions of US $)
2020-03-31	$75,452
2019-12-31	$87,437
2019-09-30	$69,981
2019-06-30	$63,404
2019-03-31	$59,700
2018-12-31	$72,383
2018-09-30	$56,576
2018-06-30	$52,886
2018-03-31	$51,042
2017-12-31	$60,453
2017-09-30	$43,744
2017-06-30	$37,955
2017-03-31	$35,714
2016-12-31	$43,741
2016-09-30	$32,714
2016-06-30	$30,404
2016-03-31	$29,128
2015-12-31	$35,746
2015-09-30	$25,358
2015-06-30	$23,185
2015-03-31	$22,717

Use actual sales (revenue) data from previous 4 years to estimate sales using the linear trend function. Please show work in excel!!

Answer 1

the following are the excel work for predicting the future sales.

we can use the above formula to predict future sales. and we can also insert chart using insert option-chart-right click on chart- add trend line. excel default add lenear trend line and we can change according to the need.

the following are the sales forcasted for the future

6/30/2020	$      79,876
9/30/2020	$      80,215
12/31/2020	$      79,876
3/31/2021	$      79,057
6/30/2021	$      78,300
9/30/2021	$      76,846
12/31/2021	$      75,244
3/31/2022	$      73,698
6/30/2022	$      72,337
9/30/2022	$      71,319
12/31/2022	$      70,826
3/31/2023	$      70,803
6/30/2023	$      70,482
9/30/2023	$      71,192
12/31/2023	$      72,419