On the answer schedule, you can use cell references OR manually input your answers (as long as you did the actual calculations in Excel) For

On the answer schedule, you can use cell references OR manually input your answers (as long as you did the actual calculations in Excel)

For example: show the growth rate for equity on the worksheet that contains the data you use for the calculation

PLEASE SHOW ME THE STEPS OR FORMULA FOR I CAN UNDERSTAND IT.

image text in transcribed

Answer Schedule Format Remarks billion 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 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 DGM 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 billion 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 Average tax rate Pre tax cost of debt (bonds) After tax cost of debt (bonds) Total market value of equity and debt Weight for equity Weight 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 2021-05 2020-05 2019-05 2018-05 2017-05 2016-05 7,087 12,069 587 Fed Ex Corp (FDX) BALANCE SHEET 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 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 837 20,580 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 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 38,989 52,330 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 Other 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 Stockholders' equity 32 32 32 32 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 3,356 25,216 (9,162) (1,147) 18,295 73,537 32 3,231 24,648 (9,289) (865) 17,757 54,403 3,117 24,823 (7,978) (578) 19,416 52,330 3,005 20,833 (7,382) (415) 16,073 48,552 2,892 18,371 (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,006 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 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 540 FED Ex Corp. yahoo finance data 05/31/21(year end) Quarterly Dividends Annual Annual Growth Dividends Rates Average Growth 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 $ $ 15.91 19.79 2.70 0.6000 0.6000 0.6000 264 million 0.6000 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.5500 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 Fed Ex Corp. outstanding bonds as of 05/31/21 Face amounts are in millions. Name Maturity Year Current Price Coupon % Market Value $ (Mil) Weight Weighted YTM % Senior Secured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt (Foreign) Senior Unsecured Debt (Foreign) Senior Unsecured Debt (Foreign) Senior Unsecured Debt (Foreign) Senior Unsecured Debt (Foreign) Other Debt and Capital Leases Totals 2034 2026 2028 2029 2030 2031 2034 2035 2041 2043 2044 2045 2046 2047 2048 2049 2050 2065 2098 2026 2027 2029 2032 2033 various Face 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 100.215 92.100 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 75.692 105.333 98.699 100.397 100.000 100.667 99.241 100.000 1.875% 3.250% 3.400% 4.200% 3.650% 2.400% 4.900% 3.900% 3.250% 4.000% 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% Yield to Maturity % 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.9419% 5.2713% 6.0852% 7.2131% 0.6686% 1.5655% 0.4500% 1.2404% 1.0121% 2.1998% 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 Remarks billion 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 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 DGM 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 billion 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 Average tax rate Pre tax cost of debt (bonds) After tax cost of debt (bonds) Total market value of equity and debt Weight for equity Weight 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 2021-05 2020-05 2019-05 2018-05 2017-05 2016-05 7,087 12,069 587 Fed Ex Corp (FDX) BALANCE SHEET 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 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 837 20,580 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 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 38,989 52,330 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 Other 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 Stockholders' equity 32 32 32 32 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 3,356 25,216 (9,162) (1,147) 18,295 73,537 32 3,231 24,648 (9,289) (865) 17,757 54,403 3,117 24,823 (7,978) (578) 19,416 52,330 3,005 20,833 (7,382) (415) 16,073 48,552 2,892 18,371 (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,006 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 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 540 FED Ex Corp. yahoo finance data 05/31/21(year end) Quarterly Dividends Annual Annual Growth Dividends Rates Average Growth 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 $ $ 15.91 19.79 2.70 0.6000 0.6000 0.6000 264 million 0.6000 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.5500 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 Fed Ex Corp. outstanding bonds as of 05/31/21 Face amounts are in millions. Name Maturity Year Current Price Coupon % Market Value $ (Mil) Weight Weighted YTM % Senior Secured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt Senior Unsecured Debt (Foreign) Senior Unsecured Debt (Foreign) Senior Unsecured Debt (Foreign) Senior Unsecured Debt (Foreign) Senior Unsecured Debt (Foreign) Other Debt and Capital Leases Totals 2034 2026 2028 2029 2030 2031 2034 2035 2041 2043 2044 2045 2046 2047 2048 2049 2050 2065 2098 2026 2027 2029 2032 2033 various Face 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 100.215 92.100 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 75.692 105.333 98.699 100.397 100.000 100.667 99.241 100.000 1.875% 3.250% 3.400% 4.200% 3.650% 2.400% 4.900% 3.900% 3.250% 4.000% 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% Yield to Maturity % 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.9419% 5.2713% 6.0852% 7.2131% 0.6686% 1.5655% 0.4500% 1.2404% 1.0121% 2.1998% 0.0000 0.0000% 0.000 or 0.000 billion Pre-tax Cost of Debt Adjustment for tax rate After tax Cost of Debt