Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started