The learning objective of this module is to introduce you to data analytics which employers consistently tell us are important to new accountants. We will be using an EY-developed case, Implementing the DuPont Method, which I have edited for ACCT 3371.
A key purpose of financial statements is to provide useful information to decision makers, including investors. Investors can use the information contained in financial statements to better understand company performance so they can make better investment decisions. One introductory framework that has been especially useful in understanding company performance is the DuPont Method (sometimes called DuPont Analysis, DuPont Model or DuPont Framework).
To understand the DuPont Method, it helps to use an analytics mindset. For this case, we (1) define an analytics mindset, (2) discuss the history of and ratios involved in the DuPont Method and (3) use the DuPont Method to perform data analytics and data visualization techniques.
For this case, you will implement an analytics mindset by comparing and contrasting different companies within different industries using the accounting ratios from the DuPont method. Your overall goal is to develop an investment recommendation for an investor.
The module has two parts:
NewGenApp.com describes Tableau as data visualization software used for data science and business intelligence. Tableau can create a wide range of different visualization to interactively present the data and showcase insights. It comes with tools that allow to drill down data and see the impact in a visual format that can be easily understood. Tableau specializes in transforming boring tabulated data into eye-candy graphs and representations. You can easily import data into Tableau’s data engine from multiple sources and integrate them by combining multiple views in an interactive dashboard.
|Question 1 – total assets||3|
|Question 2 – count companies||3|
|Question 3 – companies per industry||3|
|Question 4 – net revenues per industry||5|
|Calculate profit margin||5|
|Calculate asset turnover||5|
|Calculate financial leverage||5|
|Question 1 – Median ROE||4|
|Question 2 – Median PMR||4|
|Question 3 – Median AT||4|
|Question 4 – Dashboard||3|
|Question 5 – Multiple viz on one sheet (2pts per ratio)||8|
|Question 1 – student choice||6|
|Question 2 – student choice||6|
|Question 3 – student choice||6|
|Question 4 – student choice||6|
|Story – opinion well presented and supported by 4 viz||19|
Are you busy and do not have time to handle your assignment? Are you scared that your paper will not make the grade? Do you have responsibilities that may hinder you from turning in your assignment on time? Are you tired and can barely handle your assignment? Are your grades inconsistent?
Whichever your reason may is, it is valid! You can get professional academic help from our service at affordable rates. We have a team of professional academic writers who can handle all your assignments.
Our essay writers are graduates with diplomas, bachelor, masters, Ph.D., and doctorate degrees in various subjects. The minimum requirement to be an essay writer with our essay writing service is to have a college diploma. When assigning your order, we match the paper subject with the area of specialization of the writer.
PLACE THIS ORDER OR A SIMILAR ORDER WITH USA ELITE WRITERS TODAY AND GET AN AMAZING DISCOUNT