# price of bond, price of stock, NPV , WACC

Please solve all problems in Excel.

1. Janice Smith wishes to accumulate $8,000 by the end of 5 years by making equal annual end-of-year deposits over the next five years. If Janice can earn 7 percent on her investments, how much must she deposit at the end of each year to meet this goal?

2. J& J just issued a bond with a $1,000 face value and a coupon rate of 7%. If the bond has a life of 30 years, pays annual coupons and the yield to maturity (YTM) is 6.8%, what will be the bond sell for?

3. Biogenetics, Inc plans to retain and reinvest all of their earnings for the next 30 years. Beginning in year 31, the firm will begin to pay a $12.00 per share dividend. The dividend will not subsequently change. Given a required return of 15%, what should the stock sell for today?

4. What is the NPV of a project that is expected to pay $10,000 a year for 7 years if the initial investment is $40,000 and the required return is 15%?

5. A firm has 2,000,000 shares of common stock outstanding with a market price of $2.00 per share. It has 2,000 bonds outstanding, each selling for $1,200. The bonds mature in 15 years, have a coupon rate of 10% and pay coupons annually. The firm's beta is 1.2, the risk free rate is 5%, and the market risk premium is 7%. The tax rate is 34%. Calculate the WACC?

© BrainMass Inc. brainmass.com June 3, 2020, 9:58 pm ad1c9bdddfhttps://brainmass.com/business/bond-valuation/price-of-bond-price-of-stock-npv-wacc-208112

#### Solution Preview

1.Janice Smith wishes to accumulate $8,000 by the end of 5 years by making equal annual end-of-year deposits over the next five years. If Janice can earn 7 percent on her investments, how much must she deposit at the end of each year to meet this goal?

Future value of an annuity FV= C/r*((1+r)^n-1)

Here we have FV=8000

r=7%

n=5 years

8000=C/7% *((1+7%)^5-1)

Solving we get C=1391.13

She must deposit $1391.13 at the end of each year to meet this goal.

2. J& J just issued a bond with a $1,000 face value and a coupon rate of 7%. If the bond has a life of 30 years, pays annual coupons and the yield to maturity (YTM) is 6.8%, what will be the bond sell for?

Price of bond is the PV of all future cash flows associated with the bond

Coupon Payment = $70

Face value = ...

#### Solution Summary

Solves five problems on corporate finance topics such as security valuation, WACC, NPV etc.