finance hw

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? 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 profitabilityand asset utilization?

Please find attached document to be filled out for your boss.

Scoring Rubric

  Levels of Achievement
Criteria Exemplary Accomplished Developing Beginning
Excel File 
Weight 50.00%
100 %

Models were estimated with great accuracy, using Excel and provided relevant outputs in an excel file

85 %

Models were estimated with moderate accuracy, using Excel and provided relevant outputs in an excel file

75 %

Models were estimated with inaccuracy, using Excel and provided relevant outputs in an excel file

50 %

Model estimations are mostly incorrect, or no model was provided

Interpretation
Weight 50.00%
100 %

Interpretations are provided with great accuracy by addressing all the required questions, and minimum words requirement is met

85 %

Interpretations are provided with moderate accuracy by addressing most of all required questions, and minimum words requirement is met

75 %

Interpretations are provided with many errors, and, some of important questions were not answered. Minimum words requirement is not met.

50 %

Interpretations are mostly incorrect, or no interpretation was provided.

Scroll to Top