Your boss has come to you for advice on the

Your boss has come to you for advice on the current finances of the company and needs you to create an extended DuPont analysis, common size analysis, and percentage change analysis. Your boss wants you to fill out the attached Excel file because he/she has no idea what she is talking about and is going to use your report as her work.

Questions are in excel (photos attached) but are as follows:

-Has J&W’s liquidity position improved or worsened? Explain

-Has J&W’s ability to manage its assets improved or worsened? Explain

-How has J&W’s profitability changed during the last year?

-Perform an extended DuPont analysis for J7W for 2015 and 2016. What do these results tell you?
-Perform a common size analysis. What has happened to the composition (That is, the percentage in each category) of assets and liabilities?

-Perform a percentage change analysis. What does this tell you about the change in profitability and asset utilization?

Fill in all yellow Squares with the appropriate answer.