Question: how to calculate pvif in excel?
Answer: Using the formula for calculating the PVIF, the calculation would be $10,000 / (1 + .05) ^ 5. The resulting PVIF figure from the calculation is $7,835.26. The present value of the future sum is then determined by subtracting the PVIF figure from the total future sum to be received.