I need support with this Business question so I can learn better.

Discussion Questions

Financial statement is provided in Exhibits 4 and 5 for the last 3 years. The industry averages can be found in Exhibit 6. Provide a summary of the issue that J.C. Penny face.

Assume the role of Alicia Smith, prepare a 3-5-page memo that analyzes the financial condition of JCP.

Included in the memo should be a section describing the company’s liquidity, asset management, debt management, profitability, market value and your recommendations to JCP. Make sure that you include the heading of each section in your report.

Also include the following financial exhibits:

Calculate the JCP’s Free Cash Flow for 2017 and 2016

Ratio table (do the ratios included in Exhibit 6)

Vertical (common-size) analysis of income statement and balance sheet

Horizontal (percent-change) analysis of income statement and balance sheet.

Also give a summary update on how JC Penney performed since 2017? What is new for JCP? How did they react when Sears went bankrupt? Are these changes reflected in Sales and Profit? What about the stock price? Is JCP out of trouble or further into trouble?

please answer all questions and also please show calculation in a separate excel worksheet.

please see attached case and excel worksheet for balance sheet and income statement. Thank you