S
shepzuck
need for projected csah flow report.thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
Not much info to go on, but one way:
B1: = A1 * 1.02
B1: = A1 * 1.02
S
shepzuck
Thanks.Can you advise how to apply the 2% increase to each succeeding year as
a formula ?Thanks.
a formula ?Thanks.
F
Fred Smith
Yes, just keep mulitplying the previous year by 1.02.
If you want to calculate multiple years in one formula, you want the future
value function.
PV=Starting Cash Flow
IntRate=2%
Nper=Number of years
Regards,
Fred.
If you want to calculate multiple years in one formula, you want the future
value function.
PV=Starting Cash Flow
IntRate=2%
Nper=Number of years
Regards,
Fred.
S
shepzuck
Thanks for the assist.
Fred Smith said:Yes, just keep mulitplying the previous year by 1.02.
If you want to calculate multiple years in one formula, you want the future
value function.
PV=Starting Cash Flow
IntRate=2%
Nper=Number of years
Regards,
Fred.