SCF

02-13-2016, 12:44 PM

Having trouble making the RATE formula work. Tried the formula in the excel but get #NUM response. I would post the attachment here but this site will not let me.

View Full Version : HELP with Formula to calculate Interest Rate

SCF

02-13-2016, 12:44 PM

Having trouble making the RATE formula work. Tried the formula in the excel but get #NUM response. I would post the attachment here but this site will not let me.

Aussiebear

02-13-2016, 06:25 PM

The #Num! error occurs if you have failed to use a negative figure for the payment amount.

SCF

02-14-2016, 04:56 AM

Thank You

SCF

02-15-2016, 12:34 PM

I thought it was solved because it gave me a % but when I checked it with my calculator I got a different %

SCF

02-15-2016, 12:44 PM

This is the excel for formula =RATE(Z55/52,-Y55,R55)*-1

NUMBERS …. Z55 = 182, Y55 = $55, R55=$3360

Z55 = term( this is weekly payments) Y55 = weekly payment, R55 = Present value

The formula calculates a 65% Yield …My calculator say 79.74%

The figures Z55,Y55 and R55 are calculated formulas not direct entered ( if that makes a difference?)

NUMBERS …. Z55 = 182, Y55 = $55, R55=$3360

Z55 = term( this is weekly payments) Y55 = weekly payment, R55 = Present value

The formula calculates a 65% Yield …My calculator say 79.74%

The figures Z55,Y55 and R55 are calculated formulas not direct entered ( if that makes a difference?)

SCF

02-15-2016, 12:54 PM

I just tried the formula by direct entered numbers ( not formulas) does the same thing

Paul_Hossler

02-16-2016, 05:24 PM

Your calculator is right, your Excel is wrong

You're dividing by 52 in the wrong place, and you should be multiplying the RATE() by it

15420

You're dividing by 52 in the wrong place, and you should be multiplying the RATE() by it

15420

Aussiebear

02-16-2016, 05:48 PM

I agree with Paul, as the need to divide the number of payments is outside the Nper requirements

Powered by vBulletin® Version 4.2.5 Copyright © 2019 vBulletin Solutions Inc. All rights reserved.