create an extended DuPont analysis, common size analysis, and percentage change analysis. Consider the following scenario:ÿ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.ÿRemember to answer all the questions in the attached document.Has J&W’s liquidity position improved or worsened? ExplainHas J&W’s ability to manage its assets improved or worsened? ExplainHow 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 inprofitabilityÿand asset utilization?Please find attached document to be filled out for your boss.
create an extended DuPont analysis, common size analysis, and percentage change analysis
