Login In Real Options Valuation,Inc
User Name
:

Password
:

    

Not Registered yet? Register

MODELING TOOLKIT



點擊此處獲得 Basel II 介紹冊子詳細信息或者發送電子郵件到admin@realoptionsvaluation.com 聯系我們以了解更多關於Basel II Modeling Toolkit軟件的信息! Basel II Modeling Toolkit軟件 (高級版) 提供了以下分析軟件和建模工具:

  • MODELING TOOLKIT (BASEL II)軟件
  • RISK SIMULATOR 軟件
  • REAL OPTIONS SLS 軟件

MODELING TOOLKIT 2011(Basel II)
Real Options Valuation公司榮譽推出最新創新成果——Modeling Toolkit(高級版)。 該工具箱涵蓋了風險分析、模擬、預測、Basel II 風險分析、信用違約風險和計量模型等相關領域的800多個分析模型、公式和工具以及300多個Excel/SLS分析模板和實例試算表。該工具箱是將一系列復雜的數學模型通過C++編譯後嵌入到Excel表格中。這1100個模型、公式、表格和SLS模板主要包括:

分析

1. 中心極限定理

2. 中心極限定理(彩票理論)

3. 均值缺陷

4. 數學整合

5. 參數和非參數假設檢驗數據集合

6. 拋體運動

7. 回歸診斷

8. Ships in the Night

9. 統計分析

10. 統計分析

銀行模型

11.建設貸款審計

12.銀行的建設預算

13.分類盈虧平衡貸款清單

14.分類貸款的借款基准

15.分類貸款的現金預算和透支機制(facilities)

16.美國聯邦儲備Camels評價系統

17.財務困境公司

18.項目融資風險評級模型

19.排隊模型

20.安然公司現金流分析(reconciling)

21.風險評級模型

22.Sample Cash Flows

23.敏感性預測分析(projections)

24.隨機貸款定價模型

25.估值與評價

信用分析

26.信用違約互換和信用利差期權

27.信用違約互換(with Counterparty Defaults and Correlations)

28.信用溢價

29.信用風險和對價格影響

30.外部債務評級和利差

31.內部信用風險評級模型

32.新信用的收益成本分析

債務分析

33.資產權益平價模型

34.利率均值回復下風險債務價格收益率的Cox模型

35.債務償還和攤銷

36.債務敏感性分析

37.隨機資產價格和利率下風險債務的Merton價格

38.Vasicek債務期權估值模型

39.Vasicek風險債務價格收益率模型

決策分析

40.決策樹基礎

41.EVPI決策樹,極大極小和貝頁斯定理

42.經濟訂貨量和存貨再訂點

43.經濟訂貨量和最優制造量

44.預期效用分析

45.存貨控制

46.排隊模型

奇異期權

47.美式期權、百慕大期權和歐式期權

48.亞式算術

49.亞式幾何

50.Asset or nothing

51.障礙期權

52.二值期權

53.Cash or nothing

54.商品期權

55.Complex Chooser

56.信用利差期權

57.貨幣期權

58.雙障礙期權

59.外匯資產

60.極端價差

61.外資參股挂鉤外匯

62.外資參股本幣

63.外資參股固定外匯

64.外資收購期權

65.遠期協議

66.期貨和遠期協議期權

67.GAP期權

68.Graduated Barriers

69.指數期權

70.反Gamma虛值期權

71.跳躍擴散

72.峰度偏度期權

73.回望Fixed Strike Partial Time

74.回望 Fixed Strike

75.回望floating Strike Partial Time

76.回望floating Strike

77.Min and Max of Two Assets

78.期權箍

79.期權期權

80.永久期權

81.Simple Chooser

82.期貨價差

83.Supershares

84.Time Switch

85.Trading Day Corrections

86.雙資產障礙期權

87.雙資產現金Two Assets Cash

88.雙資產Two Assets Correlated

89.不定股利Uneven Dividends

90.賣方可延期Writer Extendible

預測

91.隨機布朗運動

92.數據診斷

93.計量經濟學,相關性分析和多元回歸建模

94.指數J-增長曲線

95.預測的手動計算

96.隨機跳過程

97.線性Linear Interpolation

98.物流G增長曲線

99.馬爾科夫鏈和市場份額

100.均值回復隨機過程

101.多元回歸

102.非線性外推法

103.隨機過程和收益率曲線

104.Stock Distribution at Horizon

105.時間序列分析

106.時間序列ARIMA模型

行業應用

107.資產負債管理ALM

108.生物技術-制造策略

109.生物技術-許可和交易

110.生物技術-投資估值

111.電力行業-有效前沿Generation

112.電力行業-電力合同風險

113.信息技術-預測

114.信息技術-決策分析

115.養老金-封閉式投資組合匹配

116.養老金-會計建模與優化

117.房地產-商業投資回報率ROI

優化

118.資本投資(A部分)

119.資本投資(B部分)

120.連續投資組合資產配置

121.離散項目選擇

122.存貨優化

123.投資組合資產配置

124.軍用投資組合和有效前沿

125.彈性概念下的最優化定價

126.收益模型優化

127.普通最小二乘優化

128.隨機組合配置

期權分析

129.二進制數字儀表Binary Digital Instruments

130.逆浮動債券Lattice Maker

131.利差調整債務期權

132.債務期權

133.期權交易策略

違約概率

134.實証(個人)

135.外部期權模型(上市公司)

136.默頓內部模型(私企)

137.默頓市場期權模型(行業可比)

138.收益率和價差(可比市場)

項目管理

139.成本估計模型

140.關鍵路徑分析(CPM PERT GANTT)

141.項目時間安排

實物期權SLS

142.員工股票期權-簡單美式看漲

143.員工股票期權-含等待期的簡單百慕大看漲vesting

144.員工股票期權-簡單歐式看漲

145.員工股票期權-次優交易行為

146.員工股票期權-等待期和次優交易行為

147.員工股票期權-等待期、封鎖期、次優交易行為和員工離職率forfeiture

148.奇異期權-含紅利的美式看漲期權

149.奇異期權-籃子資產計提

150.奇異期權-美式外匯看漲期權

151.奇異期權-美式指數期貨看漲期權

152.奇異期權-障礙期權-下界障礙期權

153.奇異期權-障礙期權-外下界障礙期權

154.奇異期權-障礙期權-上界障礙期權

155.奇異期權-障礙期權-上下雙界障礙期權

156.奇異期權-障礙期權-外上界障礙期權

157.奇異期權-障礙期權-上下界外障礙期權

158.奇異期權-基本美式、歐式和百慕大看漲期權

159.奇異期權-選擇期權

160.奇異期權-股票挂鉤票據

161.奇異期權-含紅利的歐式看漲期權

162.奇異期權-Range Accruals

163.期權分析-香草看漲期權I

164.期權分析-香草看漲期權II

165.期權分析-香草看漲期權III

166.期權分析-香草看漲期權IV、期權分析

167.期權分析-香草看跌期權

168.實物期權-美式放棄期權

169.實物期權-百慕大放棄期權

170.實物期權-自定義放棄期權

171.實物期權-歐式放棄期權

172.實物期權-收縮美式和歐式期權

173.實物期權-收縮百慕大期權

174.實物期權-收縮自定義期權

175.實物期權-雙資產彩虹期權Pentanomial Lattice

176.實物期權-基於Excel的期權模型

177.實物期權-奇異復雜浮動美式選擇期權

178.實物期權-奇異復雜浮動歐式選擇期權

179.實物期權-美式和歐式擴張、收縮、放棄期權

180.實物期權-百慕大擴張、收縮、放棄期權

181.實物期權-自定義擴張、收縮、放棄期權I

182.實物期權-自定義擴張、收縮、放棄期權II

183.實物期權-美式和歐式擴張期權

184.實物期權-百慕大擴張期權

185.實物期權-自定義擴張期權

186.實物期權-四叉網格下的跳躍擴散看漲看跌期權

187.實物期權-三叉網格下的均值回復看漲看跌期權

188.實物期權-多資產競爭期權(3D網格)

189.實物期權-復雜多階段連續混合期權

190.實物期權-多階段連續混合期權

191.實物期權-同時多階段混合期權

192.實物期權-簡單二叉樹看漲看跌期權

193.實物期權-簡單兩階段連續混合期權

194.實物期權-簡單同時兩階段混合期權

195.實物期權-策略案例-高科技制造策略A

196.實物期權-策略案例-高科技制造策略B

197.實物期權-策略案例-高科技制造策略C

198.實物期權-策略案例-石油和天然氣-策略A

199.實物期權-策略案例-石油和天然氣-策略B

200.實物期權-策略案例-研發階段-門過程A Gate process

201.實物期權-策略案例-研發階段-門過程B

202.實物期權-策略案例-股權置換期權策略A Switching option

203.實物期權-策略案例-股權置換期權策略A

204.三叉網格-美式看漲期權

205.三叉網格-美式看跌期權

206.三叉網格-歐式看漲期權

207.三叉網格-歐式看跌期權

208.三叉網格-美式均值回復看漲期權

209.三叉網格-美式均值回復看跌期權

210.三叉網格-歐式均值回復看漲期權

211.三叉網格-歐式均值回復看跌期權

212.三叉網格-美式均值回復放棄期權

213.三叉網格-美式均值回復收縮期權

214.三叉網格-美式均值回復擴張期權

215.三叉網格-美式均值回復放棄、收縮、擴張期權

216.三叉網格-百慕大均值回復放棄、收縮、擴張期權

217.三叉網格-自定義均值回復放棄、收縮、擴張期權

218.三叉網格-歐式均值回復放棄、收縮、擴張期權

219.四叉網格-美式跳躍擴散看漲期權

220.四叉網格-美式跳躍擴散看跌期權

221.四叉網格-歐式跳躍擴散看漲期權

222.四叉網格-歐式跳躍擴散看跌期權

223.五叉網格-美式彩虹看漲期權

224.五叉網格-美式彩虹看跌期權

225.五叉網格-逆雙執行價格美式看漲期權(3D網格)

226.五叉網格-逆雙執行價格美式看跌期權(3D網格)

227.五叉網格-雙執行價格美式看漲期權(3D網格)

228.五叉網格-雙執行價格美式看跌期權(3D網格)

229.五叉網格-歐式彩虹看漲期權

230.五叉網格-歐式彩虹看跌期權

231.五叉網格-兩資產交換美式看跌期權(3D網格)

232.五叉網格-最大雙資產美式看漲期權(3D網格)

233.五叉網格-最大雙資產美式看跌期權(3D網格)

234.五叉網格-最小雙資產美式看漲期權(3D網格)

235.五叉網格-最小雙資產美式看跌期權(3D網格)

236.五叉網格-組合美式看漲期權(3D網格)

237.五叉網格-組合美式看跌期權(3D網格)

238.五叉網格-雙資產價差美式看漲期權(3D網格)

239.五叉網格-雙資產價差美式看跌期權(3D網格)

風險分析

240.一體化風險分析

241.利率風險

242.投資組合風險和收益

風險對沖

243.Delta和Gamma對沖

244.Delta對沖

245.固定利率和浮動利率影響比較

246.外匯現金流量模型

247.外匯暴露對沖

敏感性

248.希臘字母

249.颶風圖和線形敏感性圖表

250.颶風圖和非線性敏感度

仿真

251.基本仿真模型

252.Best Surgical Team

253.相關模擬

254.相關效應模型

255.數據擬合

256.DCF、ROI和波動性

257.債務償還和攤銷

258.需求曲線和彈性估計

259.傳染病

260.招聘預算(負二項式模擬和多維模擬)

261.VBA宏下的退休基金

262.輪盤賭

263.貨幣的時間價值

6-sigma

264.假設檢驗的執行區間

265.控制圖(c, n, p, u, X, XmR, R)

266.Delta精度

267.試驗和組合的設計

268.假設檢驗和自舉法模擬

269.樣本尺寸相關性

270.樣本尺寸DPU

271.樣本尺寸均值

272.樣本尺寸比例

273.樣本尺寸Sigma

274.假設檢驗的統計分析(CDF,PDF,ICDF)

275.Statistical Capability Measures

276.Unit Capability Measures

估值

277.APT、Beta值和CAPM

278.購買與租賃

279.頂和底

280.可轉債

281.財務比率分析

282.財務報表分析

283.估值模型

284.估值-權証-混合價值

285.估值-權証-看跌價值

286.估值-權証-權証價值

在險價值VaR

287.模擬優化組合的VaR

288.Options Delta Portfolio

289.組合業務和資本充足率

290.右尾資本要求

291.靜態協方差法

波動性

292.EWMA波動模型

293.GARCH波動模型

294.Implied Volatility

295.資產對數收益法

296.現金流對數收益波動性概率

收益率曲線

297.CIR模型

298.曲線插值BIM

299.曲線插值NS

300.即期利率推遠期利率

301.樣條插值和外推法

302.波動性的期限結構

303.美國國債無風險利率

304.Vasicek 模型


List of Functions

Below is a comprehensive list of the functions in Modeling Toolkit that can be accessed either through the analytical DLL libraries or in Excel. Please keep checking back at the website for more updates. The software is continually evolving and newer applications and models are constantly added. Finally, the Risk Simulator tools applicable when using the Modeling Toolkit are included at the end of the list.

1. B2AEPMarketValueAsset

Market Value of Asset using the Asset-Equity Parity Model.

2. B2AEPMarketValueDebt

Market Value of Debt using the Asset-Equity Parity Model.

3. B2AEPRequiredReturnDebt

Required Return on Risky Debt using the Asset-Equity Parity Model.

4. B2AltDistributionCallOption

Computes the European call option for an underlying asset returns distribution with skew and kurtosis, and is not perfectly normal. May return an error for unsolvable inputs.

5. B2AltDistributionPutOption

Computes the European put option for an underlying asset returns distribution with skew and kurtosis, and is not perfectly normal. May return an error for unsolvable inputs.

6. B2AnnuityRate

Returns the percentage equivalent of the required periodic payment on an annuity (e.g., mortgage payments, loan repayment). Returns the percentage of the total principal at initiation.

7. B2AsianCallwithArithmeticAverageRate

An average rate option is a cash-settled option whose payoff is based on the difference between the arithmetic average value of the underlying during the life of the option and a fixed strike.

8. B2AsianCallwithGeometricAverageRate

An average rate option is a cash-settled option whose payoff is based on the difference between the geometric average value of the underlying during the life of the option and a fixed strike.

9. B2AsianPutwithArithmeticAverageRate

An average rate option is a cash-settled option whose payoff is based on the difference between a fixed strike and the arithmetic average value of the underlying during the life of the option.

10. B2AsianPutwithGeometricAverageRate

An average rate option is a cash-settled option whose payoff is based on the difference between a fixed strike and the geometric average value of the underlying during the life of the option.

11. B2AssetExchangeAmericanOption

Option holder has the right up to and including expiration to swap out Asset 2 and receive Asset 1, with predetermined quantities.

12. B2AssetExchangeEuropeanOption

Option holder has the right at expiration to swap out Asset 2 and receive Asset 1, with predetermined quantities.

13. B2AssetOrNothingCall

At expiration, if in-the-money, the option holder receives the stock or asset. For a call option, as long as the stock or asset price exceeds the strike at expiration, the stock is received.

14. B2AssetOrNothingPut

At expiration, if in-the-money, the option holder receives the stock or asset. For a put option, stock is received only if the stock or asset value falls below the strike price.

15. B2BarrierDoubleUpInDownInCall

Valuable or knocked in-the-money only if either barrier (upper or lower) is breached (i.e., asset value is above the upper or below the lower barriers), and the payout is in the form of a call option on the underlying asset.

16. B2BarrierDoubleUpInDownInPut

Valuable or knocked in-the-money only if either barrier (upper or lower) is breached (i.e., asset value is above the upper or below the lower barriers), and the payout is in the form of a put option on the underlying asset.

17. B2BarrierDoubleUpOutDownOutCall

Valuable or stays in-the-money only if either barrier (upper or lower barrier) is not breached, and the payout is in the form of a call option on the underlying asset.

18. B2BarrierDoubleUpOutDownOutPut

Valuable or stays in-the-money only if either barrier (upper or lower barrier) is not breached, and the payout is in the form of a put option on the underlying asset.

19. B2BarrierDownandInCall

Becomes valuable or knocked in-the-money if the lower barrier is breached, and the payout is the call option on the underlying asset. Sometimes cash is paid at maturity, assuming that the option has not been knocked in.

20. B2BarrierDownandInPut

Becomes valuable or knocked in-the-money if the lower barrier is breached, and the payout is the put option on the underlying asset. Sometimes cash is paid at maturity, assuming that the option has not been knocked in.

21. B2BarrierDownandOutCall

Valuable or in-the-money only if the lower barrier is not breached, and the payout is the call option on the underlying asset. Sometimes cash is paid at maturity, assuming that the option has not been knocked out.

22. B2BarrierDownandOutPut

Valuable or in-the-money only if the lower barrier is not breached, and the payout is the put option on the underlying asset. Sometimes cash is paid at maturity, assuming that the option has not been knocked out.

23. B2BarrierUpandInCall

Becomes valuable or knocked in-the-money if the upper barrier is breached, and the payout is the call option on the underlying asset. Sometimes cash is paid at maturity, assuming that the option has not been knocked in.

24. B2BarrierUpandInPut

Becomes valuable or knocked in-the-money if the upper barrier is breached, and the payout is the put option on the underlying asset. Sometimes cash is paid at maturity, assuming that the option has not been knocked in.

25. B2BarrierUpandOutCall

Valuable or in-the-money only if the upper barrier is not breached, and the payout is the call option on the underlying asset. Sometimes cash is paid at maturity, assuming that the option has not been knocked out.

26. B2BarrierUpandOutPut

Valuable or in-the-money only if the upper barrier is not breached, and the payout is the put option on the underlying asset. Sometimes cash is paid at maturity, assuming that the option has not been knocked out.

27. B2BDTAmericanCallonDebtLattice

Computes the American call option on interest-based instruments and debt or bonds, and creates the entire pricing lattice.

28. B2BDTAmericanCallonDebtValue

Computes the American call option value on interest-based instruments and debt or bonds, and returns only one value instead of the entire lattice.

29. B2BDTAmericanPutonDebtLattice

Computes the American put option on interest-based instruments and debt or bonds, and creates the entire pricing lattice.

30. B2BDTAmericanPutonDebtValue

Computes the American put option value on interest-based instruments and debt or bonds, and returns only one value instead of the entire lattice.

31. B2BDTCallableDebtPriceLattice

Computes the revised price lattice of a callable debt such that the options adjusted spread can be imputed. Allows for changing interest and interest volatilities over time.

32. B2BDTCallableDebtPriceValue

Computes the present value of a coupon bond/debt that is callable, to see the differences in value from a noncallable debt. The lattice can be computed using the function call: B2BDTCallableDebtPriceLattice.

33. B2BDTCallableSpreadValue

Computes the option adjusted spread (i.e., the additional premium that should be charged on the callable option provision).

34. B2BDTEuropeanCallonDebtLattice

Computes the European call option on interest-based instruments and debt or bonds, and creates the entire pricing lattice.

35. B2BDTEuropeanCallonDebtValue

Computes the European call option value on interest-based instruments and debt or bonds, and returns only one value instead of the entire lattice.

36. B2BDTEuropeanPutonDebtLattice

Computes the European put option on interest-based instruments and debt or bonds, and creates the entire pricing lattice.

37. B2BDTEuropeanPutonDebtValue

Computes the European put option value on interest-based instruments and debt or bonds, and returns only one value instead of the entire lattice.

38. B2BDTFloatingCouponPriceLattice

Value of the floater bond’s lattice (coupon rate is floating and can be directly or inversely related to interest rates; e.g., rates drop, coupon increases, the bond appreciates in price, and the yield increases).

39. B2BDTFloatingCouponPriceValue

Value of the floater bond (coupon rate is floating and can be directly or inversely related to interest rates; e.g., rates drop, coupon increases, the bond appreciates in price, and the yield increases).

40. B2BDTNoncallableDebtPriceLattice

Computes the pricing lattice of a coupon bond/debt that is not callable, to see the differences in value from a callable debt.

41. B2BDTNoncallableDebtPriceValue

Computes the present value of a coupon bond/debt that is not callable, to see the differences in value from a callable debt.

42. B2BDTInterestRateLattice

Computes the short rate interest lattice based on a term structure of interest rates and changing interest volatilities, as a means to compute option values.

43. B2BDTNonCallableSpreadValue

Computes the straight spread on a bond that is noncallable, to compare it with the option provision of an option adjusted spread model.

44. B2BDTZeroPriceLattice

Computes the straight price lattice of zero bonds based on a term structure of interest rates and changing interest volatilities, as a means to compute interest-based option values.

45. B2BDTZeroPriceLattice2

Computes the straight price lattice of zero bonds based on a term structure of interest rates and changing interest volatilities, as a means to compute interest-based option values. Returns the same results as the B2BDTZeroPriceLattice function but requires interest rates and interest volatilities as inputs, rather than the entire interest rate lattice.

46. B2BDTZeroPriceValue

Computes the straight price of zero bonds at time zero, based on a term structure of interest rates and changing interest volatilities, as a means to compute interest-based option values.

47. B2BinaryDownAndInAssetAtExpirationOrNothing

Binary digital instrument receiving the asset at expiration, only if a corresponding asset hits a lower barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

48. B2BinaryDownAndInAssetAtExpirationOrNothingCall

Binary digital call option receiving the asset at expiration if the asset hits a lower barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

49. B2BinaryDownAndInAssetAtExpirationOrNothingPut

Binary digital put option receiving the asset at expiration if the asset hits a lower barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

50. B2BinaryDownAndInAssetAtHitOrNothing

Binary digital instrument receiving the asset when it hits a lower barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

51. B2BinaryDownAndInCashAtExpirationOrNothing

Binary digital instrument receiving a cash amount at expiration, only if a corresponding asset hits a lower barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

52. B2BinaryDownAndInCashAtExpirationOrNothingCall

Binary digital call option receiving the cash at expiration if the asset hits a lower barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

53. B2BinaryDownAndInCashAtExpirationOrNothingPut

Binary digital put option receiving the cash at expiration if the asset hits a lower barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

54. B2BinaryDownAndInCashAtHitOrNothing

Binary digital instrument receiving a cash amount when a corresponding asset hits a lower barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

55. B2BinaryDownAndOutAssetAtExpirationOrNothing

Binary digital instrument receiving the asset at expiration, only if a corresponding asset does not hit a lower barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

56. B2BinaryDownAndOutAssetAtExpirationOrNothingCall

Binary digital call options receiving the asset at expiration, only if a corresponding asset does not hit a lower barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

57. B2BinaryDownAndOutAssetAtExpirationOrNothingPut

Binary digital put options receiving the asset at expiration, only if a corresponding asset does not hit a lower barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

58. B2BinaryDownAndOutCashAtExpirationOrNothing

Binary digital instrument receiving a cash amount at expiration, only if a corresponding asset does not hit a lower barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

59. B2BinaryDownAndOutCashAtExpirationOrNothingCall

Binary digital call option receiving a cash amount at expiration, only if a corresponding asset does not hit a lower barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

60. B2BinaryDownAndOutCashAtExpirationOrNothingPut

Binary digital put option receiving a cash amount at expiration, only if a corresponding asset does not hit a lower barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

61. B2BinaryUpAndInAssetAtExpirationOrNothing

Binary digital instrument receiving the asset at expiration, only if a corresponding asset hits an upper barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

62. B2BinaryUpAndInAssetAtExpirationOrNothingCall

Binary digital call option receiving the asset at expiration if the asset hits an upper barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

63. B2BinaryUpAndInAssetAtExpirationOrNothingPut

Binary digital put option receiving the asset at expiration, only if a corresponding asset hits an upper barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

64. B2BinaryUpAndInAssetAtHitOrNothing

Binary digital instrument receiving the asset when it hits an upper barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

65. B2BinaryUpAndInCashAtExpirationOrNothing

Binary digital instrument receiving a cash amount at expiration, only if a corresponding asset hits an upper barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

66. B2BinaryUpAndInCashAtExpirationOrNothingCall

Binary digital call option receiving the cash at expiration, only if a corresponding asset hits an upper barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

67. B2BinaryUpAndInCashAtExpirationOrNothingPut

Binary digital put option receiving the cash at expiration, only if a corresponding asset hits an upper barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

68. B2BinaryUpAndInCashAtHitOrNothing

Binary digital instrument receiving a cash amount when a corresponding asset hits an upper barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

69. B2BinaryUpAndOutAssetAtExpirationOrNothing

Binary digital instrument receiving the asset at expiration, only if a corresponding asset does not hit an upper barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

70. B2BinaryUpAndOutAssetAtExpirationOrNothingCall

Binary digital call options receiving the asset at expiration, only if a corresponding asset does not hit an upper barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

71. B2BinaryUpAndOutAssetAtExpirationOrNothingPut

Binary digital put options receiving the asset at expiration, only if a corresponding asset does not hit an upper barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

72. B2BinaryUpAndOutCashAtExpirationOrNothing

Binary digital instrument receiving a cash amount at expiration, only if a corresponding asset does not hit an upper barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

73. B2BinaryUpAndOutCashAtExpirationOrNothingCall

Binary digital call option receiving a cash amount at expiration, only if a corresponding asset does not hit an upper barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

74. B2BinaryUpAndOutCashAtExpirationOrNothingPut

Binary digital put option receiving a cash amount at expiration, only if a corresponding asset does not hit an upper barrier or receives nothing otherwise. DT is monitoring steps: 1/12 monthly, 1/52 weekly, 1/250 daily, 0 continuously.

75. B2Binomial3DAmericanDualStrikeCallOption

Returns the American option with the payoff [Max(Q2S2 – X2, Q1S1 – X1)] and valued using a 3D binomial lattice model.

76. B2Binomial3DAmericanDualStrikePutOption

Returns the American option with the payoff [Max(X2 – Q2S2, X1 – Q1S1)] and valued using a 3D binomial lattice model.

77. B2Binomial3DEuropeanDualStrikeCallOption

Returns the European option with the payoff [Max(Q2S2 – X2, Q1S1 – X1)] and valued using a 3D binomial lattice model.

78. B2Binomial3DEuropeanDualStrikePutOption

Returns the European option with the payoff [Max(X2 – Q2S2, X1 – Q1S1)] and valued using a 3D binomial lattice model.

79. B2Binomial3DAmericanExchangeOption

Returns the American and European call and put option (same values exist for all types) with the payoff (Q2S2 – Q1S1) and valued using a 3D binomial lattice model.

80. B2Binomial3DAmericanMaximumTwoAssetsCallOption

Returns the American option with the payoff [Max(Q2S2, Q1S1) – X] and valued using a 3D binomial lattice model.

81. B2Binomial3DAmericanMaximumTwoAssetsPutOption

Returns the American option with the payoff [X – Max(Q2S2, Q1S1)] and valued using a 3D binomial lattice model.

82. B2Binomial3DEuropeanMaximumTwoAssetsCallOption

Returns the European option with the payoff [Max(Q2S2, Q1S1) – X] and valued using a 3D binomial lattice model.

83. B2Binomial3DEuropeanMaximumTwoAssetsPutOption

Returns the European option with the payoff [X – Max(Q2S2, Q1S1)] and valued using a 3D binomial lattice model.

84. B2Binomial3DAmericanMinimumTwoAssetsCallOption

Returns the American option with the payoff [Min(Q2S2, Q1S1) – X] and valued using a 3D binomial lattice model.

85. B2Binomial3DAmericanMinimumTwoAssetsPutOption

Returns the American option with the payoff [X – Min(Q2S2, Q1S1)] and valued using a 3D binomial lattice model.

86. B2Binomial3DEuropeanMinimumTwoAssetsCallOption

Returns the European option with the payoff [Min(Q2S2, Q1S1) – X] and valued using a 3D binomial lattice model.

87. B2Binomial3DEuropeanMinimumTwoAssetsPutOption

Returns the European option with the payoff [X – Min(Q2S2, Q1S1)] and valued using a 3D binomial lattice model.

88. B2Binomial3DAmericanPortfolioCallOption

Returns the American option with the payoff (Q2S2 + Q1S1 – X) and valued using a 3D binomial lattice model.

89. B2Binomial3DAmericanPortfolioPutOption

Returns the American option with the payoff (X – Q2S2 + Q1S1) and valued using a 3D binomial lattice model.

90. B2Binomial3DEuropeanPortfolioCallOption

Returns the European option with the payoff (Q2S2 + Q1S1 – X) and valued using a 3D binomial lattice model.

91. B2Binomial3DEuropeanPortfolioPutOption

Returns the European option with the payoff (X – Q2S2 + Q1S1) and valued using a 3D binomial lattice model.

92. B2Binomial3DAmericanReverseDualStrikeCallOption

Returns the American option with the payoff [Max(X2 – Q2S2, Q1S1 – X1)] and valued using a 3D binomial lattice model.

93. B2Binomial3DAmericanReverseDualStrikePutOption

Returns the American option with the payoff [Max(Q2S2 – X2, X1 – Q1S1)] and valued using a 3D binomial lattice model.

94. B2Binomial3DEuropeanReverseDualStrikeCallOption

Returns the European option with the payoff [Max(X2 – Q2S2, Q1S1 – X1)] and valued using a 3D binomial lattice model.

95. B2Binomial3DEuropeanReverseDualStrikePutOption

Returns the American option with the payoff [Max(Q2S2 – X2, X1 – Q1S1)] and valued using a 3D binomial lattice model.

96. B2Binomial3DAmericanSpreadCallOption

Returns the American option with the payoff (Q1S1 – Q2S2 – X) and valued using a 3D binomial lattice model.

97. B2Binomial3DAmericanSpreadPutOption

Returns the American option with the payoff (X + Q2S2 – Q1S1) and valued using a 3D binomial lattice model.

98. B2Binomial3DEuropeanSpreadCallOption

Returns the European option with the payoff (Q1S1 – Q2S2 – X) and valued using a 3D binomial lattice model.

99. B2Binomial3DEuropeanSpreadPutOption

Returns the European option with the payoff (X + Q2S2 – Q1S1) and valued using a 3D binomial lattice model.

100. B2BinomialAdjustedBarrierSteps

Computes the correct binomial lattice steps to use for convergence and barrier matching when running a barrier option.

101. B2BinomialAmericanCall

Returns the American call option with a continuous dividend yield using a binomial lattice, where the option can be exercised at any time up to and including maturity.

102. B2BinomialAmericanPut

Returns the American put option with a continuous dividend yield using a binomial lattice, where the option can be exercised at any time up to and including maturity.

103. B2BinomialBermudanCall

Returns the American call option with a continuous dividend yield using a binomial lattice, where the option can be exercised at any time up to and including maturity except during the vesting period.

104. B2BinomialBermudanPut

Returns the American put option with a continuous dividend yield using a binomial lattice, where the option can be exercised at any time up to and including maturity except during the vesting period.

105. B2BinomialEuropeanCall

Returns the European call option with a continuous dividend yield using a binomial lattice, where the option can be exercised only at maturity.

106. B2BinomialEuropeanPut

Returns the European put option with a continuous dividend yield using a binomial lattice, where the option can be exercised only at maturity.

107. B2BlackCallOptionModel

Returns the Black model (modified Black-Scholes-Merton) for forward contracts and interest-based call options.

108. B2BlackPutOptionModel

Returns the Black model (modified Black-Scholes-Merton) for forward contracts and interest-based put options.

109. B2BlackFuturesCallOption

Computes the value of a commodities futures call option given the value of the futures contract.

110. B2BlackFuturesPutOption

Computes the value of a commodities futures put option given the value of the futures contract.

111. B2BlackScholesCall

European call option using the Black-Scholes-Merton model.

112. B2BlackScholesProbabilityAbove

Computes the expected probability the stock price will rise above the strike price under a Black-Scholes paradigm.

113. B2BlackScholesPut

European put option using the Black-Scholes-Merton model.

114. B2BondCIRBondDiscountFactor

Returns the discount factor on a bond or risky debt using the Cox-Ingersoll-Ross model, accounting for mean-reverting interest rates.

115. B2BondCIRBondPrice

Cox-Ross model on Zero Coupon Bond Pricing assuming no arbitrage and mean-reverting interest rates.

116. B2BondCIRBondYield

Cox-Ross model on Zero Coupon Bond Yield assuming no arbitrage and mean-reverting interest rates.

117. B2BondConvexityContinuous

Returns the debt’s Convexity or second-order sensitivity using a series of cash flows and current interest rate, with continuous discounting.

118. B2BondConvexityDiscrete

Returns the debt’s Convexity or second-order sensitivity using a series of cash flows and current interest rate, with discrete discounting.

119. B2BondConvexityYTMContinuous

Returns the debt’s Convexity or second-order sensitivity using an internal Yield to Maturity of the cash flows, with continuous discounting.

120. B2BondConvexityYTMDiscrete

Returns the debt’s Convexity or second-order sensitivity using an internal Yield to Maturity of the cash flows, with discrete discounting.

121. B2BondDurationContinuous

Returns the debt’s first-order sensitivity Duration measure using continuous discounting.

122. B2BondDurationDiscrete

Returns the debt’s first-order sensitivity Duration measure using discrete discounting.

123. B2BondHullWhiteBondCallOption

Values a European call option on a bond where the interest rates are stochastic and mean-reverting. Make sure Bond Maturity > Option Maturity.

124. B2BondHullWhiteBondPutOption

Values a European put option on a bond where the interest rates are stochastic and mean-reverting. Make sure Bond Maturity > Option Maturity.

125. B2BondMacaulayDuration

Returns the debt’s first-order sensitivity Macaulay Duration measure.

126. B2BondMertonBondPrice

Bond price using Merton Stochastic Interest and Stochastic Asset Model.

127. B2BondModifiedDuration

Returns the debt’s first-order sensitivity Modified Duration measure.

128. B2BondPriceContinuous

Returns the bond price of a cash flow series given the time and discount rate, using continuous discounting.

129. B2BondPriceDiscrete

Returns the bond price of a cash flow series given the time and discount rate, using discrete discounting.

130. B2BondVasicekBondCallOption

Values a European call option on a bond where the interest rates are stochastic and mean-reverting to a long-term rate. Make sure Bond Maturity > Option Maturity.

131. B2BondVasicekBondPrice

Vasicek Zero Coupon Price assuming no arbitrage and mean-reverting interest rates.

132. B2BondVasicekBondPutOption

Values a European put option on a bond where the interest rates are stochastic and mean-reverting to a long-term rate. Make sure Bond Maturity > Option Maturity.

133. B2BondVasicekBondYield

Vasicek Zero Coupon Yield assuming no arbitrage and mean-reverting interest rates.

134. B2BondYTMContinuous

Returns bond’s Yield to Maturity assuming continuous discounting.

135. B2BondYTMDiscrete

Returns bond’s Yield to Maturity assuming discrete discounting.

136. B2CallDelta

Returns the option valuation sensitivity Delta (a call option value’s sensitivity to changes in the asset value).

137. B2CallGamma

Returns the option valuation sensitivity Gamma (a call option value’s sensitivity to changes in the Delta value).

138. B2CallOptionOnTheMax

The maximum values at expiration of both assets are used in option exercise, where the call option payoff at expiration is the maximum price between Asset 1 and Asset 2 against the strike price.

139. B2CallOptionOnTheMin

The minimum values at expiration of both assets are used in option exercise, where the call option payoff at expiration is the minimum price between Asset 1 and Asset 2 against the strike price.

140. B2CallRho

Returns the option valuation sensitivity Rho (a call option value’s sensitivity to changes in the interest rate).

141. B2CallTheta

Returns the option valuation sensitivity Theta (a call option value’s sensitivity to changes in the maturity).

142. B2CallVega

Returns the option valuation sensitivity Vega (a call option value’s sensitivity to changes in the volatility).

143. B2CashOrNothingCall

At expiration, if the option is in-the-money, the option holder receives a predetermined cash payment. For a call option, as long as the stock or asset price exceeds the strike at expiration, cash is received.

144. B2CashOrNothingPut

At expiration, if the option is in-the-money, the option holder receives a predetermined cash payment. For a put option, cash is received only if the stock or asset value falls below the strike price.

145. B2ChooserBasicOption

Holder chooses whether the option is a call or a put by the chooser time, with the same strike price and maturity. Typically cheaper than buying a call and a put together while providing the same level of hedge.

146. B2ChooserComplexOption

Holder gets to choose whether the option is a call or a put within the Chooser Time, with different strike prices and maturities. Typically cheaper than buying a call and a put, while providing the same level of hedge.

147. B2ClosedFormAmericanCall

Returns the American option approximation model with a continuous dividend yield call option.

148. B2ClosedFormAmericanPut

Returns the American option approximation model with a continuous dividend yield put option.

149. B2CoefficientofVariationPopulation

Computes the population coefficient of variation (standard deviation of the sample divided by the mean), to obtain a relative measure of risk and dispersion.

150. B2CoefficientofVariationSample

Computes the sample coefficient of variation (standard deviation of the sample divided by the mean), to obtain a relative measure of risk and dispersion.

151. B2CommodityCallOptionModel

Computes the value of a commodity-based call option based on spot and futures market, and accounting for volatility of the forward rate.

152. B2CommodityPutOptionModel

Computes the value of a commodity-based put option based on spot and futures market, and accounting for volatility of the forward rate.

153. B2CompoundOptionsCallonCall

A compound option allowing the holder to buy (call) a call option with some maturity, in the future within the option maturity period, for a specified strike price on the option.

154. B2CompoundOptionsCallonPut

A compound option allowing the holder to buy (call) a put option with some maturity, in the future within the option maturity period, for a specified strike price on the option.

155. B2CompoundOptionsPutonCall

A compound option allowing the holder to sell (put) a call option with some maturity, in the future within the option maturity period, for a specified strike price on the option.

156. B2CompoundOptionsPutonPut

A compound option allowing the holder to sell (put) a call option with some maturity, in the future within the option maturity period, for a specified strike price on the option.

157. B2ConvenienceYield

The convenience yield is simply the rate differential between a non-arbitrage futures and spot price and a real-life fair market value of the futures price.

158. B2ConvertibleBondAmerican

Computes the value of an American convertible bond using binomial lattices, and accounting for the stock's volatility and dividend yield, as well as the bond's credit spread above risk-free.

159. B2ConvertibleBondEuropean

Computes the value of a European convertible bond using binomial lattices, and accounting for the stock's volatility and dividend yield, as well as the bond's credit spread above risk-free.

160. B2CreditAcceptanceCost

Computes the risk-adjusted cost of accepting a new credit line with a probability of default.

161. B2CreditAssetSpreadCallOption

Provides protection from an increase in spread but ceases to exist if the underlying asset defaults and the option is based on the price of the asset.

162. B2CreditAssetSpreadPutOption

Provides protection from a decrease in spread but ceases to exist if the underlying asset defaults and the option is based on the price of the asset.

163. B2CreditDefaultSwapSpread

Returns the valuation of a credit default swap (CDS) spread, allowing the holder to sell a bond/debt at par value when a credit event occurs.

164. B2CreditDefaultSwapCorrelatedBondandSwapPrice

Computes the valuation of a bond with a credit default swap where both parties are correlated and each has a probability of default and possible recovery rates. At default, the holder receives the notional principal or par value of the bond.

165. B2CreditDefaultSwapCorrelatedBondPrice

Computes the valuation of a bond without any credit default swap where the bond or debt has a probability of default and possible recovery rate.

166. B2CreditDefaultSwapCorrelatedSwapPrice

Computes the price of a credit default swap where both parties are correlated and each has a probability of default and possible recovery rates. At default, the holder receives the notional principal or par value of the bond.

167. B2CreditRatingWidth

Computes the credit ratings width to generate the credit ratings table.

168. B2CreditRejectionCost

Computes the risk-adjusted cost of rejecting a new credit line with a probability of default.

169. B2CreditRiskShortfall

Returns the Credit Risk Shortfall given probability of default and recovery rates.

170. B2CreditSpreadCallOption

Provides protection from an increase in spread but ceases to exist if the underlying asset defaults. Only credit default swaps can cover default events. Credit spread options (CSOs) are sometimes combined with CDSs.

171. B2CreditSpreadPutOption

Provides protection from a decrease in spread but ceases to exist if the underlying asset defaults. Only credit default swaps can cover default events (CSOs are sometimes combined with CDSs).

172. B2CubicSpline

Interpolates and extrapolates the unknown Y values (based on the required X value) given some series of known X and Y values, and can be used to interpolate inside the data sample or extrapolate outside the known sample.

173. B2CurrencyCallOption

Option to exchange foreign currency into domestic currency by buying domestic currency (selling foreign currency) at a set exchange rate on a specified date. Exchange rate is foreign currency to domestic currency.

174. B2CurrencyForwardCallOption

Computes the value of a currency forward call option.

175. B2CurrencyForwardPutOption

Computes the value of a currency forward put option.

176. B2CurrencyPutOption

Option to exchange domestic currency into foreign currency by selling domestic currency (buying foreign currency) at a set exchange rate on a specified date. Exchange rate is foreign currency to domestic currency.

177. B2DeltaGammaHedgeCallBought

Computes the total amount of call values that has to be bought to perform a Delta-Gamma neutral hedge. Returns a negative value indicating cash outflow.

178. B2DeltaGammaHedgeCallSold

Computes the single unit of call value that has to be sold to perform a Delta-Gamma neutral hedge. Returns a positive value indicating cash inflow.

179. B2DeltaGammaHedgeMoneyBorrowed

Computes the amount of money that has to be borrowed to perform a Delta-Gamma neutral hedge. Returns a positive value indicating cash inflow.

180. B2DeltaGammaHedgeSharesBought

Computes the total value of stocks that has to be bought to perform a Delta-Gamma neutral hedge. Returns a negative value indicating cash outflow.

181. B2DeltaHedgeCallSold

Computes the single unit of call value that has to be sold to perform a Delta-neutral hedge. Returns a positive value indicating cash inflow.

182. B2DeltaHedgeMoneyBorrowed

Computes the amount of money that has to be borrowed to perform a Delta-neutral hedge. Returns a positive value indicating cash inflow.

183. B2DeltaHedgeSharesBought

Computes the total value of stocks that has to be bought to perform a Delta-neutral hedge. Returns a negative value indicating cash outflow.

184. B2DistributionBernoulliKurtosis

Returns the Bernoulli distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

185. B2DistributionBernoulliMean

Returns the Bernoulli distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

186. B2DistributionBernoulliSkew

Returns the Bernoulli distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means average exceeds median and the tail points to the right, whereas negative skew means average is less than median and the tail points to the left.

187. B2DistributionBernoulliStdev

Returns the Bernoulli distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

188. B2DistributionBetaKurtosis

Returns the Beta distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

189. B2DistributionBetaMean

Returns the Beta distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

190. B2DistributionBetaSkew

Returns the Beta distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means average exceeds median and the tail points to the right, whereas negative skew means average is less than median and the tail points to the left.

191. B2DistributionBetaStdev

Returns the Beta distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

192. B2DistributionBinomialKurtosis

Returns the Binomial distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

193. B2DistributionBinomialMean

Returns the Binomial distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

194. B2DistributionBinomialSkew

Returns the Binomial distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means average exceeds median and the tail points to the right, whereas negative skew means average is less than median and the tail points to the left.

195. B2DistributionBinomialStdev

Returns the Binomial distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

196. B2DistributionCauchyKurtosis

Returns the Cauchy distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

197. B2DistributionCauchyMean

Returns the Cauchy distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

198. B2DistributionCauchySkew

Returns the Cauchy distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means average exceeds median and the tail points to the right, whereas negative skew means average is less than median and the tail points to the left.

199. B2DistributionCauchyStdev

Returns the Cauchy distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

200. B2DistributionChiSquareKurtosis

Returns the Chi-Square distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

201. B2DistributionChiSquareMean

Returns the Chi-Square distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

202. B2DistributionChiSquareSkew

Returns the Chi-Square distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means average exceeds median and the tail points to the right, whereas negative skew means average is less than median and the tail points to the left.

203. B2DistributionChiSquareStdev

Returns the Chi-Square distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

204. B2DistributionDiscreteUniformKurtosis

Returns the Discrete Uniform distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

205. B2DistributionDiscreteUniformMean

Returns the Discrete Uniform distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

206. B2DistributionDiscreteUniformSkew

Returns the Discrete Uniform distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means average exceeds median and the tail points to the right, whereas negative skew means average is less than median and the tail points to the left.

207. B2DistributionDiscreteUniformStdev

Returns the Discrete Uniform distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

208. B2DistributionExponentialKurtosis

Returns the Exponential distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

209. B2DistributionExponentialMean

Returns the Exponential distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

210. B2DistributionExponentialSkew

Returns the Exponential distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means average exceeds median and the tail points to the right, whereas negative skew means average is less than median and the tail points to the left.

211. B2DistributionExponentialStdev

Returns the Exponential distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

212. B2DistributionFKurtosis

Returns the F distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

213. B2DistributionFMean

Returns the F distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

214. B2DistributionFSkew

Returns the F distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means average exceeds median and the tail points to the right, whereas negative skew means average is less than median and the tail points to the left.

215. B2DistributionFStdev

Returns the F distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

216. B2DistributionGammaKurtosis

Returns the Gamma distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

217. B2DistributionGammaMean

Returns the Gamma distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

218. B2DistributionGammaSkew

Returns the Gamma distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means average exceeds median and the tail points to the right, whereas negative skew means average is less than median and the tail points to the left.

219. B2DistributionGammaStdev

Returns the Gamma distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

220. B2DistributionGeometricKurtosis

Returns the Geometric distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

221. B2DistributionGeometricMean

Returns the Geometric distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

222. B2DistributionGeometricSkew

Returns the Geometric distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means the average exceeds the median and the tail points to the right, whereas negative skew means the average is less than the median and the tail points to the left.

223. B2DistributionGeometricStdev

Returns the Geometric distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

224. B2DistributionGumbelMaxKurtosis

Returns the Gumbel Max distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

225. B2DistributionGumbelMaxMean

Returns the Gumbel Max distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

226. B2DistributionGumbelMaxSkew

Returns the Gumbel Max distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means the average exceeds the median and the tail points to the right, whereas negative skew means the average is less than the median and the tail points to the left.

227. B2DistributionGumbelMaxStdev

Returns the Gumbel Max distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

228. B2DistributionGumbelMinKurtosis

Returns the Gumbel Min distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

229. B2DistributionGumbelMinMean

Returns the Gumbel Min distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

230. B2DistributionGumbelMinSkew

Returns the Gumbel Min distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means the average exceeds the median and the tail points to the right, whereas negative skew means the average is less than the median and the tail points to the left.

231. B2DistributionGumbelMinStdev

Returns the Gumbel Min distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

232. B2DistributionHypergeometricKurtosis

Returns the Hypergeometric distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

233. B2DistributionHypergeometricMean

Returns the Hypergeometric distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

234. B2DistributionHypergeometricSkew

Returns the Hypergeometric distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means the average exceeds the median and the tail points to the right, whereas negative skew means the average is less than the median and the tail points to the left.

235. B2DistributionHypergeometricStdev

Returns the Hypergeometric distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

236. B2DistributionLogisticKurtosis

Returns the Logistic distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

237. B2DistributionLogisticMean

Returns the Logistic distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

238. B2DistributionLogisticSkew

Returns the Logistic distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means the average exceeds the median and the tail points to the right, whereas negative skew means the average is less than the median and the tail points to the left.

239. B2DistributionLogisticStdev

Returns the Logistic distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

240. B2DistributionLognormalKurtosis

Returns the Lognormal distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

241. B2DistributionLognormalMean

Returns the Lognormal distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

242. B2DistributionLognormalSkew

Returns the Lognormal distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means the average exceeds the median and the tail points to the right, whereas negative skew means the average is less than the median and the tail points to the left.

243. B2DistributionLognormalStdev

Returns the Lognormal distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

244. B2DistributionNegativeBinomialKurtosis

Returns the Negative Binomial distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

245. B2DistributionNegativeBinomialMean

Returns the Negative Binomial distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

246. B2DistributionNegativeBinomialSkew

Returns the Negative Binomial distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means the average exceeds the median and the tail points to the right, whereas negative skew means the average is less than the median and the tail points to the left.

247. B2DistributionNegativeBinomialStdev

Returns the Negative Binomial distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

248. B2DistributionNormalKurtosis

Returns the Normal distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

249. B2DistributionNormalMean

Returns the Normal distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

250. B2DistributionNormalSkew

Returns the Normal distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means the average exceeds the median and the tail points to the right, whereas negative skew means the average is less than the median and the tail points to the left.

251. B2DistributionNormalStdev

Returns the Normal distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

252. B2DistributionParetoKurtosis

Returns the Pareto distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

253. B2DistributionParetoMean

Returns the Pareto distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

254. B2DistributionParetoSkew

Returns the Pareto distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means the average exceeds the median and the tail points to the right, whereas negative skew means the average is less than the median and the tail points to the left.

255. B2DistributionParetoStdev

Returns the Pareto distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

256. B2DistributionPoissonKurtosis

Returns the Poisson distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

257. B2DistributionPoissonMean

Returns the Poisson distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

258. B2DistributionPoissonSkew

Returns the Poisson distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means the average exceeds the median and the tail points to the right, whereas negative skew means the average is less than the median and the tail points to the left.

259. B2DistributionPoissonStdev

Returns the Poisson distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

260. B2DistributionRayleighKurtosis

Returns the Rayleigh distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

261. B2DistributionRayleighMean

Returns the Rayleigh distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

262. B2DistributionRayleighSkew

Returns the Rayleigh distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means the average exceeds the median and the tail points to the right, whereas negative skew means the average is less than the median and the tail points to the left.

263. B2DistributionRayleighStdev

Returns the Rayleigh distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

264. B2DistributionTKurtosis

Returns the Student’s T distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

265. B2DistributionTMean

Returns the Student’s T distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

266. B2DistributionTSkew

Returns the Student’s T distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means the average exceeds the median and the tail points to the right, whereas negative skew means the average is less than the median and the tail points to the left.

267. B2DistributionTStdev

Returns the Student’s T distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

268. B2DistributionTriangularKurtosis

Returns the Triangular distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

269. B2DistributionTriangularMean

Returns the Triangular distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

270. B2DistributionTriangularSkew

Returns the Triangular distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means the average exceeds the median and the tail points to the right, whereas negative skew means the average is less than the median and the tail points to the left.

271. B2DistributionTriangularStdev

Returns the Triangular distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

272. B2DistributionUniformKurtosis

Returns the Uniform distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

273. B2DistributionUniformMean

Returns the Uniform distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

274. B2DistributionUniformSkew

Returns the Uniform distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means the average exceeds the median and the tail points to the right, whereas negative skew means the average is less than the median and the tail points to the left.

275. B2DistributionUniformStdev

Returns the Uniform distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

276. B2DistributionWeibullKurtosis

Returns the Weibull distribution’s theoretical excess kurtosis (fourth moment), measuring the peakedness of the distribution and its extreme tail events. An excess kurtosis of 0 implies a normal tail.

277. B2DistributionWeibullMean

Returns the Weibull distribution’s theoretical mean or expected value (first moment), measuring the central tendency of the distribution.

278. B2DistributionWeibullSkew

Returns the Weibull distribution’s theoretical skew (third moment), measuring the direction of the distribution’s tail. Positive skew means the average exceeds the median and the tail points to the right, whereas negative skew means the average is less than the median and the tail points to the left.

279. B2DistributionWeibullStdev

Returns the Weibull distribution’s theoretical standard deviation (second moment), measuring the width and average dispersion of all points around the mean.

280. B2DistributionCDFBernoulli

Computes the Bernoulli distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

281. B2DistributionCDFBeta

Computes the Beta distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

282. B2DistributionCDFBinomial

Computes the Binomial distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

283. B2DistributionCDFChiSquare

Computes the Chi-Square distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

284. B2DistributionCDFDiscreteUniform

Computes the Discrete Uniform distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

285. B2DistributionCDFExponential

Computes the Exponential distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

286. B2DistributionCDFFDist

Computes the F distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

287. B2DistributionCDFGamma

Computes the Gamma distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

288. B2DistributionCDFGeometric

Computes the Geometric distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

289. B2DistributionCDFGumbelMax

Computes the Gumbel Max distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

290. B2DistributionCDFGumbelMin

Computes the Gumbel Min distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

291. B2DistributionCDFLogistic

Computes the Logistic distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

292. B2DistributionCDFLognormal

Computes the Lognormal distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

293. B2DistributionCDFNormal

Computes the Normal distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

294. B2DistributionCDFPareto

Computes the Pareto distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

295. B2DistributionCDFPoisson

Computes the Poisson distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

296. B2DistributionCDFRayleigh

Computes the Rayleigh distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

297. B2DistributionCDFStandardNormal

Computes the Standard Normal distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

298. B2DistributionCDFTDist

Computes the Student’s T distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

299. B2DistributionCDFTriangular

Computes the Triangular distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

300. B2DistributionCDFUniform

Computes the Uniform distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

301. B2DistributionCDFWeibull

Computes the Weibull distribution’s theoretical Cumulative Distribution Function (CDF)—that is, the cumulative probability of the distribution at all points less than or equal to X.

302. B2DistributionICDFBernoulli

Computes the Bernoulli distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

303. B2DistributionICDFBeta

Computes the Beta distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

304. B2DistributionICDFBinomial

Computes the Binomial distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

305. B2DistributionICDFChiSquare

Computes the Chi-Square distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

306. B2DistributionICDFDiscreteUniform

Computes the Discrete Uniform distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

307. B2DistributionICDFExponential

Computes the Exponential distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

308. B2DistributionICDFFDist

Computes the F distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

309. B2DistributionICDFGamma

Computes the Gamma distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

310. B2DistributionICDFGeometric

Computes the Geometric distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

311. B2DistributionICDFGumbelMax

Computes the Gumbel Max distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

312. B2DistributionICDFGumbelMin

Computes the Gumbel Min distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

313. B2DistributionICDFLogistic

Computes the Logistic distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

314. B2DistributionICDFLognormal

Computes the Lognormal distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

315. B2DistributionICDFNormal

Computes the Normal distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

316. B2DistributionICDFPareto

Computes the Pareto distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

317. B2DistributionICDFPoisson

Computes the Poisson distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

318. B2DistributionICDFRayleigh

Computes the Rayleigh distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

319. B2DistributionICDFStandardNormal

Computes the Standard Normal distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

320. B2DistributionICDFTDist

Computes the Student’s T distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

321. B2DistributionICDFTriangular

Computes the Triangular distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

322. B2DistributionICDFUniform

Computes the Uniform distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

323. B2DistributionICDFWeibull

Computes the Weibull distribution’s theoretical Inverse Cumulative Distribution Function (ICDF); that is, given the cumulative probability between 0 and 1 and the distribution’s parameters, the function returns the relevant X value.

324. B2DistributionPDFBernoulli

Computes the Bernoulli distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

325. B2DistributionPDFBeta

Computes the Beta distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

326. B2DistributionPDFBinomial

Computes the Binomial distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

327. B2DistributionPDFChiSquare

Computes the Chi-Square distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

328. B2DistributionPDFDiscreteUniform

Computes the Discrete Uniform distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

329. B2DistributionPDFExponential

Computes the Exponential distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

330. B2DistributionPDFFDist

Computes the F distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

331. B2DistributionPDFGamma

Computes the Gamma distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

332. B2DistributionPDFGeometric

Computes the Geometric distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

333. B2DistributionPDFGumbelMax

Computes the Gumbel Max distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

334. B2DistributionPDFGumbelMin

Computes the Gumbel Min distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

335. B2DistributionPDFLogistic

Computes the Logistic distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

336. B2DistributionPDFLognormal

Computes the Lognormal distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

337. B2DistributionPDFNormal

Computes the Normal distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

338. B2DistributionPDFPareto

Computes the Pareto distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

339. B2DistributionPDFPoisson

Computes the Poisson distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

340. B2DistributionPDFRayleigh

Computes the Rayleigh distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

341. B2DistributionPDFStandardNormal

Computes the Standard Normal distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

342. B2DistributionPDFTDist

Computes the Student’s T distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

343. B2DistributionPDFTriangular

Computes the Triangular distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

344. B2DistributionPDFUniform

Computes the Uniform distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

345. B2DistributionPDFWeibull

Computes the Weibull distribution’s theoretical Probability Density Function (PDF). The PDF of a discrete distribution returns the exact probability mass function or probability of occurrence, but the PDFs of continuous distributions are only theoretical values and not exact probabilities.

346. B2EquityLinkedFXCallOptionDomesticValue

Call options whose underlying asset is in a foreign equity market, and the fluctuations of the foreign exchange risk are hedged by having a strike price on the foreign exchange rate. Resulting valuation is in the domestic currency.

347. B2EquityLinkedFXPutOptionDomesticValue

Put options whose underlying asset is in a foreign equity market, and the fluctuations of the foreign exchange risk are hedged by having a strike price on the foreign exchange rate. Resulting valuation is in the domestic currency.

348. B2EWMAVolatilityForecastGivenPastPrices

Computes the annualized volatility forecast of the next period, given a series of historical prices and the corresponding weights placed on the previous volatility estimate.

349. B2EWMAVolatilityForecastGivenPastVolatility

Computes the annualized volatility forecast of the next period given the previous period’s volatility and changes in stock returns in the previous period.

350. B2ExtremeSpreadCallOption

Maturities are divided into two segments, and the call option pays the difference between the max assets from segment two and max of segment one.

351. B2ExtremeSpreadPutOption

Maturities are divided into two segments, and the put option pays the difference between the min of segment two’s asset value and the min of segment one’s asset value.

352. B2ExtremeSpreadReverseCallOption

Maturities are divided into two segments, and a reverse call pays the min from segment one less the min of segment two.

353. B2ExtremeSpreadReversePutOption

Maturities are divided into two segments, and a reverse put pays the max of segment one less the max of the segment two.

354. B2FinanceFV

Computes the future value of an investment based on periodic constant payments and constant interest rate.

355. B2FinanceInterestAnnualtoPeriodic

Converts an annualized interest rate into a periodic interest rate.

356. B2FinanceInterestContinuousToPeriodic

Converts a continuously compounding rate into a periodic interest rate.

357. B2FinanceInterestPeriodictoAnnual

Converts a periodic interest rate into an annualized interest rate.

358. B2FinanceInterestPeriodictoContinuous

Converts a periodic interest rate to a continuously compounding rate.

359. B2FinancePMT

Computes the constant payment required to pay off a loan or hit some target investment in the future.

360. B2FinancePV

Computes the present value of an investment or the amount of a series of future payments worth today.

361. B2FinanceRate

Computes the constant interest rate per period of a loan or investment.

362. B2FinanceYears

Computes the number of periods for an investment or loan based on a constant payment and constant interest rate.

363. B2FiniteDifferenceAmericanCall

Computes the American call option using finite differencing methods, as an alternative to simulation, closed-form approximation models, and lattices.

364. B2FiniteDifferenceAmericanPut

Computes the American put option using finite differencing methods, as an alternative to simulation, closed-form approximation models, and lattices.

365. B2FiniteDifferenceEuropeanCall

Computes the European call option using finite differencing methods, as an alternative to simulation, closed-form approximation models, and lattices.

366. B2FiniteDifferenceEuropeanPut

Computes the European put option using finite differencing methods, as an alternative to simulation, closed-form approximation models, and lattices.

367. B2FixedStrikeLookbackCall

Strike price is fixed, while at expiration the payoff is the difference between the maximum asset price less the strike price during the lifetime of the option.

368. B2FixedStrikeLookbackPut

Strike price is fixed, while at expiration the payoff is the maximum difference between the lowest observed asset price less the strike price during the lifetime of the option.

369. B2FixedStrikePartialLookbackCall

Strike price is fixed, while at expiration the payoff is the difference between the maximum asset price less the strike price during the starting period of the lookback to the maturity of the option.

370. B2FixedStrikePartialLookbackPut

Strike price is fixed, while at expiration the payoff is the maximum difference between the lowest observed asset price less the strike price during the starting period of the lookback to the maturity of the option.

371. B2FloatingStrikeLookbackCallonMin

Strike price is floating, while at expiration the payoff on the call option is being able to purchase the underlying asset at the minimum observed price during the life of the option.

372. B2FloatingStrikeLookbackPutonMax

Strike price is floating, while at expiration the payoff on the put option is being able to sell the underlying asset at the maximum observed asset price during the life of the option.

373. B2FloatingStrikePartialLookbackCallonMin

Strike price is floating, while at expiration the payoff on the call option is being able to purchase the underlying at the minimum observed asset price from inception to the end of the lookback time.

374. B2FloatingStrikePartialLookbackPutonMax

Strike price is floating, while at expiration the payoff on the put option is being able to sell the underlying at the maximum observed asset price from inception to the end of the lookback time.

375. B2ForecastBrownianMotionSimulatedSeries

Computes the entire time-series of Brownian motion stochastic process forecast values.

376. B2ForecastDistributionValue

Computes the forecast price of an asset in the future, assuming the asset follows a Brownian motion random walk and returns the forecast price given the cumulative probability level.

377. B2ForecastDistributionValuePercentile

Computes the cumulative probability or percentile of an asset in the future, assuming the asset follows a Brownian motion random walk and returns the forecast cumulative percentile given the future price.

378. B2ForecastDistributionReturns

Computes the forecast return of an asset in the future, assuming the asset follows a Brownian motion random walk and returns the forecast percent return given the cumulative probability level.

379. B2ForecastDistributionReturnsPercentile

Computes the cumulative probability or percentile of an asset's returns in the future, assuming the asset follows a Brownian motion random walk and returns the forecast cumulative percentile given the return.

380. B2ForecastJumpDiffusionSimulatedSeries

Computes the entire time-series of a jump-diffusion stochastic process forecast values.

381. B2ForecastMeanReversionSimulatedSeries

Computes the entire time-series of a mean-reverting stochastic process forecast values.

382. B2ForecastIncrementalFinancialNeeds

Computes the incremental funds required to cover the projected organic sales growth of the company based on the projected year’s financials.

383. B2ForecastIncrementalPercentSalesGrowthFinancedExternally

Computes the incremental funds as a percent of sales growth that is required from external funding to cover the projected organic sales growth of the company.

384. B2ForeignEquityDomesticCurrencyCall

Computes the value of a foreign-based equity call option struck in a domestic currency and accounting for the exchange rate volatility.

385. B2ForeignEquityDomesticCurrencyPut

Computes the value of a foreign-based equity put option struck in a domestic currency and accounting for the exchange rate volatility.

386. B2ForeignEquityFixedFXRateDomesticValueQuantoCall

Quanto call options are denominated in a currency other than the underlying asset, with expanding or contracting protection coverage of the foreign exchange rates.

387. B2ForeignEquityFixedFXRateDomesticValueQuantoPut

Quanto put options are denominated in a currency other than the underlying asset, with expanding or contracting protection coverage of the foreign exchange rates.

388. B2ForwardRate

Computes the Forward Interest Rate given two Spot Rates.

389. B2ForwardStartCallOption

Starts proportionally in or out of the money in the future. Alpha < 1: call starts (1 – A)% in-the-money, put starts (1 – A)% out of the money. Alpha > 1: call (A – 1)% out of the money, put (A – 1)% in-the-money.

390. B2ForwardStartPutOption

Starts proportionally in or out of the money in the future. Alpha < 1: call starts (1 – A)% in-the-money, put starts (1 – A)% out of the money. Alpha > 1: call (A – 1)% out of the money, put (A – 1)% in-the-money.

391. B2FuturesForwardsCallOption

Similar to a regular option but the underlying asset is a futures of a forward contract. A call option is the option to buy a futures contract, with the specified futures strike price at which the futures is traded if the option is exercised.

392. B2FuturesForwardsPutOption

Similar to a regular option but the underlying asset is a futures of a forward contract. A put option is the option to sell a futures contract, with the specified futures strike price at which the futures is traded if the option is exercised.

393. B2FuturesSpreadCall

The payoff of a spread option is the difference between the two futures’ values at expiration. The spread is Futures 1 – Futures 2, and the call payoff is Spread – Strike.

394. B2FuturesSpreadPut

The payoff of a spread option is the difference between the two futures’ values at expiration. The spread is Futures 1 – Futures 2, and the put payoff is Strike – Spread.

395. B2GARCH

Computes the forward-looking volatility forecast using the generalized autoregressive conditional heteroskedasticity (p, q) model where future volatilities are forecast based on historical price levels and information.

396. B2GapCallOption

The call option is knocked in if the asset exceeds the reference Strike 1, and the option payoff is the asset price less Strike 2 for the underlying.

397. B2GapPutOption

The put option is knocked in only if the underlying asset is less than the reference Strike 1, providing a payoff of Strike 2 less the underlying asset value.

398. B2GeneralizedBlackScholesCall

Returns the Black-Scholes model with a continuous dividend yield call option.

399. B2GeneralizedBlackScholesCallCashDividends

Modification of the Generalized Black-Scholes model to solve European call options, assuming a series of dividend cash flows that may be even or uneven. A series of dividend payments and time are required.

400. B2GeneralizedBlackScholesPut

Returns the Black-Scholes model with a continuous dividend yield put option.

401. B2GeneralizedBlackScholesPutCashDividends

Modification of the Generalized Black-Scholes model to solve European put options, assuming a series of dividend cash flows that may be even or uneven. A series of dividend payments and time are required.

402. B2GraduatedBarrierDownandInCall

Barriers are graduated ranges between lower and upper values. The option is knocked in-the-money proportionally depending on how low the asset value is in the range.

403. B2GraduatedBarrierDownandOutCall

Barriers are graduated ranges between lower and upper values. The option is knocked out of the money proportionally depending on how low the asset value is in the range.

404. B2GraduatedBarrierUpandInPut

Barriers are graduated ranges between lower and upper values. The option is knocked in-the-money proportionally depending on how high the asset value is in the range.

405. B2GraduatedBarrierUpandOutPut

Barriers are graduated ranges between lower and upper values. The option is knocked out of the money proportionally depending on how high the asset value is in the range.

406. B2ImpliedVolatilityBestCase

Computes the implied volatility given an expected value of an asset, along with an alternative best-case scenario value and its corresponding percentile (must be above 50%).

407. B2ImpliedVolatilityCall

Computes the implied volatility in a European call option given all the inputs parameters and the option value.

408. B2ImpliedVolatilityPut

Computes the implied volatility in a European put option given all the inputs parameters and the option value.

409. B2ImpliedVolatilityWorstCase

Computes the implied volatility given an expected value of an asset, along with an alternative worst-case scenario value and its corresponding percentile (must be below 50%).

410. B2InterestAnnualtoPeriodic

Computes the periodic compounding rate based on the annualized compounding interest rate per year.

411. B2InterestCaplet

Computes the interest rate caplet (sum all the caplets into the total value of the interest rate cap) and acts like an interest rate call option.

412. B2InterestContinuousToDiscrete

Returns the corresponding discrete compounding interest rate, given the continuous compounding rate.

413. B2InterestContinuousToPeriodic

Computes the periodic compounding interest rate based on a continuous compounding rate.

414. B2InterestDiscreteToContinuous

Returns the corresponding continuous compounding interest rate, given the discrete compounding rate.

415. B2InterestFloorlet

Computes the interest rate floorlet (sum all the floorlets into the total value of the interest rate floor) and acts like an interest rate put option.

416. B2InterestPeriodictoAnnual

Computes the annualized compounding interest rate per year based on a periodic compounding rate.

417. B2InterestPeriodictoContinuous

Computes the continuous compounding rate based on the periodic compounding interest rate.

418. B2InverseGammaCallOption

Computes the European call option assuming an inverse Gamma distribution, rather than a normal distribution, and is important for deep out-of-the-money options.

419. B2InverseGammaPutOption

Computes the European put option assuming an inverse Gamma distribution, rather than a normal distribution, and is important for deep out-of-the-money options.

420. B2IRRContinuous

Returns the continuously discounted Internal Rate of Return for a cash flow series with its respective cash flow times in years.

421. B2IRRDiscrete

Returns the discretely discounted Internal Rate of Return for a cash flow series with its respective cash flow times in years.

422. B2LinearInterpolation

Interpolates and fills in the missing values of a time series.

423. B2MarketPriceRisk

Computes the market price of risk used in a variety of options analyses, using market return, risk-free return, volatility of the market, and correlation between the market and the asset.

424. B2MathGammaLog

Returns the result from a log gamma function.

425. B2MathIncompleteBeta

Returns the result from an incomplete Beta function.

426. B2MathIncompleteGammaP

Returns the result from an incomplete Gamma P function.

427. B2MathIncompleteGammaQ

Returns the result from an incomplete Gamma Q function.

428. B2MatrixMultiplyAxB

Multiplies two compatible matrices, such as M ´ N and N ´ M, to create an M ´ M matrix. Copy and paste the function and use Ctrl+Shift+Enter to obtain the matrix.

429. B2MatrixMultiplyAxTransposeB

Multiplies the first matrix with the transpose of the second matrix (multiplies M ´ N with M ´ N matrix by transposing the second matrix to N ´ M, generating an M ´ M matrix). Copy and paste the function and use Ctrl+Shift+Enter to obtain the matrix.

430. B2MatrixMultiplyTransposeAxB

Multiplies the transpose of the first matrix with the second matrix (multiplies M ´ N with M ´ N matrix by transposing the first matrix to N ´ M, generating an N ´ N matrix). Copy and paste the function and use Ctrl+Shift+Enter to obtain the matrix.

431. B2MatrixTranspose

Transposes a matrix from M ´ N to N ´ M. Copy and paste the function and use Ctrl+Shift+Enter to obtain the matrix.

432. B2MertonJumpDiffusionCall

Call value of an underlying whose asset returns are assumed to follow a Poisson Jump Diffusion process; that is, prices jump several times a year, and cumulatively these jumps explain a percentage of the total asset volatility.

433. B2MertonJumpDiffusionPut

Put value of an underlying whose asset returns are assumed to follow a Poisson Jump Diffusion process; that is, prices jump several times a year, and cumulatively these jumps explain a percentage of the total asset volatility.

434. B2NextSettlement

Computes the next settlement date based on the U.S. trading calendar.

435. B2NextSettlementQuarterly

Computes the next settlement date in the quarter based on the U.S. trading calendar.

436. B2NextSettlementyearly

Computes the next settlement date in the year based on the U.S. trading calendar.

437. B2NormalTransform

Converts values into a normalized distribution.

438. B2NPVContinuous

Returns the Net Present Value of a cash flow series given the time and discount rate, using continuous discounting.

439. B2NPVDiscrete

Returns the Net Present Value of a cash flow series given the time and discount rate, using discrete discounting.

440. B2OptionStrategyLongBearCreditSpread

Returns the matrix [stock price, buy put, sell put, profit] of a long bearish credit spread (buying a higher strike put with a high price and selling a lower strike put with a low price).

441. B2OptionStrategyLongBullCreditSpread

Returns the matrix [stock price, buy put, sell put, profit] of a long bullish credit spread (buying a lower strike put at a low price and selling a higher strike put at a high price).

442. B2OptionStrategyLongBearDebitSpread

Returns the matrix [stock price, buy call, sell call, profit] of a long bearish debit spread (buying a higher strike call with a low price and selling a lower strike call with a high price).

443. B2OptionStrategyLongBullDebitSpread

Returns the matrix [stock price, buy call, sell call, profit] of a bullish debit spread (buying a lower strike call at a high price and selling a further out-of-the-money higher strike call at a low price).

444. B2OptionStrategyLongCoveredCall

Returns the matrix [stock price, buy stock, sell call, profit] of a long covered call position (buying the stock and selling a call of the same asset).

445. B2OptionStrategyLongProtectivePut

Returns the matrix [stock price, buy stock, buy put, profit] of a long protective put position (buying the stock and buying a put of the same asset).

446. B2OptionStrategyLongStraddle

Returns the matrix [stock price, buy call, buy put, profit] of a long straddle position (buying an equal number of puts and calls with identical strike price and expiration) to profit from high volatility.

447. B2OptionStrategyLongStrangle

Returns the matrix [stock price, buy call, buy put, profit] of a long strangle (buying a higher strike call at a low price and buying a lower strike put at a low price—close expirations) to profit from high volatility.

448. B2OptionStrategyWriteCoveredCall

Returns the matrix [stock price, sell stock, buy call, profit] of writing a covered call (selling the stock and buying a call of the same asset).

449. B2OptionStrategyWriteProtectivePut

Returns the matrix [stock price, sell stock, sell put, profit] of a writing a protective put position (selling the stock and selling a put of the same asset).

450. B2OptionStrategyWriteStraddle

Returns the matrix [stock price, sell call, sell put, profit] of writing a straddle position (selling an equal number of puts and calls with identical strike price and expiration) to profit from low volatility.

451. B2OptionStrategyWriteStrangle

Returns the matrix [stock price, sell call, sell put, profit] of writing a strangle (sell a higher strike call at a low price and sell a lower strike put at a low price—close expirations) to profit from low volatility.

452. B2Payback

Computes the payback in years given some initial investment and subsequent cash flows.

453. B2PerpetualCallOption

Computes the American perpetual call option. Note that it returns an error if dividend is 0% (this is because the American option reverts to European and a perpetual European has no value).

454. B2PerpetualPutOption

Computes the American perpetual put option. Note that it returns an error if dividend is 0% (this is because the American option reverts to European and a perpetual European has no value).

455. B2PrevSettlement

Computes the previous settlement date based on the U.S. trading calendar.

456. B2PrevSettlementQuarterly

Computes the previous settlement date in the quarter based on the U.S. trading calendar.

457. B2PrevSettlementYearly

Computes the previous settlement date in the year based on the U.S. trading calendar.

458. B2PortfolioReturns

Computes the portfolio weighted average expected returns given individual asset returns and allocations.

459. B2PortfolioRisk

Computes the portfolio risk given individual asset allocations and variance-covariance matrix.

460. B2PortfolioVariance

Computes the portfolio variance given individual asset allocations and variance-covariance matrix. Take the square root of the result to obtain the portfolio risk.

461. B2ProbabilityDefaultAdjustedBondYield

Computes the required risk-adjusted yield (premium spread plus risk-free rate) to charge given the cumulative probability of default.

462. B2ProbabilityDefaultAverageDefaults

Credit Risk Plus’ average number of credit defaults per period using total portfolio credit exposures, average cumulative probability of default, and percentile Value at Risk for the portfolio.

463. B2ProbabilityDefaultCorrelation

Computes the correlations of default probabilities given the probabilities of default of each asset and the correlation between their equity prices. The result is typically much smaller than the equity correlation.

464. B2ProbabilityDefaultCumulativeBondYieldApproach

Computes the cumulative probability of default from Year 0 to Maturity using a comparable zero bond yield versus a zero risk-free yield and accounting for a recovery rate.

465. B2ProbabilityDefaultCumulativeSpreadApproach

Computes the cumulative probability of default from Year 0 to Maturity using a comparable risky debt’s spread (premium) versus the risk-free rate and accounting for a recovery rate.

466. B2ProbabilityDefaultHazardRate

Computes the hazard rate for a specific year (in survival analysis) using a comparable zero bond yield versus a zero risk-free yield and accounting for a recovery rate.

467. B2ProbabilityDefaultMertonDefaultDistance

Distance to Default (does not require market returns and correlations but requires the internal growth rates).

468. B2ProbabilityDefaultMertonI

Probability of Default (without regard to Equity Value or Equity Volatility, but requires asset, debt, and market values).

469. B2ProbabilityDefaultMertonII

Probability of Default (does not require market returns and correlations but requires the internal growth rates).

470. B2ProbabilityDefaultMertonImputedAssetValue

Returns the imputed market value of asset given external equity value, equity volatility, and other option inputs. Used in the Merton probability of default model.

471. B2ProbabilityDefaultMertonImputedAssetVolatility

Returns the imputed volatility of asset given external equity value, equity volatility, and other option inputs. Used in the Merton probability of default model.

472. B2ProbabilityDefaultMertonMVDebt

Computes the market value of debt (for risky debt) in the Merton-based simultaneous options model.

473. B2ProbabilityDefaultMertonRecoveryRate

Computes the rate of recovery in percent for risky debt in the Merton-based simultaneous options model.

474. B2ProbabilityDefaultPercentileDefaults

Credit Risk Plus method to compute the percentile given some estimated average number of defaults per period.

475. B2PropertyDepreciation

Value of the periodic depreciation allowed on a commercial real estate project, given the percent of price going to improvement and the allowed recovery period.

476. B2PropertyEquityRequired

Value of the required equity down payment on a commercial real estate project, given the valuation of the project.

477. B2PropertyLoanAmount

Value of the required mortgage amount on a commercial real estate project, given the value of the project and the loan required (loan-to-value ratio or the percentage of the value that a loan represents is required).

478. B2PropertyValuation

Value of a commercial real estate property assuming Gross Rent, Vacancy, Operating Expenses, and the Cap Rate at Purchase Date (Net Operating Income/Sale Price).

479. B2PutCallParityCalltoPut

Computes the European put option value given the value of a corresponding European call option with identical input assumptions.

480. B2PutCallParityCalltoPutCurrencyOptions

Computes the European currency put option value given the value of a corresponding European currency call option on futures and forwards with identical input assumptions.

481. B2PutCallParityCalltoPutFutures

Computes the value of a European put option on futures and forwards given the value of a corresponding European call option on futures and forwards with identical input assumptions.

482. B2PutCallParityPuttoCall

Computes the European call option value given the value of a corresponding European put option with identical input assumptions.

483. B2PutCallParityPuttoCallCurrencyOptions

Computes the value of a European currency call option given the value of a corresponding European currency put option on futures and forwards with identical input assumptions.

484. B2PutCallParityPuttoCallFutures

Computes the value of a European call option on futures and forwards given the value of a corresponding European put option on futures and forwards with identical input assumptions.

485. B2PutDelta

Returns the option valuation sensitivity Delta (a put option value’s sensitivity to changes in the asset value).

486. B2PutGamma

Returns the option valuation sensitivity Gamma (a put option value’s sensitivity to changes in the Delta value).

487. B2PutOptionOnTheMax

The maximum values at expiration of both assets are used in option exercise, where the call option payoff at expiration is the strike price against the maximum price between Asset 1 and Asset 2.

488. B2PutOptionOnTheMin

The minimum values at expiration of both assets are used in option exercise, where the call option payoff at expiration is the strike price against the minimum price between Asset 1 and Asset 2.

489. B2PutRho

Returns the option valuation sensitivity Rho (a put option value’s sensitivity to changes in the interest rate).

490. B2PutTheta

Returns the option valuation sensitivity Theta (a put option value’s sensitivity to changes in the maturity).

491. B2PutVega

Returns the option valuation sensitivity Vega (a put option value’s sensitivity to changes in the volatility).

492. B2QueuingMCAveCustomersinSystem

Average number of customers in the system, using a multiple-channel queuing model assuming a Poisson arrival rate with Exponential distribution of service times.

493. B2QueuingMCAveCustomersWaiting

Average number of customers in the waiting line, using a multiple-channel queuing model assuming a Poisson arrival rate with Exponential distribution of service times.

494. B2QueuingMCAveTimeinSystem

Average time a customer spends in the system, using a multiple-channel queuing model assuming a Poisson arrival rate with Exponential distribution of service times.

495. B2QueuingMCAveTimeWaiting

Average time a customer spends in the waiting line, using a multiple-channel queuing model assuming a Poisson arrival rate with Exponential distribution of service times.

496. B2QueuingMCProbHaveToWait

Probability an arriving customer has to wait, using a multiple-channel queuing model assuming a Poisson arrival rate with Exponential distribution of service times.

497. B2QueuingMCProbNoCustomer

Probability that no customers are in the system, using a multiple-channel queuing model assuming a Poisson arrival rate with Exponential distribution of service times.

498. B2QueuingMGKAveCustomersinSystem

Average number of customers in the system, using a multiple-channel queuing model assuming a Poisson arrival rate with unknown distribution of service times.

499. B2QueuingMGKCostPerPeriod

Total cost per time period, using a multiple-channel queuing model assuming a Poisson arrival rate with unknown distribution of service times.

500. B2QueuingMGKProbBusy

Probability a channel will be busy, using a multiple-channel queuing model assuming a Poisson arrival rate with unknown distribution of service times.

501. B2QueuingSCAAveCustomersinSystem

Average number of customers in the system, using an MG1 single-channel arbitrary queuing model assuming a Poisson arrival rate with unknown distribution of service times.

502. B2QueuingSCAAveCustomersWaiting

Average number of customers in the waiting line, using an MG1 single-channel arbitrary queuing model assuming a Poisson arrival rate with unknown distribution of service times.

503. B2QueuingSCAAveTimeinSystem

Average time a customer spends in the system, using an MG1 single-channel arbitrary queuing model assuming a Poisson arrival rate with unknown distribution of service times.

504. B2QueuingSCAAveTimeWaiting

Average time a customer spends in the waiting line, using an MG1 single-channel arbitrary queuing model assuming a Poisson arrival rate with unknown distribution of service times.

505. B2QueuingSCAProbHaveToWait

Probability an arriving customer has to wait, using an MG1 single-channel arbitrary queuing model assuming a Poisson arrival rate with unknown distribution of service times.

506. B2QueuingSCAProbNoCustomer

Probability that no customers are in the system, using an MG1 single-channel arbitrary queuing model assuming a Poisson arrival rate with unknown distribution of service times.

507. B2QueuingSCAveCustomersinSystem

Average number of customers in the system, using a single-channel queuing model.

508. B2QueuingSCAveCustomersWaiting

Returns the average number of customers in the waiting line, using a single-channel queuing model.

509. B2QueuingSCAveTimeinSystem

Average time a customer spends in the system, using a single-channel queuing model.

510. B2QueuingSCAveTimeWaiting

Average time a customer spends in the waiting line, using a single-channel queuing model.

511. B2QueuingSCProbHaveToWait

Probability an arriving customer has to wait, using a single-channel queuing model.

512. B2QueuingSCProbNoCustomer

Returns the probability that no customers are in the system, using a single-channel queuing model.

513. B2RatiosBasicEarningPower

Computes the basic earning power (BEP) by accounting for earnings before interest and taxes (EBIT) and the amount of total assets employed.

514. B2RatiosBetaLevered

Computes the levered beta from an unlevered beta level after accounting for the tax rate, total debt, and equity values.

515. B2RatiosBetaUnlevered

Computes the unlevered beta from a levered beta level after accounting for the tax rate, total debt, and equity values.

516. B2RatiosBookValuePerShare

Computes the book value per share (BV) by accounting for the total common equity amount and number of shares outstanding.

517. B2RatiosCapitalCharge

Computes the capital charge value (typically used to compute the economic profit of a project).

518. B2RatiosCAPM

Computes the capital asset pricing model’s required rate of return in percent, given some benchmark market return, beta risk coefficient, and risk-free rate.

519. B2RatiosCashFlowtoEquityLeveredFirm

Cash flow to equity for a levered firm (accounting for operating expenses, taxes, depreciation, amortization, capital expenditures, change in working capital, preferred dividends, principal repaid, and new debt issues).

520. B2RatiosCashFlowtoEquityUnleveredFirm

Cash flow to equity for an unlevered firm (accounting for operating expenses, taxes, depreciation, amortization, capital expenditures, change in working capital, and taxes).

521. B2RatiosCashFlowtoFirm

Cash flow to the firm (accounting for earnings before interest and taxes [EBIT], tax rate, depreciation, capital expenditures, and change in working capital).

522. B2RatiosCashFlowtoFirm2

Cash flow to the firm (accounting for net operating profit after taxes [NOPAT], depreciation, capital expenditures, and change in working capital).

523. B2RatiosContinuingValue1

Computes the continuing value based on a constant growth rate of free cash flows to perpetuity using a Gordon Growth Model.

524. B2RatiosContinuingValue2

Computes the continuing value based on a constant growth rate of free cash flows to perpetuity using net operating profit after taxes (NOPAT), return on invested capital (ROIC), growth rate, and current free cash flow.

525. B2RatiosCostEquity

Computes the cost of equity (as used in a CAPM model) using the dividend rate, growth rate of dividends, and current equity price.

526. B2RatiosCurrentRatio

Computes the current ratio by accounting for the individual asset and liabilities.

527. B2RatiosDaysSalesOutstanding

Computes the days sales outstanding by looking at the accounts receivable value, total annual sales, and number of days per year.

528. B2RatiosDebtAssetRatio

Computes the debt-to-asset ratio by accounting for the total debt and total asset values.

529. B2RatiosDebtEquityRatio

Computes the debt-to-equity ratio by accounting for the total debt and total common equity levels.

530. B2RatiosDebtRatio1

Computes the debt ratio by accounting for the total debt and total asset values.

531. B2RatiosDebtRatio2

Computes the debt ratio by accounting for the total equity and total asset values.

532. B2RatiosDividendsPerShare

Computes the dividends per share (DPS) by accounting for the dividend payment amount and number of shares outstanding.

533. B2RatiosEarningsPerShare

Computes the earnings per share (EPS) by accounting for the net income amount and number of shares outstanding.

534. B2RatiosEconomicProfit1

Computes the economic profit using invested capital, return on invested capital (ROIC), and weighted average cost of capital (WACC).

535. B2RatiosEconomicProfit2

Computes the economic profit using net operating profit after taxes (NOPAT), return on invested capital (ROIC), and weighted average cost of capital (WACC).

536. B2RatiosEconomicProfit3

Computes the economic profit using net operating profit after taxes (NOPAT) and capital charge.

537. B2RatiosEconomicValueAdded

Computes the economic value added using earnings before interest and taxes (EBIT), total capital employed, tax rate, and weighted average cost of capital (WACC).

538. B2RatiosEquityMultiplier

Computes the equity multiplier (the ratio of total assets to total equity).

539. B2RatiosFixedAssetTurnover

Computes the fixed asset turnover by accounting for the annual sales levels and net fixed assets.

540. B2RatiosInventoryTurnover

Computes the inventory turnover using sales and inventory levels.

541. B2RatiosMarketBookRatio1

Computes the market to book value (BV) per share by accounting for the share price and the book value per share.

542. B2RatiosMarketBookRatio2

Computes the market to book value (BV) per share by accounting for the share price, total common equity value, and number of shares outstanding.

543. B2RatiosMarketValueAdded

Computes the market value added by accounting for the stock price, total common equity, and number of shares outstanding.

544. B2RatiosNominalCashFlow

Computes the nominal cash flow amount assuming some inflation rate, real cash flow, and the number of years in the future.

545. B2RatiosNominalDiscountRate

Computes the nominal discount rate assuming some inflation rate and real discount rate.

546. B2RatiosPERatio1

Computes the price-to-earnings (P/E) ratio using stock price and earnings per share (EPS).

547. B2RatiosPERatio2

Computes the price-to-earnings (P/E) ratio using stock price, net income, and number of shares outstanding.

548. B2RatiosPERatio3

Computes the price-to-earnings (P/E) ratio using growth rates, rate of return, and discount rate.

549. B2RatiosProfitMargin

Computes the profit margin by taking the ratio of net income to annual sales.

550. B2RatiosQuickRatio

Computes the quick ratio by accounting for the individual assets and liabilities.

551. B2RatiosRealCashFlow

Computes the real cash flow amount assuming some inflation rate, nominal cash flow (Nominal CF), and the number of years in the future.

552. B2RatiosRealDiscountRate

Computes the real discount rate assuming some inflation rate and nominal discount rate.

553. B2RatiosReturnonAsset1

Computes the return on assets using net income amount and total assets employed.

554. B2RatiosReturnonAsset2

Computes the return on assets using net profit margin percentage and total asset turnover ratio.

555. B2RatiosReturnonEquity1

Computes return on equity using net income and total common equity values.

556. B2RatiosReturnonEquity2

Computes return on equity using return on assets (ROA), total assets, and total equity values.

557. B2RatiosReturnonEquity3

Computes return on equity using net income, total sales, total assets, and total common equity values.

558. B2RatiosReturnonEquity4

Computes return on equity using net profit margin, total asset turnover, and equity multiplier values.

559. B2RatiosROIC

Computes the return on invested capital (typically used for computing economic profit) accounting for change in working capital; property, plant, and equipment (PPE); and other assets.

560. B2RatiosShareholderEquity

Computes the common shareholder’s equity after accounting for total assets, total liabilities, and preferred stocks.

561. B2RatiosTimesInterestEarned

Computes the times interest earned ratio by accounting for earnings before interest and taxes (EBIT) and the amount of interest payment.

562. B2RatiosTotalAssetTurnover

Computes the total asset turnover by accounting for the annual sales levels and total assets.

563. B2RatiosWACC1

Computes the weighted average cost of capital (WACC) using market values of debt, preferred equity, and common equity, as well as their respective costs.

564. B2RatiosWACC2

Computes the weighted average cost of capital (WACC) using market values of debt, and market values of common equity, as well as their respective costs.

565. B2ROBinomialAmericanAbandonContract

Returns the American option to abandon and contract using a binomial lattice model.

566. B2ROBinomialAmericanAbandonContractExpand

Returns the American option to abandon, contract, and expand using a binomial lattice model.

567. B2ROBinomialAmericanAbandonExpand

Returns the American option to abandon and expand using a binomial lattice model.

568. B2ROBinomialAmericanAbandonment

Returns the American option to abandon using a binomial lattice model.

569. B2ROBinomialAmericanCall

Returns the American call option with dividends using a binomial lattice model.

570. B2ROBinomialAmericanChangingRiskFree

Returns the American call option with dividends and assuming the risk-free rate changes over time, using a binomial lattice model.

571. B2ROBinomialAmericanChangingVolatility

Returns the American call option with dividends and assuming the volatility changes over time, using a binomial lattice model. Use small number of steps or it will take a long time to compute!

572. B2ROBinomialAmericanContractExpand

Returns the American option to contract and expand using a binomial lattice model.

573. B2ROBinomialAmericanContraction

Returns the American option to contract using a binomial lattice model.

574. B2ROBinomialAmericanCustomCall

Returns the American option call option with changing inputs, vesting periods, and suboptimal exercise multiple using a binomial lattice model.

575. B2ROBinomialAmericanExpansion

Returns the American option to expand using a binomial lattice model.

576. B2ROBinomialAmericanPut

Returns the American put option with dividends using a binomial lattice model.

577. B2ROBinomialBermudanAbandonContract

Returns the Bermudan option to abandon and contract using a binomial lattice model, where there is a vesting/blackout period during which the option cannot be executed.

578. B2ROBinomialBermudanAbandonContractExpand

Returns the Bermudan option to abandon, contract, and expand, using a binomial lattice model, where there is a vesting/blackout period during which the option cannot be executed.

579. B2ROBinomialBermudanAbandonExpand

Returns the Bermudan option to abandon and expand using a binomial lattice model, where there is a vesting/blackout period during which the option cannot be executed.

580. B2ROBinomialBermudanAbandonment

Returns the Bermudan option to abandon using a binomial lattice model, where there is a vesting/blackout period during which the option cannot be executed.

581. B2ROBinomialBermudanCall

Returns the Bermudan call option with dividends, where there is a vesting/blackout period during which the option cannot be executed.

582. B2ROBinomialBermudanContractExpand

Returns the Bermudan option to contract and expand, using a binomial lattice model, where there is a vesting/blackout period during which the option cannot be executed.

583. B2ROBinomialBermudanContraction

Returns the Bermudan option to contract using a binomial lattice model, where there is a vesting/blackout period during which the option cannot be executed.

584. B2ROBinomialBermudanExpansion

Returns the Bermudan option to expand using a binomial lattice model, where there is a vesting/blackout period during which the option cannot be executed.

585. B2ROBinomialBermudanPut

Returns the Bermudan put option with dividends, where there is a vesting/blackout period during which the option cannot be executed.

586. B2ROBinomialEuropeanAbandonContract

Returns the European option to abandon and contract, using a binomial lattice model, where the option can be executed only at expiration.

587. B2ROBinomialEuropeanAbandonContractExpand

Returns the European option to abandon, contract, and expand, using a binomial lattice model, where the option can be executed only at expiration.

588. B2ROBinomialEuropeanAbandonExpand

Returns the European option to abandon and expand, using a binomial lattice model, where the option can be executed only at expiration.

589. B2ROBinomialEuropeanAbandonment

Returns the European option to abandon using a binomial lattice model, where the option can be executed only at expiration.

590. B2ROBinomialEuropeanCall

Returns the European call option with dividends, where the option can be executed only at expiration.

591. B2ROBinomialEuropeanContractExpand

Returns the European option to contract and expand, using a binomial lattice model, where the option can be executed only at expiration.

592. B2ROBinomialEuropeanContraction

Returns the European option to contract using a binomial lattice model, where the option can be executed only at expiration.

593. B2ROBinomialEuropeanExpansion

Returns the European option to expand using a binomial lattice model, where the option can be executed only at expiration.

594. B2ROBinomialEuropeanPut

Returns the European put option with dividends, where the option can be executed only at expiration.

595. B2ROJumpDiffusionCall

Returns the closed-form model for a European call option whose underlying asset follows a Poisson Jump Diffusion process.

596. B2ROJumpDiffusionPut

Returns the closed-form model for a European put option whose underlying asset follows a Poisson Jump Diffusion process.

597. B2ROMeanRevertingCall

Returns the closed-form model for a European call option whose underlying asset follows a mean-reversion process.

598. B2ROMeanRevertingPut

Returns the closed-form model for a European put option whose underlying asset follows a mean-reversion process.

599. B2ROPentanomialAmericanCall

Returns the Rainbow American call option with two underlying assets (these are typically price and quantity, and are multiplied together to form a new combinatorial pentanomial lattice).

600. B2ROPentanomialAmericanPut

Returns the Rainbow American put option with two underlying assets (these are typically price and quantity, and are multiplied together to form a new combinatorial pentanomial lattice).

601. B2ROPentanomialEuropeanCall

Returns the Rainbow European call option with two underlying assets (these are typically price and quantity, and are multiplied together to form a new combinatorial pentanomial lattice).

602. B2ROPentanomialEuropeanPut

Returns the Rainbow European put option with two underlying assets (these are typically price and quantity, and are multiplied together to form a new combinatorial pentanomial lattice).

603. B2ROQuadranomialJumpDiffusionAmericanCall

Returns the American call option whose underlying asset follows a Poisson Jump Diffusion process, using a combinatorial quadranomial lattice.

604. B2ROQuadranomialJumpDiffusionAmericanPut

Returns the American put option whose underlying asset follows a Poisson Jump Diffusion process, using a combinatorial quadranomial lattice.

605. B2ROQuadranomialJumpDiffusionEuropeanCall

Returns the European call option whose underlying asset follows a Poisson Jump Diffusion process, using a combinatorial quadranomial lattice.

606. B2ROQuadranomialJumpDiffusionEuropeanPut

Returns the European put option whose underlying asset follows a Poisson Jump Diffusion process, using a combinatorial quadranomial lattice.

607. B2ROStateAmericanCall

Returns the American call option using a state jump function, where the up and down states can be asymmetrical, solved in a lattice model.

608. B2ROStateAmericanPut

Returns the American put option using a state jump function, where the up and down states can be asymmetrical, solved in a lattice model.

609. B2ROStateBermudanCall

Returns the Bermudan call option using a state jump function, where the up and down states can be asymmetrical, solved in a lattice model, and where the option cannot be exercised during certain vesting/blackout periods.

610. B2ROStateBermudanPut

Returns the Bermudan put option using a state jump function, where the up and down states can be asymmetrical, solved in a lattice model, and where the option cannot be exercised during certain vesting/blackout periods.

611. B2ROStateEuropeanCall

Returns the European call option using a state jump function, where the up and down states can be asymmetrical, solved in a lattice model, and where the option can be exercised only at maturity.

612. B2ROStateEuropeanPut

Returns the European put option using a state jump function, where the up and down states can be asymmetrical, solved in a lattice model, and where the option can be exercised only at maturity.

613. B2ROTrinomialAmericanCall

Returns the American call option with dividend, solved using a trinomial lattice.

614. B2ROTrinomialAmericanMeanRevertingCall

Returns the American call option with dividend, assuming the underlying asset is mean-reverting, and solved using a trinomial lattice.

615. B2ROTrinomialAmericanMeanRevertingPut

Returns the American put option with dividend, assuming the underlying asset is mean-reverting, and solved using a trinomial lattice.

616. B2ROTrinomialAmericanPut

Returns the American put option with dividend, solved using a trinomial lattice.

617. B2ROTrinomialBermudanCall

Returns the Bermudan call option with dividend, solved using a trinomial lattice, where during certain vesting/blackout periods the option cannot be exercised.

618. B2ROTrinomialBermudanPut

Returns the Bermudan put option with dividend, solved using a trinomial lattice, where during certain vesting/blackout periods the option cannot be exercised.

619. B2ROTrinomialEuropeanCall

Returns the European call option with dividend, solved using a trinomial lattice, where the option can be exercised only at maturity.

620. B2ROTrinomialEuropeanMeanRevertingCall

Returns the European call option with dividend, solved using a trinomial lattice, assuming the underlying asset is mean-reverting, and where the option can be exercised only at maturity.

621. B2ROTrinomialEuropeanMeanRevertingPut

Returns the European put option with dividend, solved using a trinomial lattice, assuming the underlying asset is mean-reverting, and where the option can be exercised only at maturity.

622. B2ROTrinomialEuropeanPut

Returns the European put option with dividend, solved using a trinomial lattice, where the option can be exercised only at maturity.

623. B2SCurveValue

Computes the S-Curve extrapolation’s next forecast value based on previous value, growth rate, and maximum capacity levels.

624. B2SCurveValueSaturation

Computes the S-Curve extrapolation’s saturation level based on previous value, growth rate, and maximum capacity levels.

625. B2SemiStandardDeviationPopulation

Computes the semi-standard deviation of the population; that is, only the values below the mean are used to compute an adjusted population standard deviation, a more appropriate measure of downside risk.

626. B2SemiStandardDeviationSample

Computes the semi-standard deviation of the sample; that is, only the values below the mean are used to compute an adjusted sample standard deviation, a more appropriate measure of downside risk.

627. B2SharpeRatio

Computes the Sharpe Ratio (returns-to-risk ratio) based on a series of stock prices of an asset and a market benchmark series of prices.

628. B2SimulateBernoulli

Returns simulated random numbers from the Bernoulli distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

629. B2SimulateBeta

Returns simulated random numbers from the Beta distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

630. B2SimulateBinomial

Returns simulated random numbers from the Binomial distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

631. B2SimulateChiSquare

Returns simulated random numbers from the Chi-Square distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

632. B2SimulatedEuropeanCall

Returns the Monte Carlo simulated European call option (only European options can be approximated well with simulation). This function is volatile.

633. B2SimulatedEuropeanPut

Returns the Monte Carlo simulated European put option (only European options can be approximated well with simulation). This function is volatile.

634. B2SimulateDiscreteUniform

Returns simulated random numbers from the Discrete Uniform distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

635. B2SimulateExponential

Returns simulated random numbers from the Exponential distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

636. B2SimulateFDist

Returns simulated random numbers from the F distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

637. B2SimulateGamma

Returns simulated random numbers from the Gamma distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

638. B2SimulateGeometric

Returns simulated random numbers from the Geometric distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

639. B2SimulateGumbelMax

Returns simulated random numbers from the Gumbel Max distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

640. B2SimulateGumbelMin

Returns simulated random numbers from the Gumbel Min distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

641. B2SimulateLogistic

Returns simulated random numbers from the Logistic distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

642. B2SimulateLognormal

Returns simulated random numbers from the Lognormal distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

643. B2SimulateNormal

Returns simulated random numbers from the Normal distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

644. B2SimulatePareto

Returns simulated random numbers from the Pareto distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

645. B2SimulatePoisson

Returns simulated random numbers from the Poisson distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

646. B2SimulateRayleigh

Returns simulated random numbers from the Rayleigh distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

647. B2SimulateStandardNormal

Returns simulated random numbers from the Standard Normal distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

648. B2SimulateTDist

Returns simulated random numbers from the Student’s T distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

649. B2SimulateTriangular

Returns simulated random numbers from the Triangular distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

650. B2SimulateUniform

Returns simulated random numbers from the Uniform distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

651. B2SimulateWeibull

Returns simulated random numbers from the Weibull distribution. Type in RAND() as the random input parameter to generate volatile random values from this distribution.

652. B2SixSigmaControlCChartCL

Computes the center line in a control c-chart. C-charts are applicable when only the number of defects is important.

653. B2SixSigmaControlCChartDown1Sigma

Computes the lower 1 sigma limit in a control c-chart. C-charts are applicable when only the number of defects is important.

654. B2SixSigmaControlCChartDown2Sigma

Computes the lower 2 sigma limit in a control c-chart. C-charts are applicable when only the number of defects is important.

655. B2SixSigmaControlCChartLCL

Computes the lower control limit in a control c-chart. C-charts are applicable when only the number of defects is important.

656. B2SixSigmaControlCChartUCL

Computes the upper control limit in a control c-chart. C-charts are applicable when only the number of defects is important.

657. B2SixSigmaControlCChartUp1Sigma

Computes the upper 1 sigma limit in a control c-chart. C-charts are applicable when only the number of defects is important.

658. B2SixSigmaControlCChartUp2Sigma

Computes the upper 2 sigma limit in a control c-chart. C-charts are applicable when only the number of defects is important.

659. B2SixSigmaControlNPChartCL

Computes the center line in a control np-chart. NP-charts are applicable when proportions of defects are important, and where in each experimental subgroup the number of sample sizes is constant.

660. B2SixSigmaControlNPChartDown1Sigma

Computes the lower 1 sigma limit in a control np-chart. NP-charts are applicable when proportions of defects are important, and where in each experimental subgroup the number of sample sizes is constant.

661. B2SixSigmaControlNPChartDown2Sigma

Computes the lower 2 sigma limit in a control np-chart. NP-charts are applicable when proportions of defects are important, and where in each experimental subgroup the number of sample sizes is constant.

662. B2SixSigmaControlNPChartLCL

Computes the lower control limit in a control np-chart. NP-charts are applicable when proportions of defects are important, and where in each experimental subgroup the number of sample sizes is constant.

663. B2SixSigmaControlNPChartUCL

Computes the upper control limit in a control np-chart. NP-charts are applicable when proportions of defects are important, and where in each experimental subgroup the number of sample sizes is constant.

664. B2SixSigmaControlNPChartUp1Sigma

Computes the upper 1 sigma limit in a control np-chart. NP-charts are applicable when proportions of defects are important, and where in each experimental subgroup the number of sample sizes is constant.

665. B2SixSigmaControlNPChartUp2Sigma

Computes the upper 2 sigma limit in a control np-chart. NP-charts are applicable when proportions of defects are important, and where in each experimental subgroup the number of sample sizes is constant.

666. B2SixSigmaControlPChartCL

Computes the center line in a control p-chart. P-charts are applicable when proportions of defects are important, and where in each experimental subgroup the number of sample sizes might be different.

667. B2SixSigmaControlPChartDown1Sigma

Computes the lower 1 sigma limit in a control p-chart. P-charts are applicable when proportions of defects are important, and where in each experimental subgroup the number of sample sizes might be different.

668. B2SixSigmaControlPChartDown2Sigma

Computes the lower 2 sigma limit in a control p-chart. P-charts are applicable when proportions of defects are important, and where in each experimental subgroup the number of sample sizes might be different.

669. B2SixSigmaControlPChartLCL

Computes the lower control limit in a control p-chart. P-charts are applicable when proportions of defects are important, and where in each experimental subgroup the number of sample sizes might be different.

670. B2SixSigmaControlPChartUCL

Computes the upper control limit in a control p-chart. P-charts are applicable when proportions of defects are important, and where in each experimental subgroup the number of sample sizes might be different.

671. B2SixSigmaControlPChartUp1Sigma

Computes the upper 1 sigma limit in a control p-chart. P-charts are applicable when proportions of defects are important, and where in each experimental subgroup the number of sample sizes might be different.

672. B2SixSigmaControlPChartUp2Sigma

Computes the upper 2 sigma limit in a control p-chart. P-charts are applicable when proportions of defects are important, and where in each experimental subgroup the number of sample sizes might be different.

673. B2SixSigmaControlRChartCL

Computes the center line in a control R-chart. R-charts are used when the number of defects is important; in each subgroup experiment multiple measurements are taken, and the range of the measurements is the variable plotted.

674. B2SixSigmaControlRChartLCL

Computes the lower control limit in a control R-chart. R-charts are used when the number of defects is important; in each subgroup experiment multiple measurements are taken, and the range of the measurements is the variable plotted.

675. B2SixSigmaControlRChartUCL

Computes the upper control limit in a control R-chart. R-charts are used when the number of defects is important; in each subgroup experiment multiple measurements are taken, and the range of the measurements is the variable plotted.

676. B2SixSigmaControlUChartCL

Computes the center line in a control u-chart. U-charts are applicable when the number of defects is important, and where in each experimental subgroup the number of sample sizes is the same.

677. B2SixSigmaControlUChartDown1Sigma

Computes the lower 1 sigma limit in a control u-chart. U-charts are applicable when the number of defects is important, and where in each experimental subgroup the number of sample sizes is the same.

678. B2SixSigmaControlUChartDown2Sigma

Computes the lower 2 sigma limit in a control u-chart. U-charts are applicable when the number of defects is important, and where in each experimental subgroup the number of sample sizes is the same.

679. B2SixSigmaControlUChartLCL

Computes the lower control limit in a control u-chart. U-charts are applicable when the number of defects is important, and where in each experimental subgroup the number of sample sizes is the same.

680. B2SixSigmaControlUChartUCL

Computes the upper control limit in a control u-chart. U-charts are applicable when the number of defects is important, and where in each experimental subgroup the number of sample sizes is the same.

681. B2SixSigmaControlUChartUp1Sigma

Computes the upper 1 sigma limit in a control u-chart. U-charts are applicable when the number of defects is important, and where in each experimental subgroup the number of sample sizes is the same.

682. B2SixSigmaControlUChartUp2Sigma

Computes the upper 2 sigma limit in a control u-chart. U-charts are applicable when the number of defects is important, and where in each experimental subgroup the number of sample sizes is the same.

683. B2SixSigmaControlXChartCL

Computes the center line in a control X-chart. X-charts are used when the number of defects is important; in each experimental subgroup multiple measurements are taken, and the average of the measurements is the variable plotted.

684. B2SixSigmaControlXChartLCL

Computes the lower control limit in a control X-chart. X-charts are used when the number of defects is important; in each experimental subgroup multiple measurements are taken, and the average of the measurements is the variable plotted.

685. B2SixSigmaControlXChartUCL

Computes the upper control limit in a control X-chart. X-charts are used when the number of defects is important; in each experimental subgroup multiple measurements are taken, and the average of the measurements is the variable plotted.

686. B2SixSigmaControlXMRChartCL

Computes the center line in a control XmR-chart. XmR-charts are used when the number of defects is important; there is only a single measurement for each sample, and a time series of moving ranges is the variable plotted.

687. B2SixSigmaControlXMRChartLCL

Computes the lower control limit in a control XmR-chart. XmR-charts are used when the number of defects is important; there is only a single measurement for each sample, and a time series of moving ranges is the variable plotted.

688. B2SixSigmaControlXMRChartUCL

Computes the upper control limit in a control XmR-chart. XmR-charts are used when the number of defects is important; there is only a single measurement for each sample, and a time series of moving ranges is the variable plotted.

689. B2SixSigmaDeltaPrecision

Computes the error precision given specific levels of Type I and Type II errors, as well as the sample size and variance.

690. B2SixSigmaSampleSize

Computes the required minimum sample size given Type I and Type II errors, as well as the required precision of the mean and the error tolerances.

691. B2SixSigmaSampleSizeDPU

Computes the required minimum sample size given Type I and Type II errors, as well as the required precision of the defects per unit and the error tolerances.

692. B2SixSigmaSampleSizeProportion

Computes the required minimum sample size given Type I and Type II errors, as well as the required precision of the proportion of defects and the error tolerances.

693. B2SixSigmaSampleSizeStdev

Computes the required minimum sample size given Type I and Type II errors, as well as the required precision of the standard deviation and the error tolerances.

694. B2SixSigmaSampleSizeZeroCorrelTest

Computes the required minimum sample size to test whether a correlation is statistically significant at an alpha of 0.05 and beta of 0.10.

695. B2SixSigmaStatCP

Computes the potential process capability index Cp given the actual mean and sigma of the process, including the upper and lower specification limits.

696. B2SixSigmaStatCPK

Computes the process capability index Cpk given the actual mean and sigma of the process, including the upper and lower specification limits.

697. B2SixSigmaStatDPMO

Computes the defects per million opportunities (DPMO) given the actual mean and sigma of the process, including the upper and lower specification limits.

698. B2SixSigmaStatDPU

Computes the proportion of defects per unit (DPU) given the actual mean and sigma of the process, including the upper and lower specification limits.

699. B2SixSigmaStatProcessSigma

Computes the process sigma level given the actual mean and sigma of the process, including the upper and lower specification limits.

700. B2SixSigmaStatYield

Computes the nondefective parts or the yield of the process, given the actual mean and sigma of the process, including the upper and lower specification limits.

701. B2SixSigmaUnitCPK

Computes the process capability index Cpk given the actual counts of defective parts and the total opportunities in the population.

702. B2SixSigmaUnitDPMO

Computes the defects per million opportunities (DPMO) given the actual counts of defective parts and the total opportunities in the population.

703. B2SixSigmaUnitDPU

Computes the proportion of defects per unit (DPU) given the actual counts of defective parts and the total opportunities in the population.

704. B2SixSigmaUnitProcessSigma

Computes the process sigma level given the actual counts of defective parts and the total opportunities in the population.

705. B2SixSigmaUnitYield

Computes the nondefective parts or the yield of the process given the actual counts of defective parts and the total opportunities in the population.

706. B2StandardNormalBivariateCDF

Given the two Z-scores and correlation, returns the value of the bivariate standard normal (means of zero, variances of 1) cumulative distribution function.

707. B2StandardNormalCDF

Given the Z-score, returns the value of the standard normal (mean of zero, variance of 1) cumulative distribution function.

708. B2StandardNormalInverseCDF

Computes the inverse cumulative distribution function of a standard normal distribution (mean of zero, variance of 1).

709. B2StandardNormalPDF

Given the Z-score, returns the value of the standard normal (mean of zero, variance of 1) probability density function.

710. B2StockAfterDilution1

Applies a search algorithm to impute the diluted stock price after a warrant issue by assuming that the total equity remains constant before and after the new issues.

711. B2StockAfterDilution2

Applies an approximation model computing the diluted stock price after a warrant issue by assuming that the total equity remains constant before and after the new issues.

712. B2StockIndexCallOption

Similar to a regular call option but the underlying asset is a reference stock index such as the Standard & Poor’s 500. The analysis can be solved using a Generalized Black-Scholes-Merton model as well.

713. B2StockIndexPutOption

Similar to a regular put option but the underlying asset is a reference stock index such as the Standard & Poor’s 500. The analysis can be solved using a Generalized Black-Scholes-Merton model as well.

714. B2SuperShareOptions

The option has value only if the stock or asset price is between the upper and lower barriers, and at expiration provides a payoff equivalent to the stock or asset price divided by the lower strike price (S/X Lower).

715. B2SwapDomesticValue

Computes the value of an interest rate swap to the domestic counterparty in a fixed-floating swap.

716. B2SwapDValues

Computes the series of cash payments of an interest rate swap to the domestic counterparty in a fixed-floating swap.

717. B2SwapForeignValue

Computes the value of an interest rate swap to the foreign counterparty in a fixed-floating swap.

718. B2SwapFValues

Computes the series of cash payments of an interest rate swap to the foreign counterparty in a fixed-floating swap.

719. B2SwapValue

Computes the total value of an interest rate swap between a domestic firm and a foreign counterparty in a fixed-floating swap.

720. B2SwaptionEuropeanPayer

European Call Interest Swaption.

721. B2SwaptionEuropeanReceiver

European Put Interest Swaption.

722. B2TakeoverFXOption

At a successful takeover (foreign firm value in foreign currency is less than the foreign currency units), option holder can purchase the foreign units at a predetermined strike price (in exchange rates of the domestic to foreign currency).

723. B2ThirdFriday

Computes the third Friday in the month for U.S. trading purposes.

724. B2ThirdFridayQuarter

Computes the third Friday in the quarter for U.S. trading purposes.

725. B2ThirdFridayYearly

Computes the third Friday in the year for U.S. trading purposes.

726. B2TimeSwitchOptionCall

Holder gets AccumAmount ´TimeSteps each time asset > strike for a call. TimeSteps is the frequency at which the asset price is checked as to whether the strike is breached (e.g., for 252 trading days, set DT as 1/252).

727. B2TimeSwitchOptionPut

Holder gets AccumAmount ´ TimeSteps each time asset < strike for a put. TimeSteps is the frequency at which the asset price is checked as to whether the strike is breached (e.g., for 252 trading days, set DT as 1/252).

728. B2TradingDayAdjustedCall

Call option corrected for varying volatilities (higher on trading days than on nontrading days). Trading Days Ratio is the number of trading days left until maturity divided by total trading days per year (between 250 and 252).

729. B2TradingDayAdjustedPut

Put option corrected for varying volatilities (higher on trading days than on nontrading days). Trading Days Ratio is the number of trading days left until maturity divided by total trading days per year (between 250 and 252).

730. B2TrinomialImpliedArrowDebreuLattice

Computes the complete set of implied Arrow-Debreu prices in an implied trinomial lattice using actual observed data. Copy and paste the function and use Ctrl+Shift+Enter to obtain the matrix.

731. B2TrinomialImpliedArrowDebreuValue

Computes the single value of implied Arrow-Debreu price (for a specific step/column and up-down event/row) in an implied trinomial lattice using actual observed data.

732. B2TrinomialImpliedCallOptionValue

Computes the European call option using an implied trinomial lattice approach, taking into account actual observed inputs.

733. B2TrinomialImpliedDownProbabilityLattice

Computes the complete set of implied DOWN probabilities in an implied trinomial lattice using actual observed data. Copy and paste the function and use Ctrl+Shift+Enter to obtain the matrix.

734. B2TrinomialImpliedDownProbabilityValue

Computes the single value of implied DOWN probability (for a specific step/column and up-down event/row) in an implied trinomial lattice using actual observed data.

735. B2TrinomialImpliedLocalVolatilityLattice

Computes the complete set of implied local probabilities in an implied trinomial lattice using actual observed data. Copy and paste the function and use Ctrl+Shift+Enter to obtain the matrix.

736. B2TrinomialImpliedLocalVolatilityValue

Computes the single value of implied localized volatility (for a specific step/column and up-down event/row) in an implied trinomial lattice using actual observed data.

737. B2TrinomialImpliedUpProbabilityLattice

Computes the complete set of implied UP probabilities in an implied trinomial lattice using actual observed data. Copy and paste the function and use Ctrl+Shift+Enter to obtain the matrix.

738. B2TrinomialImpliedUpProbabilityValue

Computes the single value of implied UP probability (for a specific step/column and up-down event/row) in an implied trinomial lattice using actual observed data.

739. B2TrinomialImpliedPutOptionValue

Computes the European put option using an implied trinomial lattice approach, taking into account actual observed inputs.

740. B2TwoAssetBarrierDownandInCall

Valuable or knocked in-the-money only if the lower barrier is breached (reference Asset 2 goes below the barrier), and the payout is in the option on Asset 1 less the strike price.

741. B2TwoAssetBarrierDownandInPut

Valuable or knocked in-the-money only if the lower barrier is breached (reference Asset 2 goes below the barrier), and the payout is in the option on the strike price less the Asset 1 value.

742. B2TwoAssetBarrierDownandOutCall

Valuable or stays in-the-money only if the lower barrier is not breached (reference Asset 2 does not go below the barrier), and the payout is in the option on Asset 1 less the strike price.

743. B2TwoAssetBarrierDownandOutPut

Valuable or stays in-the-money only if the lower barrier is not breached (reference Asset 2 does not go below the barrier), and the payout is in the option on the strike price less the Asset 1 value.

744. B2TwoAssetBarrierUpandInCall

Valuable or knocked in-the-money only if the upper barrier is breached (reference Asset 2 goes above the barrier), and the payout is in the option on Asset 1 less the strike price.

745. B2TwoAssetBarrierUpandInPut

Valuable or knocked in-the-money only if the upper barrier is breached (reference Asset 2 goes above the barrier), and the payout is in the option on the strike price less the Asset 1 value.

746. B2TwoAssetBarrierUpandOutCall

Valuable or stays in-the-money only if the upper barrier is not breached (reference Asset 2 does not go above the barrier), and the payout is in the option on Asset 1 less the strike price.

747. B2TwoAssetBarrierUpandOutPut

Valuable or stays in-the-money only if the upper barrier is not breached (reference Asset 2 does not go above the barrier), and the payout is in the option on the strike price less the Asset 1 value.

748. B2TwoAssetCashOrNothingCall

Pays cash at expiration as long as both assets are in-the-money. For call options, both asset values must be above their respective strike prices.

749. B2TwoAssetCashOrNothingDownUp

Cash will be paid only if at expiration the first asset is below the first strike, and the second asset is above the second strike.

750. B2TwoAssetCashOrNothingPut

Pays cash at expiration as long as both assets are in-the-money. For put options, both assets must be below their respective strike prices.

751. B2TwoAssetCashOrNothingUpDown

Cash will be paid only if the first asset is above the first strike price, and the second asset is below the second strike price at maturity.

752. B2TwoAssetCorrelationCall

Asset 1 is the benchmark asset, whereby if at expiration Asset 1’s value exceeds Strike 1’s value, then the call option is knocked in-the-money, and the payoff on the option is Asset 2 – Strike 2; otherwise the option becomes worthless.

753. B2TwoAssetCorrelationPut

Asset 1 is the benchmark asset, whereby if at expiration Asset 1’s value is below Strike 1’s value, then the put option is knocked in-the-money, and the payoff on the option is Strike 2 – Asset 2; otherwise the option becomes worthless.

754. B2VaRCorrelationMethod

Computes the Value at Risk using the Variance-Covariance and Correlation method, accounting for a specific VaR percentile and holding period.

755. RB2VaROptions

Computes the Value at Risk of a portfolio of correlated options.

756. B2Volatility

Returns the Annualized Volatility of time-series cash flows. Enter in the number of periods in a cycle to annualize the volatility (1 = annual, 4 = quarterly, 12 = monthly data).

757. B2VolatilityImpliedforDefaultRisk

Used only when computing the implied volatility required for optimizing an option model to compute the probability of default.

758. B2WarrantsDilutedValue

Returns the value of a warrant (like an option) that is convertible to stock while accounting for dilution effects based on the number of shares and warrants outstanding.

759. B2WriterExtendibleCallOption

The call option is extended beyond the initial maturity to an extended date with a new extended strike if at maturity the option is out of the money, providing a safety net of time for the option holder.

760. B2WriterExtendiblePutOption

The put option is extended beyond the initial maturity to an extended date with a new extended strike if at maturity the option is out of the money, providing a safety net of time for the option holder.

761. B2YieldCurveBIM

Returns the Yield Curve at various points in time using the Bliss model.

762. B2YieldCurveNS

Returns the Yield Curve at various points in time using the Nelson-Siegel approach.

763. B2ZEOB

Returns the Economic Order Batch or the optimal quantity to be manufactured on each production batch.

764. B2ZEOBBatch

Returns the Economic Order Batch analysis’ optimal number of batches to be manufactured per year.

765. B2ZEOBHoldingCost

Returns the Economic Order Batch analysis’ cost of holding excess units per year if manufactured at the optimal level.

766. B2ZEOBProductionCost

Returns the Economic Order Batch analysis’ total cost of setting up production per year if manufactured at the optimal level.

767. B2ZEOBTotalCost

Returns the Economic Order Batch analysis’ total cost of production and holding costs per year if manufactured at the optimal level.

768. B2ZEOQ

Economic Order Quantity’s order size on each order.

769. B2ZEOQExcess

Economic Order Quantity’s excess safety stock level.

770. B2ZEOQOrders

Economic Order Quantity’s number of orders per year.

771. B2ZEOQProbability

Economic Order Quantity’s probability of out of stock.

772. B2ZEOQReorderPoint

Economic Order Quantity’s reorder point.

The following lists the statistical and analytical tools in the Modeling Toolkit:

773. Statistical Tool: Chi-Square Goodness of Fit Test

774. Statistical Tool: Chi-Square Independence Test

775. Statistical Tool: Chi-Square Population Variance Test

776. Statistical Tool: Dependent Means (T)

777. Statistical Tool: Friedman’s Test

778. Statistical Tool: Independent and Equal Variances (T)

779. Statistical Tool: Independent and Unequal Variances (T)

780. Statistical Tool: Independent Means (Z)

781. Statistical Tool: Independent Proportions (Z)

782. Statistical Tool: Independent Variances (F)

783. Statistical Tool: Kruskal-Wallis Test

784. Statistical Tool: Lilliefors Test

785. Statistical Tool: Principal Component Analysis

786. Statistical Tool: Randomized Block Multiple Treatments

787. Statistical Tool: Runs Test

788. Statistical Tool: Single Factor Multiple Treatments

789. Statistical Tool: Testing Means (T)

790. Statistical Tool: Testing Means (Z)

791. Statistical Tool: Testing Proportions (Z)

792. Statistical Tool: Two-Way ANOVA

793. Statistical Tool: Variance-Covariance Matrix

794. Statistical Tool: Wilcoxon Signed-Rank Test (One Variable)

795. Statistical Tool: Wilcoxon Signed-Rank Test (Two Variables)

796. Valuation Tool: Lattice Maker for Debt

797. Valuation Tool: Lattice Maker for Yield

The following lists Risk Simulator tools/applications that are used in the Modeling Toolkit:

798. Monte Carlo Simulation Using 25 Statistical Distributions

799. Monte Carlo Simulation: Simulations with Correlations

800. Monte Carlo Simulation: Simulations with Precision Control

801. Monte Carlo Simulation: Simulations with Truncation

802. Stochastic Forecasting: Box-Jenkins ARIMA

803. Stochastic Forecasting: Maximum Likelihood

804. Stochastic Forecasting: Nonlinear Extrapolation

805. Stochastic Forecasting: Regression Analysis

806. Stochastic Forecasting: Stochastic Processes

807. Stochastic Forecasting: Time-Series Analysis

808. Portfolio Optimization: Discrete Binary Decision Variables

809. Portfolio Optimization: Discrete and Continuous Decision Variables

810. Portfolio Optimization: Discrete Decision Variables

811. Portfolio Optimization: Static Optimization

812. Portfolio Optimization: Dynamic Optimization

813. Portfolio Optimization: Stochastic Optimization

814. Simulation Tools: Bootstrap Simulation

815. Simulation Tools: Custom Historical Simulation

816. Simulation Tools: Data Diagnostics

817. Simulation Tools: Distributional Analysis

818. Simulation Tools: Multiple Correlated Data Fitting

819. Simulation Tools: Scenario Analysis

820. Simulation Tools: Sensitivity Analysis

821. Simulation Tools: Single Data Fitting

822. Simulation Tools: Statistical Analysis

823. Simulation Tools: Tornado Analysis

The following lists Real Options SLS tools/applications that are used in the Modeling Toolkit:

824. Audit Sheet Functions

825. Changing Volatility and Risk-Free Rates Model

826. Lattice Maker

827. SLS Single Asset and Single Phase: American Options

828. SLS Single Asset and Single Phase: Bermudan Options

829. SLS Single Asset and Single Phase: Customized Options

830. SLS Single Asset and Single Phase: European Options

831. SLS Multiple Asset and Multiple Phases

832. SLS Multinomial Lattices: Pentanomials

833. SLS Multinomial Lattices: Quadranomials

834. SLS Multinomial Lattices: Trinomials

835. SLS Multinomial Lattices: Trinomials Mean-Reversion