J
Jonathan Rigley
Hi,
I am trying to use the RATE Function to calculate the Annual Percentage Rate
for the following Loan:
Loan Amount £300
Payments £15 a week
Duration 30 Weeks
Charges £150
Total Amount Payable £450
The Formula I am using is not giving me the correct result which should be
330%, can any one see where I am going wrong ?
=(RATE(30,-15,300*(50%),0,0))
TIA
Jonathan
I am trying to use the RATE Function to calculate the Annual Percentage Rate
for the following Loan:
Loan Amount £300
Payments £15 a week
Duration 30 Weeks
Charges £150
Total Amount Payable £450
The Formula I am using is not giving me the correct result which should be
330%, can any one see where I am going wrong ?
=(RATE(30,-15,300*(50%),0,0))
TIA
Jonathan