Need help preparing these ratios from a financial statement. I am not good with excel and have been trying for hours!
Here are the ratios I need help filling in for Target and Wal-Marts numbers. Only have to do it for 2016 numbers above.
G ACG2071: Principles of * Connect - Class: Financix M MHE Reader X Financial Statements-2.p X C Get Homework Help W x How to take a screensh x + - 0 X F C File C:/Users/TEMP/Downloads/FinancialStatements-2.pdf Target Corp TGT * Add to Portfolio Quote Chart Get E-mail Alerts Print This Page PDF Report Data Question Stock Analysis Performance Key Ratios Financials Valuation Insiders Ownership rings Balance Sheet Cash Flow Bonds Income Statement Fiscal year ends January USD in Men opt per share data 2013-01 Assets 48,163 2014-01 44,553 11,573 2015-01 41,404 Current assets 14,067 2016-01 40,262 14,130 4,046 4,046 16,388 794 654 130 784 Cast Cash and cash equivale... Short-term investments Total cash 2,210 2,210 2.210 4,046 779 8,601 1,122 8,790 7,903 Receivables Inventories Deferred income taxes Prepaid expenses Other current assets Total current assets 188 214 490 Non-current assets 695 1,347 8,766 177 272 316 11,573 32,980 31,378 6,234 1,347 31,199 45,780 (14,402) 31,378 Property, plant and eq... 7,701 16,388 31,775 30,653 6,206 7,929 29,829 43,964 (13,311) Land 231 1,546 14,087 27,317 25,958 6,127 7,899 27,038 41,064 (15,106) 25,958 Fixtures and equipment Other properties Property and equipment... Accumulated Depreciati... Property, plant and eq... Equity and other inves... Goodwill 14,130 26,132 25,217 6,125 7,964 27,374 41,463 (16,246) 30,653 25,217 305 151 206 469 Intangible assets Deferred income taxes Prepaid pension costs Other long-term assets Total non-current asse... Total assets 1,122 471 32,980 31,775 264 26.132 48,163 27,317 41,404 40,262 Liabilities and stockh... 162 Type here to search o Ei e E E S 5:34 PM 4/2/2020 " 3 G ACG2071: Principles of x r Connect - Class: Financi x M MHE Reader X Financial Statements-2. C Get Homework Help W X Q How to take a screensh x + - ] X E c File C:/Users/TEMP/Downloads/FinancialStatements-2.pdf 41,404 Liabilities and stockh... 48,163 Uabilities 41,404 27,407 11,736 Current liabilities Short-term debt Accounts payable Taxes payable . 31,605 14,031 2,994 7,056 896 2,853 44,553 28,322 12,777 1,160 7,683 890 2,772 272 7,759 40,262 40,262 27,305 12,622 815 7,418 1,076 2,179 1,134 12,622 14,683 11,945 823 576 1,504 1,806 Accrued liabilities Other current liabilit... Total current liabilit... 232 11,736 Non-current liabilitie... 12,777 15.545 14,031 17,574 14,654 1,311 15,671 12,705 1,321 151 54 1.861 12,622 1,433 115 1,375 15,545 28,322 16,231 1,609 17,574 31,605 16,558 Long-term debt Deferred taxes liabili... Pensions and other ben... Other long-term labil... Total non-current liab... Total liabilities Stockholders' equity Common stock Additional paid in cap... Retained earnings Accumulated other comp... Total stockholders' eq... Total abilities and 14,683 15,671 27,407 13,997 27,305 12,957 50 3,925 13,155 (576) 16,558 48,163 4,470 12,599 (891) 16,231 4,899 9,644 (599) 13,997 41,404 5,348 8,188 (629) 12,957 40,262 We value your feedback. Let us know what you think x FinancialStatements-2.p C Get Homework Help W x | Q How to take a screensh x | + - X ACG2071: Principles of * Connect - Class: Financi * M MHE Reader File C:/Users/TEMP/Downloads/FinancialStatements-2.pdf E Target Corp TGT Income Statement Balance Sheet Cash Flow Statement Type Annual Data Type As of Reported Period 5 Years Show Report Dates Ascending Data Scroll View Ro, Fiscal year ends in January USD in Mon except per share data Ravenue Cost of revenue 2016-01 73,795 51,997 Gross profit Operating expenses Sales, General and adm... Other operating expens... Total operating expans... Operating Income 2013-01 73,301 51,035 22,266 16,895 14,914 1,981 16,895 5,371 2014-01 72,596 51,160 21,436 17,207 15,375 1,832 17,207 4,229 2015-01 72,618 51,278 21,340 16,805 14,676 2,129 16,805 4,535 21,788 16,878 14,665 2.213 16,878 4,910 762 1,126 Interest Expense Other income (expense) Income before income t... 4,609 3,103 (882) 3,653 4,923 Provision for income t... Net Income from contin... 1,610 2,999 1,132 1.971 1,204 2,449 1,602 3,321 Net Income from discon... Net Income 2,999 1,971 (4,065) (1,636) 3.363 X M MHE Reader 5 ACG2071: Principles of Manag Financial Statements-2.pdf e r Connect - Class: Financial and X x + C Get Homework Help With Che X - 0 X E C File C:/Users/TEMP/Downloads/Financial Statements-2.pdf Wal-Mart Stores Inc WMT Income Statement Balance Sheet Cash Flow Data Scrol View Statement Type Annual Data Type As of Reported Period 5 Years Show Report Dates Ascending Rounding Export scal year ands nary USD in R ecept per share at Assets 2012-01 193,406 54,975 6,550 2015-01 203,706 63,278 2016-01 199,581 60,239 8.705 Current assets 2014-01 204,752 61,165 7,281 7,281 7,281 Cash 9,135 Cash and cash equivale... 2013-01 203,105 59,940 7,781 7,781 7,781 6,768 43,803 1,588 9.135 8,705 Total cash 8,705 6,550 6,550 5.937 40,714 1,685 9,135 6,778 Receivables 5,624 Inventores 6,677 44,858 1.909 45.141 2,224 44,469 1.441 Prepaid expenses Other current assets 460 Total current assets 61.185 60,239 Non-current assets Property, plant and eq... Land Fixtures and equipment Other properties Property and equipment... Accumulated Depreciati... Property, plant and eq... Goodwill 54,975 138,431 112,324 23,499 41,916 95,523 160,938 (48,614) 112,324 20,651 59,940 143,165 116,681 25,612 43,699 102,413 171,724 (55,043) 116,681 20,497 143,566 117,907 26,184 45.755 106,738 178,678 (60,771) 117,907 19,510 63,278 140,428 116,655 26,261 47,851 108.522 182,634 (65,979) 116,655 18,102 139,342 116,516 25,624 49,950 112,480 188,054 (71,538) 116,516 16,695 Other long-term assets Total non-current asse... Total assets Labtes and stockich... 5,456 138,431 193,406 193,406 122,091 62,300 6,022 326 Liabilities Current abilities Short-term debt Capital leases Accounts payable 5,987 143,165 203,105 203,105 126,762 71,818 12,392 327 38,080 5,062 15.957 6,149 143,566 204,751 204,751 128,496 69,345 11,773 309 37,415 3.520 16,239 5,671 140,428 203,706 203,706 122,312 65,272 6,402 287 38.410 3,613 16,560 6,131 139,342 199,581 199,581 119,035 64,619 5,453 551 38,487 3,065 17,063 36.609 1,164 18,154 Taxes payable Accrued abilities Other current liabifit... Total current liabilit... 62,300 71,818 69,345 65,272 64,619 Type here to search ^ E . (1) 2/12/2020 S ACG2071: Principles of Managex Connect - Class: Financial and x M MHE Reader X Financial Statements-2.pdf X C Get Homework Help With Che x + - X F C File C:/Users/TEMP/Downloads/Financial Statements-2.pdf 39 69,345 65,272 57,040 41,086 VU UUTTURE SU Total current Wabilit... Non-current liabilitie... Long-term debt Capital leases Deferred taxes liabili... Minority interest Other long-term liabil... Total non-current Nab... 59,151 41,771 2,788 8,017 64,619 54,416 38,214 5,816 7,321 3,065 2,606 8,805 71,818 54,944 38,394 3,023 7,613 5,395 519 54,944 126,762 76,343 5,084 62,300 59,791 44,070 3,009 7.862 4,446 404 59,791 122,091 71 315 342 3,692 68,691 (1,410) 71,315 193,406 4,543 Total liabilities 59,151 128,496 76,255 332 323 Stockholders' equity Common stock Additional pald-in cap... Retained earnings Accumulated other comp... Total stockholders' .. Total Habilities and ... 3,620 72,978 (587) 76,343 203,105 2,362 76,566 (2,996) 76,255 204,751 57,040 122,312 81,394 323 2,462 85.777 (7,168) 81,394 203,706 54,416 119,035 80,546 317 1,805 90,021 (11,597) 80,546 199,581 . Type here to search ^ Et 5:52 PM 1) 4/2/2020 + - 0 X 5 ACG2071: Principles of Managx Em Connect - Class: Financial and C Get Homework Help With Che X X M MHE Reader X Financial Statements-2.pdf C File C:/Users/TEMP/Downloads/Financial Statements-2.pdf Wal-Mart Stores Inc WMT Add to Portfolio Get E-mail Alerts Print This Page POF Report Data Question Quote Chart Stock Analysis Performance Key Ratios Financials Valuation Income Statement Balance Sheet Cash Flow Insiders Ownership Fings Bonds Statement Type Annual Data Scroll Data Type As of Reported Perted 5 Years Show Report Dates Ascending View Rounding Export Fiscal year ends in January USD in Miten except per share data 2015-01 485,651 365,086 Revenue Cost of revenue Gross profit Operating expenses Sales, General and adm... Total operating expens... 120,565 2012-01 446,950 335,127 111,823 85,265 85,265 85,265 25,558 2013-01 469,162 352.488 116,674 88,873 88.873 88,873 27,801 2014-01 475,294 358,069 118,225 91,353 91,353 91,353 26,872 2016-01 482,130 360,964 121,146 97,041 97,041 97,041 24,105 93,418 93,418 93,418 27,147 Operating income 2,322 2,335 2,548 Interest Expense Other income (expense) Income before income t.. 162 2,251 187 25,737 119 2.461 113 24,799 24,398 24,656 21,638 7,981 8,105 7.985 6.558 386 673 736 Provision for income t... Minority interest Other income Net income from contin... 7,944 688 688 16,454 757 752 673 385 736 16,814 17,756 16,551 15,080 Net income from discon... Other (67) (688) 15.699 (757) 16,999 (673) 16.022 285 (736) 16,363 (386) 14,694 Net Income ^E (1) 272/2020 33 Type here to search Worksheet-3 - Compatibility Mode - Saved Sign in - o X AutoSave Of HOSE File Home Insert Page Layout Formulas Data Review View Help Search Comments X === Arial - 10 BIU - 2. -A A A. Wrap Text Merge & Center - General $ - % , Share AutoSumA Fill- Sort & Find & Clear Filter - Select Paste " 3 , apo - , 40.00 Insert Delete Format Ideas Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number Cells Editing Ideas A1 X for Student Name: _Chase L M N O LA F G H I J K Calculate ratios and circle or highlight with color which ratio is best. Which company has the best Profit Margin, etc? Show the numerator and denominator in columns F & I Target Wal-Mart In this column, write the elements 1 Student Name: Chase 2 3 Managerial Accounting 4 Ratios for 2016 data: 5 Ratio Categories 6 Profitability 7 that are measured in the ratio. I have completed five as examples: Profit Margin Net Income 3363000 14694000 0.05% Revenue 73785000 Return on Total Assets 9 Profitability 10 Return on Common Stockholders' Equity 11 12 Profitability 13 14 15 Profitability 16 17 Earnings Per Share of Common Stock Net Income - Preferred Dividends N umber of shares of common stock outstanding P/E ratio 18 Analyzing stock Fin Ratio Worksheet o Type here to search Ei e ? s 9 0 A x - - + 100% 5:44 PM r 1) 4/2/20203 Worksheet-3 - Compatibility Mode - Saved Sign in - o X AutoSave Of HOSE File Home Insert Page Layout Formulas Data Review View Help Search Comments X - 10 Arial -A A === Wrap Text E AutoSum General | PP SEX 2 Share 48 0 Sort & Find & Filter - Select Editing % Paste - BIU - - A- E E E E Merge & Center - $ , % 49.00 Insert Delete Format Fill- Clear Ideas Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number Cells Ideas X for Student Name: _Chase_ B C D E F G H I J K L M N O LA P/E ratio (Price-Earnings) Current Ratio 18 Analyzing stock 19 20 21 Liquidity 22 (ability to pay current liabilities) 23 24 Profitability 25 (stock value) Book Value per share Total SHE (common stock) Number of shares of common stock outstanding 26 Debt-to-Equity Ratio 27 Solvency 28 29 30 Turnover efficiency Inventory Turnover Cost of Revenue Average Inventory 32 33 Turnover efficiency AR Turnover Revenue Fin Ratio Worksheet - + 100% Type here to search o Ei e = 9 x 5:45 PM - Ed ( 1) 4/2/2020 33 Worksheet-3 - Compatibility Mode - Saved Sign in - o X AutoSave Of HOSE File Home Insert Page Layout Formulas Data Review View Help Search Comments X - 10 Arial -A A === E AutoSum Wrap Text General Share 48 0 Sort & Find & Filter - Select Editing % Paste " - - A- BIU - E E E E Merge & Center - Fill- Clear $ , % 49.00 Insert Delete Format Ideas Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number Cells Ideas X for Student Name: _Chase_ F G H I J K L M N O LA AR Turnover 33 Turnover efficiency 34 35 Revenue Average Receivables (Accounts Receivable) 36 Turnover efficiency Total Asset Turnover 37 39 40 41 1. Write the ratio elements in the middle column of the worksheet: For Example, Return on Sales is "Net Income / Revenue." 42 *Neither company has issued Preferred Stock so there won't be any Preferred Dividends* 43 *Cost of Revenue is another term for Cost of Goods Sold* 44 *Revenue is another term for Net Sales 45 46 2. Calculate the Financial Ratios for Target and Wal-Mart for Fiscal Year 2016 and enter data and ratios onto your worksheet. 47 Round your answers to two decimal places. 48 49 3. On the worksheet, circle or highlight which ratio is the 'best' when compared between the two corporations. 50 51 Use the following data in addition to the financial statements: 52 Target market price of $72.23 and Wal-Mart market price of $69.12 53 Target number of outstanding common shares is 561.7 in millions 54 Wal-Mart number of outstanding common shares is 3073.19 in millions Fin Ratio Worksheet - + 100% 5:46 PM Type here to search o 0 -- - Ed ( 1) 4/2/2020 33 e me 9x AutoSave Of H Worksheet-3 - Compatibility Mode - Saved Sign in 7 - 0 X = Page Layout File Home Insert Formulas Data Review View Help Search Comments Arial BI U - 10 - A A - - A- === S Wrap Text 3 Merge & Center General 0,0% - 40.00 Paste La I X 2 Insert Delete Format Share AutoSum 47 0 Fill- Sort & Find & Clear Filter Select Editing 2 P D Conditional Format as Cell Formatting Table Styles Styles E , Ideas Clipboard Font Alignment Number Cells Ideas A1 X for Student Name: _Chase C D F G H I J K L M N O LA 51 Use the following data in addition to the financial statements: 52 Target market price of $72.23 and Wal-Mart market price of $69.12 53 Target number of outstanding common shares is 561.7 in millions 54 Wal-Mart number of outstanding common shares is 3073.19 in millions 55 56 4. Which stock would you buy? 57 Write three complete paragraphs, addressing the strengths and weaknesses of each company and your 58 reasoning for purchasing Target or Wal-Mart stock. 59 60 Please read instruction page for additional information. G ACG2071: Principles of * Connect - Class: Financix M MHE Reader X Financial Statements-2.p X C Get Homework Help W x How to take a screensh x + - 0 X F C File C:/Users/TEMP/Downloads/FinancialStatements-2.pdf Target Corp TGT * Add to Portfolio Quote Chart Get E-mail Alerts Print This Page PDF Report Data Question Stock Analysis Performance Key Ratios Financials Valuation Insiders Ownership rings Balance Sheet Cash Flow Bonds Income Statement Fiscal year ends January USD in Men opt per share data 2013-01 Assets 48,163 2014-01 44,553 11,573 2015-01 41,404 Current assets 14,067 2016-01 40,262 14,130 4,046 4,046 16,388 794 654 130 784 Cast Cash and cash equivale... Short-term investments Total cash 2,210 2,210 2.210 4,046 779 8,601 1,122 8,790 7,903 Receivables Inventories Deferred income taxes Prepaid expenses Other current assets Total current assets 188 214 490 Non-current assets 695 1,347 8,766 177 272 316 11,573 32,980 31,378 6,234 1,347 31,199 45,780 (14,402) 31,378 Property, plant and eq... 7,701 16,388 31,775 30,653 6,206 7,929 29,829 43,964 (13,311) Land 231 1,546 14,087 27,317 25,958 6,127 7,899 27,038 41,064 (15,106) 25,958 Fixtures and equipment Other properties Property and equipment... Accumulated Depreciati... Property, plant and eq... Equity and other inves... Goodwill 14,130 26,132 25,217 6,125 7,964 27,374 41,463 (16,246) 30,653 25,217 305 151 206 469 Intangible assets Deferred income taxes Prepaid pension costs Other long-term assets Total non-current asse... Total assets 1,122 471 32,980 31,775 264 26.132 48,163 27,317 41,404 40,262 Liabilities and stockh... 162 Type here to search o Ei e E E S 5:34 PM 4/2/2020 " 3 G ACG2071: Principles of x r Connect - Class: Financi x M MHE Reader X Financial Statements-2. C Get Homework Help W X Q How to take a screensh x + - ] X E c File C:/Users/TEMP/Downloads/FinancialStatements-2.pdf 41,404 Liabilities and stockh... 48,163 Uabilities 41,404 27,407 11,736 Current liabilities Short-term debt Accounts payable Taxes payable . 31,605 14,031 2,994 7,056 896 2,853 44,553 28,322 12,777 1,160 7,683 890 2,772 272 7,759 40,262 40,262 27,305 12,622 815 7,418 1,076 2,179 1,134 12,622 14,683 11,945 823 576 1,504 1,806 Accrued liabilities Other current liabilit... Total current liabilit... 232 11,736 Non-current liabilitie... 12,777 15.545 14,031 17,574 14,654 1,311 15,671 12,705 1,321 151 54 1.861 12,622 1,433 115 1,375 15,545 28,322 16,231 1,609 17,574 31,605 16,558 Long-term debt Deferred taxes liabili... Pensions and other ben... Other long-term labil... Total non-current liab... Total liabilities Stockholders' equity Common stock Additional paid in cap... Retained earnings Accumulated other comp... Total stockholders' eq... Total abilities and 14,683 15,671 27,407 13,997 27,305 12,957 50 3,925 13,155 (576) 16,558 48,163 4,470 12,599 (891) 16,231 4,899 9,644 (599) 13,997 41,404 5,348 8,188 (629) 12,957 40,262 We value your feedback. Let us know what you think x FinancialStatements-2.p C Get Homework Help W x | Q How to take a screensh x | + - X ACG2071: Principles of * Connect - Class: Financi * M MHE Reader File C:/Users/TEMP/Downloads/FinancialStatements-2.pdf E Target Corp TGT Income Statement Balance Sheet Cash Flow Statement Type Annual Data Type As of Reported Period 5 Years Show Report Dates Ascending Data Scroll View Ro, Fiscal year ends in January USD in Mon except per share data Ravenue Cost of revenue 2016-01 73,795 51,997 Gross profit Operating expenses Sales, General and adm... Other operating expens... Total operating expans... Operating Income 2013-01 73,301 51,035 22,266 16,895 14,914 1,981 16,895 5,371 2014-01 72,596 51,160 21,436 17,207 15,375 1,832 17,207 4,229 2015-01 72,618 51,278 21,340 16,805 14,676 2,129 16,805 4,535 21,788 16,878 14,665 2.213 16,878 4,910 762 1,126 Interest Expense Other income (expense) Income before income t... 4,609 3,103 (882) 3,653 4,923 Provision for income t... Net Income from contin... 1,610 2,999 1,132 1.971 1,204 2,449 1,602 3,321 Net Income from discon... Net Income 2,999 1,971 (4,065) (1,636) 3.363 X M MHE Reader 5 ACG2071: Principles of Manag Financial Statements-2.pdf e r Connect - Class: Financial and X x + C Get Homework Help With Che X - 0 X E C File C:/Users/TEMP/Downloads/Financial Statements-2.pdf Wal-Mart Stores Inc WMT Income Statement Balance Sheet Cash Flow Data Scrol View Statement Type Annual Data Type As of Reported Period 5 Years Show Report Dates Ascending Rounding Export scal year ands nary USD in R ecept per share at Assets 2012-01 193,406 54,975 6,550 2015-01 203,706 63,278 2016-01 199,581 60,239 8.705 Current assets 2014-01 204,752 61,165 7,281 7,281 7,281 Cash 9,135 Cash and cash equivale... 2013-01 203,105 59,940 7,781 7,781 7,781 6,768 43,803 1,588 9.135 8,705 Total cash 8,705 6,550 6,550 5.937 40,714 1,685 9,135 6,778 Receivables 5,624 Inventores 6,677 44,858 1.909 45.141 2,224 44,469 1.441 Prepaid expenses Other current assets 460 Total current assets 61.185 60,239 Non-current assets Property, plant and eq... Land Fixtures and equipment Other properties Property and equipment... Accumulated Depreciati... Property, plant and eq... Goodwill 54,975 138,431 112,324 23,499 41,916 95,523 160,938 (48,614) 112,324 20,651 59,940 143,165 116,681 25,612 43,699 102,413 171,724 (55,043) 116,681 20,497 143,566 117,907 26,184 45.755 106,738 178,678 (60,771) 117,907 19,510 63,278 140,428 116,655 26,261 47,851 108.522 182,634 (65,979) 116,655 18,102 139,342 116,516 25,624 49,950 112,480 188,054 (71,538) 116,516 16,695 Other long-term assets Total non-current asse... Total assets Labtes and stockich... 5,456 138,431 193,406 193,406 122,091 62,300 6,022 326 Liabilities Current abilities Short-term debt Capital leases Accounts payable 5,987 143,165 203,105 203,105 126,762 71,818 12,392 327 38,080 5,062 15.957 6,149 143,566 204,751 204,751 128,496 69,345 11,773 309 37,415 3.520 16,239 5,671 140,428 203,706 203,706 122,312 65,272 6,402 287 38.410 3,613 16,560 6,131 139,342 199,581 199,581 119,035 64,619 5,453 551 38,487 3,065 17,063 36.609 1,164 18,154 Taxes payable Accrued abilities Other current liabifit... Total current liabilit... 62,300 71,818 69,345 65,272 64,619 Type here to search ^ E . (1) 2/12/2020 S ACG2071: Principles of Managex Connect - Class: Financial and x M MHE Reader X Financial Statements-2.pdf X C Get Homework Help With Che x + - X F C File C:/Users/TEMP/Downloads/Financial Statements-2.pdf 39 69,345 65,272 57,040 41,086 VU UUTTURE SU Total current Wabilit... Non-current liabilitie... Long-term debt Capital leases Deferred taxes liabili... Minority interest Other long-term liabil... Total non-current Nab... 59,151 41,771 2,788 8,017 64,619 54,416 38,214 5,816 7,321 3,065 2,606 8,805 71,818 54,944 38,394 3,023 7,613 5,395 519 54,944 126,762 76,343 5,084 62,300 59,791 44,070 3,009 7.862 4,446 404 59,791 122,091 71 315 342 3,692 68,691 (1,410) 71,315 193,406 4,543 Total liabilities 59,151 128,496 76,255 332 323 Stockholders' equity Common stock Additional pald-in cap... Retained earnings Accumulated other comp... Total stockholders' .. Total Habilities and ... 3,620 72,978 (587) 76,343 203,105 2,362 76,566 (2,996) 76,255 204,751 57,040 122,312 81,394 323 2,462 85.777 (7,168) 81,394 203,706 54,416 119,035 80,546 317 1,805 90,021 (11,597) 80,546 199,581 . Type here to search ^ Et 5:52 PM 1) 4/2/2020 + - 0 X 5 ACG2071: Principles of Managx Em Connect - Class: Financial and C Get Homework Help With Che X X M MHE Reader X Financial Statements-2.pdf C File C:/Users/TEMP/Downloads/Financial Statements-2.pdf Wal-Mart Stores Inc WMT Add to Portfolio Get E-mail Alerts Print This Page POF Report Data Question Quote Chart Stock Analysis Performance Key Ratios Financials Valuation Income Statement Balance Sheet Cash Flow Insiders Ownership Fings Bonds Statement Type Annual Data Scroll Data Type As of Reported Perted 5 Years Show Report Dates Ascending View Rounding Export Fiscal year ends in January USD in Miten except per share data 2015-01 485,651 365,086 Revenue Cost of revenue Gross profit Operating expenses Sales, General and adm... Total operating expens... 120,565 2012-01 446,950 335,127 111,823 85,265 85,265 85,265 25,558 2013-01 469,162 352.488 116,674 88,873 88.873 88,873 27,801 2014-01 475,294 358,069 118,225 91,353 91,353 91,353 26,872 2016-01 482,130 360,964 121,146 97,041 97,041 97,041 24,105 93,418 93,418 93,418 27,147 Operating income 2,322 2,335 2,548 Interest Expense Other income (expense) Income before income t.. 162 2,251 187 25,737 119 2.461 113 24,799 24,398 24,656 21,638 7,981 8,105 7.985 6.558 386 673 736 Provision for income t... Minority interest Other income Net income from contin... 7,944 688 688 16,454 757 752 673 385 736 16,814 17,756 16,551 15,080 Net income from discon... Other (67) (688) 15.699 (757) 16,999 (673) 16.022 285 (736) 16,363 (386) 14,694 Net Income ^E (1) 272/2020 33 Type here to search Worksheet-3 - Compatibility Mode - Saved Sign in - o X AutoSave Of HOSE File Home Insert Page Layout Formulas Data Review View Help Search Comments X === Arial - 10 BIU - 2. -A A A. Wrap Text Merge & Center - General $ - % , Share AutoSumA Fill- Sort & Find & Clear Filter - Select Paste " 3 , apo - , 40.00 Insert Delete Format Ideas Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number Cells Editing Ideas A1 X for Student Name: _Chase L M N O LA F G H I J K Calculate ratios and circle or highlight with color which ratio is best. Which company has the best Profit Margin, etc? Show the numerator and denominator in columns F & I Target Wal-Mart In this column, write the elements 1 Student Name: Chase 2 3 Managerial Accounting 4 Ratios for 2016 data: 5 Ratio Categories 6 Profitability 7 that are measured in the ratio. I have completed five as examples: Profit Margin Net Income 3363000 14694000 0.05% Revenue 73785000 Return on Total Assets 9 Profitability 10 Return on Common Stockholders' Equity 11 12 Profitability 13 14 15 Profitability 16 17 Earnings Per Share of Common Stock Net Income - Preferred Dividends N umber of shares of common stock outstanding P/E ratio 18 Analyzing stock Fin Ratio Worksheet o Type here to search Ei e ? s 9 0 A x - - + 100% 5:44 PM r 1) 4/2/20203 Worksheet-3 - Compatibility Mode - Saved Sign in - o X AutoSave Of HOSE File Home Insert Page Layout Formulas Data Review View Help Search Comments X - 10 Arial -A A === Wrap Text E AutoSum General | PP SEX 2 Share 48 0 Sort & Find & Filter - Select Editing % Paste - BIU - - A- E E E E Merge & Center - $ , % 49.00 Insert Delete Format Fill- Clear Ideas Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number Cells Ideas X for Student Name: _Chase_ B C D E F G H I J K L M N O LA P/E ratio (Price-Earnings) Current Ratio 18 Analyzing stock 19 20 21 Liquidity 22 (ability to pay current liabilities) 23 24 Profitability 25 (stock value) Book Value per share Total SHE (common stock) Number of shares of common stock outstanding 26 Debt-to-Equity Ratio 27 Solvency 28 29 30 Turnover efficiency Inventory Turnover Cost of Revenue Average Inventory 32 33 Turnover efficiency AR Turnover Revenue Fin Ratio Worksheet - + 100% Type here to search o Ei e = 9 x 5:45 PM - Ed ( 1) 4/2/2020 33 Worksheet-3 - Compatibility Mode - Saved Sign in - o X AutoSave Of HOSE File Home Insert Page Layout Formulas Data Review View Help Search Comments X - 10 Arial -A A === E AutoSum Wrap Text General Share 48 0 Sort & Find & Filter - Select Editing % Paste " - - A- BIU - E E E E Merge & Center - Fill- Clear $ , % 49.00 Insert Delete Format Ideas Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number Cells Ideas X for Student Name: _Chase_ F G H I J K L M N O LA AR Turnover 33 Turnover efficiency 34 35 Revenue Average Receivables (Accounts Receivable) 36 Turnover efficiency Total Asset Turnover 37 39 40 41 1. Write the ratio elements in the middle column of the worksheet: For Example, Return on Sales is "Net Income / Revenue." 42 *Neither company has issued Preferred Stock so there won't be any Preferred Dividends* 43 *Cost of Revenue is another term for Cost of Goods Sold* 44 *Revenue is another term for Net Sales 45 46 2. Calculate the Financial Ratios for Target and Wal-Mart for Fiscal Year 2016 and enter data and ratios onto your worksheet. 47 Round your answers to two decimal places. 48 49 3. On the worksheet, circle or highlight which ratio is the 'best' when compared between the two corporations. 50 51 Use the following data in addition to the financial statements: 52 Target market price of $72.23 and Wal-Mart market price of $69.12 53 Target number of outstanding common shares is 561.7 in millions 54 Wal-Mart number of outstanding common shares is 3073.19 in millions Fin Ratio Worksheet - + 100% 5:46 PM Type here to search o 0 -- - Ed ( 1) 4/2/2020 33 e me 9x AutoSave Of H Worksheet-3 - Compatibility Mode - Saved Sign in 7 - 0 X = Page Layout File Home Insert Formulas Data Review View Help Search Comments Arial BI U - 10 - A A - - A- === S Wrap Text 3 Merge & Center General 0,0% - 40.00 Paste La I X 2 Insert Delete Format Share AutoSum 47 0 Fill- Sort & Find & Clear Filter Select Editing 2 P D Conditional Format as Cell Formatting Table Styles Styles E , Ideas Clipboard Font Alignment Number Cells Ideas A1 X for Student Name: _Chase C D F G H I J K L M N O LA 51 Use the following data in addition to the financial statements: 52 Target market price of $72.23 and Wal-Mart market price of $69.12 53 Target number of outstanding common shares is 561.7 in millions 54 Wal-Mart number of outstanding common shares is 3073.19 in millions 55 56 4. Which stock would you buy? 57 Write three complete paragraphs, addressing the strengths and weaknesses of each company and your 58 reasoning for purchasing Target or Wal-Mart stock. 59 60 Please read instruction page for additional information
