very basic problem, trying to find interest with quarterly payments on excel pv= -5000 fv= 7000 p/yr=4 n=28(7yrs times 4 periods) i/yr=4.83% excel gives me 1.20, i need the formula to return 4.83%. i am sure this is easy. thanks for the help
you have to times 1.2 by 4 which gives you 4.8%. The reason b/c you multiplied n by 4.