Download the financial statements for Pelican Briefs. Note: The order of the years is reversed from the spreadsheet we used in class. Note: The structure of the statements is slightly different that what we used in class. You can either modify the structure of the income statement to mimic the one used in class or you adjust any calculation below to accommodate it. Assignment 1. (7 points) On the Statement of Cash Flows worksheet (tab), construct the Statement of Cash Flows using the template. 2. (8 points) On the "Free Cash Flow worksheet (tab), calculate NI, NOPAT, NWC, NOWC, Cap Ex, FCF, MVA, and EVA for 2020 and 2021. 3. (10 points) On the Ratio Analysis worksheet, calculate the financial ratios listed. a. A couple of the ratios are not in the text, but we covered in class. b. Evaluate Pelican Brief's liquidity, asset utilization, profitability, and debt position using the YOY changes and industry average ratios for 2021 listed in the spreadsheet? C. Can you think of a way to correct any problems or discrepancies that may exist? Download the financial statements for Pelican Briefs. Note: The order of the years is reversed from the spreadsheet we used in class. Note: The structure of the statements is slightly different that what we used in class. You can either modify the structure of the income statement to mimic the one used in class or you adjust any calculation below to accommodate it. Assignment 1. (7 points) On the Statement of Cash Flows worksheet (tab), construct the Statement of Cash Flows using the template. 2. (8 points) On the "Free Cash Flow worksheet (tab), calculate NI, NOPAT, NWC, NOWC, Cap Ex, FCF, MVA, and EVA for 2020 and 2021. 3. (10 points) On the Ratio Analysis worksheet, calculate the financial ratios listed. a. A couple of the ratios are not in the text, but we covered in class. b. Evaluate Pelican Brief's liquidity, asset utilization, profitability, and debt position using the YOY changes and industry average ratios for 2021 listed in the spreadsheet? C. Can you think of a way to correct any problems or discrepancies that may exist