Search for tools, help, and more (Option + Q) McGraw Hill Excel Question - Saved View Draw File Insert Share Formulas Data Review Help Home Calibri ( Body) v 11 v By My A v ... Ev ab ] General X V fx Accessibility tab summary: An adjusted trial balance for FedEx Corporation is presented in cells A5 A1 A B D E F 64 Net Income $540 1 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 FedEx CORPORATION 72 Statement of Retained Earnings 73 For the Year Ended May 31, 2019 74 (in millions 75 Beginning Balance, 6/1/2018 $14,770 + 76 Add: Net Income 540 77 Less: Dividends 710 78 Ending Balance, 5/31/2019 $14,600 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.) 83 (Negative amounts or amounts to be deducted should be input and displayed as negative values.) 84 85 FedEx CORPORATION 86 Balance Sheet 87 May 31 88 (in millions) 89 Assets Liabilities 90 Current Assets 91 Current Liabilities Cash $2,300 Accounts Payable $2,960 = Grading Worksheet + Workbook Statistics MacBook Pro C Q 3 # N 9 % 3McGraw Hill Excel Question - Saved Search for tools, help, and more (Option + Q) X File Home Insert Share Formulas Data Review View Help Draw Calibri (Body) v 11 B V V A v ... Ev aby General A1 X V fx Accessibility tab summary: An adjusted trial balance for FedEx Corporation is presented in cells A5 A B D Service Revenue by, /UU 50 Interest Revenue 60 51 52 Total Revenues 59,760 53 Expenses 54 Depreciation Expense 3,300 55 Income Tax Expense 120 56 Interest Expense 590 57 Office Expense 13,760 58 Rent Expense 3,300 Repairs and Maintenance 59 Expense 2,800 + 60 Salaries and Wages Expense 24,800 61 Transportation Expense 20,550 62 63 Total Expenses 69,220 64 Net Income $540 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.) 62 (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 FedEx CORPORATION 72 Statement of Retained Earnings 73 For the Year Ended May 31, 2019 74 in millions Beginning Balance, 6/1/2018 $14,770 = A Grading Worksheet + Workbook Statistics MacBook Pro C Q 3 # % A W 4 5McGraw Hill Excel Question - Saved Search for tools, help, and more (Option + Q) X File Home Insert Share Formulas Data Review View Help Draw Calibri (Body) v 1 1 - B E . v Q V A v ... Ev ab y General A1 X V fx Accessibility tab summary: An adjusted trial balance for FedEx Corporation is presented in cells A5 A B G 38 Required: 39 3-a. Prepare an income statement for the year ended May 31, 2019. 40 (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.) 43 44 FedEx CORPORATION 45 Income Statement 46 47 (in millions) 48 Revenues + 49 Service Revenue $69,700 50 Interest Revenue 60 51 52 Total Revenues 69,760 Expense 54 Depreciation Expense 3,300 55 Income Tax Expense 120 56 Interest Expense 590 57 Office Expense 117 13,760 58 Rent Expense 3,300 59 Repairs and Maintenance Expense 2,800 60 Salaries and Wages Expense 24,800 61 Transportation Expense 20,550 62 63 Total Expenses 69,220 & Grading Worksheet + Workbook Statistics MacBook Pro > Q w # B N % & w 5X McGraw Hill Excel Question - Saved Search for tools, help, and more (Option + Q) File Home Insert Share Formulas Data Review View Help Draw Calibri (Body) v 1ly By by A v ... Ev ab Ev General A1 " X V fx Accessibility tab summary: An adjusted trial balance for FedEx Corporation is presented in cells A5 B D E F TICOTIC TOATayaDie A G 21 Interest Expense 590 22 Interest Receivable 200 23 Interest Revenue 60 24 Notes Payable (long-term) 27,600 25 Notes Payable (short-term) 1,000 26 Office Expenses 13,760 27 Prepaid Rent 900 28 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 500 35 Transportation Expense 20,550 36 $153,430 $153,430 37 38 Required: 39 3-a. Prepare an income statement for the year ended May 31, 2019. 40 (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.) 43 44 FedEx CORPORATION 45 Income Statement 46 47 (in millions) > Grading Worksheet + Workbook Statistics MacBook Pro Q 3 @ # % N W 4 5