{"id":6837,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/vdb\/"},"modified":"2021-02-26T08:16:10","modified_gmt":"2021-02-26T08:16:10","slug":"vdb","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/vdb\/","title":{"rendered":"VDB"},"content":{"rendered":"<p>La fonction VDB, qui signifie Valeur D\u00e9gressive D\u00e9gressive, est un outil crucial pour la gestion des amortissements dans Excel et Google Sheets. Cette fonction est utilis\u00e9e pour calculer l&rsquo;amortissement d&rsquo;un bien sur une p\u00e9riode donn\u00e9e selon la m\u00e9thode de l&rsquo;amortissement d\u00e9gressif double.<\/p>\n<h2>Syntaxe et exemples<\/h2>\n<p>Pour utiliser la fonction VDB, vous devez fournir plusieurs param\u00e8tres essentiels:<\/p>\n<ul>\n<li><strong>Co\u00fbt initial :<\/strong> Le prix d&rsquo;achat de l&rsquo;actif.<\/li>\n<li><strong>Valeur de sauvetage :<\/strong> La valeur r\u00e9siduelle de l&rsquo;actif \u00e0 la fin de sa p\u00e9riode d&rsquo;utilisation pr\u00e9vue.<\/li>\n<li><strong>Dur\u00e9e de vie :<\/strong> La dur\u00e9e totale pendant laquelle l&rsquo;actif doit \u00eatre amorti.<\/li>\n<li><strong>P\u00e9riode initiale :<\/strong> Le d\u00e9but de la p\u00e9riode pour laquelle vous souhaitez calculer l&rsquo;amortissement.<\/li>\n<li><strong>P\u00e9riode finale :<\/strong> La fin de la p\u00e9riode pour laquelle l&rsquo;amortissement doit \u00eatre calcul\u00e9.<\/li>\n<li><strong>Facteur :<\/strong> Le taux d&rsquo;amortissement d\u00e9gressif. Par d\u00e9faut, ce taux est de 2, ce qui correspond \u00e0 l&rsquo;amortissement d\u00e9gressif double.<\/li>\n<\/ul>\n<pre> <code> =VDB(co\u00fbt, valeur_de_sauvetage, dur\u00e9e_de_vie, p\u00e9riode_initiale, p\u00e9riode_fin, [facteur], [no_switch]) <\/code> <\/pre>\n<h2>Exemple concret<\/h2>\n<p>Prenons l&rsquo;exemple d&rsquo;une machine achet\u00e9e pour 10 000\u20ac, avec une valeur r\u00e9siduelle pr\u00e9vue de 1 000\u20ac et une dur\u00e9e de vie de 5 ans. Vous souhaitez conna\u00eetre l&rsquo;amortissement de cette machine \u00e0 la fin de la premi\u00e8re ann\u00e9e.<\/p>\n<pre> <code> =VDB(10000, 1000, 5, 0, 1) <\/code> <\/pre>\n<p>Ce calcul indique le montant de l&rsquo;amortissement pour la premi\u00e8re ann\u00e9e, utilisant la m\u00e9thode d&rsquo;amortissement double d\u00e9gressif.<\/p>\n<h2>Applications pratiques<\/h2>\n<p>La fonction VDB est particuli\u00e8rement utile dans divers sc\u00e9narios \u00e9conomiques et financiers :<\/p>\n<ul>\n<li><strong>Gestion d&rsquo;entreprise :<\/strong> Elle aide les entreprises \u00e0 d\u00e9terminer avec pr\u00e9cision l&rsquo;amortissement d&rsquo;actifs co\u00fbteux, ce qui est essentiel pour la planification financi\u00e8re et fiscale.<\/li>\n<li><strong>Cas d&rsquo;amortissement partiel :<\/strong> Pour un actif acquis en cours d&rsquo;exercice fiscal, il est souvent n\u00e9cessaire de calculer l&rsquo;amortissement pour une partie de l&rsquo;ann\u00e9e, ce que la fonction VDB g\u00e8re efficacement.<\/li>\n<\/ul>\n<p>Amortissement partiel en exemple :<\/p>\n<p>Reprenons la machine achet\u00e9e \u00e0 mi-ann\u00e9e. Vous devez calculer son amortissement de juillet \u00e0 la fin de l&rsquo;ann\u00e9e.<\/p>\n<pre> <code> =VDB(10000, 1000, 5, 0.5, 1) <\/code> <\/pre>\n<p>Dans cet exemple, la p\u00e9riode initiale est de 0.5, couvrant la moiti\u00e9 de la premi\u00e8re ann\u00e9e, tandis que la p\u00e9riode finale est 1, indiquant la fin de la premi\u00e8re ann\u00e9e compl\u00e8te.<\/p>\n<p>Cette m\u00e9thode offre une grande flexibilit\u00e9 et pr\u00e9cision dans le calcul de l&rsquo;amortissement, rendant la fonction VDB indispensable aux responsables financiers et comptables.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Renvoie l\u2019amoRtissement d\u2019un bien pouR une p\u00e9Riode sp\u00e9cifi\u00e9e ou paRtielle en utilisant une m\u00e9thode de l\u2019amoRtissement d\u00e9gRessif \u00e0 taux fixe<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[311],"tags":[],"class_list":["post-6837","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Fonction VDB dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction VDB d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;utilisation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/fr\/vdb\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction VDB dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction VDB d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/vdb\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:16:10+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction VDB dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/vdb\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/vdb\/\",\"name\":\"Fonction VDB dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:16:10+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction VDB d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/vdb\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/vdb\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/vdb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Finances\",\"item\":\"https:\/\/functiontranslator.com\/fr\/finances\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"VDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction VDB dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction VDB d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/fr\/vdb\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction VDB dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction VDB d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/vdb\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:16:10+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction VDB dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/vdb\/","url":"https:\/\/functiontranslator.com\/fr\/vdb\/","name":"Fonction VDB dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:16:10+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction VDB d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/vdb\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/vdb\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/vdb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Finances","item":"https:\/\/functiontranslator.com\/fr\/finances\/"},{"@type":"ListItem","position":3,"name":"VDB"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6837","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6837"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6837\/revisions"}],"predecessor-version":[{"id":29846,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6837\/revisions\/29846"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6837"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6837"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6837"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}