principles of fincnace week 7
tedy.r
week_07_problems.xlsProblem 1
Please enter your answer here:
Problem 2
| Part a. | ||
| Rate | 6% | |
| Nper | 20 | |
| pmt | $50 | |
| fv | $1,000 | |
| type | 0 | |
| PV | ||
| Part b. | ||
| Rate | 6% | |
| Nper | 10 | |
| pmt | $50 | |
| fv | $1,000 | |
| type | 0 | |
| PV | ||
| Part c. | ||
| Current yield for a. | ||
| Current yield for b. | ||
| Yield to maturity | ||
| Nper | ||
| Pmt | ||
| PV | ||
| FV | ||
| Type | ||
| Semi-Annual Return Rate | ||
| Annual Return Rate | ||
| Nper | ||
| Pmt | ||
| PV | ||
| FV | ||
| Type | ||
| Semi-Annual Return Rate | ||
| Annual Return Rate | ||
| Part d. | ||
| Rate | 4% | 4% |
| Nper | 20 | 10 |
| pmt | $50 | $50 |
| fv | $1,000 | $1,000 |
| type | 0 | 0 |
| PV | ||
| Part e. | ||
| Current yield for d. at 10 years | ||
| Current yield for d. at 5 years | ||
| Part f. |
Please enter your answer here:
Use the Rate function to calculate this.
Problem 3
| Rate |
| Nper |
| Pmt |
| PV |
| Type |
| FV |
| Add the initial principal ($1,000) to your FV |
| Solve for total return on your $1,000 cash out flow |
| Nper |
| Pmt |
| PV |
| FV |
| Type |
| Annual Return Rate |
| Annual Return |
Problem 4
| Part a. | ||||||
| Current Yield | Yield to Maturity | |||||
| XY bond | AB bond | XY bond | AB bond | |||
| Rate | Nper | |||||
| Nper | PMT | |||||
| PMT | PV | |||||
| FV | FV | |||||
| Type | Type | |||||
| PV | Rate | |||||
| Current Yield XY | ||||||
| Currient Yield AB | ||||||
| Part b. | ||||||
| Part c. |
Please enter your answer here:
Please enter your answer here:
Please enter your answer here:
