Option Premium

Option Premium

The option premium is described in this article and calculated by the Options Profit Calculator with MarketXLS. Option premium depends on different variables, which are listed in detail. This article will discuss how to calculate the option premium of your portfolio. Contents What is Option Premium? Impact of Option Greeks on Option Premium Pricing Option …

Read moreOption Premium

Credit Spread Vs Debit Spread

Credit Spread Vs Debit Spread

Credit Spread Vs Debit Spread are the strategies used in options; it is a defined-risk strategy that lets you make bullish or bearish speculative trades. Investors looking to make the best returns in today’s market can opt for a better trade options strategy. Let’s understand which is the better strategy credit spread or debit spread. …

Read moreCredit Spread Vs Debit Spread

Wealth Index using Excel

The Wealth Index of portfolio with MarketXLS calculates the highest rate of return for the investment. The MarketXLS add-in enables it to apply to either financial instrument or business portfolios. The wealth index is a popular function to evaluate the investment and to calculate the returns. What is Wealth Index The wealth index is a …

Read moreWealth Index using Excel

Portfolio Optimization

Portfolio Optimisation

The Portfolio Optimization with MarketXLS calculates the optimal capital weightings for a basket of investments that gives the highest return for the least risk. The MarketXLS add-in enables it to be applied to either financial instrument or business portfolios. The ability to apply optimization analysis to a portfolio represents an excellent framework for driving capital …

Read morePortfolio Optimization

Monte Carlo Simulation Excel

Monte Carlo Simulation

Monte Carlo Simulation Excel is an excellent tool for investors when assessing the potential risks associated with the portfolio and asset allocation. This article will discuss what it is, how it is works, how MarketXLS add-in calculates Monte Carlo simulation of your portfolio. The Monte Carlo approach is a computer-based method that uses statistical sampling …

Read moreMonte Carlo Simulation Excel

Value-at-risk VaR using Excel (with MarketXLS)

VaR

Value-at-risk using Excel  is one of the most important financial tools that help an investor measure the  risk of an investment portfolio. This article will discuss what it is, how it is then calculated, how MarketXLS calculates Value-at-risk of your Portfolio. Value-at-risk is a statistical measure of the riskiness of portfolios of assets. It quantifies …

Read moreValue-at-risk VaR using Excel (with MarketXLS)

Efficient Frontier using Excel (with MarketXLS)

Efficient Frontier

The Efficient frontier using excel is one of the most important financial tools that help an investor compose an investment portfolio with the maximum returns and minimum amount of risk. This article will discuss what it is, how it is then calculated, and how MarketXLS calculates it of your Portfolio. Contents: What is Efficient frontier …

Read moreEfficient Frontier using Excel (with MarketXLS)

Binomial Option Pricing Model Excel

Binomial Option Model

The Binomial Option Pricing Model Excel is available as a template with MarketXLS. The Binomial Option Pricing Model is a popular model for stock options evaluation, and to calculate the options premium. The Binomial Options Pricing Model provides investors with a tool to help evaluate stock options. The model uses multiple periods to value the …

Read moreBinomial Option Pricing Model Excel

Dividend Growth Investing

Dividend growth investing has long been the strategy of choice for both new and seasoned investors. Instead of relying on fluctuating share prices and unstable markets to hopefully make a profit, dividend stocks provide a steady, reliable income. Generated by a portfolio of shares in companies with a track record of paying consistent and increasing …

Read moreDividend Growth Investing