Free Finance Excel Addins

Finance XL
Math XL
Support Forum
About CBD
Contact us




Financial XL Categories

Options and Futures

Offers quantitative and risk management techniques for a wide range of option and futures contracts. We apply the Black-Scholes-Merton Options pricing model to European, Asian, American, Lookback, Bermuda and Binary Options using Analytic, Monte Carlo and Finite Difference techniques. Models of implied and historical volatility along with futures account management and market risk monitoring are also included.

More Information

Example Workbooks

Function Docs


Portfolio

Apply the Markowitz and Capital Asset Pricing Model to analyze the construction and qualitative nature of a portfolios risk-return characteristics. Including covariance and correlation, expectation and risk, Efficient frontier, Indifference curves, Capital Market Line, systematic and unsystematic risk, characteristic line, alpha and beta coefficients, security market line and risk adjusted performance measures.

More Information

Example Workbooks

Function Docs


Bonds

Model the pricing and risk analytics of interest rate cash and derivative products. We cover the fundamental theory of bonds including: Treasury bonds, Yield/Pricing, Zero Curve, Forward rates/FRAs, Duration and Convexity. We also cover the topics of Fixed-Interest bonds and interest based calculations.

More Information

Example Workbooks

Function Docs


Technical Analysis

Provides technical indicators including moving averages, (average) directional movement indicator (DMI, ADX), Accumulation/Distribution, Chaikin (Oscillator, Money Flow), Aroon (Up/Down, Oscillator), Balance of Power (BOP), Oscillators (Money Flow Index, Momentum, Rate of Change), Bollinger Bands, Commodity Channel Index.

More Information

Example Workbooks

Function Docs


Equities, Interest and Real Estate

Non-stochastic methods are used to evaluate and analyze investments of equity, interest and real estate type. In particular, methods are developed for calculating the accumulated value, present value and yield of an interest bearing investment. For equity and real estate investments we cover models of discounted future cash flows and investment ratio comparison methods including the topics of dividends (real and prospective), yield gap, PE ratio, stock splits, rental yield and rental growth.

More Information

Example Workbooks

Function Docs





© 1999-2008 WebCab Components. All rights reserved.