Jump to content

Wikipedia:Reference desk/Archives/Mathematics/2014 January 30

From Wikipedia, the free encyclopedia
Mathematics desk
< January 29 << Dec | January | Feb >> Current desk >
Welcome to the Wikipedia Mathematics Reference Desk Archives
The page you are currently viewing is a transcluded archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages.


January 30

[edit]

ANNUITY

[edit]

How can I make r as subject of the following formula? A=R(1-(1+r)^-n)/r Thank you.175.157.115.182 (talk) 16:13, 30 January 2014 (UTC)[reply]

In general (unless n is small) you cannot express r as a simple function of A, R and n. You can, however, solve for r using numerical methods - see internal rate of return. Gandalf61 (talk) 16:37, 30 January 2014 (UTC)[reply]
... and you can set that up very easily on a spreadsheet, then use goal seek. Dbfirs 17:37, 30 January 2014 (UTC)[reply]
MS Excel even has a built in function for this: IRR(). OldTimeNESter (talk) 20:08, 31 January 2014 (UTC)[reply]

The equation in terms of r is non-linear and there is no formula for it. However you can write

f(r) = A - R(1-(1+r)^-n)/r

And search for values of r that makes f(r) = 0 , probably the easiest is to ask the computer to plot the graph of f(r). 202.177.218.59 (talk) 23:15, 2 February 2014 (UTC)[reply]

Use the binomial theorem

Truncate the series and solve the resulting algebraic equation numerically. Bo Jacoby (talk) 11:11, 3 February 2014 (UTC).[reply]