B
Brent Starks
This is an open letter to all who contributed solutions
to my problem. I finally went with Harlan Grove's and
entered the PV argument. Simple and effective.
=FV(((1+Rate/12)^12-1)*(1-TaxRate),Years,
-FV(Rate/12,12,-Pmt,0,1)*(1-TaxRate)-12*Pmt*TaxRate,
-FirstPmt,0)
It worked fine this time, although it didn't the first
time I tried to use it (perhaps because I entered an
argument incorrectly). Thanks again to Ron Rosenfeld,
Fred Smith, Harlan Grove, Mangesh and Dana. I shall
continue to study your varied solutions to help me become
better at writing Excel programs.
Brent Starks
to my problem. I finally went with Harlan Grove's and
entered the PV argument. Simple and effective.
=FV(((1+Rate/12)^12-1)*(1-TaxRate),Years,
-FV(Rate/12,12,-Pmt,0,1)*(1-TaxRate)-12*Pmt*TaxRate,
-FirstPmt,0)
It worked fine this time, although it didn't the first
time I tried to use it (perhaps because I entered an
argument incorrectly). Thanks again to Ron Rosenfeld,
Fred Smith, Harlan Grove, Mangesh and Dana. I shall
continue to study your varied solutions to help me become
better at writing Excel programs.
Brent Starks