Posted inFinance Understanding Option Delta in Excel Option’s delta is a measure of how much the price of an option changes when…
Posted inFinance Financial Flexibility with Synthetic Forwards in Excel A synthetic forward contract is a way of creating a position that is equivalent to…
Posted inFinance Creating a Risk-Free Portfolio in Excel A risk-free portfolio is a portfolio that has no risk of losing money, regardless of…
Posted inFinance Binomial Trees Option Pricing in Excel The binomial option pricing model is a way of finding the fair value of an…
Posted inFinance Understanding the Black-Scholes Option-Pricing Formula in Excel for Non-Dividend-Paying Assets The Black-Scholes option-pricing formula is a mathematical model that calculates the fair value of a…
Posted inFinance Understanding the Black-Scholes Pricing Model for Options in Microsoft Excel The Black–Scholes pricing model is a mathematical method to calculate the fair value of European-style…
Posted inFinance Understanding Probability Distribution in Options Using Excel Formulas Probability distribution in options is a way of describing the likelihood of different outcomes for…
Posted inFinance Understanding Probability Density in Options Using Excel Probability density in options is a way of measuring how likely the price of an…
Posted inFinance Understanding Arithmetic Mean and Standard Deviation in Options Using Excel In options trading, arithmetic mean and standard deviation are used to estimate the future price…
Posted inFinance Understanding Currency Swaps in Excel A currency swap is a financial contract between two parties to exchange a specific amount…