# How to calculate asset depreciation with DDB function in Excel Published

on If you want to learn how to calculate an Assets depreciation in Excel, keep reading the following article.

When we talk about depreciation, we refer to something similar to an operating expense, where they will be taken into account before calculating the net profits of a company or company.

It is carried out in order to know the depreciation that some tangible asset of the company can reach, a very important calculation that must always be made for the financial statement, to later know your economic situation, and if it is profitable to think about the corporate advantages of the global market (something many entrepreneurs aspire to one day reach).

In accounting matters, depreciation is a calculation that must be carried out after a set time has elapsed, in order to know how much an asset depreciates from time to time.

## How to calculate asset depreciation using Excel’s DDB function?

Calculating depreciation by the double decrease method is calculated at an accelerated rate, that is, the depreciation is greater during the first period and decreases in the succession of the following periods. Calculating is very simple, even more so if you use the Excel sheet to carry it out, but to use this syntax you must specify the following arguments:

• Cost. Refers to the initial amount
• Residual value. The final residual value of depreciation, which can even be 0.
• Lifetime. It is the period during which the property can be depreciated. This can be known as the useful life of the property.
• Period. It is the time for which you want to calculate the depreciation. The resulting values ​​must use the same units as the previous point.
• Factor. The rate of depreciation of the balance. Omitting this value immediately assumes that its value is 2. But it is important to remember that this can only be calculated if the numbers are positive.

## Excel formula for depreciation with DDB

In the DDB function, a specific formula is used to calculate the depreciation of a period: Min (cost – total depreciation of previous periods) * (factor/life) (cost / residual – total depreciation of previous periods). To understand it a little more, the following example will be used:

• Initial cost: \$ 2,400
• Residual value: \$ 300
• Life (years): 10

The amounts of the three arguments must be placed in boxes A2, A3, and A4 correspondingly if the following example is to be understood in itself. Therefore, the following formula would apply = DDB (A2, A3, A4 * 365, 1)

This would be the amortization on the first day of the year, assuming the factor is 2. Your result would be \$ 1.32. = DDB (A2, A3, A4 * 12, 1, 2) . The first month’s amortization would be \$ 40.00 = DDB (A2, A3, A4, 1, 2) . With this, the amortization for the first year would be calculated, resulting in \$ 480.00 = DDB (A2, A3, A4, 2, 1, 5).

But in this case, to get the amortization of the second year, a factor of 1.5 was used, instead of 2. Obtaining, as a result, \$ 306.00. = DDB (A2, A3, A4, 10)

This would be the final formula to calculate the depreciation of the lifetime that we wanted to find, and in the case of this example, the total depreciation of those ten (10) years was \$ 22.12. Taking into account that for this formula the factor remained at 2.

For many people, it may seem a bit confusing to apply the DDB formula, but the truth is that it is very easy to use as soon as you get the hang of it, although you can also copy the formulas shown here and paste them into the Excel sheet to obtain results quickly.

In accounting issues, payroll calculations, simple discounts or depreciation, is something that is quickly learned to remove manually, so using Excel makes the task much easier to perform. With excel you can also make forecasts or sales projections of a product to study the finances.

# Determining Lowest and Highest Values ​​in Microsoft Excel Published

on Determining the lowest and highest values ​​requires a special formula or function that you can do with Microsoft Excel.

Determining the highest value can be done easily when there is very little data, but what about when there is a lot of data?

For that you need an Excel formula.

How to? Come on, follow this tutorial in full.

## HOW TO DETERMINE THE LOWEST AND HIGHEST VALUE

To do this, the formula you can use is MAX and MIN.

As the name implies, MAX is to find the highest value, while MIN is to find the lowest value.

Meanwhile, for writing the formula, the highest value is MAX(Number1; [Number2]; …)

Number is the range of numbers for which you want to know the highest value.

## Finding Lowest Value

Now, to find the lowest value you can use the formula MIN(Number1; [Number2]; …).

As usual number is a range of numbers, or the same when you look for the previous highest value.

How, very easy isn’t it? Although it looks complicated, Excel formulas will really make things easier for you.

That’s all and good luck.

# How to Use Automatic Ranking Formulas in Excel Published

on The formula for finding rankings in Excel is also available for those of you who want to rank in a group.

This one formula is a formula that is quite widely used, especially in the field of education.

Well, here’s an Excel formula tutorial to find rankings.

## RANKING FORMULAS IN EXCEL

There are several formulas you can use that basically have the same function for finding rankings.

And the first formula you can use is = RANK(Number;Reference;[order]).

The order in the formula is the number 0 or 1 as a ranking reference.

When you want to sort the value in descending or descending order, fill it with 0 or empty, while when you want to give the value ascending then fill it with the number 1.

But you also need to know that the formula will also give the same rank when there are the same values.

To overcome this you can use this one formula.

## RANK.AVG Rumus formula

The usage is still the same, only the formula is different which becomes RANK.AVG(Number; Reference; [order])

And when you apply it and there is the same value, it will produce an average ranking of that value.

So, for an assessment, this formula is the most appropriate.

Well, if you look at the example, a value of 70 gets a rating of 7.5 while a value of 75 gets a rating of 5.5.

That’s how the ranking formula in Excel works.

That’s all and good luck.

# How to Calculate Workdays with Excel Formulas Published

on Calculating weekdays will be very effective when you use the easiest formula in Microsoft Excel.

Most people are lazy to use Excel for their daily needs, even though this software is very useful.

Then what about the formula for finding the working day? It’s really easy. Here’s the full tutorial.

## HOW TO CALCULATE WORKING DAYS

You can do this with the NETWORKDAYS formula which only counts weekdays, without weekends.

But you also need to know that the weekends here are Saturday and Sunday.

For example, if you want to determine the weekend with another day, then there is a different formula which I will discuss later.

The formula for writing is =NETWORKDAYS(Start_Date; End_Date, [Holiday_Day])

For more details, consider the following image.

In this example, the number of effective working days is 87 days, where Saturday and Sunday are not included.

## NETWORKDAYS.ITL

Well, for this formula you can determine the time off or weekend as needed.

The formula for writing is =NETWORKDAYS.INTL(Start_Date; End_Date; [Weekend_End]; [Holiday_Holiday])

The difference in this formula is that [weekends] are used to exclude and treat as weekdays.

If you do not fill it in, it will be considered as the previous formula.

You can also use a holiday code with a seven-character text string consisting of a combination of the text numbers 1 and 0 to represent Monday-Sunday.

So what happens is the number 1 represents holidays while the number 0 for workdays.

For example, on weekends or holidays Saturday and Sunday, the string code you are using is 0000011.

As for working days only Monday, Tuesday and Thursday or Wednesday, Friday, Saturday and Sunday off, the code used is 0010111.

That’s all and good luck.