Hamlin's Financial Add-in for Excel v1.0 Description:
lets you add several financial functions to Microsoft Excel. "AveDebtInterest" calculates the interest on the average debt outstanding without creating a cyclical reference even when the ending debt outstanding is dependent on this interest calculation.
"AveInterestEarn" computes the interest earned on the average cash outstanding without creating a cyclical reference even when the ending cash is dependent on this interest-earned calculation.
While "BlackScholesCall" returns the value of a call option using the Black-Scholes model, "BlackScholesPut" returns the value of a put option using the same model. With proper input values, "BlackScholesCall" can be used to calculate call option values in compliance with the Financial Accounting Standards Board ruling 123.
"CompoundRate" returns the single rate resulting from the compounding of a range of interest rates and "DebtEquity" returns the ratio of debt to debt-plus-equity.
"DSO" returns the Days Sales Outstanding for receivables based on the current outstanding receivable balance and a range of historical sales. This function can also be used to calculate the periods outstanding (in days or other measurements) of other balance sheet items.
Finally, "FPO" (Future Periods Outstanding) returns the number of periods outstanding for an item based on the current outstanding balance and a range of forecast consumption for that item. This function is the prospective (is based on forecast rather than historic) equivalent of the "DSO" function.