I have to determine the Price earnings ratio for a company. I have to use an excel formula in my box. The formula I have is share price/earnings per share. Please see attached sheets. I am getting an error message. This is my formula ='P & G Stock prices'!E26/'P& G Income Statements'!B50. So e26 would be $124.90/earnings per share I calculated (see balance sheet) .08 I can't figure out what I am doing wrong!!

AutoSave Off module FINAL - Excel Search A BELLI, NANCY IT X File Home Insert Page Layout Formulas Data Review View Help Share Comments Arial AutoSum 10 AA Number 1 AT TIX AY o 5 X Cut LECopy Format Painter === a Wrap Text EEE 2 Merge & Center Fill Paste CA $ %) Insert Delete Format Ideas Sensitivity Conditional Format as Cell Formatting Table Styles Clear Sort & Find & Filter Select Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity J25 fx ='P & G Stock prices'!E26/'P& G Income Statements'!B50 E G H I J K L L M N o Q F Not Qualified D Not Qualified Yes Millions 2569 9281 4686 1335 588 2815 4738 Yes Millions 5569 9568 4594 1308 529 2787 4624 2019 0.75 Ratios 2018 0.83 1.24 2017 0.88 1.16 3116 1.42 Current Ratio Debt to Income Free Cash Flow Earnings Per Share Price Earnings Ra ! Return on Equity Net Profit Margin 0.19 0.28 2046 2139 0.08 87.343 8% 6% 19% 15% 28% 24% B Audit Status Not 14 Qualified 15 Consolidated Yes 16 Scale Millions 17 Cash & cash equivalents 4239 18 Available-for-sale investment securities 6048 19 Accounts receivable 4951 20 Materials & Supplies 1289 21 Work in process 612 22 Finished goods 23 Total inventories 5017 24 Deferred income taxes - 25 Prepaid expenses & other current assets 2218 26 Current assets held for sale 27 Total current assets 22473 28 Buildings 7746 29 Machinery & equipment 32263 30 Land 805 31 Construction in progress 2579 32 Total property, plant & equipment 43393 33 Less: accumulated depreciation 22122 34 Property, plant & equipment, net 21271 35 Goodwill 40273 36 Trademark & other intangible assets, net 24215 37 Other noncurrent assets 6863 38 Total assets 115095 39 Accounts payable 11260 40 Marketing & promotion 4299 41 Compensation expenses 1623 42 Restructuring reserves 468 43 Taxes payable 341 44 Legal & environmental 45 Other accrued & other liabilities 2323 46 Accrued & other liabilities 9054 17 lucrat liabilitian bald far asla P&G Balance Sheets P& G Income Statements P & G Cash Flow 23320 7188 30595 841 3223 41847 21247 20600 45175 23902 5313 118310 10344 3208 1298 513 268 156 2027 7470 26494 6943 29505 765 2935 40148 20255 19893 44699 24187 5133 120406 9632 2792 1344 277 449 168 1994 7024 P & G Stock prices KMB Balance Sheets KMB II ... + Ready B + 100% Type here to search e 9 )) #9 4:16 PM 2/10/2021 AutoSave Off He module FINAL - Excel Search A BELLI, NANCY IT X File Home Insert Page Layout Formulas Data Review View Help Share Comments AutoSum ~10 - A AI === ab Wrap Text Number TT 47 X Cut LECopy Format Painter s Fill Paste 60 EEEE Merge & Center BIU A Ideas $ % Insert Delete Format Conditional Format as Cell Formatting Table Styles Sensitivity Clear Sort & Find & Filter Select Editing Clipboard Font Alignment Number Styles Cells Ideas Sensitivity A24 X ='P & G Stock prices": B D E F. G H J K L M N O R. S T V WA Low 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 Date Open High Close 12/31/2019 124.43 124.99 123.95 124.9 11/29/2019 121.99 122.63 121.71 122.06 10/31/2019 124.79 125.448 123.355 124.51 09/30/2019 124.57 125.36 124.13 124.38 08/30/2019 121.96 122 119.51 120.23 07/31/2019 119.66 120.68 117.07 118.04 06/28/2019 111.86 111.96 109.02 109.65 05/31/2019 104.89 104.9 102.405 102.91 04/30/2019 104.86 106.62 104.655 106.48 03/29/2019 103.86 104.15 103.11 104.05 02/28/2019 98.91 99.2 98.08 98.55 01/31/2019 94.43 96.81 94.08 96.47 12/31/2018 91.63 92.18 91.15 91.92 11/30/2018 93.18 94.65 92.75 94.51 10/31/2018 88.77 89.32 87.27 88.68 09/28/2018 83.03 83.29 82.79 83.23 08/31/2018 83.35 83.53 82.39 82.95 07/31/2018 80.39 80.98 79.43 80.88 06/29/2018 77.93 78.54 77.29 78.06 05/31/2018 74.67 74.69 72.8 73.17 04/30/2018 72.91 72.915 72.16 72.34 03/29/2018 79.43 80.49 79.1799 79.28 02/28/2018 80.68 80.79 78.5 78.52 01/31/2018 86.81 87.41 86.075 86.34 12/29/2017 92 24 92.46 91.88 91.88 11/30/2017 89.35 90.37 89.21 89.99 10/31/2017 86.49 86.5 85.72 86.34 09/29/2017 90.97 91.43 90.7 90.98 08/31/2017 91.89 92.39 91.84 92.27 07/31/2017 90.21 91.07 90.21 90.82 06/30/2017 87.05 87.47 87 87.15 05/31/2017 87.67 88.35 87.45 88.09 07 07c 0716 0722 P&G Balance Sheets P& G Income Statements Price Move (%) 2.33 -1.97 0.1 3.45 1.86 7.65 6.55 -3.35 2.34 5.58 2.16 4.95 -2.74 6.57 6.55 0.34 2.56 3.61 6.68 1.15 -8.75 0.97 -9.06 -6.03 2.1 4.23 -5.1 -1.4 1.6 4.21 -1.07 0.87 CO 04/2010 17 P&G Cash Flow P & G Stock prices KMB Balance Sheets KMB II ... + Point O + 100% Type here to search e a 4:17 PM 2/10/2021 AutoSave Off module FINAL - Excel Search A BELLI, NANCY IT X File Home Insert Page Layout Formulas Data Review View Help Share Comments Arial AutoSum 10 AA Number 1 AT TIX AY o 5 X Cut LECopy Format Painter === a Wrap Text EEE 2 Merge & Center Fill Paste CA $ %) Insert Delete Format Ideas Sensitivity Conditional Format as Cell Formatting Table Styles Clear Sort & Find & Filter Select Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity J25 fx ='P & G Stock prices'!E26/'P& G Income Statements'!B50 E G H I J K L L M N o Q F Not Qualified D Not Qualified Yes Millions 2569 9281 4686 1335 588 2815 4738 Yes Millions 5569 9568 4594 1308 529 2787 4624 2019 0.75 Ratios 2018 0.83 1.24 2017 0.88 1.16 3116 1.42 Current Ratio Debt to Income Free Cash Flow Earnings Per Share Price Earnings Ra ! Return on Equity Net Profit Margin 0.19 0.28 2046 2139 0.08 87.343 8% 6% 19% 15% 28% 24% B Audit Status Not 14 Qualified 15 Consolidated Yes 16 Scale Millions 17 Cash & cash equivalents 4239 18 Available-for-sale investment securities 6048 19 Accounts receivable 4951 20 Materials & Supplies 1289 21 Work in process 612 22 Finished goods 23 Total inventories 5017 24 Deferred income taxes - 25 Prepaid expenses & other current assets 2218 26 Current assets held for sale 27 Total current assets 22473 28 Buildings 7746 29 Machinery & equipment 32263 30 Land 805 31 Construction in progress 2579 32 Total property, plant & equipment 43393 33 Less: accumulated depreciation 22122 34 Property, plant & equipment, net 21271 35 Goodwill 40273 36 Trademark & other intangible assets, net 24215 37 Other noncurrent assets 6863 38 Total assets 115095 39 Accounts payable 11260 40 Marketing & promotion 4299 41 Compensation expenses 1623 42 Restructuring reserves 468 43 Taxes payable 341 44 Legal & environmental 45 Other accrued & other liabilities 2323 46 Accrued & other liabilities 9054 17 lucrat liabilitian bald far asla P&G Balance Sheets P& G Income Statements P & G Cash Flow 23320 7188 30595 841 3223 41847 21247 20600 45175 23902 5313 118310 10344 3208 1298 513 268 156 2027 7470 26494 6943 29505 765 2935 40148 20255 19893 44699 24187 5133 120406 9632 2792 1344 277 449 168 1994 7024 P & G Stock prices KMB Balance Sheets KMB II ... + Ready B + 100% Type here to search e 9 )) #9 4:16 PM 2/10/2021 AutoSave Off He module FINAL - Excel Search A BELLI, NANCY IT X File Home Insert Page Layout Formulas Data Review View Help Share Comments AutoSum ~10 - A AI === ab Wrap Text Number TT 47 X Cut LECopy Format Painter s Fill Paste 60 EEEE Merge & Center BIU A Ideas $ % Insert Delete Format Conditional Format as Cell Formatting Table Styles Sensitivity Clear Sort & Find & Filter Select Editing Clipboard Font Alignment Number Styles Cells Ideas Sensitivity A24 X ='P & G Stock prices": B D E F. G H J K L M N O R. S T V WA Low 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 Date Open High Close 12/31/2019 124.43 124.99 123.95 124.9 11/29/2019 121.99 122.63 121.71 122.06 10/31/2019 124.79 125.448 123.355 124.51 09/30/2019 124.57 125.36 124.13 124.38 08/30/2019 121.96 122 119.51 120.23 07/31/2019 119.66 120.68 117.07 118.04 06/28/2019 111.86 111.96 109.02 109.65 05/31/2019 104.89 104.9 102.405 102.91 04/30/2019 104.86 106.62 104.655 106.48 03/29/2019 103.86 104.15 103.11 104.05 02/28/2019 98.91 99.2 98.08 98.55 01/31/2019 94.43 96.81 94.08 96.47 12/31/2018 91.63 92.18 91.15 91.92 11/30/2018 93.18 94.65 92.75 94.51 10/31/2018 88.77 89.32 87.27 88.68 09/28/2018 83.03 83.29 82.79 83.23 08/31/2018 83.35 83.53 82.39 82.95 07/31/2018 80.39 80.98 79.43 80.88 06/29/2018 77.93 78.54 77.29 78.06 05/31/2018 74.67 74.69 72.8 73.17 04/30/2018 72.91 72.915 72.16 72.34 03/29/2018 79.43 80.49 79.1799 79.28 02/28/2018 80.68 80.79 78.5 78.52 01/31/2018 86.81 87.41 86.075 86.34 12/29/2017 92 24 92.46 91.88 91.88 11/30/2017 89.35 90.37 89.21 89.99 10/31/2017 86.49 86.5 85.72 86.34 09/29/2017 90.97 91.43 90.7 90.98 08/31/2017 91.89 92.39 91.84 92.27 07/31/2017 90.21 91.07 90.21 90.82 06/30/2017 87.05 87.47 87 87.15 05/31/2017 87.67 88.35 87.45 88.09 07 07c 0716 0722 P&G Balance Sheets P& G Income Statements Price Move (%) 2.33 -1.97 0.1 3.45 1.86 7.65 6.55 -3.35 2.34 5.58 2.16 4.95 -2.74 6.57 6.55 0.34 2.56 3.61 6.68 1.15 -8.75 0.97 -9.06 -6.03 2.1 4.23 -5.1 -1.4 1.6 4.21 -1.07 0.87 CO 04/2010 17 P&G Cash Flow P & G Stock prices KMB Balance Sheets KMB II ... + Point O + 100% Type here to search e a 4:17 PM 2/10/2021