Determines the 5 C's, credit worthiness, and estimated valuation of any small or mid-sized business using Activity, Debt, Liquidity, and Profitability ratio analysis.
Black-Scholes is a popular method for calculating option prices. This version includes the expected dividend yield.
Calculates corporate and municipal bond investments based on $100, $1,000 or $10,000 par values. Computations include yield, price and accrued interest.
Performs cap table math, including post-money valuation, ownership percentages, and employee pool calculations.
Finds the Capital Asset Pricing Model's required rate of return on an investment.
Calculates compound interest problems where payments are not the same from period to period. Computations include net present value (NPV), net future value (NFV), standard and modified internal rate of return (IRR and MIRR), net uniform series (NUS), profitability index and payback.
Calculates compound and simple interest problems assuming lump sum payments at the end of a loan or investment. Also calculates the effective interest rate.
Calculates the value of a good or service in current or nominal rates based on the annual Canadian consumer price index (CPI).
Calculates the value of a good or service in current or nominal rates based on the annual US consumer price index (CPI).
Continuous Time Value of Money (TVM) assumes payment periods per year and interest compounding per year is continuous.
Calculates covered call options, which is an options strategy whereby an investor holds a long position in an asset and writes (sells) call options on that same asset in an attempt to generate increased income.
Convert between common currencies, determining exchange rates and currency amounts.
Uses future free cash flow projections and discounts them using the weighted average cost of capital (WACC) or CAPM to arrive at a present value.
Values the price of a stock by discounting expected dividends to the present value.
Converts nominal (or stated) interest rates into Effective Interest Rates by giving consideration to the impact of prepaid interest in the form of points, and deferred interest in the form of prepayment penalties.
Fix an exchange rate manually so you know what it's really costing based on the exchange rate you changed your cash at.
Analyze key financial statement ratios such as current ratio, quick ratio, free cash flow and more.
Converts market price of gold per Troy Ounce into a price per kilogram of gold.
Gordon's growth model is a way of measuring the market's perceived riskiness of a given stock.
Models the impact of transfer restrictions on stock prices per Dr. John Finnerty at Fordham University.
Because prices increase over time, an amount of money can buy more today than it can tomorrow. This template considers the effects of inflation on an amount of money.
Given three of the four, calculates simple interest rate, principle, earnings, or duration.
Estimates the return of an investment given sell and buy values and dividends. Calculates both a total and annual return. Also displays the actual return, with other expenses and taxes taken into consideration.
Calculates the future value of either a taxable or non-taxable Individual Retirement Account (IRA).
Performs various return analyses on property leases, including net present value (NPV), NPV per term, Net Uniform Series (NUS) per annuity, internal rate of return (IRR), and both US and Canadian Net Effective Rate (or Rental).
Loan constant measures the true cost of borrowing with consideration to the effective interest rate, the payback of interest and the payback of principal. Loan constant can also be used to compare loan alternatives.
Calculates how many months it takes to pay off the cost of refinancing a loan. Money is saved on payments after the break even point.
Calculates the maximum loan amount a bank would be willing to lend given a certain income level.
Calculates the amount of money that must be invested to provide a perpetual $1.00 payment at the end of each year based upon the inputted interest rate.
Calculates the present value of an annuity that grows over time. Also called growth annuity or increasing annuity.
Performs several basic investment return analyses for a property acquisition. Analysis includes Net Present Value (NPV), NPV per Term, Net Uniform Series (NUS) per Annuity, Average Rental, and Internal Rate of Return (IRR).
Calculate the value of an account or net worth when taking regular withdrawals. This calculation is important for retirees living on a fixed income.
Integrates calculations for savings and withdrawal templates to determine how much needs to be saved for retirement and how much can be spent during retirement.
Helps calculate monthly savings required to amass a certain income, whether for a future date or retirement. It also shows that future amount in today's terms.
Calculates a series loan payment amount for any given month where the payment amount changes each month.
Calculates the current value of a security using projections of next year's stock price, current dividend payouts, taxes on those dividends, and required rate of return.
Calculates the pre-tax yield that a taxable bond needs to possess for its yield to be equal to a tax-free municipal bond.
Also known as TVM or amortization, calculates compound interest problems where the payment is steady from period to period. Variables include present value, future value, payment, interest rate per year and periods.
Calculates a payment to achieve an average desired interest rate over the life of a loan.
Used for evaluating a company's financial health and predicting corporate failure with a 70% accuracy up to two years before collapse.