accounting 203
Bengazzz
ACCT203EMPLOYING-THEDUPONTMODELFALL2018-2.xlsxDUPONT MODEL INPUT AND OUTPUT
| 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 SPRING 2018 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. | ||||||||||
| 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% |
&"Helvetica,Regular"&12&K000000&P
OUTPUT -COPY TO ANSWER SHEET
| 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% |
&"Helvetica,Regular"&12&K000000&P
