[Step-by-Step] You are considering the following bonds to include in your portfolio: Bond 1 Bond 2 Bond 3 Price $900.00 $1,100.00 $1,000.00 Face Value $1,000.00
Question: You are considering the following bonds to include in your portfolio:
| Bond 1 | Bond 2 | Bond 3 | |
| Price | $900.00 | $1,100.00 | $1,000.00 |
| Face Value | $1,000.00 | $1,000.00 | $1,000.00 |
| Coupon Rate | 7.00% | 10.00% | 9.00% |
| Frequency | 1 | 2 | 4 |
| Maturity (Years) | 15 | 20 | 30 |
| Required Return | 9.00% | 8.00% | 9.00% |
Determine the highest price you would be willing to pay for each of these bonds using the PV function. Also find whether the bond is undervalued, overvalued, or fairly valued.
Determine the yield to maturity on these bonds using the Rate function assuming that you purchase them at the given price. Also calculate the current yield of each bond.
Determine the yield to call of each bond using the Rate function if the time to first call and the call premium are the following:
| Bond A | Bond B | Bond C | |
| Call Premium % | 3.00% | 4.00% | 5.00% |
| Years to first call | 5 | 4 | 3 |
Assume the following settlement dates for each bond:
| Bond 1 | Bond 2 | Bond 3 | |
| Settlement Date | 1/1/2018 | 6/1/2018 | 9/1/2018 |
Use the Price and Yield functions to recalculate your answers on parts (a), (b), and (c).
Deliverable: Word Document 
![[Solution Library] Weighted Average Cost of Capital](/images/solutions/MC-solution-library-77553.jpg "[Solution Library] Weighted Average Cost of Capital Use Excel Calculate")
[Solution Library] Weighted Average Cost of Capital Use Excel Calculate
(Solution Library) In an effort to improve their program for teaching
Solution: A researcher wants to evaluate the effectiveness of a
![[Steps Shown] Listed below are the amounts](/images/solutions/MC-solution-library-77556.jpg "[Steps Shown] Listed below are the amounts (in millions of dollars)")
[Steps Shown] Listed below are the amounts (in millions of dollars)
![[See Solution] Cans of soda vary slightly](/images/solutions/MC-solution-library-77557.jpg "[See Solution] Cans of soda vary slightly in weight. Given below are")
[See Solution] Cans of soda vary slightly in weight. Given below are
Linear Equation Point Slope Form Calculator - MathCracker.com