ACC1AIS-Homework Exercises - Week 10 Excel Exercise 1- Prepare vertical analysis This exercise is required to be done in MS Excel environment. No manual/paper calculation is accepted. Operating data for Beach Ltd is presented here: 2019 2020 Sales $870,000 $900,000 Cost of sales $460,000 $520,000 Selling expenses $93,000 $140,000 Administrative expenses $61,000 $65,000 Income tax expense $76,800 Profit $179,200 $52,500 $122,500 Required 1. Transfer the above data to an MS Excel worksheet. 2. Within the MS Excel worksheet prepare a schedule to indicate a vertical analysis for 2019 and 2020. The base amount for performing vertical analysis is the sales amount. 3. In your worksheet draw graphs for 2019 and 2020 to show how expenses are distributed in 2019 and 2020.