How do you solve for "x" here?

[grimm1111]

How would I solve for "x" in this equation?

P = (c/x) * (1 - (1/(1+x)^t))


I'm stuck.

 

[Deleted member 4993]

How would I solve for "x" in this equation?

P = (c/x) * (1 - (1/(1+x)^t))


I'm stuck.

You can get approximate solutions using numerical method.

 

[grimm1111]

You can get approximate solutions using numerical method.

I'm trying to build an excel model that solves for "x"

("x" is a discount rate, "p" is present value, "c" is cash flow, and "t" is time periods)

 

[Deleted member 4993]

I'm trying to build an excel model that solves for "x"

("x" is a discount rate, "p" is present value, "c" is cash flow, and "t" is time periods)

Not sure ... but I seem to remember that excel has a function.

If you cannot find the "canned" function - use "goal-seek" - that'll do your job.

 

[Denis]

...in other words: CANNOT be solved directly.

Have a look at the formulas for PV and FV of annuities...