Reference no: EM132293563

Application of DuPont Model

This project is open book, open note, open classmate (up to 2 students per team). You must properly cite all sources of information in a reference page at the end of your report. This assignment is subject to electronic evaluation via the Turnitin.com module in D2L. Any uncited materials will be treated as plagiarism (see syllabus for policy on academic integrity). Conduct research to populate an excel spreadsheet(s) of the DuPont model for these three situations:

1. For one company, compare the most currently reported year with a previous year (up to 5 years previous). Comment on all the differences you find. What could have caused them?

2. For two companies that compete in the same product/market segments, compare one to the other on one spreadsheet. Comment on the differences you find. Why are they different?

You can google for annual reports or 10K forms from specific companies. Also, Bloomberg, Yahoo Finance. Market Watch, and other financial websites may have several years of income statements and balance sheets conveniently presented in a single table. You can try Googling your company's financial statement (e.g., "Home Depot Income Statement").

The report should include a printed spreadsheet and your written, single-spaced comments for each of these two situations. I expect at least 1-2 full pages of written analysis to accompany each scenario, not including the spreadsheet figure.

This project is due in accordance with the course syllabus, via D2L Assignments. Late submissions will not be accepted (refer to syllabus for policy). You should turn in:

1. Written report prepared in MS Word format. For each scenario, include a graphic of the completed DuPont model.

2. Completed DuPont model worksheet for each scenario, saved in a single Excel file.

Attachment:- Technical Report Template.rar