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 = |