Help on a formula

Hey everyone, I hope the studies are going well for you… I have a small problem with isolating a variable in a formula. Really appreciate some help… I know I should be stuying :slight_smile: Here goes the formula: A = B*(r-D)*(1+r)^n/((1+r)^n - (1+D)^n) I need to isolate D. how can we start the formula by D = … Thx a lot for the help

You can’t isolate D from this formula. You need to use a numerical method (like Newton’s method) to get D. Excel Solver can do it for you if you don’t have the time to program it yourself.

Thx for your help. One question though: Excel won’t give me the formula, right? it will give the values of D that satisfies a specific value of another variable. Or is it possible to get the expression for the formula… I’m not really familiar with the newton’s method…

I believe you and can use goal seek function to solve for D if all other variables are defined.