Question

1 Approved Answer

Posted on Sep 19, 2024

2021-05 2020-05 2019-05 2018-05 2017-05 2016-05 Fed Ex Com Fiscal year ends in May. USD in millions. Assets Current assets Cash and cash equivalents Receivables

image text in transcribed

2021-05 2020-05 2019-05 2018-05 2017-05 2016-05 Fed Ex Com Fiscal year ends in May. USD in millions. Assets Current assets Cash and cash equivalents Receivables Inventories Prepaid expenses Total current assets Non-current assets - Gross property, plant and equipment Accumulated Depreciation Soodwill Intangible assets ther long-term assets Total non-current assets Total assets 7,087 12,069 587 837 20,580 4,881 10,102 572 828 16,383 2,319 9,116 553 1,098 13,086 3,265 8,481 525 1,070 13,341 3,969 7,599 514 546 12,628 3,534 7,252 496 707 11,989 70,077 (34,325) 6,992 15,383 4,070 62,197 82,777 65,024 (31,416) 6,372 13,917 3,257 57,154 73,537 59,511 (29,082) 6,884 600 3,404 41,317 54,403 55,121 (26,967) 6,973 480 3,382 38,989 52,330 50,626 (24,645) 7,154 529 2,260 35,924 48,552 47,018 (22,734) 6,747 1,008 2,036 34,075 46,064 146 3,841 7,465 2,208 13,660 51 3,269 5,101 1,923 10,344 964 3,030 3,634 1,385 9,013 1,342 2,977 4,375 933 9,627 22 2,752 4,363 781 7,918 29 2,944 4,231 804 8,008 Liabilities Current liabilities Short-term debt Accounts payable Accrued liabilities Other current liabilities Total current liabilities Non-current liabilities - Long-term debt Deferred taxes liabilities Accrued liabilities Pensions and other benefits ther long-term liabilities Total non-current liabilities Total liabilities 20,879 total debt, this should match the number you get on the Bond Sched, cell G31 20,733 3,927 15,805 3,501 983 44,949 58,609 21,952 3,162 14,299 5,019 466 44,898 55,242 16,617 2,821 1,998 5,095 1,102 27,633 36,646 15,243 2,867 1,905 2,187 1,085 23,287 32,914 14,909 2,485 1,631 4,487 1,049 24,561 32,479 13,838 1,567 1,469 6,227 1,171 24,272 32,280 32 3,356 32 2,892 25,216 18,371 Stockholders' equity Common stock Additional paid-in capital Retained earnings Treasury stock Accumulated other comprehensive income Total stockholders' equity Total liabilities and stockholders' equity 32 3,481 29,817 (8,430) (732) 24,168 82,777 (9,162) (1,147) 18,295 73,537 32 3,231 24,648 (9,289) (865) 17,757 54,403 32 3,117 24,823 (7,978) (578) 19,416 52,330 32 3,005 20,833 (7,382) (415) 16,073 48,552 (7,342) (169) 13,784 46,064 Fed Ex Corp (FDX) INCOME STATEMENT Fiscal year ends in May. USD in millions. 2021-05 2020-05 2019-05 2018-05 2017-05 2016-05 Revenue (Sales) Cost of revenue (Cost of goods sold) Gross profit (Gross margin) Sales, general and administrative Other operating expenses EBITDA Deprec and amort Operating income (EBIT) Interest Expense Taxable income Income tax expense Net Income 83,959 58,953 25,00 1,765 11,981 11,260 3,793 7,467 793 6,674 1,443 5,231 69,217 51,055 18,162 1,714 10,492 5,956 3,615 2,341 672 1,669 383 1,286 69,693 52,354 17,339 1,687 11,056 4,596 3,353 1,243 588 655 115 540 65,450 49,764 15,686 1,645 4,674 9,367 3,095 6,272 558 5,714 1,142 4,572 60,319 45,504 14,815 1,599 5,655 7,561 2,995 4,566 512 4,054 1,057 2,997 50,365 38,539 11,826 1,498 4,621 5,707 2,630 3,077 337 2,740 922 1,818 Name Maturity Year Current Price Coupon % Yield to Maturity % Weight Value $ (Mil) Weighted YTM % 100.215 92.100 2034 2026 2028 2029 2030 2031 2034 2035 2041 2043 2044 2045 2046 1.875% 3.250% 3.400% 4.200% 3.650% 2.400% 4.900% 3.900% 3.250% enior Secured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt (Foreign) enior Unsecured Debt (Foreign) enior Unsecured Debt (Foreign) enior Unsecured Debt (Foreign) enior Unsecured Debt (Foreign) ther Debt and Capital Leases Totals 89.370 100.506 99.598 100.406 98.218 85.172 99.865 81.070 93.333 78.171 83.283 79.140 73.309 100.120 99.675 4.000% Amount $(Mil) 930.00 810.00 555.00 395.00 1,740.00 985.00 505.00 580.00 740.00 1,215.00 795.00 820.00 2,955.00 930.00 1,345.00 835.00 1.230.00 325.00 225.00 615.00 1.510.00 725.00 600.00 790.00 525.00 22,680.00 or 22.680 billion 1.8575% 4.7605% 5.0153% 4.1322% 3.6978% 2.3581% 5.0782% 5.3440% 3.2588% 5.4509% 5.6076% 5.7547% 5.9151% 5.9614% 6.0339% 4.94 19% 5.2713% 2047 2048 2049 2050 2065 2098 2026 2027 5.100% 4.100% 4.650% 4.400% 4.050% 4.950% 5.250% 4.500% 7.600% 0.450% 1.625% 0.450% 1.300% 0.950% 2.200% 75.692 105.333 98.699 100.397 100.000 100.667 99.241 100.000 6.0852% 7.2131% 2029 2032 2033 0.6686% 1.5655% 0.4500% 1.2404% 1.0121% 2.1998% various 0.0000 0.0000% 0.000 or 0.000 billion Pre-tax Cost of Debt Adjustment for tax rate After tax Cost of Debt 2021-05 2020-05 2019-05 2018-05 2017-05 2016-05 Fed Ex Com Fiscal year ends in May. USD in millions. Assets Current assets Cash and cash equivalents Receivables Inventories Prepaid expenses Total current assets Non-current assets - Gross property, plant and equipment Accumulated Depreciation Soodwill Intangible assets ther long-term assets Total non-current assets Total assets 7,087 12,069 587 837 20,580 4,881 10,102 572 828 16,383 2,319 9,116 553 1,098 13,086 3,265 8,481 525 1,070 13,341 3,969 7,599 514 546 12,628 3,534 7,252 496 707 11,989 70,077 (34,325) 6,992 15,383 4,070 62,197 82,777 65,024 (31,416) 6,372 13,917 3,257 57,154 73,537 59,511 (29,082) 6,884 600 3,404 41,317 54,403 55,121 (26,967) 6,973 480 3,382 38,989 52,330 50,626 (24,645) 7,154 529 2,260 35,924 48,552 47,018 (22,734) 6,747 1,008 2,036 34,075 46,064 146 3,841 7,465 2,208 13,660 51 3,269 5,101 1,923 10,344 964 3,030 3,634 1,385 9,013 1,342 2,977 4,375 933 9,627 22 2,752 4,363 781 7,918 29 2,944 4,231 804 8,008 Liabilities Current liabilities Short-term debt Accounts payable Accrued liabilities Other current liabilities Total current liabilities Non-current liabilities - Long-term debt Deferred taxes liabilities Accrued liabilities Pensions and other benefits ther long-term liabilities Total non-current liabilities Total liabilities 20,879 total debt, this should match the number you get on the Bond Sched, cell G31 20,733 3,927 15,805 3,501 983 44,949 58,609 21,952 3,162 14,299 5,019 466 44,898 55,242 16,617 2,821 1,998 5,095 1,102 27,633 36,646 15,243 2,867 1,905 2,187 1,085 23,287 32,914 14,909 2,485 1,631 4,487 1,049 24,561 32,479 13,838 1,567 1,469 6,227 1,171 24,272 32,280 32 3,356 32 2,892 25,216 18,371 Stockholders' equity Common stock Additional paid-in capital Retained earnings Treasury stock Accumulated other comprehensive income Total stockholders' equity Total liabilities and stockholders' equity 32 3,481 29,817 (8,430) (732) 24,168 82,777 (9,162) (1,147) 18,295 73,537 32 3,231 24,648 (9,289) (865) 17,757 54,403 32 3,117 24,823 (7,978) (578) 19,416 52,330 32 3,005 20,833 (7,382) (415) 16,073 48,552 (7,342) (169) 13,784 46,064 Fed Ex Corp (FDX) INCOME STATEMENT Fiscal year ends in May. USD in millions. 2021-05 2020-05 2019-05 2018-05 2017-05 2016-05 Revenue (Sales) Cost of revenue (Cost of goods sold) Gross profit (Gross margin) Sales, general and administrative Other operating expenses EBITDA Deprec and amort Operating income (EBIT) Interest Expense Taxable income Income tax expense Net Income 83,959 58,953 25,00 1,765 11,981 11,260 3,793 7,467 793 6,674 1,443 5,231 69,217 51,055 18,162 1,714 10,492 5,956 3,615 2,341 672 1,669 383 1,286 69,693 52,354 17,339 1,687 11,056 4,596 3,353 1,243 588 655 115 540 65,450 49,764 15,686 1,645 4,674 9,367 3,095 6,272 558 5,714 1,142 4,572 60,319 45,504 14,815 1,599 5,655 7,561 2,995 4,566 512 4,054 1,057 2,997 50,365 38,539 11,826 1,498 4,621 5,707 2,630 3,077 337 2,740 922 1,818 Name Maturity Year Current Price Coupon % Yield to Maturity % Weight Value $ (Mil) Weighted YTM % 100.215 92.100 2034 2026 2028 2029 2030 2031 2034 2035 2041 2043 2044 2045 2046 1.875% 3.250% 3.400% 4.200% 3.650% 2.400% 4.900% 3.900% 3.250% enior Secured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt enior Unsecured Debt (Foreign) enior Unsecured Debt (Foreign) enior Unsecured Debt (Foreign) enior Unsecured Debt (Foreign) enior Unsecured Debt (Foreign) ther Debt and Capital Leases Totals 89.370 100.506 99.598 100.406 98.218 85.172 99.865 81.070 93.333 78.171 83.283 79.140 73.309 100.120 99.675 4.000% Amount $(Mil) 930.00 810.00 555.00 395.00 1,740.00 985.00 505.00 580.00 740.00 1,215.00 795.00 820.00 2,955.00 930.00 1,345.00 835.00 1.230.00 325.00 225.00 615.00 1.510.00 725.00 600.00 790.00 525.00 22,680.00 or 22.680 billion 1.8575% 4.7605% 5.0153% 4.1322% 3.6978% 2.3581% 5.0782% 5.3440% 3.2588% 5.4509% 5.6076% 5.7547% 5.9151% 5.9614% 6.0339% 4.94 19% 5.2713% 2047 2048 2049 2050 2065 2098 2026 2027 5.100% 4.100% 4.650% 4.400% 4.050% 4.950% 5.250% 4.500% 7.600% 0.450% 1.625% 0.450% 1.300% 0.950% 2.200% 75.692 105.333 98.699 100.397 100.000 100.667 99.241 100.000 6.0852% 7.2131% 2029 2032 2033 0.6686% 1.5655% 0.4500% 1.2404% 1.0121% 2.1998% various 0.0000 0.0000% 0.000 or 0.000 billion Pre-tax Cost of Debt Adjustment for tax rate After tax Cost of Debt