formulas

A few common Excel Formula Errors: 1) ###### - The column is not wide enough to display data (for numbers). Date or time may be negative. 2) #VALUE! - Occurs when the wrong type of argument is used in a function or formula. For example, there is text in a formula that requires a number or...

SHORT CONDOR Sell One + Buy One + Buy One + Sell One = Credit received RISK COLLAR / FENCE (RISK CONVERSION) Long Underlying Security = Purchasing OTM Put + Selling the OTM call RISK COLLAR / FENCE (RISK REVERSAL) Short Underlying Security = Purchasing OTM Call + Selling the OTM Put

LONG IRON BUTTERFLY Sell ATM Straddle – Buy OTM Strangle = Receive a credit SHORT IRON BUTTERFLY Buy ATM Straddle – Sell OTM Strangle = Total Debit LONG CONDOR Buy One + Sell One + Sell One + Buy One = Total Debit paid

SHORT STRANGLE OTM Put Strike Price – (OTM Call Price + OTM Put Price) = Low Break-even Point OTM Call Strike Price + (OTM Call Price + OTM Put Price) = High Break-even Point LONG BUTTERFLY Buy One + Sell Two + Buy One = Total Debit SHORT BUTTERFLY Sell One + Buy Two + Sell One = Total Credit

SHORT STRADDLE Strike Price – (Call Price + Put Price) = Low Break-even Point Strike Price + (Call Price + Put Price) = High Break-even Point LONG STRANGLE OTM Put Strike Price – (OTM Call Price + OTM Put Price) = Low Break-even Point OTM Call Strike Price + (OTM Call Price + OTM Put...

RATIO BEAR SPREAD (SHORT) A long put spread plus a short OTM put LONG STRADDLE Strike Price – (Call Price + Put Price) = Low Break-even Point Strike Price + (Call Price + Put Price) = High Break-even Point

RATIO BULL SPREAD (LONG) A short call spread plus a long OTM call RATIO BULL SPREAD (SHORT) A long call spread plus a short OTM call RATIO BEAR SPREAD (LONG) A short put spread plus a long OTM put

*MARRIED PUT (Stock Price – Strike Price) + Put Price = Maximum Loss *PROTECTING UNREALIZED PROFIT (Strike Price – Put Price) – Initial Stock Purchase = Unrealized Profit *COVERED CALL POTENTIAL (Call Price + Strike Price) – Stock Price = Covered Call Potential * BULL SPREAD (LONG CALL...

Formulas C Tables Glossary of Finance for mba

04/10/2002 ------------- THEORY OF EQUATIONS: ----------------------------- (1) If an equation (i:e f(x)=0 ) contains all positive co-efficients of any powers of x , it has no positive roots then. eg: x^4+3x^2+2x+6=0 has no positive roots . (2) For an equation , if all the even powers of...

Area Of the Triangle The Area of the triangle as Follows, = 1/2 Base X Height = (abc) / 4R = rS = = 1/2 a b Sin c S = (a+b+c) / 2 Cos C = (a2 +b2 - c2) / 2ab _________________

In his famous book, "For God, Country & Coca-Cola: The Definitive History of the World's Most popular soft drink," a Harvard graduate and investigative journalist, Mark Pendergrast, has come up with 30 business lessons based on the experience of the magical soft drink. We have tried to bring it...