i am needing help with the charts.

Part One: The Excel file titled "Lone Star Analysis Sheets" contains financial information for 2021 and 2020. 1. Prepare a Comparative Balance Sheet with vertical analysis (required columns added). Tab 1 2. Prepare a Comparative Income Statement with horizontal analysis (required columns added). Tab 2 3. Based on the financial information given: calculate the following 2021 ratios for the company (formulas are shown, but you are to show calculations and answers) Tab 3. To aid in your analysis the Smart Phone covers industry ratios are provided as a comparison resource. Depending on the Case (A,B or C) assume the industry ratios below. Industry Ratio ABC a. Current Ratio 3.40 b. Quick ratio 2.60 c. Accounts Receivable Turnover 7.90 d. Inventory Tumover 14.00 e. Number of Days Sales in Inventory 26.00 f. Debt to Equity Ratio. 72 g. Rate earned on Total Assets 42.30% h. Rate earned on Stockholders' Equity 62.40% Q. Earnings Per Share (add'l shares sold on Jan1, 2021) \$2.08 j. Profit Margin Ratio 24.00% 4. Calculate the expected 2022 Income from operations break-even point and for a target profit of $600,000 (Galculate units and dollars of sales) Tab 3. Round to the nearest unit and dollar. For purposes of calculating the break-even point and target profit use the information below: (only use your Case info) ABC Unit Sales Price $32.00 Unit Variable Cost $20.80 Fixed Cost - use $130,000 for all Lone Star Smart Phone Covers, Inc. Comparative Balance Sheet December 31, 2021 and 2020 A B C Lone Star Smart Phone Covers, Inc