Home |
Search |
Today's Posts |
#1
|
|||
|
|||
A=P(1+i)^n
Trying to do a school project and need to find i in the formula
A=P(1+i/2)^n*2. Also in a different question I need to find n in the formula A=P(1+i/12)^n*12 |
#2
|
|||
|
|||
But what has that got to do with Excel?
This is a paper exercise. Start with A=P(1+i/2)^n*2 = A/P=(1+i/2)^n*2 = A/2P=(1+i/2)^n = (A/2P)^(1/n)=1+i/2 etc Just follow the same steps for the second equation. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "A=P(1+i)^n" wrote in message ... Trying to do a school project and need to find i in the formula A=P(1+i/2)^n*2. Also in a different question I need to find n in the formula A=P(1+i/12)^n*12 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.789 / Virus Database: 534 - Release Date: 07/11/2004 |
#3
|
|||
|
|||
Generally we do not do homework but here's hint for the second question:
take logs Bernard "A=P(1+i)^n" wrote in message ... Trying to do a school project and need to find i in the formula A=P(1+i/2)^n*2. Also in a different question I need to find n in the formula A=P(1+i/12)^n*12 |
#4
|
|||
|
|||
Just guessing, but it looks like a financial equation. See if using
Excel's functions NPER and RATE would help. (for your n & i). -- Dana DeLouis Win XP & Office 2003 "Bernard Liengme" wrote in message ... Generally we do not do homework but here's hint for the second question: take logs Bernard "A=P(1+i)^n" wrote in message ... Trying to do a school project and need to find i in the formula A=P(1+i/2)^n*2. Also in a different question I need to find n in the formula A=P(1+i/12)^n*12 |
#5
|
|||
|
|||
While what you did is correct given XL's rules of operator precedence,
the OP meant ^(n*2). The formula s/he started with calculates the final amount A given a principal P compounded at a periodic rate of i over n periods with compounding occuring every t intervals (where n/t is an integer). Then, A=P(1+i/t)^(n*t) -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... But what has that got to do with Excel? This is a paper exercise. Start with A=P(1+i/2)^n*2 = A/P=(1+i/2)^n*2 = A/2P=(1+i/2)^n = (A/2P)^(1/n)=1+i/2 etc Just follow the same steps for the second equation. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|