DB Function in Excel

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


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
Svtuition: DB Function in Excel
DB Function in Excel
Not found any lecture VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES Lectures View All RECOMMENDED FOR YOU Category ARCHIVE SEARCH ALL Lectures Not found any lecture match with your request, please help to write it and send it to our email at vinod@svtuition.org for making this website free accounting and finance encyclopedia. Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock