Reference no: EM133083575
Project 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 2019-21. You also see partial balance sheet and income statement data for LGI's main competitors.
· Use this information to complete the calculations in tabs 2-4.
· 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 2018-20 ratios.
· Calculate the ratios for each year.
Open tab 3.
· Complete a common-size analysis.
Open tab 4.
· Complete a cash flow analysis.
Attachment:- Project Excel Workbook.rar