Posted to microsoft.public.excel.worksheet.functions

John

Posts: n/a

yield on bond priced over 100

Why does excel seem to only calculate yield using prices under $100. What if
a security is priced above par? Am I missing something?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Calculating Bond Price	legu	Excel Worksheet Functions	0	January 16th 06 04:43 PM
Yield Maintenance - Mortgage Prepayment Penalty	zeno	Excel Discussion (Misc queries)	1	December 14th 05 11:24 PM
date and bond calculations	saturnin02	Excel Worksheet Functions	1	April 29th 05 05:34 PM
Bond Yield Template with Payment schecule and chart (Excel)	Jen	Excel Discussion (Misc queries)	3	April 28th 05 08:18 PM
yield to call	Dins95	Excel Discussion (Misc queries)	1	January 6th 05 02:36 AM

All times are GMT +1. The time now is 10:39 AM.

About Us

"It's about Microsoft Excel"