Project 1, Step 4: Instructions for This Excel Workbook

View the balance sheet and income statement for the client company, Largo Global Inc. (LGI), using this Excel workbook, which includes the following tabs:

1. Bal. Sheet & Inc. Statement

2. Ratio Analysis

3. Common-size Analysis

4. Cash Flow Analysis

You may submit this workbook as a milestone in Step 4, so you can receive feedback on the accuracy of your calculations before submitting your final project in Step 5 at the end of Week 2.

Open tab 1. You see the balance sheet and income statement for LGI for 202022. You also see estimated average income statement data for LGIs main competitors.

Use this information to complete the calculations in tabs 24.

Perform your calculations using the formula bar in the Excel workbook.

Open tab 2. You see six groups of financial ratios as well as an industry benchmark you can use for comparison with LGI's 202022 ratios.

Calculate the ratios for each year.

Open tab 3.

Complete a common-size analysis.

Open tab 4.

Complete a cash flow analysis.