Windows · Free download · Excel Add-Ons
lets you add several financial functions to Microsoft Excel.
264 downloads·695 page views
Overview
lets you add several financial functions to Microsoft Excel.
In depth
"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.
Verdict
Hamlin's Financial Add-in for Excel runs on Windows 95/98/Me/NT/2000/Windows 10/11 and is available under the 30-day Trial license — the installer is 65 KB. We’ve catalogued it under Excel Add-Ons.
At a glance
Help fellow users decide. Share your experience with Hamlin's Financial Add-in for Excel.