Thread: A=P(1+i)^n
View Single Post
  #2   Report Post  
Ken Wright
 
Posts: n/a
Default

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