Over time, assets lose some or all of their value through depreciation or amortization. The current value of these assets obviously has an impact on the value of the company itself. Net Book Value expresses the historical value of an asset after deducting the corresponding accumulated depreciation or amortization.

In this article, you will learn about Net Book Value and why it matters. You will also learn how Net Book Value is calculated, as well as how to use the formula to calculate Net Book Value with step-by-step instructions and examples.

## What is Net Book Value?

Net Book Value (NBV) refers to the historical value of an asset after subtracting accumulated depreciation or amortization - depending on the asset type - from the original cost. It is used to determine the value of a company’s assets and is an important aspect of financial reporting.

The Net Book Value does not necessarily reflect the market value of the asset at any point. Once the asset’s useful life is at an end, its Net Book Value should be an approximate match for its salvage value, if any.

## How to Calculate Net Book Value?

Net Book Value is calculated by subtracting cumulative depreciation from the original cost of the asset. Cumulative depreciation or amortization refers to the value obtained by multiplying the yearly value by the number of years you have owned the asset.

### Net Book Value Formula

To calculate the Net Book Value of an asset, use the following formula:

net book value = original asset cost - accumulated depreciation/amortization

Depreciation applies to tangible assets with a useful life greater than one year. A percentage of the asset’s price at purchase is deducted periodically over the course of its useful life. The asset's value at the end of its useful life will be approximately its salvage value if it has any. To calculate accumulated depreciation using the straight-line method, use the formula below.

accumulated depreciation = ((original cost - salvage value) / useful life) * years in use

In this context, amortization is very similar to depreciation, but it applies to intangible assets, like loans, patents, or trademarks.

accumulated amortization = (original cost - residual value) / useful life) * years consumed

An amortization schedule helps to determine how your monthly payments affect your loan cost. Here’s how to create an amortization schedule in Google Sheets.

READ MORE## How is Net Book Value Calculated in Google Sheets?

You can easily calculate the Net Book Value of your assets in Google Sheets. Below, you have step-by-step instructions on how to calculate Net Book Value in Google Sheets for two different types of assets.

### Calculate Net Book Value Using Accumulated Depreciation

Imagine your company purchased a truck 5 years ago. The original cost was $100,000, and the truck depreciates at $7,000 per year, with a salvage value of $20,000. Follow the steps below to calculate the current Net Book Value for the truck.

**1.**In Sheets, input the relevant values into separate cells.

**2.**Type in the formula using the cell references from the previous step. You can calculate cumulative depreciation directly or first calculate yearly depreciation like below.

**3.**Multiply the yearly depreciation by the number of years that the asset has been in use to get the accumulated depreciation.

**4.**In a separate cell, type in the formula for the Net Book Value.

**5.**That’s it. The Net Book Value of the truck after 5 years is $60,000.

#### How to Use the PMT Function in Google Sheets

The PMT formula is a financial function that can be used to calculate loan payments. Here’s how to use the PTM function in Google Sheets, including examples.

READ MORE### Calculate Net Book Value Using Accumulated Amortization

Imagine your company purchased scheduling software for $10,000 2 years ago. The software has a useful life of 5 years but no residual value at the end of its life.

**1.**In Sheets, input the relevant values into separate cells.

**2.**Type in the formula using the cell references from the previous step. You can calculate accumulated amortization directly or first calculate yearly amortization like below.

**3.**Multiply the yearly amortization by the number of years that the asset has been in use to get the accumulated amortization.

**4.**In a separate cell, type in the formula for the Net Book Value.

**5.**That’s it! You have the Net Book Value for the software after two years: $6,000.

## How to automate your FP&A on top of Google Sheets?

Layer is an add-on that equips finance teams with the tools to increase efficiency and data quality in their FP&A processes on top of Google Sheets. Share parts of your Google Sheets, monitor, review and approve changes, and sync data from different sources – all within seconds. See how it works.

Using Layer, you can:

**Share & Collaborate:**Automate your data collection and validation through user controls.**Automate & Schedule:**Schedule recurring data collection and distribution tasks.**Integrate & Sync:**Connect to your tech stack and sync all your data in one place.**Visualize & Report:**Generate and share reports with real-time data and actionable decisions.

**Limited Time Offer:** **Install the Layer Google Sheets Add-On today** and **Get Free Access** to all the paid features, so you can start managing, automating, and scaling your FP&A processes on top of Google Sheets!

## Conclusion

As you have seen, Net Book Value is an important concept in financial reporting. Assets lose most or all of their value with the passage of time, so it’s important that this be accurately reflected in the books to provide an accurate picture of what the business is worth. However, just like with many aspects of financial reporting, it relies on fair value reporting. In other words, the accuracy and usefulness of this measure will depend on the reliability of the information it’s based on.

You now know about Net Book Value and how it is calculated for different types of assets. You also know how to calculate Net Book Value in Google Sheets, so you can easily repeat your Net Book Value calculations using accumulated depreciation or accumulated amortization.

Share parts of your Google Sheets, monitor, review and approve changes, and sync data from different sources – all within seconds.

GET STARTED FOR FREE