Difference in Values for Price function in Excel
 

Hi
I am trying to calculate the Price of a bond using the function as pe
the Excel and calculating the price manually as per the formula give
in excelhelp
however there appears to be a difference in the same.
can anyone help me on this please?
Best Regards
Abh

--
abhi_2
-----------------------------------------------------------------------
abhi_23's Profile: http://www.excelforum.com/member.php...fo&userid=3051
View this thread: http://www.excelforum.com/showthread.php?threadid=50162

Difference in Values for Price function in Excel
 

Might be more helpful if you give both sets of equations so we can help.
Unless someone already knows and can answer your question without more info.

"abhi_23" wrote:


Hi
I am trying to calculate the Price of a bond using the function as per
the Excel and calculating the price manually as per the formula given
in excelhelp
however there appears to be a difference in the same.
can anyone help me on this please?
Best Regards
Abhi


--
abhi_23
------------------------------------------------------------------------
abhi_23's Profile: http://www.excelforum.com/member.php...o&userid=30511
View this thread: http://www.excelforum.com/showthread...hreadid=501625

Difference in Values for Price function in Excel
 

Hi GB
I am attaching the sample file for your reference.
Any inputs are welcome.
Best Regards
Abh

+-------------------------------------------------------------------
|Filename: Sample for query.zip
|Download: http://www.excelforum.com/attachment.php?postid=4223
+-------------------------------------------------------------------

--
abhi_2
-----------------------------------------------------------------------
abhi_23's Profile: http://www.excelforum.com/member.php...fo&userid=3051
View this thread: http://www.excelforum.com/showthread.php?threadid=50162

Difference in Values for Price function in Excel
 

Hi
I have attached the help document of the price function in excel, If
any one can help me with this.
Best Regards
Abhijit


+-------------------------------------------------------------------+
|Filename: Sample for query.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4227 |
+-------------------------------------------------------------------+

--
abhi_23
------------------------------------------------------------------------
abhi_23's Profile: http://www.excelforum.com/member.php...o&userid=30511
View this thread: http://www.excelforum.com/showthread...hreadid=501625

Difference in Values for Price function in Excel
 

For one reason or another I am unable to get to the files that are attached
to your posts. Maybe someone else still can. :\

"abhi_23" wrote:


Hi
I have attached the help document of the price function in excel, If
any one can help me with this.
Best Regards
Abhijit


+-------------------------------------------------------------------+
|Filename: Sample for query.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4227 |
+-------------------------------------------------------------------+

--
abhi_23
------------------------------------------------------------------------
abhi_23's Profile: http://www.excelforum.com/member.php...o&userid=30511
View this thread: http://www.excelforum.com/showthread...hreadid=501625

Difference in Values for Price function in Excel
 

Hi,
I have made some changes to the attachments so as to make me query to
be understood better.
Anyone who can help me on this. just to brief you people again on this
my query is as follows:

I am trying to calculate the Price of a bond using the price formula
there apprears to be a difference in the results when the
Price is calculated as per the formula and when one calculates the
Price using the Definition of the Formula ( Excel help ) manually.
Refer the attachments for the sample calculations as well as the
formula definitions

Thanks
Abhi


+-------------------------------------------------------------------+
|Filename: Sample for query.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4234 |
+-------------------------------------------------------------------+

--
abhi_23
------------------------------------------------------------------------
abhi_23's Profile: http://www.excelforum.com/member.php...o&userid=30511
View this thread: http://www.excelforum.com/showthread...hreadid=501625