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.
When a business purchases an asset which includes several assets such as land, land improvements, and buildings which have dissimilar depreciation rates, it needs to be able to allocate the total cost of the asset to its component parts. The relative fair market value method is one technique used to carry out this allocation.
A rental deposit is paid by a business to a landlord when renting premises. The deposit is refundable but is held by the landlord as security in the event that the business has caused damage to the property or has rent outstanding when the property is vacated.
The four main financial statements are the income statement, statement of retained earnings, balance sheet, and cash flow statement. All four statements are interrelated and allow the user to more fully understand the financial performance of the business through the analysis of its financial statements.
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).
Errors in inventory impact the balance sheet and income statement of a business, but have no effect on its operating cash flow. In the cash flow the change in net income as a result of the inventory error, is compensated for by a change in the movement on working capital.
A business has an estimated annual income tax expense of 14,000 due of profits for the accounting period. A demand for the amount has not yet been received from the tax authorities, and the expense has not been recorded in the accounting records. An accrued income tax adjusting entry is made in the accounting records.
A business operating a perpetual inventory system needs to record goods received into inventory even if it has not yet received an invoice from its supplier. Since the liability cannot be posted to the accounts payable account, a temporary posting is made to the goods received not invoiced account.
A business will often purchase a number of long term assets for a single combined purchase price. In order to record the assets in the accounting records and to allow depreciation to be correctly calculated, the basket purchase price needs to be allocated in proportion to the fair market value of the assets.