Entering Assets

In this article

Customarily, long-lasting purchases (called “assets”) are treated differently than regular expenses. Consider two purchases as an example: 1. a company truck and a tank of fuel to power it. The fuel is a short-lived purchase - buy it in January, use it in January. That’s how regular expenses work.

The truck is different, though. It’s an expensive purchase, and it won’t be gone at the end of the first month. A good truck will deliver value for years to come, so it makes sense to spread out its cost over time. That’s the idea behind asset purchases.

When you enter an asset into your forecast, Upmetrics will place its full value in your financial statements, and then calculate the amount of value it will lose (through amortization or depreciation) each month over its useful life.

If you plan to get a loan to pay for an asset (as in the company truck example), be sure to add that loan separately in the Financing page. All we’re doing here is adding the asset itself.

NOTE: Not all assets are covered here. Cash, accounts receivable, and inventory are assets too, but we address those separately in our forecast. Just focus here on long-lasting purchases like equipment, vehicles, or furniture. You can also use this feature to spread out the expense of annual contracts or other short-term assets.

Adding a Long-term Asset:

1

Under the  working capital tab of the financial forecasting tool, Click on the Assets tab, and then click Add Assets Button:

2

In the overlay that appears, Enter a name for the assets (or short description):

3

Choose the  Long term for the asset type:

4

Choose how you want to enter the asset. Will you pay a one-time amount for it, pay the same amount per month/year for it, or pay varying amounts per month/year for it?

  • If you choose a One-time purchase, enter the expected purchase price and purchase date:
  • If you choose a Constant amount, enter how much you will pay for it (per month or year), and when that payment will begin::

  • If you choose Varying amounts over time, enter how much you will spend in the excel sheet, in the months in which you'll spend it:

5

Depreciation: Indicate the useful life of the asset, which will help Upmetrics calculate the depreciation. If this asset won't depreciate, choose Forever (do not depreciate) at the bottom of the list: 

Finally, if you chose " One-time amount" on the previous step of the overlay, you'll see an option that asks you to indicate whether you plan to sell this asset during the period covered by your forecast, and if so, when:

NOTE: If you don't see this option in your overlay, it means that you chose a constant or varying payment for the asset in the previous step of the overlay.

6

Click Save and Close.

Determining the useful life of a Long-term Asset

For more details on how to choose the useful life of an asset, see Depreciation, Amortization, and Determining the useful life of an asset.

Adding Current Assets

A current asset is one that is used up within 12 months (for example, an annual service contract). For more details, learn more about the difference between a long-term asset and a current asset

1

Under the  working capital tab of the financial forecasting tool, Click on the Assets tab, and then click Add Assets Button:

2

In the overlay that appears, Enter a name for the assets (or short description):

3

Click  Current to indicate that this is a current asset:

4

Choose how you want to enter the asset. Will you pay a one-time amount for it, pay the same amount per month/year for it, or pay varying amounts per month/year for it?

  • If you choose a One-time purchase, enter the expected purchase price and purchase date:
  • If you choose a Constant amount, enter how much you will pay for it (per month or year), and when that payment will begin::

  • If you choose Varying amounts over time, enter how much you will spend in the excel sheet, in the months in which you'll spend it:

5

Select the length of time that this current asset will provide value, so Upmetrics can amortize that value. If you don't want to amortize it at all, choose the Do Not Amortize (Keep at full value) option at the bottom of the list:   

6

Click Save and Close.

Editing or Deleting Assets

1

To delete an asset, click on the  Delete Asset button on the asset item:

2

To modify an asset, simply click on the edit icon as below:

Where does this entry appear in the financial statements?

Assets can be entered as Current Assets or Long-term Assets, and these two entries appear in different parts of the financials. In the Profit and Loss table, only the depreciation and amortization of an asset will be listed, as this is the only part of the asset that's considered an expense of daily operations. 

The amortization of a current asset will appear under Operating Expenses in the P&L, as shown below:

The depreciation of a long-term asset will appear in the P&L under Depreciation & Amortization, as shown below:

In the Balance Sheet, a current asset will appear as "Other Current Assets," with its value decreasing month to month as the asset is amortized:

A long-term asset appears in the Balance Sheet as shown below. You can see the value of the asset and the depreciation on separate lines:

In the Cash Flow statement, both short-term and long-term assets will appear as shown below. The value of the asset purchase appears as a negative cash flow, and the Depreciation & Amortization appears as a positive cash flow. This doesn't mean depreciation is a source of income. Instead, the positive depreciation amounts are adjustments to the cash value of the asset:

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us