tag:blogger.com,1999:blog-4667220180824072004.post5134438190256807904..comments2017-06-05T10:10:48.636-07:00Comments on Charlotte Credit Technology: SQL 2008 Excel-like RATE Function ReduxMicah Minarikhttp://www.blogger.com/profile/02534860732247959746noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-4667220180824072004.post-29251681036602052892009-04-23T12:40:00.000-07:002009-04-23T12:40:00.000-07:00flockenator,
Thanks for the heads up. Looks like...flockenator,<br /><br />Thanks for the heads up. Looks like good stuff.<br /><br />MicahMicah Minarikhttps://www.blogger.com/profile/02534860732247959746noreply@blogger.comtag:blogger.com,1999:blog-4667220180824072004.post-73337004139554879122009-04-02T07:18:00.000-07:002009-04-02T07:18:00.000-07:00You can now find every EXCEL function implemented ...You can now find every EXCEL function implemented in SQL Server at www.westclintech.com. The functions are organized along the same lines as EXCEL, so there are financial functions, engineering fucntions, statistical functions, math functions, etc. They all work exactly the same as EXCEL (and in some instances are less restrictive than EXCEL) and can be used like any user-defined function in SQL Serverflockenatorhttps://www.blogger.com/profile/02257946420572511664noreply@blogger.comtag:blogger.com,1999:blog-4667220180824072004.post-75872137695367283932009-03-11T14:40:00.000-07:002009-03-11T14:40:00.000-07:00Piyush,You are correct, the CAGR formula you descr...Piyush,<BR/><BR/>You are correct, the CAGR formula you describe is correct for determining rates of return with no payment stream. For payment streams, it is necessary to use the basic DCF techniques implied by the Rate function.<BR/><BR/>MicahMicah Minarikhttps://www.blogger.com/profile/02534860732247959746noreply@blogger.comtag:blogger.com,1999:blog-4667220180824072004.post-84012759717887415412009-01-23T08:11:00.000-08:002009-01-23T08:11:00.000-08:00I was looking for this function and got your site....I was looking for this function and got your site. <BR/><BR/>Interestingly the CAGR() formula using wikipedia gives the exact value as the Rate() function in Excel. CAGR was easy to implement in my case. <BR/><BR/>CAGR = ((futurevalue/previousvalue)^(1/number-of-years)) - 1Piyushnoreply@blogger.comtag:blogger.com,1999:blog-4667220180824072004.post-62237199501419155042008-11-30T18:44:00.000-08:002008-11-30T18:44:00.000-08:00Drew,Unfortunately, you would need the payment to ...Drew,<BR/><BR/>Unfortunately, you would need the payment to give you an accurate calculation of the interest rate. You may be able to infer the payment based on the delta and periods and then plug them into the function.<BR/><BR/>We actually use this function to calculate yield to maturities on loans. The only drawback is the bullet (full par repayment at maturity) assumption which will lose you principal/discount amortization in the calculation.<BR/><BR/>Let me know if that works.<BR/><BR/>MicahMicah Minarikhttps://www.blogger.com/profile/02534860732247959746noreply@blogger.comtag:blogger.com,1999:blog-4667220180824072004.post-73409545838324636032008-11-26T15:10:00.000-08:002008-11-26T15:10:00.000-08:00Hey, what if I want to calculate an interest rate ...Hey, what if I want to calculate an interest rate on a loan? The only values I have are:<BR/><BR/>1. the delta between original balance and current balance<BR/>2. the number of periods that have transpired<BR/>3. the term of the loan<BR/><BR/>can it be done?<BR/><BR/>-DrewAndrew Frazierhttps://www.blogger.com/profile/06891761261926460849noreply@blogger.com