Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate a Bond's YTW %, Price, Value, and Market Weight For YTW %, I'm using =YIELD(5/29/20, G9,D9,J9, 100, 2) for price, I have =PRICE(5/29/20, G17,D17,K17/100,
Calculate a Bond's YTW %, Price, Value, and Market Weight
For YTW %, I'm using =YIELD("5/29/20", G9,D9,J9, 100, 2)
for price, I have =PRICE("5/29/20", G17,D17,K17/100, 100, 2)
Weight/market value formula?
Coupon | Issue | Maturity | Issue | Market | ||||||||
Description | Amt Out | Current Amt | Coupon | Type | Date | Date | Currency | Seniority | Price | YTW % | Value | Weight |
Dunkin | 500.0 | 500.0 | 2.000% | Fixed | 03/2020 | 03/2027 | USD | SNR Unsec | 100.10 | .02 | ||
Dunkin | 1,000.0 | 1,000.0 | 4.450% | Fixed | 05/2019 | 08/2049 | USD | SNR Unsec | 116.67 | 3.53 | ||
LT Debt Total | $18,342.2 | $18,342.2 | ||||||||||
Total Debt Total | $20,698.7 | $20,698.7 | Total Market Value | $0.00 |
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