In: Finance
ou are given three investment alternatives to analyze. The cash flows from these three investments are shown in the popup window:.... Assuming a discount rate of 21 percent, find the present value of each investment.
a. What is the present value of investment A at 21 percent annual discount rate? $ nothing (Round to the nearest cent.)
b. What is the present value of investment B at 21 percent annual discount rate? $ nothing (Round to the nearest cent.)
END OF YEAR |
A |
B |
C |
|
1 |
$16,000 |
$16,000 |
||
2 |
16,000 |
|||
3 |
16,000 |
|||
4 |
16,000 |
|||
5 |
16,000 |
$16,000 |
|
|
6 |
16,000 |
80,000 |
||
7 |
16,000 |
|||
8 |
16,000 |
|||
9 |
16,000 |
|||
10 |
16,000 |
16,000 |
The following is the Excel worksheet of the calculation of present values of the three projects:-
Following is the formula sheet of the above Excel worksheet for easy understanding of the formulas used:-
Answers:-
Present Value of Investment A = $46815.7494
Present Value of Investment B = $24218.1906
Present Value of Investment C = $41091.9040