Monthly return

[compound1]

I need to solve for X in the following equation and want to use this formula in MS excel. Pleas help

(1+X)^Y=Z

Y and Z are given.

 

[chrisr]

(1+x)[sup:1obcd4ov]y[/sup:1obcd4ov]=z
{(1+x)[sup:1obcd4ov]y[/sup:1obcd4ov]}[sup:1obcd4ov]1/y[/sup:1obcd4ov]=z[sup:1obcd4ov]1/y[/sup:1obcd4ov]
1+x=z[sup:1obcd4ov]1/y[/sup:1obcd4ov]
x=z[sup:1obcd4ov]1/y[/sup:1obcd4ov]-1

 

[Denis]

I need to solve for X in the following equation and want to use this formula in MS excel.
(1+X)^Y=Z

Just remember that if a^x = b, then a = b^(1/x)

 

[Deleted member 4993]

I need to solve for X in the following equation and want to use this formula in MS excel. Pleas help

(1+X)^Y=Z

Y and Z are given.

You could also use "log" or "ln" functions here.

Y * Ln(1+X) = Ln(Z)

Ln(1+X) = Ln(Z)/Y

1+ X = EXP(Ln(Z)/Y)

X = EXP(Ln(Z)/Y) -1

Ofcourse, this is same as the answer above - except put in a different form.

 

[Denis]

X = EXP(Ln(Z)/Y) -1

How can you be so cruel at Xmas :wink: