[Pearle44]

I have saved this URL as a favourite thinking I will be come very good friend with a lot of you. I hope to contribute back as well.
I am challenged with an Excel formula. I know the end state and % increase but don't know the start value (ie., 10$ TY at 25% Growth vPY) what is start value for PY?
My co-worker and I have been trying to figure this out for 1 hour, help.

[Advertisements]

I've probably missed what you're looking for but...

if x * 1.25 = y then x = y/1.25

So if you don't know what you started with (x) but know that x grew at 25% and ended at $10 then...

x * 1.25 = 10 then x = 10/1.25 = $8

So you started with $8

Now you can tell me I've misunderstood!

[Vino Rosso]

I've probably missed what you're looking for but...

if x * 1.25 = y then x = y/1.25

So if you don't know what you started with (x) but know that x grew at 25% and ended at $10 then...

x * 1.25 = 10 then x = 10/1.25 = $8

So you started with $8

Now you can tell me I've misunderstood!

[Pearle44]

Yes, you are absolutely right. How would you write that in an excel formula?
Hope you are having a super day, you just made mine.

[Vino Rosso]

Well, it will depend on the formatting used in your spreadsheet but, in general terms, you could try something like:

A1 = Original Unknown value
B1 = Percentage increase (growth) typed as a number e.g. 10% is just 10
C1 = Resulting value typed as a number e.g. $10 is just 10

In A1 type, =C1/(1+(B1/100))

If you type 25 in B1 and 10 in C1, you'll get 8 in A1.

Now mess about with the cell format to get currency, etc.

[Jonesey]

And if you really want, we can introduce compound interest at a later stage!

[Vino Rosso]

And if you really want, we can introduce compound interest at a later stage!

Show off!!