Excel Spreadsheets In One Workbook

3 Excel Spreadsheets In 1 Workbook

You are a staff accountant in a CPA firm. Your manager has asked you to provide a report containing accounting information on the following 3 clients:

  1. Global Inc. purchased a machine and incurred the following expenditures: Purchase price $20,000, Freight costs $1,000, Sales tax $2,000, Insurance on shipment $200, Insurance for the first year on the machine $500, Installation of the machine $2,000. Calculate the cost to be capitalized. Make an entry that will show which expenses will be capitalized when recording the machine on the books. Show the entry that will be recorded to expense the cost that will not be capitalized.
  2. Brands Resources traded an old machine for a new machine. The book value of the old machine was $150,000 (original cost $320,000, less accumulated depreciation of $170,000). The fair value was $180,000. Brands Resources paid $20,000 to complete the exchange. Prepare the journal entry to record the exchange.
  3. Reliable Company purchased a machine on January 1, 2008, at a net cost of $85,000. At the end of the 4-year life, it expects the machine will have a salvage value of $5,000. It also estimates that the machine will run for 10,000 hours during its 4-year life. The company’s fiscal year ends on December 31. Machine hours for each year: 2008 - 2,000 hours. Calculate depreciation using the straight-line, double declining balance, and units of production methods.

Paper For Above instruction

Accounting for asset acquisition and depreciation is fundamental to accurate financial reporting. This comprehensive report addresses three key client scenarios: the capitalization of costs for a purchased machine, the journal entry for an asset exchange, and depreciation calculations using multiple methods. Each scenario highlights essential accounting principles and demonstrates proper journal entries and calculations consistent with Generally Accepted Accounting Principles (GAAP).

1. Capitalization of Costs for Global Inc.

When a company purchases a fixed asset such as a machine, it must capitalize costs that are necessary to acquire the asset and prepare it for use. These include the purchase price, freight costs, sales tax, shipment insurance, installation costs, and any other costs directly related to bringing the asset to its intended use. Conversely, costs such as ongoing insurance expenses after installation are expensed as incurred.

Calculating the capitalized cost:

  • Purchase price: $20,000
  • Freight costs: $1,000
  • Sales tax: $2,000
  • Insurance on shipment: $200
  • Installation: $2,000

Expenses to capitalize are those directly attributable to preparing the asset for use. Therefore, insurance on shipment ($200) and ongoing insurance for the first year ($500) are not capitalized, as they are period costs. They should be expensed in the period incurred.

Capitalized costs: $20,000 + $1,000 + $2,000 + $2,000 = $25,000

Expenses not capitalized: Shipping insurance ($200) and first-year insurance ($500)

Journal entry to record the purchase:

Debit: Machinery........................................$25,000


Debit: Freight-in.......................................$1,000


Debit: Sales Tax........................................$2,000


Debit: Installation of Machinery.........................$2,000


Credit: Cash/Accounts Payable.............................$30,000

This entry capitalizes all costs necessary to acquire and prepare the machine for use. The insurance costs not included are recorded separately as expenses in the period incurred.

2. Recording the Asset Exchange for Brands Resources

Brands Resources traded an old machine with a book value of $150,000 for a new machine with a fair value of $180,000, and paid $20,000 to complete the exchange. Under GAAP, exchanges of similar assets are accounted for at fair value unless the transaction lacks commercial substance. Given the fair value of the new asset and the carrying amount of the old asset, the journal entry can be prepared as follows:

Calculate the book value of the old machine:

  • Original cost: $320,000
  • Accumulated depreciation: $170,000
  • Book value: $150,000 (given)

The gain or loss on exchange is calculated by comparing the fair value of the old machine ($180,000) with its book value ($150,000):

  • Gain on exchange: $30,000

Journal entry:

Debit: Equipment (new machine)............................$180,000


Debit: Accumulated Depreciation—Old Machine..............$170,000


Credit: Old Machine.......................................$320,000


Credit: Cash..............................................$20,000


Credit: Gain on Disposal of Machinery....................$30,000

This entry derecognizes the old machine, records the new machine at its fair value, and recognizes the gain on exchange.

3. Depreciation Calculations for Reliable Company

Reliable Company purchased a machine at $85,000 with an estimated salvage value of $5,000 and a useful life of 4 years or 10,000 hours. The depreciation methods to calculate are straight-line, double declining balance, and units of production.

Straight-line Method

The straight-line depreciation expense per year is calculated as:

(Cost – Salvage Value) / Useful Life

Annual depreciation:

($85,000 – $5,000) / 4 = $20,000 per year

Double Declining Balance Method

The double declining balance (DDB) method involves depreciating at twice the straight-line rate, applied to the declining book value each year.

Rate:

= (1 / Useful life) × 2 = (1 / 4) × 2 = 50%

Year 1 depreciation:

= $85,000 × 50% = $42,500

Book value at end of Year 1:

= $85,000 – $42,500 = $42,500

Year 2 depreciation:

= $42,500 × 50% = $21,250

Book value at end of Year 2:

= $42,500 – $21,250 = $21,250

Year 3 depreciation:

= $21,250 × 50% = $10,625

Book value at end of Year 3:

= $21,250 – $10,625 = $10,625

Year 4 depreciation:

= Remaining book value or until salvage value is reached, but in the final year, depreciation is adjusted to not depreciate below salvage value. For simplicity, in Year 4:

= $10,625 – ($10,000 – $5,000) = $5,625 (depreciation capped so book value doesn't go below salvage).

Units of Production Method

This method allocates depreciation based on machine usage. The total estimated hours are 10,000, and the total cost is $85,000 with a salvage value of $5,000. The depreciation per hour is:

($85,000 – $5,000) / 10,000 hours = $8 per hour

For 2008, hours used: 2,000 hours

Depreciation expense=$8 × 2,000 = $16,000

Summary of Depreciation Expenses for 2008:

  • Straight-line: $20,000
  • Double declining balance: $42,500 (Year 1)
  • Units of Production: $16,000

Conclusion

Proper handling of asset acquisition costs ensures accurate capitalization, and appropriate depreciation calculations reflect the asset’s usage and decline in value over time. These methods comply with GAAP standards and facilitate transparent financial reporting for clients. Accurate journal entries and depreciation methods are crucial for maintaining compliance, enabling proper asset valuation, and assessing company profitability.

References

  • Arnold, G., & Sutton, S. (2016). Financial accounting. McGraw-Hill Education.
  • Horngren, C. T., Sundem, G. L., & Elliott, J. A. (2018). Introduction to Financial Accounting. Pearson.
  • Gibson, C. H. (2017). Financial Reporting & Analysis. Cengage Learning.
  • Wiley, J. (2019). Accounting Principles. Wiley.
  • Financial Accounting Standards Board (FASB). (2020). Accounting Standards Codification (ASC) Topic 360: Property, Plant, and Equipment.
  • PKF International. (2018). Asset Exchange Transactions: GAAP Guidance.
  • Martin, R., & Riley, J. (2019). Cost Accounting: A Managerial Emphasis. McGraw-Hill.
  • Jones, M. J. (2017). Corporate Finance and Accounting. Routledge.
  • Lev, B., & Gu, F. (2016). Financial Statement Analysis and Valuation. CFA Institute Research Foundation.
  • Smith, J. (2015). Practical Guide to Fixed Asset Accounting. Accounting Today.

Related Assignments