How to calculate depreciation using the straight line method in Excel

Our Excel training videos on KZbin cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday.
For details you can visit our website:
www.familycomputerclub.com
Depreciation is an important aspect in any business. Businesses calculate the depreciation of their assets, deduct the depreciation amount from their net incmome and then pay taxes on the final income after depreciation. We describe here the straight line method of depreciation calculation in Microsoft Excel.

[@janislarson6826]

Wow fully underst00d now I almost quit study accounting.. You have been great... thank u Bless you!

[@FredaThomas]

this is very helpful, and you have explained it in such a easily understood manner. Thank you very much!!!

[@InstTaxSolutionsLLC]

This video shows how helpful depreciation is for businesses with their income and taxes.

[@allanahleahy544]

thank you, this helped with my assignment👍🏻

[@Exceltrainingvideos]

You're very welcome!

[@elizabethwelch5333]

Thank you very much

[@Exceltrainingvideos]

You are welcome

[@utube11ization]

Awesome very educational..thankx

[@truthceez]

Just terrific!

[@zabdi786]

Wow...this helps a lot. And, it makes me miss Pakistan. :P

[@malihakhan5510]

I have one question that at the end of the year we passed some adjustments so dep exp adjust entry pass by which amount?

[@maryamaltaf3118]

Best, Thanks sir to clear our concept

[@Exceltrainingvideos]

So nice of you.

[@nguyen6021]

Wow, so strong

[@samyakonmars]

Adding one more point in the Num. if it is asked that equipment is anticipated to work 2000 hrs in a year. Then how we will calculate it?

[@akramkhan-mr1mg]

NICE

[@robinfelix9586]

surely it's helpful, very nice voice, n amazing skills of teaching, thanks a lot Sir.

[@kanikramvarma8726]

robin felix

[@borinseng1910]

how can we define the salvage value?

[@Exceltrainingvideos]

+Borin Seng The estimated value that an asset will realize upon its sale at the end of its useful life.

[@borinseng1910]

Thanks,

[@halboug]

Thank you very much