Today, I spent my time to know db function in excel. It is easy but I forgot to use it. My problem is of using the figure of period and month in its formula.

Formula of db is

=DB(initial value; salvage value; useful life; period; month)

It can be used through financial function db. Its full form is declining balance. After some hard work, I understood that to show period and month is very necessary.

Because this depreciation is calculating on the current balance not on the original cost, so, period will be the first year, second year, third year or the year in which we are calculating the depreciation. Second to show the month is also very important. We know the 12 months are equal to one year. It means whether we are calculating the depreciation of first year or depreciation of 9th year, our first year is 12 months because we have bought same asset at the beginning of first year. So, month will always be the 12. If we have not bought at the beginning of the year, we have to mention the months. For example, we have bought the asset at the end of 7th month. It means, every calculation of depreciation under db, we will use 3 because 3 months are using the asset. Ok, if you want to learn more, see following video tutorial.

.
Share above Content to Your Friends

Name

accounting Accounting Concepts Accounting Course Accounting Education accounting equation Accounting Solutions Algebra Answer the Questions and Become Master Balance Sheet bank Bodybuilding Education Business Business Education Business Environment Business Solutions CA Calculus cameras car Car Driving Course Career Solutions carpentry Class 10 Maths Class 9 Maths Computer Computer Basics Computer Hardware Computer Networking Computer Software Computer Solutions cooking education Corporate Accounting Corporate Law cost cost accounting CSE Dailymotion depreciation determinant drawing Driving Education e-accounting earn money Economics Education Education Education Solutions Electronics Email Events Examination Finance Education Finance Solutions financial Financial Accounting FIR Football Gambling Gambling Addiction Goldsmith Google Adsense GST Guest Writers Health Education Help History Home Building Home Maintenance amp; Repair Index Number India Indian Language Inspiration insurance internal audit Internet Internet Forum Jobs amp; Careers Journal journal entries journal entry Kenya Laptop Basics Law Education Law Solutions Learning Lecture Legal Education Linear algebra Linear Programming Malaysia Management Accounting Management Education Management Solutions Marketing Education Mathematics Education matrices Medical and Surgery Education Mobile motivation MS Excel Nepal Nigeria organisation Other Pakistan Personal Finance Philippines Photography Photoshop Software Picture Plumbing Education Probability Profiles provision real estate rectification Relationships amp; Family Religious Studies Result Sahas Saudi Arabia Science Education Self-Learning Skating Slideshow Solution Spiritual Education Sports Statistics Statistics Education stock Story svtuition Tablet Education Tally Tally Solutions Tally.ERP 9 tax Tax Solutions teaching Teaching Education Tech Simplify Test Testimonials Travel Trigonometry tuition TV Shows UK USA variance analysis VAT vector Video Video on Demand videos Vocational Education Web design website Welding Skills Wife Window Movie Maker Wordpress working capital Youth youtube
false
ltr
item
Svtuition: DB Function in Excel
DB Function in Excel
https://i.ytimg.com/vi/lxonnpZ28a4/hqdefault.jpg
https://i.ytimg.com/vi/lxonnpZ28a4/default.jpg
Svtuition
http://www.svtuition.com/2012/06/db-function-in-excel.html
http://www.svtuition.com/
http://www.svtuition.com/
http://www.svtuition.com/2012/06/db-function-in-excel.html
true
3065238051582539150
UTF-8