What is the present value of a stream of 5 end-of-year annual cash receipts of $500 given

Question:

What is the present value of a stream of 5 end-of-year annual cash receipts of $500 given a discount rate of 14 percent? Use both the appropriate table in the text (Appendix C, Table 2) and the appropriate function in Excel to answer this question.

Discount Rate
Depending upon the context, the discount rate has two different definitions and usages. First, the discount rate refers to the interest rate charged to the commercial banks and other financial institutions for the loans they take from the Federal...