AutoSave Off HCB Week 2 Homework Student - Compatibility Mode - Excel Search UT o X File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments CIT LA Cambria 11 ' ' = = a Wrap Text General 28 O Fm EN Paste BIU E E Merge & Center 5E v $ % 909 Insert Delete Format Analyze V Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Data Clipboard Font Alignment Number Cells Editing Analysis A R53 fx E F F G L M N P 0 R S s T U VA H 1 checks how much we sell compared to our investment in ourselves 5.4 this tells us how many DAYS 36.5 days it takes us to collect our a/rec O Sales (on credit) Less: Cost of Goods Sold Gross Profit Less: Selling/Admin Expenses Operating profit (EBIT) Less Interest expense Earnings before Taxes (EBT) Less taxes Earnings after taxes (EAT) (net income) 2,064,000 1,313,000 751.000 496,000 255,000 26,900 228,100 83.300 144.800 we want as much sales as possible compared to our assets 1.5 A A 39 Fixed Asset Turnover: Sales 40 Fixed Assets 41 42 43 Days' Sales in Receiv: 365 44 Receivables Turnover 45 46 47 Total Asset Turnover: Sales 48 Total Assets 49 50 51 Profit Margin: Net Income 52 Net Sales 53 54 55 Return on Assets (ROA) Net income 56 Total Assets 57 58 59 Return on Equity (ROE) Net Income 60 Total Equity 61 62 63 64 DuPont Identity PM*TATEM 65 PM 66 TAT 67 EM 68 A higher profit margin is desirable 10% (depends!) Measures of profit per dollar of assets 10.0% Measures how shareholders did throughout the year 15.0% This is the same as the ROE... IN CLASS ACTIVITY 2 IN CLASS ACTIVITY 3 Tab 1 Tab 2 Tab 3 Tab 4 Tab 5 + Ready + 77% O II a a I w 2 3:34 PM 10/26/2021 F. AutoSave Off HCB Week 2 Homework Student - Compatibility Mode - Excel Search UT o X File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments CIT LA Cambria 11 ' ' = = a Wrap Text General 28 O Fm EN Paste BIU E E Merge & Center 5E v $ % 909 Insert Delete Format Analyze V Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Data Clipboard Font Alignment Number Cells Editing Analysis A R53 fx E F F G L M N P 0 R S s T U VA H 1 checks how much we sell compared to our investment in ourselves 5.4 this tells us how many DAYS 36.5 days it takes us to collect our a/rec O Sales (on credit) Less: Cost of Goods Sold Gross Profit Less: Selling/Admin Expenses Operating profit (EBIT) Less Interest expense Earnings before Taxes (EBT) Less taxes Earnings after taxes (EAT) (net income) 2,064,000 1,313,000 751.000 496,000 255,000 26,900 228,100 83.300 144.800 we want as much sales as possible compared to our assets 1.5 A A 39 Fixed Asset Turnover: Sales 40 Fixed Assets 41 42 43 Days' Sales in Receiv: 365 44 Receivables Turnover 45 46 47 Total Asset Turnover: Sales 48 Total Assets 49 50 51 Profit Margin: Net Income 52 Net Sales 53 54 55 Return on Assets (ROA) Net income 56 Total Assets 57 58 59 Return on Equity (ROE) Net Income 60 Total Equity 61 62 63 64 DuPont Identity PM*TATEM 65 PM 66 TAT 67 EM 68 A higher profit margin is desirable 10% (depends!) Measures of profit per dollar of assets 10.0% Measures how shareholders did throughout the year 15.0% This is the same as the ROE... IN CLASS ACTIVITY 2 IN CLASS ACTIVITY 3 Tab 1 Tab 2 Tab 3 Tab 4 Tab 5 + Ready + 77% O II a a I w 2 3:34 PM 10/26/2021 F