Please use numbers for C

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. 4. Calculate the expected 2022 Income from operations break-even point and for a target profit of $600,000 (calculate 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) RATIO ANALYSIS Required Calculation Formula (from our Text) Calculation Area Answer Current Ratio Total Current Assets Total Current Liabilities Quick Ratio Cash + Short Term Investments +A/R, Net Total Current Liabilities Accounts Rec. Turnover Net Sales Average Accounts Receivable Inventory Turnover Cost of Goods Sold Average Inventory Number Days Sales in Inv. Average Inventory Average Daily Cost of Goods Sold Debt to Equity Ratio Total Liabilities Total Equity Rate of Return Total Assets Net Income + Interest Expense Average Total Assets Rate Earned on C. S. Equity Net Income - Preferred Dividends Average Common Stockholders' Equity Earnings per Share Net Income - Preferred Dividends *Weighted Average Number of Shares Out. * Beg year number shares + End year number shares /2 = weighted Profit Margin Ratio Net Income Net Sales BREAK EVEN AND TARGE. Break Even Point in Units Fixed Cost Unit Contribution Margin Break Even Point in Sales Fixed Cost Contribution Margin Ratio Target Profit in Units Fixed Cost + Target Profit Unit Contribution Margin Target Profit in Sales Fixed Cost + Target Profit Contribution Margin Ratio