Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Answer Schedule Format Points available Remarks billion 0.50 1.75 0.50 use 05/31/21 data provided on Data tab - use value in BILLIONS use dividend growth
Answer Schedule Format Points available Remarks billion 0.50 1.75 0.50 use 05/31/21 data provided on Data tab - use value in BILLIONS use dividend growth for most recent six years as I have segregated on the Data tab use 05/31/21 data provided on Data tab use the most recent year on the Data tab use 05/31/21 data provided on Data tab 0.50 0.50 Market value of equity (market cap) Growth rate for equity Market price of stock (per share) Annual dividend Beta of stock Risk free rate Market rate of return OGM cost of equity (stock) CAPM cost of equity (stock) Average cost of equity Market value of debt 1.20% 10.30% currency, 3 decimal places percentage, 2 decimal places currency, 2 decimal places currency, 2 decimal places number, 2 decimal places percentage, 2 decimal places percentage, 2 decimal places percentage, 2 decimal places percentage, 2 decimal places percentage, 2 decimal places currency, 3 decimal places 1.25 1.25 1.00 billion 0.50 - simple average of two methods use bond schedule for 05/31/21 - use value in BILLIONS use average for most recent six calendar years = there are two acceptable ways to calculate this that result in two slightly different answers use bond schedule for 05/31/21 - use value in BILLIONS use bond schedule for 05/31/21 - use value in BILLIONS use value in BILLIONS 1.00 Average tax rate Pre tax cost of debt (bonds) After tax cost of debt (bonds) Total market value of equity and debt Neight for equity Neight for debt Weighted average cost of capital billion percentage, 2 decimal places percentage, 2 decimal places percentage, 2 decimal places currency, 3 decimal places number, 4 decimal places number, 4 decimal places percentage, 2 decimal places 3.50 1.25 0.50 1.25 1.25 3.50 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 FED EX Corp. ahoo finance data 5/31/21(year end) Annual Annual Growth Dividends Rates 2.7000 10% Average Growth Rate (0.6489) 2.4500 0.0889 Current stock price Market Cap (value) Beta PE Ratio EPS Annual dividend of shares outstanding $ 314.81 $ 83. 110 billion 1.30 15.91 $ 19.79 F$ 2.70 264 million million 2.2500 (2.0976) Quarterly Dividends 0.7500 0.6500 0.6500 0.6500 0.6500 0.6000 0.6000 0.6000 0.6000 0.5500 0.5500 0.5500 0.5500 0.5000 0.5000 0.5000 0.5000 0.4500 0.4500 0.4500 0.4500 0.4000 0.4000 0.4000 $ urrent price outstanding shares narket value Date 06/25/21 03/05/21 12/11/20 09/03/20 06/26/20 03/06/20 12/06/19 09/06/19 06/21/19 03/08/19 12/07/18 09/07/18 06/22/18 03/09/18 12/08/17 09/08/17 06/20/17 03/09/17 12/08/16 09/08/16 06/14/16 03/10/16 12/10/15 09/08/15 (2.0500) (2.1081) 314.81 264,000,000 83,109,840,000 or 83. 110 billion $ $ 1.8500 0.1212 Note: FedEx paid out more in dividends in the most recent year end han it actually earned. Companies can do this if they have sufficient etained earnings. 1.6500 Answer Schedule Format Points available Remarks billion 0.50 1.75 0.50 use 05/31/21 data provided on Data tab - use value in BILLIONS use dividend growth for most recent six years as I have segregated on the Data tab use 05/31/21 data provided on Data tab use the most recent year on the Data tab use 05/31/21 data provided on Data tab 0.50 0.50 Market value of equity (market cap) Growth rate for equity Market price of stock (per share) Annual dividend Beta of stock Risk free rate Market rate of return OGM cost of equity (stock) CAPM cost of equity (stock) Average cost of equity Market value of debt 1.20% 10.30% currency, 3 decimal places percentage, 2 decimal places currency, 2 decimal places currency, 2 decimal places number, 2 decimal places percentage, 2 decimal places percentage, 2 decimal places percentage, 2 decimal places percentage, 2 decimal places percentage, 2 decimal places currency, 3 decimal places 1.25 1.25 1.00 billion 0.50 - simple average of two methods use bond schedule for 05/31/21 - use value in BILLIONS use average for most recent six calendar years = there are two acceptable ways to calculate this that result in two slightly different answers use bond schedule for 05/31/21 - use value in BILLIONS use bond schedule for 05/31/21 - use value in BILLIONS use value in BILLIONS 1.00 Average tax rate Pre tax cost of debt (bonds) After tax cost of debt (bonds) Total market value of equity and debt Neight for equity Neight for debt Weighted average cost of capital billion percentage, 2 decimal places percentage, 2 decimal places percentage, 2 decimal places currency, 3 decimal places number, 4 decimal places number, 4 decimal places percentage, 2 decimal places 3.50 1.25 0.50 1.25 1.25 3.50 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 FED EX Corp. ahoo finance data 5/31/21(year end) Annual Annual Growth Dividends Rates 2.7000 10% Average Growth Rate (0.6489) 2.4500 0.0889 Current stock price Market Cap (value) Beta PE Ratio EPS Annual dividend of shares outstanding $ 314.81 $ 83. 110 billion 1.30 15.91 $ 19.79 F$ 2.70 264 million million 2.2500 (2.0976) Quarterly Dividends 0.7500 0.6500 0.6500 0.6500 0.6500 0.6000 0.6000 0.6000 0.6000 0.5500 0.5500 0.5500 0.5500 0.5000 0.5000 0.5000 0.5000 0.4500 0.4500 0.4500 0.4500 0.4000 0.4000 0.4000 $ urrent price outstanding shares narket value Date 06/25/21 03/05/21 12/11/20 09/03/20 06/26/20 03/06/20 12/06/19 09/06/19 06/21/19 03/08/19 12/07/18 09/07/18 06/22/18 03/09/18 12/08/17 09/08/17 06/20/17 03/09/17 12/08/16 09/08/16 06/14/16 03/10/16 12/10/15 09/08/15 (2.0500) (2.1081) 314.81 264,000,000 83,109,840,000 or 83. 110 billion $ $ 1.8500 0.1212 Note: FedEx paid out more in dividends in the most recent year end han it actually earned. Companies can do this if they have sufficient etained earnings. 1.6500
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started