Revenues FedEx CORPORATION Income Statement Service Revenue (in millions) Interest Revenue Total Revenues Expenses Depreciation Expense 5 Income Tax Expense E Interest Expense Office Expense 58 Rent Expense 59 Repairs and Maintenance Expense 60 63 Salaries and Wages Expense Transportation Expense 62 63 Total Expenses 64 Net Income 66 3-b. Prepare a statement of retained earnings for the year ended May 31, 2019. 67 (Use a cell reference to link this Enancial statement to the relevant cell in the preceding financial statement.) 60 (Enter your answers in millions, not in whole dollars.) (Negative amounts or amounts to be deducted should be input and displayed as negative values.) RIC X A C 120 29 Income Tax Expense 20 Income Tax Payable 3,300 21 Interest Expense 22 Interest Receivable 23 Interest Revenue 24 Notes Payable (long-term) 590 200 60 27,600 25 Notes Payable (short-term) 1,000 25 Office Expenses 13,760 27 Prepaid Rent 900 2 Rent Expense 3,300 29 Repairs and Maintenance Expense 2,800 30 Retained Earnings 14,770 31 Salaries and Wages Expense 24,800 32 Salaries and Wages Payable 1,740 33 Service Revenue 69,700 34 Supplies 35 Transportation Expense 36. 500 20,550 $153,430 $153,430 D 37 3 Required: 393-a. Prepare an income statement for the year ended May 31, 2019. 42 (Use a cell reference to link this financial statement to the relevant cell in the preceding financial statement.) 41 (Enter your answers in millions, not in whole dollars.) 42 (All answers should be input and displayed as positive values.) > 5 Intro expected value and variance - STAT 1430, section All, Spring... ezto.mheducation.com M Question 3 - Chapter 4 Excel Assignment Homework 5 - Connect This question has been opened in a new tab. In order to continue your assignment, please save your Excel question. 3 [The following information applies to the questions displayed below.] FedEx Corporation reported its balance sheet at May 31, 2019. Assume the following alphabetically listed accounts were included in its trial balance immediately prior to preparing the financial statements. FedEx CORPORATION Adjusted Trial Balance Part 3 of 3 10 points eBook References Accounts Payable Accounts Receivable Cash Accumulated Depreciation Depreciation Expense Common Stock Dividends Equipment Goodwill Income Tax Expense Income Tax Payable Interest Expense Interest Receivable Interest Revenue At May 31, 2019 (millions of dollars) Debit Credit $ 2,960 $ 9,200 29,100 2,300 3,200 3,300 710 59,500 10,900 120 3,300 590 200 60 Notes Payable (long-term) Notes Payable (short-term) 27,600 1,000 Office Expenses 13,760 Prepaid Rent 900 Rent Expense 3,300 Repairs and Maintenance Expense 2,800 Retained Earnings 14,770 Salaries and Wages Expense 24,800 Salaries and Wages Payable Service Revenue 1,740 69,700 Supplies 500 Transportation Expense 20,550 $153,430 $153,430 < 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. # $ 1 2 3 4 de5 % 96 MacBook Pro Q W E R T Y 28 & 7 8*> + 9 0 0 P A S D F G H J K L M Integra Z 0 1430 Chp 5 Intro expected value and variance - STAT 1430, section All, Spring... McGraw Hill Excel Question - Saved ezto.mheducation.com M Question 3- Chapter 4 Excel Assignment Homework 5 - Connect Search for tools, help, and more (Option + Q) File Home Insert Share Formulas Data Review View Help Draw V Calibri (Body) 11 V BA *** 11R x 1C Xv fx A B C D Number $ +000 .00 00.0 | E F G H 1 3 4 5 6 2 FedEx Corporation reported its balance sheet at May 31, 2019. Assume the following alphabetically listed accounts were included in its trial balance immediately prior to preparing the financial statements. FedEx CORPORATION Adjusted Trial Balance 7 At May 31, 2019 8 (millions of dollars) 9 Debit Credit 10 Accounts Payable $2,960 11 Accounts Receivable $9,200 12 Accumulated Depreciation 29,100 13 Cash 2,300 14 Common Stock 3,200 15 Depreciation Expense 3,300 16 Dividends 710 17 Equipment 59,500 18 Goodwill 10,900 19 Income Tax Expense 120 20 Income Tax Payable 3,300 21 Interest Expense 22 Interest Receivable 590 200 23 Interest Revenue 24 Notes Payable (long-term) 25 Notes Payable (short-term) 26 Office Expenses 27 Prepaid Rent 78 > 13,760 900 Rent Fynence =Grading Worksheet + Workbook Statistics 3.300 esc 1 @ 2 #3 60 27,600 1,000 $ $ 4 % do 5 Bc + MacBook Pro 96 Q W E R T Y tab A lock S D LL & 29 7 He 8 * 9 C 0 G H J K 1430 Chp 5 Intro expected value and variance - STAT 1430, section All, Spring... McGraw Hill Excel Question - Saved ezto.mheducation.com M Question 3 - Chapter 4 Excel Assignment Homework 5 - Connect Search for tools, help, and more (Option + Q) File Home Share Insert Formulas Data Review View Help Draw V Calibri (Body) 11 V Bvvv... ab Number $ 5000 .00 .0 0 1430 Chp 5 Intro expected value and variance - STAT 1430, section All, Spring... McGraw Hill Excel Question - Saved ezto.mheducation.com M Question 3 - Chapter 4 Excel Assignment Homework 5 - Connect Search for tools, help, and more (Option + Q) File Home Insert Formulas Share Data Review View Help Draw Calibri (Body) v 11 v BA~ V Number V $ 500 Bc He 3 205 S4 $ % 96 & 29 7 8 * 61 ) 0 Q tab W E R T Y U 1 0 A lock S D F G H J K < GO 1430 Chp 5 Intro expected value and variance - STAT 1430, section All, Spring... McGraw Hill Excel Question Saved ezto.mheducation.com M Question 3 - Chapter 4 Excel Assignment Homework 5 - Connect Search for tools, help, and more (Option + Q) File Home Share Insert Review Data Formulas View Help Draw Calibri (Body) 11 V B~ Av 11Rx 1C V XVfx A B C D 57 55 Office Expense Rent Expense 58 Repairs and Maintenance 59 Expense 60 Salaries and Wages Expense 61 Transportation Expense 62 63 Total Expenses V Number V $ 600 .00 .00 .0 077 E FL G H J + 64 Net Income 65 66 3-b. Prepare a statement of retained earnings for the year ended May 31, 2019. 67 (Use a cell reference to link this financial statement to the relevant cell in the preceding financial statement.) 68 (Enter your answers in millions, not in whole dollars.) 69 (Negative amounts or amounts to be deducted should be input and displayed as negative values.) 70 71 72 73 74 FedEx CORPORATION Statement of Retained Earnings For the Year Ended May 31, 2019 (in millions) 75 Beginning Balance, 6/1/2018 76 Add: Net Income 77 Less: Dividends 78 Ending Balance, 5/31/2019 79 80 3-c. Prepare a classified balance sheet at May 31, 2019. 81 (Use a cell reference to link this financial statement to the relevant cell in the preceding financial statement.) 82 (Enter your answers in millions, not in whole dollars.) Alnanti mente amounts to ha dadunted child him.. dil tab =Grading Worksheet Workbook Statistics esc 1 e2 + Q W lock A S > Bc do 5 $ % 674 # 3 E D MacBook Pro & 6 29 7 R T Y U LL He 8 * 9 0 0 G H J K