| ACCT203 SPECIAL ASSIGNMENT - EMPLOYING THE DUPONT MODEL |
| THIS IS A "PROTECTED" WORKSHEET - YOU CAN ONLY (AND MUST) FILL IN THE THESE DATA:
YOUR NAME, COMPANY NAME, SOURCE LINK, AND...
THE DATA BLOCK (YEAR, NET PROFIT SALES, ASSETS, & EQUITY).
JUST ARROW OVER TO THE YEAR DATA AND INSERT DATA (IN $MILLIONS) IN EACH DATA CELL (INCLUDING THE CONSECUTIVE YEARS YOU CHOSE). |
| FIRST: | ACTION REQUIRED - SAVE THIS FILE WITH YOUR LAST NAME |
| | SAVE THIS FILE AS: | ACCT203 SA DUPONT MODEL LAST NAME.xlsx | | | | Where: "LAST NAME" = Student's Last Name; i.e., Sloane Stephens = STEPHENS |
| THEN: INPUT |
| | INSERT ORIGINAL DATA HERE: |
| | STUDENT NAME = | NAME OF STUDENT IN EARL SEDLIK'S ACCT203 COURSE |
| | COMPANY NAME = | FICTITIOUS COMPANY, INC. |
| | SOURCE OF DATA = | NO SOURCE |
| | DATA BLOCK: ALL DATA IN MILLIONS OF $ ($ 000,000) |
| | YEAR | NET PROFIT | SALES | ASSETS | EQUITY |
| YEAR 1 = | 2008 | 300 | 1000 | 500 | 600 |
| YEAR 2 = | 2009 | 325 | 1150 | 520 | 620 |
| YEAR 3 = | 2010 | 415 | 1200 | 530 | 630 |
| OUTPUT | THIS GRID DISPLAYS THE DATA AND THE COMPUTED RATIO ANALYSIS THAT FOLLOWS THE DUPONT MODEL, WHILE COMPUTING THE PERCENTAGE CHANGES IN YEAR 2 AND 3 FOR DEEPER INSIGHT. |
| YOU ARE TO COPY THESE NUMBERS INTO THE WORD DOCUMENT ANSWER SHEET ENTITLED
ACCT203 F17 SA ANSWER SHEET DUPONT MODEL LAST NAME.docx | COLUMN => | 1 | 2 | 3 | 4 | Col 5
= (1/2) | Col 6
= (2/3) | Col 7
= (3/4) | Col 8
= ( 5*6*7)
same as:
=(1/4) | Col 8
VERIFICATION
as
=(1/4) |
| | YEAR | NET PROFIT | SALES | ASSETS | EQUITY | PROFIT MARGIN RATIO | ASSET TURNOVER RATIO | LEVERAGE RATIO | RETURN ON EQUITY | RETURN ON EQUITY |
| | 2008 | 300 | 1000 | 500 | 600 | 30.00% | 200.00% | 83.33% | 50.00% | 50.00% | YES |
| | 2009 | 325 | 1150 | 520 | 620 | 28.26% | 221.15% | 83.87% | 52.42% | 52.42% | YES |
| | 2010 | 415 | 1200 | 530 | 630 | 34.58% | 226.42% | 84.13% | 65.87% | 65.87% | YES |
| | PERCENTAGE CHANGE IN YEAR 2
= (YR 2 - YR 1)
/ YR 1 | 8.33% | 15.00% | 4.00% | 3.33% | -5.80% | 10.58% | 0.65% | 4.84% |
| | PERCENTAGE CHANGE IN YEAR 3
= (YR 3 - YR 2)
/ YR 2 | 27.69% | 4.35% | 1.92% | 1.61% | 22.37% | 2.38% | 0.31% | 25.67% |
Hedgehog18
ACCT203EMPLOYING-THEDUPONTMODEL1.xlsx
