Question

All answers must be entered as formulas on excel

CHAPTER 3 Saved Help Save & Exit Submit Shelton, Inc., has sales of $17.5 million, total assets of $13.1 million, and total debt of $5.7 million. If the profit margin is 6 percent, what is net income? What is ROA? What is ROE? Sales Total assets Total debt Profit margin 17,500,000 13,100,000 5,700,000 6% Complete the following analysis. Do not hard code values in your calculations. Net income Return on assets Total equity Return on equity

Answer 1

А D E F G H J K L M N O P Q R sales Total assets Total debt Profit margin 17,500,000 13,100,000 5,700,000 6% Net income 1,050,000 Return on assets 8.02% Total equity 7,400,000 Return on equity 14.19% K M Sheet544 Sheet545 Sheet546 Sheet547 Sheet548 Sheet549 Sheet550 Sheet551 Sheet552 L ENG 13:50 il TOUS 30/10/2019

sales Total assets Total debt Profit margin 17500000 13100000 5700000 0.06 Net income =C6*C9 Return on assets =C6*C9/07 Total equity =C7-C8 Return on equity =C6*C9/(07-08) 27 K M Sheet544 Sheet545 Sheet546 Sheet547 Sheet548 Sheet549 Sheet550 Sheet551 Sheet552 - ENG 13:51 - US 30/10/2019