Here are some tools that we find particularly useful. Some require Excel security to be set to "medium" because they contain VBA code, for a simple user interface. Click on the name to download any of the following for free.
Return on Investment Calculator
Enter simple benefit and investment data and view an interactive analysis of cash and P and L results with varying carrying costs, discount rates, and tax rates.
Breakeven Calculator
See a graphic view of the volume of sales required to cover all fixed and variable costs of producing goods for sale.
Fixed Asset Calculator
Asset depreciation can be complex, with multiple acquisition dates, periods, and methods. Using a simple entry form, quickly enter information for up to 100 assets, and see the period impact on Balance Sheet Fixed Assets, P and L Depreciation, and Cash Flow for up to 20 years.
Price Sensitivity Calculator
Estimate the most profitable price - volume level based on estimates of customer sensitivity to price changes.
Loan Calculator
Using a simple entry form, enter multiple loans and see the period impacts on Balance Sheet and P and L elements.
Net Present Value and IRR Calculator
Use simple Excel and VBA tools to calculate NPV and IRR, and to learn a little about how they are calculated.
Earnings per Share Calculator
Optimize shareholder value for an expansion investment, with a mix of funding from borrowing and from issuing stock.
Throughput Calculator
See the financial results of increasing throughput, improving yield, and changing workforce configuration under varying demand requirements.
|