Reviewing Asset Depreciation Calculation Results

This chapter provides an overview of what if depreciation and discusses how to:

• Perform what if depreciation modeling.

• Load the new book value depreciation results into a spreadsheet program.

Understanding What If Depreciation

PeopleSoft Asset Management provides you with the ability to perform what if depreciation simulation modeling and to load the net book value results into a spreadsheet program for analysis.

Using what if depreciation simulation modeling, you can determine, evaluate, and compare the depreciation amounts for assets if you were to change all or some of the depreciation parameters. For example, you may want determine the effect on depreciation if you change the prorate convention from mid-month to mid-quarter, or if you change the depreciation method from straight line to sum of the years digits. You can experiment with depreciation to determine what the effect on depreciation would be without changing the actual depreciation parameters for an asset.

Another useful benefit of the What If Depreciation feature is to project the depreciation if you add an asset and run the actual depreciation program. For example, you can create an asset and run the What If Depreciation program rather than running the actual depreciation program. You can then see what the depreciation amount for the asset would be, go back and modify the depreciation parameters accordingly, and then perform the actual depreciation.

To perform what if depreciation simulation, the assets must already exist in the system. Add at least one asset to perform the simulation. The What If Depreciation feature uses only Add and Transfer In transactions for modeling.

Performing What If Depreciation

To generate what if depreciation simulation:

• Perform what if depreciation.

• View what if depreciation results.

Pages Used to Perform What If Depreciation

Performing What If Depreciation

Access the What If Depreciation page (Asset Management, Depreciation, What-If Scenarios, Request, What If Depreciation).

Save the what if depreciation changes that you make and run the program. If you want to run multiple modeling comparisons using the same range of assets, use different run control IDs.

The What If Depreciation page uses the AM_DEPR_COMP application engine program to run simulated depreciation instead of the actual depreciation program (AM_DEPR_CALC).

Process Scheduler runs the AM_DEPR_COMP application engine process at user-defined intervals.

Viewing What If Depreciation Results

Access the What If Depreciation Results page (Asset Management, Depreciation, What-If Scenarios, Review).

You can view the results of what if depreciation using this What If Depreciation Inquiry component or you can run a query to review results.

Using either method, examine the depreciation results to see the consequences of the depreciation parameter modifications that you made, or to see the projected depreciation if you ran depreciation for an asset. You can run the results of the query to Excel. Go back and modify the depreciation results accordingly, and then run the actual depreciation program (AM_DEPR_CALC), if applicable.

Loading the Net Book Value Table for Reporting

You can load the net book value depreciation results into a spreadsheet program.

Page Used to Load the Asset Net Book Value Reporting Table

Loading Depreciation Results for Reporting

Access the Net Book Value Table page (Asset Management, Financial Reports, Load Reporting Tables, Net Book Value Table, Net Book Value Table).

Specify the as of fiscal year (in the As Of FY field) and accounting period (in the Period field).

Once you have loaded the Net Book Value Table, you can run any of the following reports:

• Asset NBV by ChartField (AMNB1000).

• Asset NBV by Category (AMNB1010).

• Asset NBV by Location (AMNB1030).