Lump Sum Purchase Calculator

A business will often purchase a group of assets, known as a basket purchase, for a lump sum total cost. This lump sum purchase calculator uses the relative fair market value method to allocate this total cost to each of the individual assets.

The cost allocation is useful as it allows the assets to be separated into various asset categories such as property, plant, and equipment, which can then be recorded in the accounting records and depreciated at the appropriate rate for that asset category.

Using the Lump Sum Purchase Calculator

This lump sum purchase calculator can be used to allocate the total purchase cost of a group of up to 12 assets in proportion to the fair market value of each asset at the time of purchase.


The Excel lump sum purchase calculator, available for download below, is used by entering details relating to the lump sum purchase amount and the fair market value of each asset.

lump sum purchase calculator v 1.01
Lump Sum Purchase Calculator Preview

Costs to Allocate

Enter the lump sum purchase amount.


For each asset enter an asset description and its estimated fair market value at the date of purchase.

A maximum of up to 12 assets can be entered. If there are less than 12 assets in the lump sum purchase then leave the description blank and enter zero for the fair market value amount.

The lump sum purchase calculator calculates the total fair market value for the purchase and an allocation % for each asset based on its relative fair market value.

Using the allocation percentage the calculator allocates the lump sum purchase amount between the group of assets.

Lump Sum Purchase Calculator Download

The lump sum purchase worksheet is available for download in Excel format by following the link below.

The lump sum purchase calculator is one of many financial calculators used in bookkeeping and accounting, discover another at the links below.

Notes and major health warnings
Users use this lump sum purchase template at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of a basket purchase allocation calculator that you might use. It is a purely illustrative of a relative fair market value calculator. This is not intended to reflect general standards or targets for any particular company or sector. If you do spot a mistake in the lump sum purchase excel worksheet, please let us know and we will try to fix it.
Lump Sum Purchase Calculator August 11th, 2017Team

You May Also Like

Related pages

gross profit journal entrycalculating lease payments in exceljournal general entries accountingcapital lease examplehow to calculate inventory turnover periodwhat is consigned inventoryadjusting accounting entriesformula perpetuitycalculate net realizable valueunearned subscription revenueperpetuity definitioncommon size income statement formulacost accounting overheadsformula for dividend payout ratio9 accounting cycle stepsexcel data entry form template excel 2007accounting for convertible debenturesproof of annuity formulapresent value factor of annuityeom meanseffective annual interest rate equationfv pv formulaledger accounts templateretained earnings statement exampleis merchandise inventory a debit or creditunderstanding bookkeepingformula for rocehow to calculate the quick ratiopresent value of annuity due formulaamortisation schedule formuladiscounted present value exceljob timesheetchange from fifo to lifotransposition errorsfree petty cash voucher templatedouble entry accounting for dummiesdoes bad debt expense go on the income statementreturn on retained earnings formulabook keeping equationhow to figure out a lease paymentjournal entry for bills receivablewhat is intangible assets examplesaccounts receivable quizbank account ledger templatemeaning of accrued interestmarketable securities examplesmortgage payable balance sheetbookkeeping samplesthe formula for the gross margin percentage ishow to find the predetermined overhead ratemeaning deferred revenue expenditure give examplesunderstated accountingpmt excel formulaposting journal entries to ledger accountsimprest bank accountaccounting ledger examplevoucher samplesperiodic and perpetual inventory systempresent value of a lump sum calculatorreasons for material price varianceprepaid expenses appear in thebank cheque definitionpresent value of growing annuity calculatortotal manufacturing overhead variancesalaries payable adjusting entryaccounts payable internal control checklisttrade debtorsprocess costing fifofuture value ordinary annuity formulaamortisingmanufacturing overhead calculationje dividend