This assignment must be put on an excel sheet. please have the formulas (numbers you used) in excel rather than just the answer. In other words, I want to see HOW you calculated the extra credit answers, so show your work in excel

background in accounting and has quite a bit of experience in budgetary procedures. Nora's first task is to undertake a complete analysis of the firm's financial condition, including strengths and weaknesses, in order to develop sound financial plans for additional future expansion. 1. Using the financial statements and industry standard ratios below, develop a complete time series (where we compare the companies 2020&2022 results to each other and sec if things were better or worse, labeled - Good, OK, or Poor) land cross-sectional analysis (where we compare our company to standard industry ratios) of Churchill Company's financial condition including strengths and weaknesses of Churchill Company. Again, time series is where a company compares the company to its self over time. Cross-sectional is where we compare the company to the industry (standard industry ratios). 2. Prepare common size income statements for 2020 and 2021 and address changes and concerns. A common size income statement is where we take each line item and divide it by the sales. When we do this, we state each line item in a pereentage, which represents pereentage of sales. Sales then will always be 100%. Once we have done this we can compare apples to apples so to speak. 3. Nora also believes the DuPont method of analysis (to calculate ROE or return on equity) is also a good way to see how the company is generating returns to its owner. Prepare a DuPont analysis for both Churchill Company and the industry and discuss Churchill Company s performance as compared to its industry. The formula to calculate return on equity using the DuPont method is: NPM TAT FLM =ROE 4. After analyzing the data, what conclusions and recommendations would Nora be justified in making her report to Greg? What areas of Churchill Company's operations are in greatest need of immediate attention? Prepare a planned course of action for the solution of the firm's most pressing problems. Churchill Company, Inc. Comparative Balance Sheets background in accounting and has quite a bit of experience in budgetary procedures. Nora's first task is to undertake a complete analysis of the firm's financial condition, including strengths and weaknesses, in order to develop sound financial plans for additional future expansion. 1. Using the financial statements and industry standard ratios below, develop a complete time series (where we compare the companies 2020&2022 results to each other and sec if things were better or worse, labeled - Good, OK, or Poor) land cross-sectional analysis (where we compare our company to standard industry ratios) of Churchill Company's financial condition including strengths and weaknesses of Churchill Company. Again, time series is where a company compares the company to its self over time. Cross-sectional is where we compare the company to the industry (standard industry ratios). 2. Prepare common size income statements for 2020 and 2021 and address changes and concerns. A common size income statement is where we take each line item and divide it by the sales. When we do this, we state each line item in a pereentage, which represents pereentage of sales. Sales then will always be 100%. Once we have done this we can compare apples to apples so to speak. 3. Nora also believes the DuPont method of analysis (to calculate ROE or return on equity) is also a good way to see how the company is generating returns to its owner. Prepare a DuPont analysis for both Churchill Company and the industry and discuss Churchill Company s performance as compared to its industry. The formula to calculate return on equity using the DuPont method is: NPM TAT FLM =ROE 4. After analyzing the data, what conclusions and recommendations would Nora be justified in making her report to Greg? What areas of Churchill Company's operations are in greatest need of immediate attention? Prepare a planned course of action for the solution of the firm's most pressing problems. Churchill Company, Inc. Comparative Balance Sheets