Question: *** I understand how to do these questions with pen & paper. I am trying to find out the best way to put this into
*** I understand how to do these questions with pen & paper. I am trying to find out the best way to put this into excel to get the correct answer. Please provide excel formulas.
1. Find the present value of the following mixed stream of cash flows using a 10% annual discount rate. (Assume deposits are made at the end of each year)
| Year | Cash Flow Stream |
| 1 | $20,000 |
| 2 | $15,000 |
| 3 | $10,000 |
2. For each of the following cases, find the future value at the end of the deposit period, assuming that interest is compounded semiannually at the given nominal interest rate.
| Case | Amount Of Initial Deposit | Nominal Interest Rate (%) | Deposit Period (Years) |
| A | $500 | 8 | 2 |
| B | $300 | 6 | 5 |
| C | $1,000 | 10 | 7 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help