Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- Home
- >
- After Effects
- >
- Future Value calculation/expression in After Effec...

Highlighted

New Here
,

Sep 16, 2020

Copy link to clipboard

Copied

Hi guys,

Excel has a function called Future Value, it looks like this:

Future Value (rate, nper, pmt, [pv], [type])

rate - The interest rate per period. |

nper - The total number of payment periods. |

pmt - The payment made each period. Must be entered as a negative number. |

pv - The present value of future payments. If omitted, assumed to be zero. Must be entered as a negative number. |

type - When payments are due. 0 = end of period, 1 = beginning of period. Default is 0. |

I'm looking for a way to replicate this calculation within after effects in order to see a realtime calculation as I animate.

Any help greatly appreciated,

Marc

Adobe Community Professional

You would need to use the actual formula for future value.

Make variables for each thing and then pop them together into a formula. Your formula seems a little different than the ones I found by Googling, but you can probably find one and build your expression pretty easily.

The one I found was FV = PV (1 + *r*)*n*

Future Value was present value times 1 + rate to the power of number of periods.

So, the expression would be something like this (where you replace the x with a link to an expression effect slider):

```
PV = x;
R = x;
N = x;
poower = Math.pow(1+R,N);
PV*poooower
```

I don't have AE open to test it, but I don't think I'm too far off.

TOPICS

Expressions,
Scripting

Community Guidelines

Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

New Here
,

Sep 16, 2020

Copy link to clipboard

Copied

Hi guys,

Excel has a function called Future Value, it looks like this:

Future Value (rate, nper, pmt, [pv], [type])

rate - The interest rate per period. |

nper - The total number of payment periods. |

pmt - The payment made each period. Must be entered as a negative number. |

pv - The present value of future payments. If omitted, assumed to be zero. Must be entered as a negative number. |

type - When payments are due. 0 = end of period, 1 = beginning of period. Default is 0. |

I'm looking for a way to replicate this calculation within after effects in order to see a realtime calculation as I animate.

Any help greatly appreciated,

Marc

Adobe Community Professional

You would need to use the actual formula for future value.

Make variables for each thing and then pop them together into a formula. Your formula seems a little different than the ones I found by Googling, but you can probably find one and build your expression pretty easily.

The one I found was FV = PV (1 + *r*)*n*

Future Value was present value times 1 + rate to the power of number of periods.

So, the expression would be something like this (where you replace the x with a link to an expression effect slider):

```
PV = x;
R = x;
N = x;
poower = Math.pow(1+R,N);
PV*poooower
```

I don't have AE open to test it, but I don't think I'm too far off.

TOPICS

Expressions,
Scripting

Community Guidelines

Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

CreativeCI

Sep 16, 2020
0
/t5/after-effects/future-value-calculation-expression-in-after-effects/td-p/11437927
10
Replies
10

Adobe Community Professional
,

Sep 16, 2020

Copy link to clipboard

Copied

You would need to use the actual formula for future value.

Make variables for each thing and then pop them together into a formula. Your formula seems a little different than the ones I found by Googling, but you can probably find one and build your expression pretty easily.

The one I found was FV = PV (1 + *r*)*n*

Future Value was present value times 1 + rate to the power of number of periods.

So, the expression would be something like this (where you replace the x with a link to an expression effect slider):

```
PV = x;
R = x;
N = x;
poower = Math.pow(1+R,N);
PV*poooower
```

I don't have AE open to test it, but I don't think I'm too far off.

Community Guidelines

Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

Reply

Loading...

Szalam

Sep 16, 2020
0
/t5/after-effects/future-value-calculation-expression-in-after-effects/m-p/11438054#M150020
New Here
,

Sep 16, 2020

Copy link to clipboard

Copied

Thanks both,

To add context, I’m looking to build an animation of a mobile application that, in real time, shows the expected value of an investment.

There are three inputs, two are financial;

1. A monthly contribution (in units of £10)

2. An optional, one off, upfront lump sum (in units of £100)

Then there are a number of scenarios; each link a period of time with their own annual interest rate.

E.g:

1 year = 1%

2 years = 1.5%

Etc.

In the app, as the user manipulates any of the inputs, the expected outcome updates in real time. The user manipulates the inputs via ‘sliders’ therefore I’d like the expected outcome to update whenever the units are updated.

As an example:

User selects a scenario with an annual interest rate of 1.5%, for 2 years with a monthly contribution of £100.

The animation should show the financial slider starting at £0 working its way up to £100 in £10 intervals, at each interval the expected outcome should update. (This process would repeat if there was an upfront lump sum to consider).

The expected outcome should be able to display up to 8 figures (i.e tens of millions), to 2 decimal places (eg £12,345,678.90).

I hope that provides some clarity, happy to provide further information. I appreciate your help with this.

Community Guidelines

Reply

Loading...

CreativeCI

Sep 16, 2020
0
/t5/after-effects/future-value-calculation-expression-in-after-effects/m-p/11438441#M150034
Most Valuable Participant
,

Sep 16, 2020

Copy link to clipboard

Copied

You will need to be more specific about what you are actually trying to extrapolate and to what properties you want to apply the expression. Calculating fixed interest rates as Szalam provided the pseudo-code for is different from other stuff, including variable interest rates as per the Excel formula. That and from a mere technical standpoint you may actually need extra code to get nice values that AE actualyl can display. Especially with exponential stuff it's easy enough to exhaust AE's internal integer limit and then nothing will work anymore and the expression be disabled. So for all intents and purposes, it might be good if you actually provided a more detailed explanation rather than just asking how to translate a formula from another program.

Mylenium

Community Guidelines

Reply

Loading...

Mylenium

Sep 16, 2020
0
/t5/after-effects/future-value-calculation-expression-in-after-effects/m-p/11438249#M150025
New Here
,

Sep 16, 2020

Copy link to clipboard

Copied

Thanks both,

To add context, I’m looking to build an animation of a mobile application that, in real time, shows the expected value of an investment.

There are three inputs, two are financial;

1. A monthly contribution (in units of £10)

2. An optional, one off, upfront lump sum (in units of £100)

Then there are a number of scenarios; each link a period of time with their own annual interest rate.

E.g:

1 year = 1%

2 years = 1.5%

Etc.

In the app, as the user manipulates any of the inputs, the expected outcome updates in real time. The user manipulates the inputs via ‘sliders’ therefore I’d like the expected outcome to update whenever the units are updated.

As an example:

User selects a scenario with an annual interest rate of 1.5%, for 2 years with a monthly contribution of £100.

The animation should show the financial slider starting at £0 working its way up to £100 in £10 intervals, at each interval the expected outcome should update. (This process would repeat if there was an upfront lump sum to consider).

The expected outcome should be able to display up to 8 figures (i.e tens of millions), to 2 decimal places (eg £12,345,678.90).

I hope that provides some clarity, happy to provide further information. I appreciate your help with this.

Community Guidelines

Reply

Loading...

CreativeCI

Sep 16, 2020
0
/t5/after-effects/future-value-calculation-expression-in-after-effects/m-p/11438367#M150031
Guide
,

Sep 16, 2020

Copy link to clipboard

Copied

I'm not sure what AE is doing here?

AE is for rendering videos files - do you want to pre-render all possibilites?

*Martin

Community Guidelines

Reply

Loading...

Martin_Ritter

Sep 16, 2020
0
/t5/after-effects/future-value-calculation-expression-in-after-effects/m-p/11439423#M150074
New Here
,

Sep 17, 2020

Copy link to clipboard

Copied

Okay, apologies if my post is unclear.

I'm creating a video of a financial mobile application. When the user manipulates three inputs, the total will show the potential return. Therefore I need to animate various scenarios to demonstrate this.

In AE I have designed the app and input sliders, and I can separately animate the total to end up at the corret totals, however unless the total is dynamically linked to the inputs (via the correct formula), the total inbetween scenarios/keyframes will be incorrect.

Does that help explain the situation better? Again apologies if not.

Community Guidelines

Reply

Loading...

CreativeCI

Sep 17, 2020
0
/t5/after-effects/future-value-calculation-expression-in-after-effects/m-p/11439699#M150079
Most Valuable Participant
,

Sep 17, 2020

Copy link to clipboard

Copied

Slightly pointless to even rig it up, to be honest. You would have to keyframe so many input parameters, animating the bars or whatever directly would be more efficient and take less time. and with variable payment cycles and interest rates it would have to run inside one big hunking loop, anyway, or else the values wouldn't accumulate correctly, with the real kicker being that it would use valueAtTime() a lot and AE having to look up of different values at different times in potentially millions of loops will slow down things to a point where it's just not funny anymore. I would really suggest you stick to Excel, pick a few sample values and only animate those. the effort required to implement this cleanly in AE would only make sense if you'd use it as an actual template e.g. for broadcast graphics, but not for some unimportant UI mockup that likely will change quicker than you can render your dummies.

Mylenium

Community Guidelines

Reply

Loading...

Mylenium

Sep 17, 2020
0
/t5/after-effects/future-value-calculation-expression-in-after-effects/m-p/11440298#M150108
New Here
,

Sep 18, 2020

Copy link to clipboard

Copied

Thanks for the comments.

Just to update to say that after some perseverance I managed to get achieve what I set out to.

Thanks to Szalam for the inspiration and example - using this I was able to find the formula I needed and break this down in after effects into expressions. I now have a fully working app in AE with the average return dynamically updating as I manipulate and keyframe the input sliders, allowing me to create animations of any scenario with just 3 keyframes. Amazing!

Community Guidelines

Reply

Loading...

CreativeCI

Sep 18, 2020
0
/t5/after-effects/future-value-calculation-expression-in-after-effects/m-p/11443344#M150235
Adobe Community Professional
,

Sep 18, 2020

Copy link to clipboard

Copied

What gets really cool is that you can put those controls into the EGP and make them Master Properties. Then, you can make duplicates of that comp with different values of the controls, but then easily go back into the comp and change things like color and layout and it ripples through all the copies that have unique values.

Community Guidelines

Reply

Loading...

Szalam

Sep 18, 2020
1
/t5/after-effects/future-value-calculation-expression-in-after-effects/m-p/11443469#M150241
CreativeCI
LATEST

New Here
,

Sep 18, 2020

Copy link to clipboard

Copied

Community Guidelines

Reply

Loading...

CreativeCI

Sep 18, 2020
0
/t5/after-effects/future-value-calculation-expression-in-after-effects/m-p/11443672#M150245
Using the Community
Experience League
Terms of Use
Privacy Policy
Cookie preferences
AdChoices
Language:

- Deutsch
- English
- Español
- Français
- 日本語コミュニティ
- Português

Copyright © 2020 Adobe. All rights reserved.