Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. calculate a bond's ytw %, price, value, and market

Calculate a Bond's YTW %, Price, Value, and Market Weight For YTW %, I'm using...

90.2K

Verified Solution

Question

Accounting

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

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Must newspapers comply with fair housing advertising laws OA Yes newspapers must make sure real...

Basic Math
Q

Harris Shipping Company has excess cash of $300,000 and 200,000 total shares outstanding. The firm pays...

Finance
Q

Calculate the pH of the following solutions: (a) 10-3 M HClO4 (note that for HClO4 the...

Chemistry
Q

Fill in the blank Reproductive Sperm and egg microevolution Transposons Natural selection Independent assortment Mutation Gene flow populations Genetic drift Frequencies Evolution Crossing over 1. Population genetics examines changes...

Biology
Q

For this problem, carry at least four digits after the decimal in your calculations. Answers may...

Basic Math
Q

b Set the first derivative f x 0 to find any critical values Tip You...

Basic Math
Q

What is the perpendicular bisector of a triangle?the segment from one vertex perpendicular to the...

Basic Math
Q

Check Tom Yuppy, a wealthy investor, exchanged a plot...

Accounting
Q

Financial accounting provides information used primarily by creditors investors employees executives

Accounting
Q

Compute the April30 inventory and the April cost of goods sold using the UFO method

Accounting
Q

Kyle, a single taxpayer, worked as a freelance software engineer for the first three months...

Accounting
Q

Acme Co. sells two products, tables and chairs. Last year Acme sold $4.000 tables and...

Accounting