Ask Your Question
0

Why do I get error message 502 when using INTRATE() function? [closed]

asked 2014-06-26 15:36:37 +0200

john.leone.982 gravatar image

updated 2014-06-28 04:55:36 +0200

oweng gravatar image

I entered the following information

Settlement    2013-8-9
Maturity      2014-6-24
Investment    10000
Redemption    12000
Basis         3
edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-01 21:12:28.874518

Comments

What is "intrate function"? What is your formula?

bencomp gravatar imagebencomp ( 2014-06-26 22:44:58 +0200 )edit
1

There is a INTRATE function with the above mentioned input values.

horst gravatar imagehorst ( 2014-06-27 17:46:27 +0200 )edit

Oh, I see :) Thanks for editing the question!

bencomp gravatar imagebencomp ( 2014-06-29 11:05:11 +0200 )edit

3 Answers

Sort by » oldest newest most voted
2

answered 2014-06-26 19:05:03 +0200

horst gravatar image

updated 2014-06-28 21:36:43 +0200

Error 502 means normally a wrong format (number, date..) in the input fields of a formula. Check if your date format is the input format defined in Tools>Options>Languages Settings>Languages "Date acceptance Patterns".

EDIT: I inserted your values in the formula and discovered that you have to enter dates as strings "2013-8-9" with the quotation marks. If you enter them without you get the Error 502.

So forget what I wrote before. EDIT End.

edit flag offensive delete link more

Comments

@horst, thanks for your comment against the question. It all makes more sense now.

oweng gravatar imageoweng ( 2014-06-28 04:45:48 +0200 )edit
1

answered 2014-08-04 13:21:13 +0200

FinancialEngin33r gravatar image

Its seems INTRATE gives an equivalent annual average interest rate on an investment (i.e. zero coupon bond with short durations) that does not earn or pay any interest

It is the uncompounded or undiscounted interest rate where the security does not pay or earn any interest. The security is bought at a discount and at maturity pays the par value or face value of the security

Since the rate is not discounted or compounded thus the regular discounted formula is not used

Instead the INTRATE at first finds what they call the HPR - holding period return as follows

HPR = (maturity value - investment value) / investment value or HPR = (maturity value / investment value) - 1

Then it accounts the HPR for duration of the investment using various day count conventions

INTRATE = HPR * (number of days in a year / duration of investments in days)

The example calculation for your data would be

HPR = (12000 - 10000) / 10000 = 0.2 or HPR = (12000 / 10000) - 1 = 0.2

number of days in a year (basis 3) = 365 duration of investment in days = (6/24/2014)-(08/09/2013) = 319

INTRATE = 0.2 * 365 / 319 INTRATE = 0.2288401254

INTRATE = 22.88%

More on financial topics may be viewed here http://www.dailymotion.com/abraham-jo...

edit flag offensive delete link more
0

answered 2014-06-27 12:21:29 +0200

Jens S gravatar image

Set your output to -12000 (redemption as +12000 is meaningless) and use this formula:

=XIRR(B1:B2;A1:A2) with the result 26%

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-06-26 15:36:37 +0200

Seen: 4,904 times

Last updated: Aug 04 '14