ACCOUNTING-Open Financial Accounting Raw Data and save it as Financial Accounting

Financial AccountingCleanse/Prepare the dataOpen Financial Accounting Raw Data and save it as Financial Accounting Trend Analysis your name completed.Review and interpret the data. Resize and/or format the data as you desire.AnalysisChart the Revenue over three years. What conclusions can you draw from this chart? Document your conclusion on the chart.Chart the Operating Income over three years. What conclusions can you draw from this chart? Document your conclusion on the chart.Chart the Operating Cash Flow over three years. What conclusions can you draw from this chart? Document your conclusion on the chart.Create a new sheet called Asset Turnover. Calculate Asset turnover for all companies for each of the three years. Modify your formula to display 0 if assets are 0. Use conditional formatting on this range to identify asset turnover of 0.Create a chart that shows all companies with three years of Asset turnovers. What conclusions can you draw from this chart? Document your conclusion on the sheet next to the chart.Create three more charts that show each year separately. What conclusions can you draw from this chart? Document your conclusion on the sheet next to each chart.Create a new sheet called ROA.Calculate ROA for all companies for each of the three years. Use all formulas with range names.Modify your formula to display 0 if assets are 0. Use conditional formatting on this range to identify asset turnover of 0.Create a chart that shows all companies with three years of ROA. You will notice that if there is a huge range in these numbers the chart is difficult to read. Delete the chart. Make a copy of your ROA calculations and then modify the formulas to display 0% if it is <-25%. Apply a conditional format to the range and make a legend to document the formatting. Use a function to determine the highest and lowest values in the range. Now change the minimum and maximum on the vertical (value) axis to improve readability of the chart. What conclusions can you draw from this chart? Document your conclusion on the sheet next to the chart.Create three more charts that show each year separately. Use functions to determine the highest and lowest values in each range. Change the minimum and maximum on the vertical (value) axis to improve readability of the charts. What conclusions can you draw from the charts? Document your conclusion on the sheet next to each chart.Create a new sheet called Profit Margin.Calculate Profit Margin for all companies for each of the three years.Modify your formula to display 0 if revenue is 0. Use conditional formatting on this range to identify profit margin of 0.Create a chart that shows all companies with three years of profit margin. You will notice that if there is a huge range in these numbers the chart is difficult to read. Delete the chart. Make a copy of your calculations and then modify the formulas to display 0% if it is <-25%. Apply a conditional format to the range and make a legend to document the formatting. Create a chart that shows all companies with three years of profit margin.Use a function to determine the highest and lowest values in the range. Now change the minimum and maximum on the vertical (value) axis to improve readability of the chart. What conclusions can you draw from this chart? Document your conclusion on the sheet next to the chart.Create three more charts that show each year separately. Use functions to determine the highest and lowest values in each range. Change the minimum and maximum on the vertical (value) axis to improve readability of the charts. What conclusions can you draw from the charts? Document your conclusion on the sheet next to each chart.Cleanse/Preparethe data1. OpenFinancial Accounting Raw Data andsave it as Financial Accounting TrendAnalysis your name completed.2. Reviewand interpret the data. Resize and/or format the data as you desire.Analysis1. Chart the Revenue over three years. Whatconclusions can you draw from this chart? Document your conclusion on thechart.2. Chart the Operating Income over three years.What conclusions can you draw from this chart? Document your conclusion on thechart.3. Chart the Operating Cash Flow over three years.What conclusions can you draw from this chart? Document your conclusion on thechart.4. Create a new sheet called Asset Turnover.a. Calculate Asset turnover for all companies foreach of the three years.b. Modify your formula to display 0 if assets are0. Use conditional formatting on this range to identify asset turnover of 0.c. Create a chart that shows all companies withthree years of Asset turnovers. What conclusions can you draw from this chart?Document your conclusion on the sheet next to the chart.d. Create three more charts that show each yearseparately. What conclusions can you draw from this chart? Document yourconclusion on the sheet next to each chart.5. Create a new sheet called ROA.a. Calculate ROA for all companies for each of thethree years. Use all formulas with range names.b. Modify your formula to display 0 if assets are 0.Use conditional formatting on this range to identify asset turnover of 0.c. Create a chart that shows all companies withthree years of ROA. You will notice that if there is a huge range in thesenumbers the chart is difficult to read. Delete the chart. Make a copy of yourROA calculations and then modify the formulas to display 0% if it is<-25%. Apply a conditional format tothe range and make a legend to document the formatting.d. Use a function to determine the highest andlowest values in the range. Now change the minimum and maximum on the vertical(value) axis to improve readability of the chart.e. What conclusions can you draw from this chart?Document your conclusion on the sheet next to the chart.f. Create three more charts that show each yearseparately. Use functions to determine the highest and lowest values in eachrange. Change the minimum and maximum on the vertical (value) axis to improvereadability of the charts. What conclusions can you draw from the charts?Document your conclusion on the sheet next to each chart.6. Create a new sheet called Profit Margin.a. Calculate Profit Margin for all companies foreach of the three years.b. Modify your formula to display 0 if revenue is0. Use conditional formatting on this range to identify profit margin of 0.c. Create a chart that shows all companies withthree years of profit margin. You will notice that if there is a huge range inthese numbers the chart is difficult to read. Delete the chart. Make a copy ofyour calculations and then modify the formulas to display 0% if it is<-25%. Apply a conditional format tothe range and make a legend to document the formatting.d. Create a chart that shows all companies withthree years of profit margin.e. Use a function to determine the highest andlowest values in the range. Now change the minimum and maximum on the vertical(value) axis to improve readability of the chart.f. What conclusions can you draw from this chart?Document your conclusion on the sheet next to the chart.g. Create three more charts that show each yearseparately. Use functions to determine the highest and lowest values in eachrange. Change the minimum and maximum on the vertical (value) axis to improvereadability of the charts. What conclusions can you draw from the charts?Document your conclusion on the sheet next to each chart.