Jump to content


Photo

BondVal and Amortizers


5 replies to this topic

#1 François Villeneuve

François Villeneuve

    Member

  • Members
  • PipPip
  • 15 posts
  • Location:Ottawa (Canada)
  • Interests:Portfolio Manager at Export Development Canada<br /><br />Mostly interested in fixed income structured notes and their associated swap hedge. (PRDC, Range Accrual, Inverse FRN, CMS Spread, etc.)<br /><br />Also spending time on developing products with Turbo Excel

Posted 12 June 2006 - 09:40 AM

Hello everyone,

I'm trying to use the function BondVal(...) to recover the PV of a loan with multiple disbursements and repayments. The principal outstanding will be a schedule that looks like the following:

0 20
0.5 40
1 60
1.5 80
2 100
2.5 75
3 50
3.5 25
4 0

Will BondVal(...) also PV the principal cash flows?

Thanks

#2 Rich

Rich

    Advanced Member

  • Savvysoft
  • PipPipPip
  • 397 posts
  • Gender:Male

Posted 12 June 2006 - 09:58 AM

Yes.

#3 François Villeneuve

François Villeneuve

    Member

  • Members
  • PipPip
  • 15 posts
  • Location:Ottawa (Canada)
  • Interests:Portfolio Manager at Export Development Canada<br /><br />Mostly interested in fixed income structured notes and their associated swap hedge. (PRDC, Range Accrual, Inverse FRN, CMS Spread, etc.)<br /><br />Also spending time on developing products with Turbo Excel

Posted 23 June 2006 - 01:57 PM

I assume this extends to FRNVal(...) too, right? i.e. By having a par schedule, the FRNVal(...) function will take into account notional cash flows and PV them in order to recover the current price. Could you please confirm?

I assumed yes, and I tried it, but I run into a bug.

I thin there is something wrong with FRNVal(...). When I enter a par schedule, it returns the settlement date. Check out my example below:

First get the answer for:

=FRNVal(38891,38891,38898,100,0.05,5,0,0,0,"*SA0FNB")

It's an FRN settling on 30-Jun-2006 with a par of 100.

Now replace 100 by an array like the following: (30-Jun-2006; 100)
You'll see that the answer is 38898, which is 30-Jun-2006, which is the settlement date.

Do you get the same thing?

#4 Rich

Rich

    Advanced Member

  • Savvysoft
  • PipPipPip
  • 397 posts
  • Gender:Male

Posted 23 June 2006 - 02:22 PM

Yes, we can reproduce it. We'll let you know as soon as we've discovered the source of the problem.

#5 Rich

Rich

    Advanced Member

  • Savvysoft
  • PipPipPip
  • 397 posts
  • Gender:Male

Posted 23 June 2006 - 05:06 PM

The bug has been fixed. For forward starting bonds, it assumed there was no par range entered, just a single value, so it set the value of one of the legs to the first element of the schedule, which was a date, not a notional.

A new version will be posted to the ftp site shortly, with a note in the forum.

#6 Rich

Rich

    Advanced Member

  • Savvysoft
  • PipPipPip
  • 397 posts
  • Gender:Male

Posted 26 June 2006 - 08:44 AM

The new version has now been uploaded.



Reply to this topic



  


2 user(s) are reading this topic

0 members, 2 guests, 0 anonymous users