Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a. Choose one of the attached deals IPA participated on and calculate the current price of each tranche. For example, Walmart has 5 tranches in

image text in transcribedimage text in transcribedimage text in transcribed a. Choose one of the attached deals IPA participated on and calculate the current price of each tranche. For example, Walmart has 5 tranches in this deal, so you'd do 5 calculations following the methodology you learned above. i. You can calculate the current yield to maturity based on the format of the UST rate aligned with each tenor i.e. (use bloomberg to find) + the stated spread to benchmark treasury in the attached term sheets. Term sheets outline the details of a bond offering ii. Describe your rationale and label the dates when you pull your UST yields (US Bonds Section below based on tenor - i.e. due 2033 is a 10 YR security) UST 4.625% due March 15, 2026 (2026 Notes) UST 3.625% due March 31, 2028 (2028 Notes) UST 3.625% due March 31, 2030 (2030 Notes) UST 3.500% due February 15, 2033 (2033 Notes) UST 4.000% due November 15, 2052 (2053 Notes) +30 basis points ( 2026 Notes) +47 basis points ( 2028 Notes) +60 basis points ( 2030 Notes) +70 basis points (2033 Notes) +90 basis points (2053 Notes) 102153/4;3.716% (2026 Notes) 100221/4;3.471% (2028 Notes) 10106;3.432% (2030 Notes) 10026+;3.400% (2033 Notes) 10629+;3.617% (2053 Notes) 4.016% (2026 Notes) 3.941% (2028 Notes) 4.032% (2030 Notes) 4.100% (2033 Notes) 4.517% (2053 Notes) Interest will accrue from April 18, 2023. Interest on the 2026 Notes will be payable semi-annually on April 15 and October 15 of each year, beginning on October 15, 2023. Interest on the 2028 Notes will be payable semi-annually on April 15 and October 15 of each year, beginning on October 15, 2023. Interest on the 2030 Notes will be payable semi-annually on April 15 and October 15 of each year, beginning on October 15, 2023. Interest on the 2033 Notes will be payable semi-annually on April 15 and October 15 of each year, beginning on October 15, 2023. Interest on the 2053 Notes will be payable semi-annually on April 15 and October 15 of each year, beginning on October 15, 2023. 2 FINAL TERM SHEET Dated April 12, 2023 WALMART INC. $5750,000,0004.000% Notes Due 2026 $50,000,0003.900% Notes Due 2028 $500,000,0004.000% Notes Due 2030 $1,500,000,0004.100% Notes Due 2033 $1,500,000,0004.500% Notes Due 2053 Name of Issuer: Title of Securities: Aggregate Principal Amount: Issue Price (Price to Public): Maturity Date: Coupon (Interest Rate): Walmart Inc. ("Walmart" or the "Company") 4.000\% Notes Due 2026 ("2026 Notes") 3.900% Notes Due 2028 ("2028 Notes") 4.000% Notes Due 2030 ("2030 Notes") 4.100\% Notes Due 2033 ("2033 Notes") 4.500% Notes Due 2053 ("2053 Notes" and, collectively with the 2026 Notes, 2028 Notes, 2030 Notes and 2033 Notes, the "Notes") $750,000,000 (2026 Notes) $750,000,000 (2028 Notes) $500,000,000 (2030 Notes) $1,500,000,000 (2033 Notes) $1,500,000,000 (2053 Notes) 99.956% of aggregate principal amount (2026 Notes) 99.816% of aggregate principal amount (2028 Notes) 99.807% of aggregate principal amount (2030 Notes) 100.000% of aggregate principal amount (2033 Notes) 99.723% of aggregate principal amount (2053 Notes) April 15, 2026 (2026 Notes) April 15, 2028 (2028 Notes) April 15, 2030 (2030 Notes) April 15, 2033 (2033 Notes) April 15, 2053 (2053 Notes) 4.000% (2026 Notes) 3.900% (2028 Notes) 4.000% (2030 Notes) 4.100% (2033 Notes) 4.500% (2053 Notes)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Valuation A Guide For Managers And Investors

Authors: Phillip R. Daves, Michael C. Ehrhardt, Ron E. Shrieves

1st Edition

0324274289, 978-0324274288

More Books

Students also viewed these Finance questions

Question

How can either be made stronger?

Answered: 1 week ago