Question: what is pvifa in excel?
Answer: The initial deposit earns interest at the interest rate (r), which perfectly finances a series of (n) consecutive withdrawals and may be written as the following formula: PVIFA = (1 - (1 + r)^-n) / r.