LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to use RATE function?

Could anyone give me any suggestion on how to use RATE function?

F=A*((1+r)^n-1)/r

r = interest rate
n = number of installment for a fixed investment plan
A = fixed amount for each installment
F = Final capital value

For example, an insurance saving plan offers $20,000 return in the
next 20 years by paying $600 every year. How to determine the interest
rate?
((1+r)^n-1)/r = $20,000 / $600 = 33.333, when n is 20, then r will
equal to approximate 5%.

0% < r, r is a real number for the interest rate, which could be 10%
or 300%
n is a positive integer for any number of term.

There is a RATE function in excel, could anyone give me any suggestion on
how to determine the interest rate based on the above example please?

RATE(nper,pmt,pv,fv,type,guess)
RATE(20,600,20000,fv,type,guess)

What are the value fv, type, guess for this example?

Thank you in advance
Eric
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rate function with #Num! result PA Excel Worksheet Functions 2 August 1st 06 12:11 AM
bank cal for interest on cd Frank Malone Excel Worksheet Functions 12 June 11th 06 10:27 PM
numerical integration integreat Excel Discussion (Misc queries) 4 May 12th 06 02:40 AM
a function giving the interest rate for inv x for period y & bal z cal777 Excel Worksheet Functions 1 August 3rd 05 06:16 PM
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM


All times are GMT +1. The time now is 07:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"