Chapter 17 – Accounting for State and Local Governments (Part Two) – Hoyle, Schaefer, Doupnik, 13e
17–60
Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill
Education.
based on accrual accounting. Perhaps most importantly, the anticipated cost of
closure and post-closure activities must be accrued in both sets of financial
statements.
Conversely, if the landfill is recorded within the General Fund, there is no impact
on the government-wide financial statements except that all transactions and
balances are shown as governmental activities rather than as business-type
activities. However, in the fund financial statements, as a governmental fund,
only current financial resources and the changes in those financial resources are
reported. Capital assets, in these statements, as well as long-term liabilities such
as closure costs are omitted.
Excel Case
This spreadsheet would be extremely helpful for a government attempting to
determine the historical cost (less depreciation) of infrastructure assets not
problem. Here is one possible approach:
In Cell A1, enter text label “City of Loveland—Reported Value of Each Mile of
Road”
In the next three rows, enter the criteria on which calculations will be based:
Enter Column Headings:
In Cell A7, enter text label of “# of Years.”
In Cell B7, enter text label of “Date.”
In Cell C7, enter text label of “Inflation Reduced Cost.”
In Cell D7, enter text label of “Total Depreciation.”
A9. Once these cells are highlighted, you will see a small black box in the
lower right corner of this selection, which is the “fill handle.” Click on the
fill handle and drag across Cells A10 through A27 and release to display