RETURNS & STATISTICS

• Portfolio Expected Return
• Simple & Continuous Returns
• Effective Annual Interest Rate (EAR)
• Effective Rate Return
• Expected Return Rate (ERR)
• Annualized Return Rate (ARR)
• Monthly Return Rate (MRR)
• Holding Period Return
• Z-score & NormalProbability
• Find Arithmetic Mean
• Find Geometric & Harmonic Mean
• Find Weighted Average
• Arithmetic and Geometric Returns
• Expected Return (Var Idiosyncratic)

PORTFOLIO MANAGEMENT

• Portfolio Expected Return
• Portfolio Expected Return : $-Amounts
• Portfolio Expected Return : #Shares & Prices
• Portfolio Expected Return 2 Economy States
• Portfolio Expected Risk 2 Economy States
• Portfolio Expected Return 3 Economy States
• Portfolio Risk: 2 Assets
• Portfolio Risk: 2 Assets with Weights
• 2 Assets Portfolio Analysis
• Portfolio Risk: 3 Assets
• Simplified Portfolio Variance and StDev
• Portfolio Beta
• Correlation Coefficient of 2 Assets
• Covariance of 2 Assets
• Weighted Average

PORTFOLIO MANAGEMENT

• 2-Asset All-in-One Analysis
• 2-Asset All-in-one Analysis (w. Weights)
• Internal Rate of Return (IRR)
• Internal Rate of Return (uniform)
• Modified Internal Rate of Return (MIRR)
• Money Weighted Return (Dietz)
• Capital Market Line (CML)
• Security Market Line (SML)

PORTFOLIO RISK MANAGEMENT

• Sharpe Ratio
• Treynor Measure Ratio
• Beta (Sharpe/Treynor)
• Sortino Ratio
• Jensen’s Alpha
• Appraisal Ratio
• Information Ratio
• Graham & Harvey
• Value at Risk (Var)
• M Squared Measure
• M Squared Measure 2
• R Squared Measure
• R Squared Measure 2
• CAPM

DERIVATIVES and SWAP

• Black Scholes (Equities)
• Black Scholes (Futures)
• Black Scholes (Currencies)
• Black Scholes (Equities 1-time Div)
• Black Scholes : Find GREEKS (steps)
• Black Scholes : Find GREEKS (Equities)
• Black Scholes : Find GREEKS (Futures)
• Black Scholes : Find GREEKS (Currencies)
• Put-Call Parity with Dividends
• Put-Call Parity without Dividends
• Delta Hedge (Neutral)
• Solver (Call Price
• Solver (No Arbitrage)
• Binomial Option Pricing Model
• Binomial Option (2 tree)
• Binomial Factor u/d (continuous)
• Binomial Factor u/d (Factor)
• Binomial Factor u/d (Factor 2)
• Correlation Coefficient of 2 Assets
• Covariance of 2 Assets
• Capital Increase
• Residual Income Model (2 Stages ROE and RIM)
• Miller Orr Model
• SWAP (Discount Factor)

EQUITITES & FUTURES

• Total Market Value
• Value of Preferred Stock V = D / i
• Gordon Growth Model Po = D / (k-g)
• Constant Growth Model Shapiro (EPS)
• Gordon Shapiro Model EPS + ROE
• Dividend Discount Model (DDM)
• Multiple Growth Model (Div in %)
• Multiple Growth Model (Div in $)
• Multiple Growth Model (Div in $
• EPS1 = EPS0*(1+g)
• DIV1 = DIV0*(1+g)
• Market Value of Equity
• Dividend Payout Ratio = DIV / NI
• Dividend Retention Ratio = 1 – DIV/NI
• Moving Average
• Stock : Expected Return
• Expected Return using Weights
• Stock Risk
• Stock Risk using Weights
• Stock Beta
• Stock Beta using Correlation
• Stock Alpha
• Futures (Conversion Factor)
• Forward Exchange Rates
• Equity Futures (Original)
• Index Futures (Original)
• Commodity Futures (Original)
• Commodity Futures 1
• Commodity Futures 2
• Bond Futures (Hedge)
• Beta Unlevered

TIME VALUE OF MONEY

• Simple Interest A=p*i*n
• Future Value fv=pv*(1+r)^t
• Present Value pv=fv/(1+r)^t
• Compounded Interest fv=p*e^(r*t)
• Future Value (continuous) fv=pv*e^(r*t)
• Present Value (continuous) pv=fv/e^(r*t)
• Present Value of Dividends
• Present Value Pay-Out (Forever)
• Future Value of Annuity
• Present Value of Annuity (PVIFA)
• Future Value Interest Factor Annuity (FVIFAD)
• Equivalent Annual Annuity (EAA)
• Profitability Index (PI)
• Net Present Value : Even Cash Flow
• Net Present Value : Even Cash Flow (1.yr)
• Net Present Value : Even except last year
• Net Present Value : Uneven Cash Flow
• DCF Valuation

FIXED INCOME 1

• Current Yield Y = I*F / P
• Bond Price All-In-1
• Bond Yields All-in-1: YTM
• Bond Price Change (Mdur&Conv)
• Bond Price Change (Dur&Conv)
• Bond: Dirty vs Clean Price
• Accrued Interest
• Bond Price (Spot Curve)
• Bond Price (Spot Rate)
• Bond Rate (Forward Rate 1Y Implicit)
• Bond Rate (2-Yr Spot Rate)
• Bond Price Replicating Zero Coupon
• Dispersion Cash Flow
• Bond Solver (Dur)
• Bond Solver (Price Change %)
• Bond Solver (Price Change $)
• Bond Duration (Macaulay)
• Bond Duration (Macaulay
• Modified Duration (Macaulay)
• Modified Duration (Macaulay
• Bond Solver (Convexity)
• Convexity given Chg Bond Price
• Key Rate Duration
• Compounded Annual Return of Coupon Bond
• Expected Return of Defaulted Bond

FIXED INCOME 2

• Zero-Coupon Analyzer: YTM
• Zero-Coupon (Price)
• Zero-Coupon (YTM)
• Zero-Coupon (Convexity)
• Zero-Coupon (Spot Rate)
• Valuation of Zero Coupon Bonds
• Valuation of Coupon Bearing Bonds
• Estimated Yield to Call
• Estimated Yield to Put
• Convertible Bonds
• Convertible Bonds (CS)
• Floating Rate Note
• Floating Rate Note (find DM)
• Perpetual Bonds
• Portfolio YTM Approx (Mdur)
• Warrants
• Sinking Fund Price
• Time Horizon (Duration)
• Stress Test (Delta Surplus)

ACCOUNTING RATIOS

• PE Ratio
• Current Ratio = CA / CL
• Quick Ratio = (CA-INV) / CL
• Average Collection Period = AR / CS
• AR Turnover = Sales / AR
• Inventory Turnover = Cogs / Inventory
• Total Asset Turnover = Sales / Total Assets
• Fixed Asset Turnover = Sales / Fixed Assets
• OI-ROI = OI / Assets
• Debt Ratio = Total Debt / Total Assets
• ROA: Return on Assets = Net Income / Total Assets
• ROE: Return on Equity = Net Income / Equity
• ROE Growth Rate = ROE * (1-b)
• Times Interest Earned = EBIT / Interest Expense
• Operating Margin = Operating Income/Net Sales
• Net Margin Ratio = Net Income/Net Sales
• Gross Margin Ratio = Gross Margin/Net Sales
• Book Value = Cost – Accum. Depreciation
• Straight Line Depreciation
• Tax Effect = (MV-BV)*Tax Rate
• Leverage Multiplier = Total Assets/Equity
• 3 Step DuPond ROE
• Amortized Loan Payment R=Pi/(1-(1+i)^-n)
• Loan Solver
• Leasing
• Net Initial Investment (NINV)
• Cash Roce/NWC
• ROE: Return on Equity (ROA)

CORPORATE FINANCE

• Weighted Cost of Capital (WACC)
• WACC (Implicit)
• WACC (Implicit 2)
• CAPM Market Return
• CAPM Find Risk Premium
• Fama French : Find Market Risk Premium
• CAPM Risk Premium
• CAPM Risk Premium Return
• Modigaliani Miller
• Zero Growth Model
• Constant Growth Model
• Earnings Price Ratio Approach
• Gordon Shapiro Model EPS
• Gordon Shapiro Model ROE
• Approximation (Kd)
• Cost of Debt after Taxes (Kd)
• Cost of Debt after Taxes (Kd) %
• Market Value Firm
• Firm Value
• Net Operating Cash Flows (NOCF)
• Payback Period [in yrs]
• Payback Period uneven Cash Flow
• Discounted Payback Period [in yrs]
• Build Up Method
• Cash Conversion Cycle
• Conversion Cycle

ALM Hedge

• CPPI (Hedge)
• Constant Mix Strategy (Hedge)
• Protective Put Strategy (Hedge)
• Equivalent Drop Benchmark (Hedge)
• Cheapest to Deliver (Hedge)
• Target Duration (Hedge)
• ALM (Annuity Factor)
• ALM (Surplus)
• ALM (Funding Ratio)
• ALM (Surplus Return)
• ALM (Surplus Risk)
• ALM (Surplus Risk Bank – Interest Change)
• ALM (Value Pension Liabilities)
• Domestic/Foreign Return (Internat.)
• Variance Return Domestic (Internat.)
• Money Market Hedge (Internat)

ECONOMIC CALCULATIONS

• Marginal Profit
• Marginal Revenue
• Break Even Point R=C
• Continuous Income Stream
• Consumer Surplus
• Producer Surplus
• Cobb-Douglas Prod.
• Gini Coefficient
• Differentials
• deltay=f'(x)*deltax
• Logistic Differential Equation
• Simplex Algorithm
• Average Tax Rate
• Marginal Tax Rate
• Price Index
• Real GDP – Expenditure Approach
• Real GDP – Income Approach
• GDP Solver: Deflator
• Compute any Rate [%] : Labor
• Nominal & Real Interest Rate
• Unemployment Rate
• Real Interest Rate
• Inflation Rate

SMOOTHING & REGRESSION

• Simple Exponential Smoothing
• Exponential Smoothing/Forecasting (Seed)
• Find Regression Line y=mx+b
• Find Regression Line y=mx+b Step by Step
• Find Regression Line y=a+bx
• Find Median-Median Line y=mx+b
• Find Quadratic Regression y=ax^2+bx+c
• Find Cubic Regression y=ax^3+bx^2+cx+d
• Quartic Regression y=ax^4+bx^3+cx^2+dx+e
• Find Power Regression y=a*b^x
• Find Exponential Regression y=a*x^b
• Find Logarithmic Regression y=a+b*ln(x)
• Find Sinusoidal Regression y=a*sin(bx+c)+d
• Logistic Regression y=c*e^(bx)/(e^(bx)+a)

HELP & ABOUT & READS % EXTRAS

• Help & Use of Keys
• What to Input
• About us
• Set FontSize
• Value a Company (Replacement Cost)
• Value a Company (Discounted Cash Flow)
• About Stocks/Equity
• Options Formulas
• Financial Definitions
• Business Types
• More about Bonds
• Assets
• Liabilities
• Shareholders Equity
• Income Statements
• Cash Flow
• Inventory
• Percent of Sales Method
• All about Linear Regression
• Correlation is not Causation!
• Arbitrage Profit
• Put Call Parity: Find Stock Price
• Forward Price: Find Stock Price
• Put Call Parity: Find Exercise Price
• Price to receive Margin Call
• ROI on Margin Trade
• Holding Period Return
• New Financial Security (Binomial Pricing)

HELP & ABOUT

• Help & Use of Keys
• What to Input
• About us