Archive for the Calculator Category

APY & APR Converter

Annual Percentage Yield (APY) and Annual Percentage Rate (APR). This calculator converts from one to the other. Generally people want to convert from APY to APR or APR to APY in order to understand similar investments or loans, or in order to perform their own calculations. APY

Read more

Black-Scholes Model (European)


Need a European-style Black-Scholes calculator to compute the value of a Put Option or Call Option?  Just interested in how the calculation works? Want something just to double check a calculation? Either way, this spreadsheet will help. All of the formulas can be read (and modified if you

Read more



A 3 year comparison of EBITDA (Earnings Before Interest, Taxes, Depreciation and Amortization) and several financial leverage ratios (EBITDA to P&I Payments, Debt Ratio, Debt to Equity, and Interest Coverage),  are all shown graphically with a few simple inputs. The analysis will print to one page. EBITDA

Read more

Volatility Calculator Template

volatility calculator

This volatility calculator can be used to establish the volatility of a publicly traded stock based on the inputs you provide. Use this spreadsheet to price options. The historical prices are input on one tab (the download contains an example from  Then complete the remaining inputs

Read more

Loan Amortization Schedule (Simple)

loan amortization

Enter the inputs for the loan, and a simple amortization schedule is produced. This schedule is designed using an Excel table, and includes a dynamic print range so only the applicable information will print. Simple Loan Amortization Schedule

Read more

Amortization Schedule

amortization schedule

This schedule is very similar to the simple loan amortization schedule; however, it allows for additional payments to be added. Based on these additional payments, it calculates the amount of interest saved. Can’t make the same additional monthly payment? Do you have a little extra to pay

Read more

Accounts Receivable Analysis

Accounts receivable analysis

Analyze and evaluate accounts receivable over a 5 year period with this tool. All information can be reviewed graphically over time to provide additional context. Eight key ratios are calculated off of a few inputs. These ratios include Days Sales in Trade AR, AR Turnover, and Bad

Read more

Z-Score Calculator

z-score calculator

The Z-Score, also known as the insolvency predictor, can be used to determine the probability of bankruptcy within a period of two years. Simply select the type of company you’re evaluating and complete the inputs. Altman Z-Score Calculator Z-Score History: Altman’s Z-Score originally surfaced in 1968 and

Read more

Weighted Average Cost of Capital

Weighted Average Cost of Capital

Need a simple calculator to establish the weighted average cost of capital (WACC)? Additional descriptions and useful links are included within this spreadsheet to assist in what can be a complex calculation. Weighted Average Cost of Capital (WACC)

Read more

Loan Amortization Comparison

loan amortization comparison

Compare two loans instantly. Thinking about refinancing? Want to see the impact of making additional payments on your current loan? Looking to buy up? Use this loan amortization comparison spreadsheet to instantly draw a comparison between one loan and another. Three tabs are included. An Inputs tab

Read more
Page 1 of 212


The Software Product and any related documentation are provided "As Is." SpreadsheetShoppe makes no warranties, express or implied, and expressly disclaims all representations.
Read the complete End User License Agreement here