Order from us for quality, customized work in due time of your choice.
Instructions for This Excel Workbook
View the balance sheet
and income
Instructions for This Excel Workbook
View the balance sheet
and income statement for the client company, 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
Open tab 1. You see
the balance sheet and income statement for for 2021–23. You also see
estimated average 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 2021–2023 ratios.
·
Calculate the ratios for each year.
Open tab 3.
·
Complete a common-size analysis.
Open tab 4.
·
Complete a cash flow analysis.
Order from us for quality, customized work in due time of your choice.