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 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 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 Goodwill Intangible assets Other long-term assets Total non-current assets Total assets 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 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 13,660 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 Other long-term liabilities Total non-current liabilities Total liabilities 20,879 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 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 32 3,356 25,216 (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 32 2,892 18,371 (7,342) (169) 13,784 46,064 FED Ex Corp. yahoo finance data 05/31/21 year end) Quarterly Dividends Annual Dividends Annual Growth Average Growth Rates Rate Date $ $ 314.81 83.110 billion 0.7500 0.6500 0.6500 0.6500 0.6500 1.30 Current stock price Market Cap (value) Beta PE Ratio EPS Annual dividend #of shares outstanding 0.6000 $ $ 15.91 19.79 2.70 0.6000 0.6000 264 million 0.6000 0.5500 0.5500 0.5500 0.5500 $ current price outstanding shares market value 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 314.81 264,000,000 83,109,840,000 $ or $ 83.110 billion 0.5000 0.5000 0.5000 0.5000 0.4500 0.4500 0.4500 Note: FedEx paid out more in dividends in the most recent year end than it actually earned. Companies can do this if they have sufficient retained earnings. 0.4500 0.4000 0.4000 0.4000 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 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 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 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 Goodwill Intangible assets Other long-term assets Total non-current assets Total assets 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 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 13,660 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 Other long-term liabilities Total non-current liabilities Total liabilities 20,879 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 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 32 3,356 25,216 (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 32 2,892 18,371 (7,342) (169) 13,784 46,064 FED Ex Corp. yahoo finance data 05/31/21 year end) Quarterly Dividends Annual Dividends Annual Growth Average Growth Rates Rate Date $ $ 314.81 83.110 billion 0.7500 0.6500 0.6500 0.6500 0.6500 1.30 Current stock price Market Cap (value) Beta PE Ratio EPS Annual dividend #of shares outstanding 0.6000 $ $ 15.91 19.79 2.70 0.6000 0.6000 264 million 0.6000 0.5500 0.5500 0.5500 0.5500 $ current price outstanding shares market value 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 314.81 264,000,000 83,109,840,000 $ or $ 83.110 billion 0.5000 0.5000 0.5000 0.5000 0.4500 0.4500 0.4500 Note: FedEx paid out more in dividends in the most recent year end than it actually earned. Companies can do this if they have sufficient retained earnings. 0.4500 0.4000 0.4000 0.4000 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
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