Question: need excel help for this problem. Filer Manufacturing has 8 million shares of common stock outstanding. The current share price is $74, and the book

need excel help for this problem.

Filer Manufacturing has 8 million shares of common stock outstanding. The current share price is $74, and the book value per share is $5. The company also has two bond issues outstanding. The first bond issue has a face value $80 million, a coupon of9 percent, and sells for 95 percent of par. The second issue has a face value of $60 million, a coupon of10 percent, and sells for 108 percent of par. The first issue matures in 24 years, the second in 8 years.

a.

What are the company's capital structure weights on a book value basis?(Do not round intermediate calculations and round your answers to 4 decimal places, e.g., 32.1616.)

Equity / Value
Debt / Value

b.

What are the company's capital structure weights on a market value basis?(Do not round intermediate calculations and round your answers to 4 decimal places, e.g., 32.1616.)

Equity / Value
Debt / Value

c.

Which are more relevant?

Market value weights

Book value weights

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!