Schedule of Assets
Well designed schedules facilitate the calculation of values needed to complete financial statements, including the Balance Sheet, Cash Flow Statement, Income Statement, and Statement of Deferred Taxes and Valuation Equity (if used). This OSU Extension Fact Sheet provides instructions and forms for inventorying assets and documenting detail to support entries made in the financial statements1. Assets include everything owned that has value, including claims against others. One set of schedules should be prepared for the beginning of the reporting period and a second set for the end of the reporting period. Schedules for the example farm of James and Dolly Madison are included for illustration2.
Methods for Valuation
Current market value is an amount which would be received if the asset was sold at the balance sheet date. The amount is usually determined by an appraisal and is therefore subjective. Current market value may be required by lenders when the asset will be used to secure a loan. Market value is used to estimate the amount of taxes that will be owed if the assets are sold and to estimate owner equity. An estimate of direct costs necessary to convert an asset to cash may be subtracted to record a net realizable value.
For depreciable assets, another method of valuation is historical cost.3 This method is most useful in estimating costs of the assets associated with generating income for each reporting period during the life of an asset. If an expensive machine will be used to produce revenues over a 10-year period, it is inappropriate to charge the entire cost to the year of purchase. A portion of the non-recoverable cost of acquisition should be charged to each year in which the asset will generate revenues4. This charge to each reporting period is known as depreciation expense. Historical cost provides a more conservative approach to valuation than the market value approach during inflationary periods.
An asset’s book value is the cost less accumulated depreciation. When first acquired, an asset’s book value is equal to the cost (accumulated depreciation is zero); at the end of its useful life, an asset’s book value is equal to its salvage value (the asset has been fully depreciated).
The Farm Financial Standards Council recommends both current market value and book value be disclosed for most depreciable assets.5 Other valuation methods are recommended for certain types of assets and for those assets, cost or market value may or may not be considered important. Net equity may be used to determine the value of shares owned in cooperatives and investment in other entities. The most practical method of determining net equity is to utilize the financial reports made by those entities. The total equity for the entity is divided by the total number of outstanding shares to determine the equity value per share. This amount is then multiplied by the number of shares owned to arrive at net equity.
Economic depreciation may be determined by one of several different methods. Each method relies on three components to calculate the depreciation expense. Cost is the original purchase price plus any additional expenses incurred to make the asset operational, e.g. freight, inspection, repairs, modifications, and installation. The asset’s useful life is a second factor in determining depreciation since depreciation divides the expense of the asset over the time period in which it is used to generate revenue. The salvage value of the asset is the estimated market value of the asset at the end of its useful life.
The simplest method of calculating the depreciation expense to be charged to each reporting period is the straight-line method. This method allocates an equal amount of depreciation expense to each year of useful life:
(cost – salvage value)
years of useful life
This often is the most practical and meaningful method. When calculating economic depreciation for financial reporting, a reasonable estimate of salvage value should be used. If it becomes apparent that the useful life, salvage value, or both are different than originally estimated, annual depreciation expense should be adjusted to reflect the revised estimates.
Use of an accelerated method of calculating depreciation for machinery, vehicles, and some buildings and improvements may be justified by the fact that, as the asset ages, maintenance costs tend to increase. Thus, a greater amount of depreciation expense may be recorded in the early years when maintenance costs are low and a lesser amount is recorded in later years when efficiency has decreased and maintenance costs are higher.
One method for calculating accelerated depreciation is Sum-of-the-Years’-Digits. This method is calculated by multiplying the non-recoverable cost of acquisition (cost less salvage value) by a fraction. The denominator (bottom number) of the fraction is the sum of the numbers representing each year of useful life. Thus the denominator for an asset with a useful life of five years would be: 1+2+3+4+5 = 15. The denominator may also be found by the formula:
n (n+1) ÷ 2, where n = years of useful life
The numerator (top number) of the fraction is the number of years remaining in the asset’s useful life at the beginning of each year. In this example, the fraction for year one would be 5/15, year two would be 4/15, etc. so that the depreciation expense in year five would be 20 percent of that recorded in year one.
Double Declining Balance is another common method for calculating accelerated depreciation. It is calculated by multiplying book value (cost less accumulated depreciation) at the beginning of each year by twice the straight-line rate. For example, if the useful life of an asset is five years, 20 percent of the non-recoverable acquisition cost would be recorded as depreciation expense each year using the straight-line method. Therefore, 40 percent of book value would be recorded annually as depreciation expense using the double declining balance method. At some point, this method would reduce book value below salvage value (year four for property with a useful life of five years). This is handled by changing depreciation methods to straight-line in that year.
Another declining balance method is 150 percent declining balance. With this method, the straight-line rate is multiplied by 1.5 rather than 2 as was used for double declining balance. The 150 percent declining balance method will not reduce book value to salvage value by the end of the useful life. A change to the straight-line method is made when the straight line method results in a greater depreciation expense than does the 150 percent declining balance method.
In summary, the annual depreciation expense may be calculated as:
- DSL = OC-SV÷N
- Double Declining
- Dddb = 2÷N x R
- 150% Declining Balance
- D150db = 1.5÷N x R
OC = Original Cost (includes freight and expenses needed to make the item operational)
SV = Projected salvage value
N = Asset’s expected economic life (number of years)
R = Remaining book value at the beginning of the year
Current assets are cash and other assets which are typically and easily converted to cash in the course of business during the year without any loss in value. The Madison’s current assets are summarized on the Current Asset Schedule.
Cash and checking. Cash balances in various checking accounts and savings accounts may be listed at the option of the person preparing the schedules.
Marketable securities. Stock shares, bonds, and other securities which may be readily sold should be itemized. Market value may be obtained from financial quotations found on the internet. When used for planning purposes, market value at the end of the planning period may be estimated based on past performance.
Accounts receivable is a value for goods and services which have been provided but for which payment has not been received. If the receipt of payment for any of the accounts is doubtful, the amount is not included. The subtotal for accounts receivable is found on the balance sheet, line 3. The Madison’s have accounts receivable of $900 on the balance sheet date.
Prepaid expenses include expenditures for goods or services which have not yet been received as of the schedule date or which cannot be readily classified as work in process. One example is cash rent which has been paid for a lease that will expire some time in the future. Another example is fertilizer which has been applied to the soil for a crop which has not yet been planted. The subtotal for prepaid expenses is found on line 4 of the balance sheet.
If the crop is actually growing, this amount will be part of cash investment, growing crops (found on line 5 of the balance sheet). However, until a crop is planted, the cost of the applied fertilizer is a prepaid expense. The Madison example shows no prepaid expenses. Cash expenses for planting 499 acres of winter wheat which was growing on the date of record are $54,669 (an average cost of $109.55 per acre).
For growing crops, the total cost of the cash investment is also used as the market value of growing crops.
Marketable Livestock are usually valued by weight (cwt or Ib.), but are sometimes valued at so much per head. Livestock purchased for resale should be listed separately from raised livestock. Livestock are grouped according to weight and gender when this affects price per pound. Market value is estimated using local market quotations and estimated or actual weight of the animals. The market value for each animal is multiplied by the number of head in each group to arrive at the total market value for each listing. The sum of the determined market values is then transferred to the balance sheet.
The Madisons have made three entries for marketable livestock: one group of purchased steers, plus raised steers and raised heifers. On the first line of the Schedule of Assets, 167 head of steers valued at $1,092 per head local market price = $182,364 total value (rounded). The remaining lines are completed in the same manner. The total market value for all marketable livestock, $241,992, can be found on line 5 of the balance sheet.
The market value of raised crops and feed is based on market price as of the date of the schedule. Included in this category are raised crops which are stored for sale at a later date and those which will be fed on the farm. The Madison’s list 20 tons of prairie hay and 20 tons of alfalfa hay with a total market value of $4,860 can be found on line 6 of the balance sheet.
Purchased Feed should be reported at cost. This value will usually not be very different from current market value unless a large amount of feed has been purchased and held for an extended period of time. An exception would be if feed is purchased for resale. The Madison’s have no purchased feed on the balance sheet date.
Supplies are generally difficult to inventory due to the number and variety of items. Fuel, oil, lubricants, veterinary medicines, baling twine, fencing materials, nails, and welding rods are but a few examples. Some effort should be given to list those items of significant value. Others may be included as miscellaneous and given a single estimated value. Supplies should be entered at cost which will usually be similar to current market value. The total, $2,000, is found on line 8 of the Madison’s balance sheet.
Other Entries may include farm savings and non-farm current assets. Savings are generally regarded as a non-farm account and recorded on line 11 of the balance sheet. If the funds are intended for farm use only, savings are entered on line 9 of the Balance Sheet, “Other Current Assets.”
Non-current assets are durable items which have a useful life of more than one year, for example, breeding livestock, machinery, equipment, and real estate. For a market-based balance sheet, Purchased Breeding Stock are valued at the current market price. Current market price could be interpreted as a price which represents replacement breeding stock or slaughter price. Although some animals are culled and sold for slaughter from time to time, using slaughter price tends to understate the value of the animals. Using the price of purchasing a replacement of like quality is recommended when estimating market value. It is not necessary to value each animal separately; an average value for the entire herd or for groups based on age or other factors is adequate.
The initial cost should be recorded as the average cost per animal purchased multiplied by the number of those placed in the herd. Annual economic depreciation expense is calculated by subtracting the expected salvage value (price expected when culled from the herd) from the purchase price and dividing by the number of years that the animal is expected to be kept for breeding purposes. Only a part of this amount is recorded for the year of purchase unless the purchase was made very close to the asset schedule date. Accumulated depreciation keeps track of the total depreciation recorded to date and is subtracted from the original cost to arrive at a depreciation-adjusted cost basis, or book value.
In the Madison example, only herd bulls are purchased. Two bulls were purchased in 2014 for $3,000. Two bulls were purchased in January 2019 for $1,800 each. The Madisons expect to keep these two bulls for five years and estimate their salvage value to be $1,200 each. Annual depreciation expense for the two bulls purchased in 2014 is $240:
(3,600-2,400)÷5 = 240
On March 1, 2019, they recorded accumulated depreciation of $40 for January through March ($240 ÷ 12 months per year x 2 months elapsed time = $40). Subtracting accumulated depreciation from the total cost of $3,600 leaves a book value of $3,560 for both bulls.
Market value for raised breeding stock is determined in the same manner as for purchased breeding stock. Cost determination for raised breeding stock is more complicated. Full cost absorption involves extensive record keeping to calculate the cost of raising individual animals or groups of animals to production age. The costs are not expensed, but are depreciated over the useful life once the animal reaches production. A simpler, and therefore less expensive, method is base value. An estimate of the cost to raise an animal to production is used. The costs are expensed and base value is not depreciated. The Farm Financial Standards Council recognizes both full cost absorption and base value as acceptable. A more complete discussion of valuation of raised breeding stock and the following estimates are found in OSU Extension fact sheet AGEC-323. The base value method was chosen for the Madison farm example. The Madisons estimate the cost of raising replacement heifers to weaning age, $750; breeding age, $945; and first calf age, $1,000. These estimated costs are multiplied by the number of animals in each group and recorded in the columns for cost and book value. The base value is held constant year after year until the cost changes significantly.
Market value for machinery and equipment usually declines rapidly in the first few years that a new item is placed in service and more gradually in later years. However, machinery values may actually increase during times when farming is profitable and when the price for new machinery is increasing. Market value should be estimated for each major piece of machinery using local market conditions. The value entered should be the best estimate of what the machine would bring if it were sold on the date of the balance sheet.
Cost is recorded at the original purchase price, including any costs for freight and/or modification necessary to place the machine in service6. To calculate annual depreciation expense, subtract the expected salvage value from cost and divide by the estimated number of years that the machine will be in use. Accumulated depreciation is found by multiplying the number of years and partial years that the machine has been used at the asset schedule date. The Non-current Asset Schedule lists the Madison’s machinery.
The JD 9370R tractor was purchased in May 2017 for $278,000. They expect to use it for 15 years and estimate the tractor’s salvage value as $69,500 at the end of that time period. Annual depreciation expense is ($278,000 - $69,500) ÷ 15 = $13,900. Depreciation expense for May 2017 through December 2017 is ($13,900 ÷ 12 x 8) = $9,266. This is the accumulated depreciation recorded on Jan. 1, 2018. For the year 2019 statements in the example, an additional $16,217 (one full year and two months of depreciation) is added to the previously recorded $9,266 for an accumulated depreciation of $25,483. This amount is subtracted from the original cost to arrive at the book value of $252,516.
The CIH 2366 combine was purchased in May 2011. Annual depreciation is ($325,000 - $61,640) ÷ 12 = $21,946. Accumulated depreciation 2011 through 2019 is $171,915. Book value is $325,000 - $171,915 = $153,085.
Farm vehicles are valued exactly like machinery and equipment and can be found on line 17 of the balance sheet. Personal vehicles, however, which are not used primarily in operating the farm should be excluded. These vehicles would be found on the balance sheet (line 27) as non-farm assets.
Capital leases are, in simple terms, “lease-purchase” agreements. Title to the item acquired by a capital lease is transferred to the lessee at some point or the major part of the value of the item is used up by the lessee over the term of the lease. Specific rules apply to determine if a capital lease exists. See OSU Extension fact sheet AGEC-935 for more detailed information about capital leases. Farm assets acquired by capital lease are usually machinery or vehicles and are entered in the schedules in the same manner, but separate from the machinery and vehicles listings. The FFSC recommends that book value be recorded in the balance sheet regardless of whether the remainder of the balance sheet is developed using a cost or market basis. For example, if the Madisons acquired a combine by capital lease in May 2018, the original cost is $378,000, determined by discounting the payments to present value. Expected useful life is 10 years and estimated salvage value is $25,000. Annual depreciation expense is ($378,000 - $84,000) ÷ 10 = $29,400. Depreciation expense charged in the purchase year is $29,400 ÷ 12 x 11 = $26,950. Book value, $378,000 – $26,950 = 351,050, would be entered in the ending balance column on line 17 of the balance sheet.
The market value for Real Estate (Land) is determined by appraisal, usually made by the owner. This value should reflect the best estimate of what the land could be sold for at the balance sheet date. Cost is the original amount paid for the land plus any costs for terraces, water wells and ponds which are fixed to the land and which were not expensed. Land is assumed to maintain its productive capacity and is not depreciated. Therefore, land’s book value is equal to its cost.
Buildings and Other Forms of Improvements are real property, but the value is depreciated. Market values for buildings, silos and other improvements are estimates of the price which would be received if the land were sold on the asset schedule date. Depreciation is calculated in the same manner as for machinery and other depreciable farm assets. The main difference is that the useful life is usually much longer.
Non-current Non-Farm Assets should be listed separately from farm assets so that accurate business financial statements can be prepared. The rules applied to farm assets also apply when determining market value, cost, depreciation, and book value of non-farm assets.
Economic Gains (Losses) on the Sale of Assets
Gains and losses on the sale of assets are generally determined by the amount that sale price exceeds the book value of the asset. Here, the focus is on economic gains and losses rather than taxable gains and losses. Hence, market value is compared to the book value rather than the tax basis.7
For marketable securities, the book value (cost basis) is equal to the original cost of the securities including brokerage fees, if any. Book value for purchased market livestock is the original purchase price. For the Madisons, the book value of purchased market livestock, $143,286, was the total cost of the purchased steers. The costs of raising animals to a heavier weight are expensed and do not affect the cost basis.
The costs of raised marketable livestock (e.g. raised stockers) are also expensed so proceeds from their sale is operating income (rather than a gain or loss). Likewise, proceeds from sale of raised crops and feed are operational income since the costs of production are expensed during the period.
Gain/Loss from the Sale of Culled Breeding Stock sums gains and losses from sales of raised and purchased breeding animals culled. For raised breeding livestock, the gain/loss is calculated by subtracting the base value from the sale proceeds; for purchased breeding stock, subtract the cost basis from the sale proceeds to determine the gain or loss. A positive number indicates a gain on the sale; a negative number indicates a loss on the sale. Only the gain from the sale — not the gross revenue — is recorded; otherwise the revenue will be overstated. The Madisons plan to cull ten raised cows from the breeding herd. The cows are expected to net $9,000, a loss of $1,000 when compared to their base value (Madison Non-Current Assets Schedule). Thus, the gain/loss on culled breeding stock is negative $1,000. If a material downsizing or complete liquidation of the herd occurs, the gain/loss on sale should be recorded on the income statement (line 59) after Net Farm Income from Operations and before accrual adjusted Net Farm Income.
Gain/Loss on Sales of Farm Capital Assets (line 59) sums gains and losses from the sale of farm vehicles, machinery, equipment, buildings, etc. While not a routine operating item, sales of capital assets and marketable securities are used to determine the overall farm profit or loss for the accounting period. The difference between the value for which the item is sold and the adjusted cost or basis is the amount of depreciation that was over or under expensed in previous time periods.
James and Dolly Madison estimate a depreciation expense of $69,224 for year 2019 using the straight-line method for all depreciable assets.
Values for Tax Purposes
When an asset is purchased, the tax basis is the original cost of a depreciable asset for which a business expense, depreciation, may be claimed for tax purposes. During the asset’s useful life, tax basis is also used to describe the remaining cost which has not been claimed in prior periods. Costs of major repairs, such as an engine overhaul or a new roof on a building, are added to the remaining tax basis for depreciation rather than expensed in the year when the repair occurs.
Tax depreciation is a method of allocating the cost of an asset, a business expense, to each tax year during the life of the asset. The method and the life of the asset are specified by Congress and disclosed by the Internal Revenue Service. It is determined by subtracting the allowable depreciation specified in IRS publications from the purchase price.
Modified Accelerated Cost Recovery System (MACRS) is an accelerated tax depreciation method, in use at the time this fact sheet was written, to allocate the cost of an asset for tax purposes and encourage investment in durable goods. Machinery, for example, can be fully depreciated in seven years (actually 8 years because only one-half of annual depreciation is recognized in the year of purchase). Salvage value is set at zero.8 Therefore, any amount recovered upon disposal after the depreciation period is taxable as regular income. The amount received on the sale or trade-in is used to reduce the tax basis of an asset of the same kind which is purchased as a replacement. Thus the tax is deferred until the end of the useful life of the replacement asset. This also results in a smaller annual tax depreciation expense for the replacement asset. The deferral process can be continued indefinitely.
In the year 2019, James and Dolly will claim $69,224 as depreciation expense on their income tax returns. If they had used tax depreciation rules to prepare the financial statements, Net Farm Income would have been reported as $29,084, which is $2,462 lower than actual Net Farm Income of $31,546. Since the change in Retained Earnings for the year is directly related to Net Income, the use of tax depreciation rules would have caused an understatement in reported retained earnings. While not a large percentage basis in this year, the results can be dramatically different.
Valuation of durable goods at current market value, cost, book value, and tax basis are all useful in determining the overall financial position of a farm business. Agricultural producers should understand the difference between depreciation expense which is used for financial reporting and tax depreciation which is set by Congress for a different purpose.
Current Assets Schedule (cont’d.)
Madison Non-Current Assets Schedule
Madison Non-Current Asset Schedule Blank
Extension Specialist for Farm Management
Extension Specialist for Ag Finance and Management