Hello all, I am having a problem with creating an equation in excel that would return a PV factor such as in the following example:
(Input)
Discount rate: 6%
Study period:30 years
Maintenance Frequency: Every 7 years
(Output)
PV factor
How can I setup an equation that would calculate a PV factor of the maintenance frequency within 30 years so that excel will recognize that there are only 4 maintenance periods which are during the 7th, 14th, 21st and 28th years?
What I mean is instead of having to manually type this:
(1+0.06)^-7 + (1+0.06)^-14 + (1+0.06)^-21 + (1+0.06)^-28
Thanks in advance guys!
(Input)
Discount rate: 6%
Study period:30 years
Maintenance Frequency: Every 7 years
(Output)
PV factor
How can I setup an equation that would calculate a PV factor of the maintenance frequency within 30 years so that excel will recognize that there are only 4 maintenance periods which are during the 7th, 14th, 21st and 28th years?
What I mean is instead of having to manually type this:
(1+0.06)^-7 + (1+0.06)^-14 + (1+0.06)^-21 + (1+0.06)^-28
Thanks in advance guys!