EOQ Calculator Excel

This economic order quantity calculator uses the demand for a product together with estimated unit ordering and holding costs to calculate the optimum order quantity necessary to minimize inventory costs. Free Excel download.

Last modified July 16th, 2019 by Michael Brown
Read more

Cash Flow Ratios Calculator

This cash ratios calculator uses operating cash flow instead of net income to calculate three financial ratios. Unlike net income, cash flow is an objective measure of performance which cannot be manipulated or distorted using accounting assumptions and opinions.

Last modified July 16th, 2019 by Michael Brown
Read more

Lump Sum Purchase Calculator

This Excel basket purchase allocation calculator can allocate the total cost of a lump sum purchase over a maximum of 12 assets based on their relative fair market value.

Last modified January 9th, 2023 by Michael Brown
Read more

Straight Line Depreciation Schedule Calculator

The straight line method is one method of calculating the depreciation expense for an asset. This Excel calculator produces a straight line depreciation schedule setting out the beginning net book value, the depreciation expense, and the ending net book value of the asset based on a straight line depreciation rate.

Last modified July 16th, 2019 by Michael Brown
Read more

Declining Balance Depreciation Schedule Calculator

The declining balance method is one method of calculating the depreciation expense for an asset. This calculator produces as asset depreciation schedule setting out the beginning net book value, the depreciation expense, and the ending net book value of the asset based on a declining balance depreciation rate.

Last modified July 16th, 2019 by Michael Brown
Read more

Overhead Apportionment Calculator

The overhead apportionment calculator, sometimes referred to as a cost apportioning calculator, can be used to apportion up to eight overhead types between six departments or cost centers.

Last modified January 17th, 2020 by Michael Brown
Read more

Sales Tax Calculator

The sales tax calculator works out the sales tax rate percentage, sales tax amount, net amount, or gross amount by entering any two of these values.

Last modified November 22nd, 2022 by Michael Brown
Read more

Gross Profit Method Calculator

The gross profit method calculator works out a products net price after applying multiple trade discounts to its list price. This free Excel calculator also provides a summary showing the original price, total discount, and net price, together with a calculation of the single equivalent rate (SED).

Last modified July 16th, 2019 by Michael Brown
Read more

Chain Discount Calculator

The chain discount calculator works out a products net price after applying multiple trade discounts to its list price. This free Excel calculator also provides a summary showing the original price, total discount, and net price, together with a calculation of the single equivalent rate (SED).

Last modified July 16th, 2019 by Michael Brown
Read more

You May Also Like