This Excel file contains the $2018-2020$ Income Statement and Balance Sheet for Longview Manufacturing Corporation $($LMC$),$ Industry averages for $2020$ are provided on a separate tab, along with placeholders to calculate financial revenues.

a$.$ Calculate the $2017-2019$ financial ratios for LMC$.$

b$.$ Conduct a trends analysis for LMC$.$

c$.$ Compare LMC$\text{'}$s $2019$ financial ratios with the $2019$ industry averages.

d$.$ Conduct a DuPont analysis

e$.$ Write up your findings.