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.

Current Ratio 4.50

Quick Ratio 3.50

Accts Receivable Turnover 12.50

Inventory Turnover 8.20

Number of Days Sales in Inventory 39.00

Debit Equity Ratio .25

Rate earned on Total Assets 56.00%

Rate earned on Stockholders's Equity 48.60%

Earnings Per share (Add shared sold on Jan 1, 2021) $1.53

Profit Margin Ratio 21.50%

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)

Unit Sales Price $20.00

Unit Variable Cost $13.00

Fixed Cost - use $130,000 for all