1. Using the information provided in the table, find the value of each asset.
2. Find the present value of Asset D. (Show computation in an Excel spreadsheet).
3. Find the present value of Asset E. (Show the computation in an Excel spreedsheet).
| Asset |
End of Year |
Amount |
|
| A |
1 |
3000 |
19% |
|
2 |
3000 |
|
|
3 |
3000 |
|
| B |
1 through &inf; |
300 |
14% |
| C |
1 |
0 |
16% |
|
2 |
0 |
|
|
3 |
0 |
|
|
4 |
0 |
|
|
5 |
38000 |
|
| D |
1 through 5 |
1600 |
13% |
|
6 |
8100 |
|
| E |
1 |
6000 |
14% |
|
2 |
7000 |
|
|
3 |
9000 |
|
|
4 |
11000 |
|
|
5 |
8000 |
|
|
6 |
5000 |