The assignment has two requirements:Use the attached financial statements to1.) Calculate the following ratios for two years, the current ratio, quick ratio, debt to total asset, gross profit percentage, earnings per common share, dividend payout ratio and net profit margin. ALL these ratios are not in the text or in the videos. You will need to use the internet to find them. Look at the sample ratios in the Ratio tab to see the proper format for the ratios. For example, if your current ratio calculation is 1.782051 this is not the typical form you will be in a company’s published ratios. Submit your calculations in the Ratios tab of the attached Excel document. Complete all columns.
.2.) Use the attached financial statements with ratios you calculated.
Use your ratios and evaluate changes between 2021 and 2022. Make your analysis meaningful. For example, If the current ratio was 2.08 in 2021 and is 1.78 in 2022 do not say ” the current ratio decreased by .30 and stop. Expand the analysis but telling if this is a favorable or unfavorite change. What is the typical current ratio for a company. Include why it changed IE. assets decreased but liabilities increased. Attached a word document with your analysis.