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 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 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. is not met.
50 %
Interpretations are mostly incorrect, or no interpretation was provided.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more