C G Excel Case #2 - Federal Express Corp. Answer Schedule Format Points available Remarks billion 0.50 1.75 0.50 0.50 0.50 use 05/31/19 data provided on Data tab-use value in BILLIONS use dividend growth for most recent five years as have segregated on the Data tab se 05/31/19 data provided on Datatab use the most recent year on the Data tab use 05/31/19 data provided on Duta tab Market value of equity (market cap Growth rate for equity Market price of stock (per share) Antal dividend 9 Bet of stock 10 Risk tree rate 11 Maret rate of return 12 DGM cost of equity 13 CAPM cost of equity (stock 14 Average cost of equity 15 Market value of den 1.10% 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 1.25 1.00 0.50 bon simple average of two methods use bond schedule for 05/31/19 - use value in LUONS use awarage for most recent five calendar yean there are two acceptable ways to calculate this that result in two lightly different answers use bond schedule for 05/31/19-e value in BILLIONS use bond schedule for 05/31/19-ute value in BILLIONS me value in BILLIONS 16 Average tax rate 17 Pretax cost of delt bonds) 11 Aher tax cost of de bondi) 10 Total market value of equity and 10 Weight for equity 21 Weight for dett 22 Weldverage cost of capital billion percentage, 2 decimal places percenta, 2 decimal places percentage, 2 decimal places currency, a decimal places number, a decimal pa number, decimal places percent, 2 decimal places 1.00 3.50 1.25 0.50 1.25 1.25 3.50 24 Save your fee with this reformat wew Case First tilastrame tection 25 Dample Escel Case 2 Malwin W 37 Total pain 20.00 2 We will do some work with the Federal Express Corporation (FDX) in this case. You will calculate several things including the cost of equity, cost of debt and weighted 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 less-than-truckload and other freight delivery servicos. 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. C G Excel Case #2 - Federal Express Corp. Answer Schedule Format Points available Remarks billion 0.50 1.75 0.50 0.50 0.50 use 05/31/19 data provided on Data tab-use value in BILLIONS use dividend growth for most recent five years as have segregated on the Data tab se 05/31/19 data provided on Datatab use the most recent year on the Data tab use 05/31/19 data provided on Duta tab Market value of equity (market cap Growth rate for equity Market price of stock (per share) Antal dividend 9 Bet of stock 10 Risk tree rate 11 Maret rate of return 12 DGM cost of equity 13 CAPM cost of equity (stock 14 Average cost of equity 15 Market value of den 1.10% 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 1.25 1.00 0.50 bon simple average of two methods use bond schedule for 05/31/19 - use value in LUONS use awarage for most recent five calendar yean there are two acceptable ways to calculate this that result in two lightly different answers use bond schedule for 05/31/19-e value in BILLIONS use bond schedule for 05/31/19-ute value in BILLIONS me value in BILLIONS 16 Average tax rate 17 Pretax cost of delt bonds) 11 Aher tax cost of de bondi) 10 Total market value of equity and 10 Weight for equity 21 Weight for dett 22 Weldverage cost of capital billion percentage, 2 decimal places percenta, 2 decimal places percentage, 2 decimal places currency, a decimal places number, a decimal pa number, decimal places percent, 2 decimal places 1.00 3.50 1.25 0.50 1.25 1.25 3.50 24 Save your fee with this reformat wew Case First tilastrame tection 25 Dample Escel Case 2 Malwin W 37 Total pain 20.00 2 We will do some work with the Federal Express Corporation (FDX) in this case. You will calculate several things including the cost of equity, cost of debt and weighted 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 less-than-truckload and other freight delivery servicos. 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