Originally Posted by

**tw35758** but I'm completely lost on how to do a similar conversion for the FV formula or if it's even possible. I'm trying to create an Excel file comparing the result of various investments with different dividend yields and dividend growth rates, so having a single formula in a cell for each value of n would make creating that file much easier.

I will reply to your new post tomorrow

For now, see the following code in Excel to use the tadFVSchedule function that answers the original question

Code:

Public Function tadFVSchedule(ByVal pv As Double, ByVal r As Double, ByVal g As Double, ByVal n As Double, Optional ByRef c As Double = 1, Optional ByRef p As Double = 1, Optional ByRef d As Double = 1) As Double
Dim fraction As Double
Dim sum As Double
Dim k As Integer
sum = 0#
fraction = n - Int(n)
For k = 0 To Int(n - 1)
sum = sum + p * d * Log(1 + r * (1 + g) ^ k)
Next k
If (fraction <> 0) Then
k = Int(n + 0.5)
sum = sum + ((fraction - 1) * p + p * d) * Log(1 + r * (1 + g) ^ k)
End If
tadFVSchedule = pv * Exp(sum)
End Function

pv | r | g | n | c | p | d | fv |

1000 | 3% | 5% | 3 | 1 | 1 | 1 | 1097.59 |

1000 | 3% | 5% | 10 | 1 | 1 | 1 | 1448.11 |

1000 | 3% | 5% | 3.5 | 1 | 1 | 1 | 1117.42 |

1000 | 3% | 5% | 10.5 | 1 | 1 | 1 | 1484.80 |

1000 | 3% | 5% | 3 | =1/12 | 1 | 1 | 1097.59 |

1000 | 3% | 5% | 10 | =1/12 | 1 | 1 | 1448.11 |

1000 | 3% | 5% | 3 | 1 | =1/12 | 1 | 1007.79 |

1000 | 3% | 5% | 10 | 1 | =1/12 | 1 | 1031.34 |

1000 | 3% | 5% | 3 | =1/12 | =1/12 | 1 | 1007.79 |

1000 | 3% | 5% | 10 | =1/12 | =1/12 | 1 | 1031.34 |

1000 | 3% | 5% | 3 | 1 | 1 | =1/2 | 1047.66 |

1000 | 3% | 5% | 10 | 1 | 1 | =1/2 | 1203.38 |

1000 | 3% | 5% | 3.5 | 1 | 1 | =1/2 | 1047.66 |

1000 | 3% | 5% | 10.5 | 1 | 1 | =1/2 | 1203.38 |

1000 | 3% | 5% | 3 | =1/12 | 1 | =1/2 | 1047.66 |

1000 | 3% | 5% | 10 | =1/12 | 1 | =1/2 | 1203.38 |

1000 | 3% | 5% | 3 | 1 | =1/12 | =1/2 | 1003.89 |

1000 | 3% | 5% | 10 | 1 | =1/12 | =1/2 | 1015.55 |

1000 | 3% | 5% | 3 | =1/12 | =1/12 | =1/2 | 1003.89 |

1000 | 3% | 5% | 10 | =1/12 | =1/12 | =1/2 | 1015.55 |