FinTools® Software Montgomery Investment Technology, Inc. Financial Modeling Software and Consulting
OPTIONS XL EXOTICS XL BONDS XL UTILITY XL RISK XL QuoteTools SigTools Option Tracker Financial Calculators OptionsCalc ExoticsCalc BondsCalc VolatilityCalc CONTENTS What is FinTools®? MITI Mission
What is FinTools® ? • Spreadsheet and Database “Add-In” Programs • Financial Function Libraries for Developers for Options, Exotics, and Bonds Pricing, and Risk Management • Statistical tools for analyzing historical price distributions
Customer Benefits • Cost effective and market tested financial modeling software • Meets the needs of financial institutions, traders and corporations in today’s changing markets • Pricing and risk management functionality • Expert product support • Corporate License discounts
FinTools® Modules • Option, Exotic, and Bond Pricing Models for you Spreadsheet, Database or Application: • OPTIONS XL • EXOTICS XL • BONDS XL • UTILITY XL • RISK XL
“ What-If ” Scenario Analysis OPTIONS XL • Premium Series • Flexible Binomial • Eurodollar Options • Custom Models • Real Options OPTIONS XL
OPTIONS XL Premium • Black-Scholes • Modified Black-Scholes • B-S Pseudo-American • Black (futures) • Garman-Kohlhagen (FX) • French • Eurodollar Options • Binomial • Jump-Diffusion, CEV, Lines (custom)
OPTIONS XL Flexible Binomial OPTIONS XL Flexible Binomial Series allows: • Flexible input of key option variables • Stepped strikes, changes in yield over time • Discrete cash flows, multiple interest rates, repo rate • Hybrid ("Bermuda" style early exercise) • American and European style options
Average Barrier Binary Chooser Compound Currency-Translated Lookback Portfolio Rainbow Spread EXOTICS XL
Theoretical Value and sensitivities of European style Average Price / Rate options using a closed form geometric average model. Monte Carlo method for time frequency adjustments Theoretical Value and sensitivities of European style Average Price/Rate options using a closed form arithmetic average model. Monte Carlo method for time frequency adjustments EXOTICS XL Average
EXOTICS XL Barrier • Allows you to calculate the theoretical value, delta, gamma, theta, vega, implied volatility and intrinsic value of European style “Knockout” and “Knockin” options using a closed form approach. • Binomial method for American-style and Double Barrier options. • Monte Carlo method for time frequency
EXOTICS XL Binary • Allows you to calculate the theoretical value and sensitivities of more than 25 European style “Binary” options using a closed form approach.
EXOTICS XL Chooser • Allows you to calculate the theoretical value and sensitivities of European style options using a closed form approach.
EXOTICS XL Compound • Allows you to calculate the theoretical value, delta, gamma, theta, vega and implied volatility of European style Compound options on options using a closed form approach.
EXOTICS XL Lookback • Allows you to calculate the theoretical value, delta, gamma, theta, vega and implied volatility of European style Lookback call and put options using a closed form approach. • Monte Carlo method for time frequency
EXOTICS XL Rainbow • Allows you to calculate the theoretical value and sensitivities of European style options using the Rainbow model.
Allows you to calculate the theoretical value of European style Futures Spread options using a “Black-Scholes approach”. Allows you to calculate the theoretical value of European style spread options using the “Quasi-Binomial approach” and a “Binomial-tree approach”. EXOTICS XL Spread
BONDS XL • SIA Standard • International Day Count • Money Market • Bonds Futures • Stepped Coupon • SIA and MSRB Compliant • Bloomberg Compatible
BONDS XL US Standard • Provides all the standard calculations for: • US Treasuries • US Agencies • US Corporate • US Municipals • Includes calculations for bonds that are callable at a premium, and odd-first coupon bonds
BONDS XL International • Adds international bond day count calculations: • Actual/Actual • 30e/360 • Actual/365 • Various coupons frequencies and compounding frequencies may be specified.
BONDS XL US Bond Futures • US Bond Futures calculations: • Conversion factor • Basis price • Break-even rate • Net carry
BONDS XL Money Market • Bills and Eurodollar • Act/360, discounted securities • CDs • Interest at maturity securities
BONDS XL Stepped Coupon • Multiple coupons over the life of the bonds • Example: Zero coupon for 5 years, then 7% coupon for remaining life • Total rate of return calculations
UTILITY XL • Montgomery Investment Technology offers UTILITY XL which is designed to be used in conjunction with OPTIONS XL, EXOTICS XL, and BONDS XL. • UTILITY is updated frequently as new functions are added.
UTILITY XL • Historical Volatility • Advanced Price Distribution Statistics • Forex Calculations • Futures Basis • PV of Dividend Flows • Option Symbol Creator and Translator • Option Expiry Dates UTILITY XL • Option Expiry Dates • Forex Calculations • Futures Basis • Options Symbol Creator and Translator • Historical Volatility • Advanced Statistics FinTools for Excel
RISK XL • Calculates Value at Risk for a portfolio consisting of: • Equities • Foreign Exchange (FX) • Futures
QuoteTools • Microsoft Excel add-in • Automatically imports and formats CBOE option and LEAP data into Excel
SigTools • Provides macros to automatically generate Signal DDE links within spreadsheet • DDE- Dynamic Data Exchange -allows to link real-time, delayed, or end-of-the-day financial data into Excel spreadsheet
Option Tracker For ESOs • Software package to track and value employee stock option plans • Enables grants to be valued in the same database that stores employee and grant information • Easy 2- Step Process- Administration and Valuation
Option Tracker: Administration • Employees, Grants, Transactions, and Reports
Option Tracker: Valuation • Volatility, Dividends, Interest Rates and Valuation
OptionsCalc • An Options calculator that uses Black-Scholes, Whaley, Binomial, and Flexible Binomial Models • Includes theoretical value, risk sensitivities, implied volatility and charts