Compare Page Revisions
« Older Revision - Back to Page History - Newer Revision »
N
APR/12
Function AnnuityToPvRatio(i As Double, N As Integer) As Double Dim fp As Double fp = FutureToPvRatio(i, N) AnnuityToPvRatio = (i * fp) / (fp - 1) End Function Function FutureToPvRatio(i As Double, N As Integer) As Double FutureToPvRatio = (1 + i) ^ N End Function
i (1+i)^N A/P = --------------- (1+i)^N - 1 i (F/P) = ------------- (F/P) - 1
ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.