1. Business
  2. Finance
  3. please show the formula and answer in excel f find...

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
Blurred Solution
This question has been solved
Subscribe to see this solution