30 V X fx A B C D E F G H Background Information: The following data has been recorded for the past 5 years within the business. As the newly appointed accountant to the business you have been asked to use this data to make some predictions about the future performance of the business. Year Revenue Year Expenses 2016 $ 141,226.96 2016 $ 58,899.96 2017 $ 156,918.84 2017 $ 81,058.77 2018 184,610.40 2018 $ 108,078.36 2019 $ 190,320. 2019 122,816.32 2020 S 158,600.00 2020 $ 139,564.00 Required: a) Create a scatter plot showing the Revenue of the business over the past 5 years. Ensure you format the scatter plot appropriately, displaying all relevant labels. b) Display a Trend Line and Equation on the scatter plot. c) Use the information from parts a) & b) to create a table with an Estimate (using an excel formula) of the Revenue for the next two years to be used in the business budget. (d) Complete steps a) to c) using the Expenses this time. e) Based on your answers to the above, calculate the business's profit over the past 5 years and the estimated profit over the next two years. ) Ensure you save your file using the naming conventions in the Unit Guide. Introduction and Intructions Sheet1 Sheet2 + elect destination and press ENTER or choose Paste