Directory of Open Source for Quantitative Finance and Trading
Username: Password: Not registered?
 
Quick Search:    (AJAX based: No need to press button)

Main : Excel : 


Category: Excel View Full Details
Download Now!Caplet pricing using Black's formula
Submitter: vanna Date: 2008/2/2
Description:
This file calculates caplet price using Black's formula

where

and


Input parameters are:
Principal amount
Start time for caplet (Yrs) Tk
End time of caplet (Yrs) Tk+1
Discount factor from t0 to Tk+1 [P(0,Tk+1)]
Forward rate Fk applicable from Tk to Tk+1
Strike rate for caplet Rk
Volatility of forward rate Fk (annualized)

Got a question or problem with this link? Just enter your message and click on submit. No registration is required.

Note: A copy of this message will also be emailed to the submitter of this link
Downloaded 2184 times  2184  File Size 0 bytes  Supported Platforms Excel VBA  Home Page http://www.quantcode.com/
Rating: 0.00 (0 votes)
Rate this File | Modify | Delete | Report Broken File | Tell a Friend | Comments (34)

Discuss this file. Just enter your message and click on submit. No registration is required.
Similar Links:
Help for pricing caplet using LMM in VBA (Forum)
Swaplet pricing in LMM using MC simulation (Software)
Black 76 Formula in VBA (Software)
Basket CDS pricing using Copula (Software)
Accumulator pricing (Forum)

Subscribe to RSS or daily email updates of latest quantitative finance code listings
Email address :
Copyright © 2011 QuantCode Inc. All rights reserved.