Mais, tout crédit, quel qu'il soit, doit être remboursé. Si la cellule de la valeur résiduelle de la période précédente est vide, alors notre période sera vide (car cela signifie que c’est la fin de notre amortissement linéaire dans Excel).Si ce n’est pas le cas et si la valeur résiduelle est proche de 0, alors la période est vide (car on arrive à la fin).
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/54\/Prepare-Amortization-Schedule-in-Excel-Step-1-Version-3.jpg\/v4-460px-Prepare-Amortization-Schedule-in-Excel-Step-1-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/54\/Prepare-Amortization-Schedule-in-Excel-Step-1-Version-3.jpg\/v4-728px-Prepare-Amortization-Schedule-in-Excel-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/54\/Prepare-Amortization-Schedule-in-Excel-Step-1-Version-3.jpg\/v4-460px-Prepare-Amortization-Schedule-in-Excel-Step-1-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/54\/Prepare-Amortization-Schedule-in-Excel-Step-1-Version-3.jpg\/v4-728px-Prepare-Amortization-Schedule-in-Excel-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/7a\/Prepare-Amortization-Schedule-in-Excel-Step-2-Version-3.jpg\/v4-460px-Prepare-Amortization-Schedule-in-Excel-Step-2-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7a\/Prepare-Amortization-Schedule-in-Excel-Step-2-Version-3.jpg\/v4-728px-Prepare-Amortization-Schedule-in-Excel-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/49\/Prepare-Amortization-Schedule-in-Excel-Step-3-Version-3.jpg\/v4-460px-Prepare-Amortization-Schedule-in-Excel-Step-3-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/49\/Prepare-Amortization-Schedule-in-Excel-Step-3-Version-3.jpg\/v4-728px-Prepare-Amortization-Schedule-in-Excel-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/14\/Prepare-Amortization-Schedule-in-Excel-Step-4-Version-3.jpg\/v4-460px-Prepare-Amortization-Schedule-in-Excel-Step-4-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/14\/Prepare-Amortization-Schedule-in-Excel-Step-4-Version-3.jpg\/v4-728px-Prepare-Amortization-Schedule-in-Excel-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/12\/Prepare-Amortization-Schedule-in-Excel-Step-5-Version-3.jpg\/v4-460px-Prepare-Amortization-Schedule-in-Excel-Step-5-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/12\/Prepare-Amortization-Schedule-in-Excel-Step-5-Version-3.jpg\/v4-728px-Prepare-Amortization-Schedule-in-Excel-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a9\/Prepare-Amortization-Schedule-in-Excel-Step-6-Version-3.jpg\/v4-460px-Prepare-Amortization-Schedule-in-Excel-Step-6-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a9\/Prepare-Amortization-Schedule-in-Excel-Step-6-Version-3.jpg\/v4-728px-Prepare-Amortization-Schedule-in-Excel-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/1a\/Prepare-Amortization-Schedule-in-Excel-Step-7-Version-2.jpg\/v4-460px-Prepare-Amortization-Schedule-in-Excel-Step-7-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1a\/Prepare-Amortization-Schedule-in-Excel-Step-7-Version-2.jpg\/v4-728px-Prepare-Amortization-Schedule-in-Excel-Step-7-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/8e\/Prepare-Amortization-Schedule-in-Excel-Step-8-Version-2.jpg\/v4-460px-Prepare-Amortization-Schedule-in-Excel-Step-8-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8e\/Prepare-Amortization-Schedule-in-Excel-Step-8-Version-2.jpg\/v4-728px-Prepare-Amortization-Schedule-in-Excel-Step-8-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/22\/Prepare-Amortization-Schedule-in-Excel-Step-9-Version-2.jpg\/v4-460px-Prepare-Amortization-Schedule-in-Excel-Step-9-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/22\/Prepare-Amortization-Schedule-in-Excel-Step-9-Version-2.jpg\/v4-728px-Prepare-Amortization-Schedule-in-Excel-Step-9-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/96\/Prepare-Amortization-Schedule-in-Excel-Step-10-Version-2.jpg\/v4-460px-Prepare-Amortization-Schedule-in-Excel-Step-10-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/96\/Prepare-Amortization-Schedule-in-Excel-Step-10-Version-2.jpg\/v4-728px-Prepare-Amortization-Schedule-in-Excel-Step-10-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}