| UNIT 2: TEXTBOOK PROBLEMS |
|
|
|
|
| CHAPTER 4: PROBLEM 2 (a thru c) |
| | A. | B. | C. |
| Present Value | 3,550 | 3,550 | 3,550 |
| Interest Rate | 6% | 8% | 6% |
| Number of Years | 10 | 10 | 20 |
| Future Value = |
|
|
|
|
| CHAPTER 4: PROBLEM 3 |
|
|
| | A. | B. | C. | D. |
| Future Value = | 15,451 | 51,557 | 886,073 | 550,164 |
| Interest Rate | 7% | 9% | 14% | 11% |
| Number of Years | 9 | 13 | 16 | 24 |
| Present Value = |
|
|
|
|
| CHAPTER 4: PROBLEM 4 |
| | A. | B. | C. | D. |
| Present Value = | 217 | 432 | 41,000 | 54,382 |
| Future Value | 293 | 1053 | 162,181 | 483,500 |
| Number of Years | 3 | 10 | 16 | 19 |
| Interest Rate |
|
|
|
|
| CHAPTER 4: PROBLEM 5 |
| | A. | B. | C. | D. |
| Present Value = | 625 | 810 | 18,400 | 21,500 |
| Future Value | 1,284 | 4,341 | 234,162 | 215,000 |
| Interest Rate | 6% | 9% | 7% | 10% |
| Number of Years (or Periods) |
|
|
|
|
| CHAPTER 4: PROBLEM 11 |
|
|
| Discount Rate | 5% | 13% | 18% |
| Year 1: | $585 | $585 | $585 |
| Year 2: | $815 | $815 | $815 |
| Year 3: | $1,630 | $1,630 | $1,630 |
| Year 4: | $2,140 | $2,140 | $2,140 |
| Present Value @ 5%, 13%, and 18% = | | | | (Note: Use the built-in NPV formula in Excel) |
|
|
|
|
| CHAPTER 5: PROBLEM 2 |
|
|
| A. |
| Settlement | | (Think of Settlement as the beginning of the duration of the bond) |
| Maturity | | (Think of Maturity as the end of the duration of the bond) |
| Rate | | (Coupon Rate) |
| YTM | | (Yield to Maturity or Required Rate of Return) |
| Redemption | | (Bonds Face Value, Par Value, or Fair Price; Note that is $100, not $1,000. You make the adjustments by multiplying the answer by 10) |
| Frequency | | (Coupon payments are semiannual, so you put in a 2. If they are annual, then you input a 1) |
| Basis | | (Always leave it blank) |
| Bond Price | | (The answer. But you need to multiply it by 10 to get the actual bond price) |
| Multiply by 10 | | (Microsoft gives the bond price in 2 digits. You need to multiply it by 10 to get the actual bond price) |
|
|
|
|
| CHAPTER 5: PROBLEM 3 |
|
|
| Settlement | | (Think of Settlement as the beginning of the duration of the bond) |
| Maturity | | (Think of Maturity as the end of the duration of the bond) |
| Rate | | (Coupon Rate) |
| Pr | | (The bonds price per $100 face value) |
| Redemption | | (Bonds Face Value, Par Value, or Fair Price; Note that is $100, not $1,000) |
| Frequency | | (Coupon payments are semiannual, so you put in a 2. If they are annual, then you input a 1) |
| Basis: | | (Always leave it blank) |
| YTM |
|
|
|
|
| CHAPTER 6: PROBLEM 2 |
|
|
| Dividend Payment | $2.14 |
| Dividend Growth Rate | 4.40% |
| ZYX Stock Price | $32 |
|
|
| Required Return = |
|
|
|
|
| CHAPTER 6: PROBLEM 4 |
|
|
| Dividend | $3.08 |
| Dividend increase per year | 4.60% |
| Required Return (Return on Investment) | 11% |
|
|
| Stock Price = |
mcyrayvahgr
cf_template_textbook_problems_Unit_2.xls
