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.

# Tag: Financial Calculators

## Accrual to Cash Conversion Excel Worksheet

## Cash to Accrual Conversion Calculator

## 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.

## 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.

## Overhead Recovery Rate Calculator

## Overhead Apportionment Calculator

## Sales Tax Calculator

## 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).

## 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).

## Vertical Analysis Calculator

A vertical analysis shows each line of financial statements as a percentage of a base line item so that comparisons can be made. This free Excel calculator produces a vertical analysis of an income statement in relation to total revenue, and of a balance sheet in relation to total assets.