Consider a company with equity value equal to $80, and face value of debt of...

90.2K

Verified Solution

Question

Accounting

Consider a company with equity value equal to $80, and face value of debt of $50. The annual log-return on risk-free debt is 3%. If the debt of the company expires in 0.5 years, how does the probability of default of the company changes as a function of the volatility of the equity?
In excel please.
a. Create a plot where the distance to default is on the y-axes and the volatility of the equity (from 0.1 to 1.5, in increments of 0.1) is on the x-axes. That is, what is the relationship between equity (i.e. stock) volatility and the distance to default of the firm?
b. Create a plot where the probability of default is on the y-axes and the volatility of the equity (from 0.1 to 1.5, in increments of 0.1) is on the x-axes. That is, what is the relationship between equity (i.e. stock) volatility and the probability of default of the firm?
c. Comment the results.

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