Question

1 Approved Answer

Posted on Jul 19, 2024

1. Review the Statement of Cash Flow for both organizations and discuss how both organizations are generating cash 2. Review footnotes to financial statements any

1. Review the Statement of Cash Flow for both organizations and discuss how both organizations are generating cash

2. Review footnotes to financial statements any major item that warrants discussion

image text in transcribed

Excel File Edit O 3 za Sat Dec 11 10:27 PM 0.0 AutoSave OSF View Insert Format Tools Data Window Help 0 @ 2. Page Layout Formulas Data Review View Tell me Book 3 Home Insert Draw Share Comments X Calibri (Body) v 12 V APA == 24. Wrao Text General 29 Insert v Delete 27-O O v Paste BIU AVA = == Z Sort & Filter + Merge & Centar $ % Conditional Format Cell Formatting as Table Styles Find & Select ! Format Analyze Data Sensitivity N60 D D E F G L B Inventory Daily Cost of Goods Sold C 14551 239.060274 15925 H 15179 1251 134.808219 97.761101562.7616438 200.138161 60.78383396 199.0493151 69.95753789 Cost of Goods Sold Inventory 87257 14531 72653 13925 49205 13179 3.73359132 22908 12561 1.82374015 6.004886106 5.217450628 Operating Income Total Assets 18278 51236 15843 44003 6314 39471 0.15996554 4018 34508 0.11643677 0.356741354 0.360043633 4018 Operating Income Sales 18278 132110 15843 110225 6314 72148 0.08751455 0.138354402 0.143733272 71309 0.05634632 A 20 ways in VRLOTY 21 22 23 Inventory Turnover 24 25 26 Operating Profitability 27 28 Operating Return on Assets 29 30 31 Operating Profit Margin 32 33 34 Total Asset Turnover 35 36 37 Net Fixed Asset Turnover 38 39 40 Financing Decisions 41 42 Debt Ratio 43 44 45 Times Interest Earned 46 47 48 Return on Equity 49 Sales Total Assets 132110 51236 110225 44003 72148 39471 1,82787363 71309 3450B 2.06644836 2.578460457 2.504942845 Sales Net Fixed Assets 132110 22770 110225 22375 72146 18669 3.86458836 71309 18432 3.86876085 5.801932367 4.926256983 Total Debt Total Assets 54352 51236 45881 44003 37499 39471 0.95003927 30864 34508 1.060816613 1.042678908 0.8944013 Operating Income Interest Expense 18278 1347 15843 1201 6314 691 9.13748191 13.19150708 4018 624 6.43910256 13.56941351 Sheet1 + Ready 120% 11 tv /A Excel File Window Help a O 3 za Sat Dec 11 10:27 PM Edit View Insert Format Tools Data AutoSave CSF OF AOO... 0.0 Book3 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 12 Y APK == $ General V PD Conditional Format Cell Formatting as Table Styles Insert S Delete v Format 28-O 2) LEN Analyze Data Paste B B A = == + + $ %) Sort & Filter E Find & Select Sensitivity N60 A C D F G G L L B Sales Net Fixed Assets 132110 22770 E 110225 22375 H 72148 18669 3.86458836 J K 71309 18432 3.86876085 5.801932367 4.926256983 Total Debt Total Assets 54352 51236 45881 44003 37499 39471 0.95003927 30864 34508 0.8944013 1.060816613 1.042678908 37 Net Fixed Asset Turnover 38 39 40 Financing Decisions 41 42 Debt Ratio 43 44 45 Times Interest Earned 46 47 48 Return on Equity 49 50 Return on Equity 51 Operating income Interest Expense 18278 1347 15843 1201 6314 691 9.13748191 4018 624 6.43910256 13.56941351 13.19150708 Net Income Total Common Equity 12866 3116 11242 1878 4281 1972 2.17089249 2314 3644 0.63501647 4.129011553 5.986155485 Fin 80152 (Operating Return on Assets Cost of Capital 0.3567 0.0991 51236 0.36 0.1026 44003 0.1599 0.1257 39471 1349.9082 0.1164 0.0925 34508 *Total Assets 13198.3936 11326.3722 824.7412 12 01 20 53 Creating Shareholder Value 54 55 Economic Value Added 'EVA" 56 57 58 59 60 61 62 63 64 65 66 Sheet1 + Ready 120% 11 tv A AutoSave OF AA 2 O... Book 3 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (body) v 12 v A X G ab Wrap Text General Insert v 0 0 v v Paste B 1 Av = = = Y Merge & Center v Delete Format Conditional Format Cell Formatting es Table Styles Sensitivity Y Sort & Filter v Find & Select Analyze Data V N60 fy B D E F G . L M Lowes Home Depot Home Depot Home Depot Home Depot 2019 Lowes Lowes Lowes 2020 2020 2019 2020 2020 2019 2019 Formula Current Assets Current Liabilities 19810 18375 18529 16716 1513B 15182 0.99710183 14228 14497 0.98144444 1.078095238 1.108458961 Cash + Accounts Recievables Current Liabilities 4239 16375 3714 16716 0.230693878 716 15162 0.04716111 511 14497 0.03524867 0.22218234 Accounts Recievables Daily Credit Sales N/A 2106 132110 1936 110225 5.918560291 N/A 26027785 N/A 6.410886822 72148 N/A . A LUSTIJU 2 3 4 Firm Liquidity 5 6 Ratio 7 & Current Ratio 9 10 11 Acid Test Ratio 12 13 14 Days in Recievables 15 16 17 Accounts Recievable Turnover 1B 19 20 Days in Inventory 21 22 23 Inventory Turnover 24 25 26 Operating Profitability 27 28 Operating Return on Assets 29 30 31 Operating Profit Margin 32 33 34 Total Asset Turnover 72148 Credit Sales Accounts Recievable 132110 2106 110225 1936 62.7302944 56.93440083 71309 N/A N/A N/A N/A Inventory Daily Cost of Goods Sold 14531 239.060274 13925 199.0493151 13179 12561 134.808219 97.761101562.7616438 200.138161 60.78383396 69.95753789 Cost of Goods Sold Inventory 87257 14531 72653 13925 49205 13179 3.73359132 5.217450628 22908 12561 1.87374015 6.004886106 4018 Operating Income Total Assets 18278 51236 15843 44003 6314 39471 0.15996554 0.356741354 0.360043633 3450R 0.11643677 Operating Income Sales 18278 132110 15843 110225 6314 72148 0.08751455 4018 71309 0.05634632 0.138354402 0.143733273 Sales 132110 110225 72148 71309 Sheet1 + Ready + 120% Excel File Edit O 3 za Sat Dec 11 10:27 PM 0.0 AutoSave OSF View Insert Format Tools Data Window Help 0 @ 2. Page Layout Formulas Data Review View Tell me Book 3 Home Insert Draw Share Comments X Calibri (Body) v 12 V APA == 24. Wrao Text General 29 Insert v Delete 27-O O v Paste BIU AVA = == Z Sort & Filter + Merge & Centar $ % Conditional Format Cell Formatting as Table Styles Find & Select ! Format Analyze Data Sensitivity N60 D D E F G L B Inventory Daily Cost of Goods Sold C 14551 239.060274 15925 H 15179 1251 134.808219 97.761101562.7616438 200.138161 60.78383396 199.0493151 69.95753789 Cost of Goods Sold Inventory 87257 14531 72653 13925 49205 13179 3.73359132 22908 12561 1.82374015 6.004886106 5.217450628 Operating Income Total Assets 18278 51236 15843 44003 6314 39471 0.15996554 4018 34508 0.11643677 0.356741354 0.360043633 4018 Operating Income Sales 18278 132110 15843 110225 6314 72148 0.08751455 0.138354402 0.143733272 71309 0.05634632 A 20 ways in VRLOTY 21 22 23 Inventory Turnover 24 25 26 Operating Profitability 27 28 Operating Return on Assets 29 30 31 Operating Profit Margin 32 33 34 Total Asset Turnover 35 36 37 Net Fixed Asset Turnover 38 39 40 Financing Decisions 41 42 Debt Ratio 43 44 45 Times Interest Earned 46 47 48 Return on Equity 49 Sales Total Assets 132110 51236 110225 44003 72148 39471 1,82787363 71309 3450B 2.06644836 2.578460457 2.504942845 Sales Net Fixed Assets 132110 22770 110225 22375 72146 18669 3.86458836 71309 18432 3.86876085 5.801932367 4.926256983 Total Debt Total Assets 54352 51236 45881 44003 37499 39471 0.95003927 30864 34508 1.060816613 1.042678908 0.8944013 Operating Income Interest Expense 18278 1347 15843 1201 6314 691 9.13748191 13.19150708 4018 624 6.43910256 13.56941351 Sheet1 + Ready 120% 11 tv /A Excel File Window Help a O 3 za Sat Dec 11 10:27 PM Edit View Insert Format Tools Data AutoSave CSF OF AOO... 0.0 Book3 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 12 Y APK == $ General V PD Conditional Format Cell Formatting as Table Styles Insert S Delete v Format 28-O 2) LEN Analyze Data Paste B B A = == + + $ %) Sort & Filter E Find & Select Sensitivity N60 A C D F G G L L B Sales Net Fixed Assets 132110 22770 E 110225 22375 H 72148 18669 3.86458836 J K 71309 18432 3.86876085 5.801932367 4.926256983 Total Debt Total Assets 54352 51236 45881 44003 37499 39471 0.95003927 30864 34508 0.8944013 1.060816613 1.042678908 37 Net Fixed Asset Turnover 38 39 40 Financing Decisions 41 42 Debt Ratio 43 44 45 Times Interest Earned 46 47 48 Return on Equity 49 50 Return on Equity 51 Operating income Interest Expense 18278 1347 15843 1201 6314 691 9.13748191 4018 624 6.43910256 13.56941351 13.19150708 Net Income Total Common Equity 12866 3116 11242 1878 4281 1972 2.17089249 2314 3644 0.63501647 4.129011553 5.986155485 Fin 80152 (Operating Return on Assets Cost of Capital 0.3567 0.0991 51236 0.36 0.1026 44003 0.1599 0.1257 39471 1349.9082 0.1164 0.0925 34508 *Total Assets 13198.3936 11326.3722 824.7412 12 01 20 53 Creating Shareholder Value 54 55 Economic Value Added 'EVA" 56 57 58 59 60 61 62 63 64 65 66 Sheet1 + Ready 120% 11 tv A AutoSave OF AA 2 O... Book 3 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (body) v 12 v A X G ab Wrap Text General Insert v 0 0 v v Paste B 1 Av = = = Y Merge & Center v Delete Format Conditional Format Cell Formatting es Table Styles Sensitivity Y Sort & Filter v Find & Select Analyze Data V N60 fy B D E F G . L M Lowes Home Depot Home Depot Home Depot Home Depot 2019 Lowes Lowes Lowes 2020 2020 2019 2020 2020 2019 2019 Formula Current Assets Current Liabilities 19810 18375 18529 16716 1513B 15182 0.99710183 14228 14497 0.98144444 1.078095238 1.108458961 Cash + Accounts Recievables Current Liabilities 4239 16375 3714 16716 0.230693878 716 15162 0.04716111 511 14497 0.03524867 0.22218234 Accounts Recievables Daily Credit Sales N/A 2106 132110 1936 110225 5.918560291 N/A 26027785 N/A 6.410886822 72148 N/A . A LUSTIJU 2 3 4 Firm Liquidity 5 6 Ratio 7 & Current Ratio 9 10 11 Acid Test Ratio 12 13 14 Days in Recievables 15 16 17 Accounts Recievable Turnover 1B 19 20 Days in Inventory 21 22 23 Inventory Turnover 24 25 26 Operating Profitability 27 28 Operating Return on Assets 29 30 31 Operating Profit Margin 32 33 34 Total Asset Turnover 72148 Credit Sales Accounts Recievable 132110 2106 110225 1936 62.7302944 56.93440083 71309 N/A N/A N/A N/A Inventory Daily Cost of Goods Sold 14531 239.060274 13925 199.0493151 13179 12561 134.808219 97.761101562.7616438 200.138161 60.78383396 69.95753789 Cost of Goods Sold Inventory 87257 14531 72653 13925 49205 13179 3.73359132 5.217450628 22908 12561 1.87374015 6.004886106 4018 Operating Income Total Assets 18278 51236 15843 44003 6314 39471 0.15996554 0.356741354 0.360043633 3450R 0.11643677 Operating Income Sales 18278 132110 15843 110225 6314 72148 0.08751455 4018 71309 0.05634632 0.138354402 0.143733273 Sales 132110 110225 72148 71309 Sheet1 + Ready + 120%