1 Calculate the net income All answers must be entered as a formula. Click OK to begin OK DuPont Analysis - Excel ? 5 FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri HA % #1 Paste BIU > Cells Editing A Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Al fo B C D E F G H 1 4 Last year, Stumble-on-Inn, Inc., reported an ROE of 19 percent. The firm's debt ratio was 60 percent, sales were $34 million, and the capital intensity was 1.30 times Calculate the net income for Stumble-on-Inn last year. (Do not round intermediate calculations. Enter your answer in dollars not in millions.) 5 6 7 @ 9 ROE Debt ratio Sales Capital intensity ratio 19% 60% 34,000,000 1.30 $ 10 11 19 DuPont Analysis - Excel ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in X Calibri -A A % Paste BIU A Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A1 v for B C D E E G H 13 14 Complete the following analysis. Do not hard code values in your calculations 15 16 17 18 19 20 31 Total assets Total debt Total equity Net income