How do I do PVIF function in MS Excel?
N Niek Otten Jan 6, 2007 #2 What are PVIV functions? -- Kind regards, Niek Otten Microsoft MVP - Excel | How do I do PVIF function in MS Excel?
What are PVIV functions? -- Kind regards, Niek Otten Microsoft MVP - Excel | How do I do PVIF function in MS Excel?
J joeu2004 Jan 7, 2007 #3 Niek said: What are PVIV functions? Click to expand... Googling "pvif" finds an "explanation" (by example) at http://lucasbaltes.com/pub/phpfinancials/unix/phpfinancials.phps . Ostensibly, PVIF can be computed by: =(1 + intRate) ^ (1/n) where "intRate" is the compound annual rate, and "n" is the number of compounding periods per year. Alternatively: =rate(n, 0, -1, 1+intRate) But RATE() does not always succeed without the "guess" argument (sigh).
Niek said: What are PVIV functions? Click to expand... Googling "pvif" finds an "explanation" (by example) at http://lucasbaltes.com/pub/phpfinancials/unix/phpfinancials.phps . Ostensibly, PVIF can be computed by: =(1 + intRate) ^ (1/n) where "intRate" is the compound annual rate, and "n" is the number of compounding periods per year. Alternatively: =rate(n, 0, -1, 1+intRate) But RATE() does not always succeed without the "guess" argument (sigh).
