C G 1 Excel Case #2- Federal Express Corp. Answer Schedule Format Points available Remarks billi 0.50 1.75 0.50 0.50 0.50 use 05/31/19 data provided on Data tabule value in ILLIONS use dividend growth for most recent five years as have segregated on the Data tab use 05/31/19 data provided on Data tab use the most recent year on the Datatab use 05/31/19 data provided on Data tab Market value of equitymarket cap 6 Growth rate for equity Market price of stock (per share) 3. Annual dividend 9 Beta of stock 10 Risk tree rate 11 Mart rate of return 12 DGM cost of equity (stock 13 CAPM cost of equity (stock 16 Average cost of equity 15 Market value of det 1.103 9.90 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 125 125 1.00 0.50 bilo simple average of two methods use bond schedule for 05/31/19 - use value in BALLONS ute average for most recent five calendar years there are two acceptable ways to calculate this that result in two sightly different answers use band schedule for 05/31/19-use value in BILLIONS use bond schedule for 05/31/19. ure value in SILLIONS se value in BILLIONS 15 Average tax rata percentage, 2 decimal places 17 Pretax cost of debt hands percentage, 2 decimal places 18 After the cost of debt bonds) percentage 2 decimal places 19 Total market value of equity and debt billion Currency. 3 decimal places 20 Weight for equity number4 decimal places 21 Weight for det number, 4 decimal places 23 Weighted average of capital percentage 2 decimal places 21 24 Save your file with this rume format cele 2 First Lastname section 25 Example Excel Case 2 Mowinnow 1.00 3.50 1.25 0.50 1.25 1.25 3.50 27 Total points 20.00 D E Excel Case #2 - Federal Express Corp. (FDX) 2. 3 Total points available 20 s The Aswer Schedule shows the points per question / answer 6 Points available for each answer are all or nothing - must be correct answer AND in correct format 7 Rounding of your answers should take place when you get to the final step, do not round prior to that & Please refer to the other worksheets in this Excel file to get the data you need 9 You need to show your work somewhere in this excel file to get credit when calculations are involved 10 if you just provide the correct answers and do not show your work when calculations are necessary, you will not earn full credit 11 On the answer schedule, you can use cell references OR manually input your answers (as long as you did the actual calculations in Excel) 12 For example: show the growth rate for equity on the worksheet that contains the data you use for the calculation 13 we W UU average cost of capital. Please follow the instructions on the first tab of the spreadsheet. The due date is November 22nd, at 11:59pm. Let me know if you have any questions. Here is a profile of the company FedEx Corporation is in the transportation sector of the S&P 500. The company provides transportation, e-commerce, and business services worldwide. Its FedEx Express segment offers shipping services for delivery of packages and freight. Its FedEx Ground segment offers business and residential money-back guaranteed ground package delivery services, and consolidates and delivers low-weight and less time-sensitive business-to-consumer packages. Its FedEx Freight segment offers Tess-than-truckload and other freight delivery services. As of May 31, 2019, it operated approximately 28,000 vehicles and 373 service centers. Its FedEx Services segment provides sales, marketing, information technology, communications, customer service, technical support, billing and collection services, and other back-office support services. It also offers FedEx Mobile, a suite of solutions to track packages, create shipping labels, view account-specific rate quotes, and access drop-off location information, FedEx Office, a suite of printing and shipping management solutions, including digital printing, professional finishing, document creation, direct mail, signs and graphics, copying, computer rental, Wi-Fi, and corporate print solutions, and packing services, supplies, and boxes, as well as FedEx Express and FedEx Ground shipping services. Its Corporate, Other and Eliminations segment offers international trade services in customs brokerage, and Ocean and air freight forwarding services, cross-border enablement and technology solutions, and e-commerce transportation solutions, integrated supply chain management solutions: time-critical shipment services; and critical inventory and service parts logistics, 3-D printing, and technology repair. It also provides international trade advisory services, including assistance with the customs-trade partnership against terrorism program, and publishes customs duty and tax information. It has a strategic alliance with Microsoft Corp. The company was founded by Frederick Smith in 1971 and is headquartered in Memphis, Tennessee. When Mr. Smith attended graduate school at Yale University, he wrote a paper that outlined the overnight delivery service. Fed Ex Corp. outstanding bonds as of 05/31/19 Face amounts are in millions. Name Current Price Coupon % Market Value $ (MI) Weight Weighted YTM % 6 Senior Unsecured Debt 7 Senior Unsecured Debt Senior Unsecured Debt 9 Senior Unsered Debt 10 Senior Unsecured Debt 11 Senior Unsecured Debt 12 Senior Unsecured Debt 13 Senior Unsecuted Debt 14 Senior Unsoed Debt 15 Senior Unsecured Debt 16 Sanice Unsecured Debt 17 Senior Unsecured Debt 18 Senior Unsecured Debt 19 Senior Unsund Debt 20 Senior Unsecured Debt 21 Senior Unsecured Debt 22. Senar Unsecured Debt 21 Senior Unsecured Obt 24 Senior Unsecured Debt 25 Senior insecured Debt 20 Sanier insecured Debt min) 27 Senior Uhared Debt omni 20 Senior Und Debt Fomin) 29 Senior Unanum Debt Foreign 30 Other Debt and Caps Les 31 Totals 12 33 14 35 Maturity Year 2020 2022 2023 2024 2025 2026 2027 2098 2020 2034 2035 2043 2044 2045 2048 2047 2048 2049 2065 2006 2020 2022 2023 2027 various Face Amount $(MIL) 405.00 500.00 770.00 750.00 740.00 810.00 490,00 555.00 395.00 505.00 580.00 1.215.00 795.00 120.00 2.65500 930.00 1,345.00 835 00 325.00 225.00 566.00 71500 930.00 1.730.00 65.20 19,950.20 or 19.950 billion 98.8000 100.0000 97.0000 99 5000 93.5000 92.0000 90.3000 88.7500 100.7500 97.7000 85 4000 81.0000 93.3000 78.0000 33.2500 79.0000 73.2000 100 4000 75.0000 103.8000 99.8600 100,0000 89 6000 80 4000 100.0000 2.300% 3.400% 2.650% 4.000% 3 3 200% 3.250% 3.300% 3.400% 4.2005 4.900 3.000% 4.000% 5.100% 4.100% 4.650 4.400% 4.050% 4.950X 4.500% 7.600 1.450 2.300% 1.800% 1 900% 2.200% Yleld to Maturity % 3.3556% 3.4000 3.4434% 4.1094 4.4302% 4.58515 4.7592% 4.9526% 4.1080N 5.1203% 5.2557% 6.4221% 5.6001% 5.7359% 5.8954% 5.9469% 6.0110 4 9240% 6.1342% 73202% 1.689 2.3000% 4.6230% 4.0610% 2.1991 Pre-tax cost of Debel 37 18 19 Adjustment for tax rate Amateur Anal FO Thils. flis.iii isitifs all li bli 35 tipli til 131. Sarti isini. ini ! iis. 18 buli. li ji dans C G 1 Excel Case #2- Federal Express Corp. Answer Schedule Format Points available Remarks billi 0.50 1.75 0.50 0.50 0.50 use 05/31/19 data provided on Data tabule value in ILLIONS use dividend growth for most recent five years as have segregated on the Data tab use 05/31/19 data provided on Data tab use the most recent year on the Datatab use 05/31/19 data provided on Data tab Market value of equitymarket cap 6 Growth rate for equity Market price of stock (per share) 3. Annual dividend 9 Beta of stock 10 Risk tree rate 11 Mart rate of return 12 DGM cost of equity (stock 13 CAPM cost of equity (stock 16 Average cost of equity 15 Market value of det 1.103 9.90 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 125 125 1.00 0.50 bilo simple average of two methods use bond schedule for 05/31/19 - use value in BALLONS ute average for most recent five calendar years there are two acceptable ways to calculate this that result in two sightly different answers use band schedule for 05/31/19-use value in BILLIONS use bond schedule for 05/31/19. ure value in SILLIONS se value in BILLIONS 15 Average tax rata percentage, 2 decimal places 17 Pretax cost of debt hands percentage, 2 decimal places 18 After the cost of debt bonds) percentage 2 decimal places 19 Total market value of equity and debt billion Currency. 3 decimal places 20 Weight for equity number4 decimal places 21 Weight for det number, 4 decimal places 23 Weighted average of capital percentage 2 decimal places 21 24 Save your file with this rume format cele 2 First Lastname section 25 Example Excel Case 2 Mowinnow 1.00 3.50 1.25 0.50 1.25 1.25 3.50 27 Total points 20.00 D E Excel Case #2 - Federal Express Corp. (FDX) 2. 3 Total points available 20 s The Aswer Schedule shows the points per question / answer 6 Points available for each answer are all or nothing - must be correct answer AND in correct format 7 Rounding of your answers should take place when you get to the final step, do not round prior to that & Please refer to the other worksheets in this Excel file to get the data you need 9 You need to show your work somewhere in this excel file to get credit when calculations are involved 10 if you just provide the correct answers and do not show your work when calculations are necessary, you will not earn full credit 11 On the answer schedule, you can use cell references OR manually input your answers (as long as you did the actual calculations in Excel) 12 For example: show the growth rate for equity on the worksheet that contains the data you use for the calculation 13 we W UU average cost of capital. Please follow the instructions on the first tab of the spreadsheet. The due date is November 22nd, at 11:59pm. Let me know if you have any questions. Here is a profile of the company FedEx Corporation is in the transportation sector of the S&P 500. The company provides transportation, e-commerce, and business services worldwide. Its FedEx Express segment offers shipping services for delivery of packages and freight. Its FedEx Ground segment offers business and residential money-back guaranteed ground package delivery services, and consolidates and delivers low-weight and less time-sensitive business-to-consumer packages. Its FedEx Freight segment offers Tess-than-truckload and other freight delivery services. As of May 31, 2019, it operated approximately 28,000 vehicles and 373 service centers. Its FedEx Services segment provides sales, marketing, information technology, communications, customer service, technical support, billing and collection services, and other back-office support services. It also offers FedEx Mobile, a suite of solutions to track packages, create shipping labels, view account-specific rate quotes, and access drop-off location information, FedEx Office, a suite of printing and shipping management solutions, including digital printing, professional finishing, document creation, direct mail, signs and graphics, copying, computer rental, Wi-Fi, and corporate print solutions, and packing services, supplies, and boxes, as well as FedEx Express and FedEx Ground shipping services. Its Corporate, Other and Eliminations segment offers international trade services in customs brokerage, and Ocean and air freight forwarding services, cross-border enablement and technology solutions, and e-commerce transportation solutions, integrated supply chain management solutions: time-critical shipment services; and critical inventory and service parts logistics, 3-D printing, and technology repair. It also provides international trade advisory services, including assistance with the customs-trade partnership against terrorism program, and publishes customs duty and tax information. It has a strategic alliance with Microsoft Corp. The company was founded by Frederick Smith in 1971 and is headquartered in Memphis, Tennessee. When Mr. Smith attended graduate school at Yale University, he wrote a paper that outlined the overnight delivery service. Fed Ex Corp. outstanding bonds as of 05/31/19 Face amounts are in millions. Name Current Price Coupon % Market Value $ (MI) Weight Weighted YTM % 6 Senior Unsecured Debt 7 Senior Unsecured Debt Senior Unsecured Debt 9 Senior Unsered Debt 10 Senior Unsecured Debt 11 Senior Unsecured Debt 12 Senior Unsecured Debt 13 Senior Unsecuted Debt 14 Senior Unsoed Debt 15 Senior Unsecured Debt 16 Sanice Unsecured Debt 17 Senior Unsecured Debt 18 Senior Unsecured Debt 19 Senior Unsund Debt 20 Senior Unsecured Debt 21 Senior Unsecured Debt 22. Senar Unsecured Debt 21 Senior Unsecured Obt 24 Senior Unsecured Debt 25 Senior insecured Debt 20 Sanier insecured Debt min) 27 Senior Uhared Debt omni 20 Senior Und Debt Fomin) 29 Senior Unanum Debt Foreign 30 Other Debt and Caps Les 31 Totals 12 33 14 35 Maturity Year 2020 2022 2023 2024 2025 2026 2027 2098 2020 2034 2035 2043 2044 2045 2048 2047 2048 2049 2065 2006 2020 2022 2023 2027 various Face Amount $(MIL) 405.00 500.00 770.00 750.00 740.00 810.00 490,00 555.00 395.00 505.00 580.00 1.215.00 795.00 120.00 2.65500 930.00 1,345.00 835 00 325.00 225.00 566.00 71500 930.00 1.730.00 65.20 19,950.20 or 19.950 billion 98.8000 100.0000 97.0000 99 5000 93.5000 92.0000 90.3000 88.7500 100.7500 97.7000 85 4000 81.0000 93.3000 78.0000 33.2500 79.0000 73.2000 100 4000 75.0000 103.8000 99.8600 100,0000 89 6000 80 4000 100.0000 2.300% 3.400% 2.650% 4.000% 3 3 200% 3.250% 3.300% 3.400% 4.2005 4.900 3.000% 4.000% 5.100% 4.100% 4.650 4.400% 4.050% 4.950X 4.500% 7.600 1.450 2.300% 1.800% 1 900% 2.200% Yleld to Maturity % 3.3556% 3.4000 3.4434% 4.1094 4.4302% 4.58515 4.7592% 4.9526% 4.1080N 5.1203% 5.2557% 6.4221% 5.6001% 5.7359% 5.8954% 5.9469% 6.0110 4 9240% 6.1342% 73202% 1.689 2.3000% 4.6230% 4.0610% 2.1991 Pre-tax cost of Debel 37 18 19 Adjustment for tax rate Amateur Anal FO Thils. flis.iii isitifs all li bli 35 tipli til 131. Sarti isini. ini ! iis. 18 buli. li ji dans