Unformatted text preview: time of the last payment. FVAn = pmt * ((1 + rate) ^ (-time) - 1) / rate End Function Function GrAn(time As Double, discount As Double, growthRate As Double, Optional pmt As Double = 1) ' Computes the PV of a series of regular, growing payments. GrAn = pmt * (1 - ((1 + growthRate) / (1 + discount)) ^ time) / (discount -growthRate) End Function...
View Full Document
- Summer '07
- Visual Basic for Applications, Gran, Optional pmt