Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. solve the following on excel, please show formulas

Solve the following on Excel, please show formulas for each: 1. AAA Inc. has...

90.2K

Verified Solution

Question

Finance

Solve the following on Excel, please show formulas for each:

1. AAA Inc. has a bond with 5 years to maturity, annual 4% coupons and 7% yield to maturity.

a) What is the coupon rate?

b) What is the market price?

c) What is the current yield?

d) What is the Macaulay duration?

e) What is the modified duration?

f) What is the dollar duration?

g) What is the dollar convexity?

h) What is the convexity measure?

i) What is the approximate change in the market price of the bond if the yield to maturity increases by 10 basis points? How much of this is due to the convexity effect?

j) What is the approximate change in the market price of the bond if the yield to maturity increases by 100 basis points (i.e., one percentage point)? How much of this is due to the convexity effect?

k) What are the exact price changes for 10 and 100 basis point increases in yield?

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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

A farmer raises only sheep and geese. She wants to raise at least 16 animals, including...

Basic Math
Q

Find a conformal mapping which maps the upper half-plane onto the exterior of the semi-infinite strip...

Advance Math
Q

which of the followinf regarding nk cells is false? a.nk cells are a type of neutrophil b.nk...

Medical Sciences
Q

****Please make it sure that it explains with logic and/or writing. It is an essay but...

Physics
Q

Between years 1982 and 1992, McDonalds has had more then 700 claims by people burned by...

General Management
Q

Use the piecewise graph to identify the following 10 B 10 8 6 4 8...

Algebra
Q

Pharoah Co. produces wooden boxes. The companys standards per box require 7 boards, each costing...

Accounting
Q

Type or paste question here A B D E E F G H...

Accounting
Q

Bonds Issued at Face Value to Co, issued the following bonds: Required: Prepare journal entries...

Accounting
Q

Two payment streams have the same present value under effective annual interest rate of 8%:...

Finance
Q

Bill is 31 years old, married, and lived with his spouse Michelle from January 2018...

Finance
Q

The probabilities that a man survives to be 40,41 , and 42 are respectively 0.95526,0.95294,...

Finance