All answers must be entered as formulas, per the question.

1. Calculate the net income X ? DuPont Analysis - Excel X Sign In FILE HOME INSERT FORMULAS DATA REVIEW PAGE LAYOUT VIEW 11 A A Calibri 9% Alignment Number Conditional Format Formatting Table Paste Cell Cell: Editing IU E A B Styles Clipboard Font Styles A1 A C D G 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. 4 Calculate the net income for Stumble- on-Inn last year. (Do not round intermediate calculations. Enter your answer in dollars not in millions.) 7 ROE 19% Debt ratio 60% S Sales 34,000,000 10 Capital intensity ratio 1.30 11 12 13 Complete the following analysis. Do not hard code values in your calculations. 14 15 Total assets 16 Total debt 17 Total equity 18 Net income 19 20 Sheet1 READY 100% Hint Show Me Attempt(s)