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