How to calculate depreciation with the AMORTIZ.PROGRE function in Excel (example)

Who I am
Catherine Le Nevez
@catherinelenevez
EXTERNAL REFERENCES:

vgr.com gamedesigning.org Reddit.com

Author and references

Excel has multiple tools for managing and organizing data. From creating a daily agenda in Microsoft Excel to functions like AMORTIZ.PROGRE for financial calculations. That is why in this article we will teach you how to calculate depreciation with the AMORTIZ.PROGRE function in Excel

    What is the DEPRECIATION function in Excel?

    If you ask yourself like calculate depreciation With the SHOCKPROG function in Excel, you can apply a procedure that will be very useful to you. Often this function is used to get the depreciation calculation for each accounting period.



    Attributes of the DEPRECIATION function in Excel

    To calculate depreciation with the AMORTIZ.PROGRE function in Excel, you need a series of parameters to tell the application which ones are the arguments required by this function . Speaking of dates, with Excel we can also easily calculate future or due dates.

    How to calculate depreciation with the AMORTIZ.PROGRE function in Excel

    If you want to learn how to calculate depreciation with the AMORTIZ.PROGRE function in Excel, you must have this application that is part of the Office package available on the official Microsoft website, as well as knowing perfectly the syntax of that function and follow a procedure that we will explain later.

    What is the syntax of the SHOCKPROG function?

    The syntax of the SHOCKPROG function in Excel includes the following parameters: the cost of the asset or its purchase date, the end date of the first period, the residual value of the asset at the end of its useful life, the period, the depreciation rate and the annual basis. With all these elements you can easily calculate depreciation in Excel.



    To perform accurate calculations, it's a good idea to learn how to use all Excel formulas in a spreadsheet. For this reason, syntax is relevant for understanding the behavior of functions.

    Read How to fix NSIS boot installation error on my Windows PC

    The 'Annual basis' and 'Depreciation rate' parameters

    The 'base' parameter is optional and depends on a numerical value between 0 and 4. The values ​​"0" and "2" are for 360 days in the North American system, "1" is linked to the current base, "3" for 365 days a year and "4 "For 360 days a year according to the European system.

    The "depreciation rate" on the other hand varies according to the life of the asset. If the asset is between 3 and 4 years old, the rate is 1,5. While an asset between 5 and 6 years has a rate of 2 and those assets over 6 years have a depreciation rate of 2,5.

    Calculate depreciation with the AMORTIZ.PROGRE function in Excel

    if devi calculate depreciation with the AMORTIZ.PROGRE function in Excel , you must enter in a spreadsheet: the value or cost of the asset, the date of purchase of the asset, the end date of the first period, the residual value, the period, the depreciation rate and the annual basis.

    Assuming that each of these values ​​are included in cells B1, B2, B3, B4, B5, B6, B7 and B8; place the cursor in the cell where you want to see the result, write the formula = AMORTIZ.PROGRE (B1; DATE (year; month; day); DATE (year; month; day); B4; B5; B6; B7; B8) and press "Enter".


    Tips for entering the formula

    È necessario use the DATA function because errors can occur when users enter dates in text format. The arguments to the date function always follow the following order: year, month, and day separated by ";" (without quotes)


    Insert the function into the formula bar

    You can use the formula bar for calculate depreciation with the AMORTIZ.PROGRE function in Excel . To do this, click on "fx". Locate the "Financial" category and click on "AMORTIZ.PROGRE". Select each parameter from the spreadsheet and press the "OK" button.


    Read How to recover my hacked Facebook account, without password or with my phone number

    The formula bar will allow you to enter as many functions as you want, and later, you can know the function used in a cell with the UDF function if you need it.

    add a comment of How to calculate depreciation with the AMORTIZ.PROGRE function in Excel (example)
    Comment sent successfully! We will review it in the next few hours.