Question: please show the formula and answer in excel f find...
Question details
Please show the formula and answer in Excel
| f. Find the PV of an ordinary annuity that pays $1,000 at the end of each of the next 5 years if the interest rate is 15%. Then find the FV of that same annuity. | ||||||
| Inputs: | PMT = | $ 1,000 | ||||
| N = | 5 | |||||
| I/YR = | 15% | |||||
| PV: Use function wizard (PV) | PV = | |||||
| FV: Use function wizard (FV) | FV = | |||||
Solution by an expert tutor
