For the following items, provide the most recent values as well as which statement they are listed on "Most values are listed as 'n millions' or similar. Leave them this way, and note it at the bottom of the values column Statement Item Value le: IS, BS 7 Net Income 8 Total abilities 9 Total Assets 10 Total Current Assets 11 Total Current Liabilities 12 Cash & Equivalents 13 Short-Term Invesments 14 Net Current Receivables 15 Net Credit Sales (or Net Sales/Revenues) 16 Net Sales /Revenues 17 Income Tax Expense 18 Interest Expense 19 Preferred Dividends (o if none) 20 Market Price per Share of Stock $ 1,847.84 (Use the value provided on the assignment page) 21 Average Total Assets (Show calculation, average of the two most recent years) 22 Cost of Goods Sold (cost of sales) 23 Average Merchandise Inventory (Show calculation, average of the two most recent years) 24 Average Net Accounts Receivable (Show calculation, average of the two most recent years) 25 Average Common Shares Outstanding (Show calculation, average of the two most recent years) 26 Average Shareholder's Equity (Show calculation, average of the two most recent years) For this part of your company project, you'll download the Excel file and fill in the Project Part 3' sheet of the workbook. Fill in all blue cells in the sheet and upload when complete. You may email me drafts for review prior to the weekend. For one of the questions, you will need the market price of shares. Use the values listed below. Do not use current prices for shares; we want the share price that represents the reporting period. Share prices: Amazon: $1,847.84 Apple: $218.82 Walmart: $113.02 Microsoft: $133.96 Note: Once these are graded update the values in your Excel file. You will use the same spreadsheet to complete parts d and later in the semester Email me with any questions Company Annual Report Links: Amazon Apple Microsoft Walmart Company Project Excel File.xlsx August 19 2020, 7:07 PM Submission status For the following items, provide the most recent values as well as which statement they are listed on "Most values are listed as 'n millions' or similar. Leave them this way, and note it at the bottom of the values column Statement Item Value le: IS, BS 7 Net Income 8 Total abilities 9 Total Assets 10 Total Current Assets 11 Total Current Liabilities 12 Cash & Equivalents 13 Short-Term Invesments 14 Net Current Receivables 15 Net Credit Sales (or Net Sales/Revenues) 16 Net Sales /Revenues 17 Income Tax Expense 18 Interest Expense 19 Preferred Dividends (o if none) 20 Market Price per Share of Stock $ 1,847.84 (Use the value provided on the assignment page) 21 Average Total Assets (Show calculation, average of the two most recent years) 22 Cost of Goods Sold (cost of sales) 23 Average Merchandise Inventory (Show calculation, average of the two most recent years) 24 Average Net Accounts Receivable (Show calculation, average of the two most recent years) 25 Average Common Shares Outstanding (Show calculation, average of the two most recent years) 26 Average Shareholder's Equity (Show calculation, average of the two most recent years) For this part of your company project, you'll download the Excel file and fill in the Project Part 3' sheet of the workbook. Fill in all blue cells in the sheet and upload when complete. You may email me drafts for review prior to the weekend. For one of the questions, you will need the market price of shares. Use the values listed below. Do not use current prices for shares; we want the share price that represents the reporting period. Share prices: Amazon: $1,847.84 Apple: $218.82 Walmart: $113.02 Microsoft: $133.96 Note: Once these are graded update the values in your Excel file. You will use the same spreadsheet to complete parts d and later in the semester Email me with any questions Company Annual Report Links: Amazon Apple Microsoft Walmart Company Project Excel File.xlsx August 19 2020, 7:07 PM Submission status
