writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 12:
Line 12: − DDB(C, Salvage, L, P, NoMonths)+ − + − + − +
no edit summary
== Description ==
== Description ==
DB(C, Salvage, L, P, NoMonths)
*Depreciation is the decrease in value of assets. Depreciation of an asset is highest in the first period and decreases in successive periods.
*Depreciation is the decrease in value of assets. Depreciation of an asset is highest in the first period and decreases in successive periods.
*DB() calculates the depreciation using the fixed-declining balance method.
*DB() calculates the depreciation using the fixed-declining balance method.
*If <math>Salvage</math> <0, Calci displays #N/A error message.
*If <math>Salvage</math> <0, Calci displays #N/A error message.
*If <math>C</math> ,<math>L</math>, <math>P</math>, <math>F</math> <=0, Calci displays #N/A error message.
*If <math>C</math> ,<math>L</math>, <math>P</math>, <math>NoMonths</math> <=0, Calci displays #N/A error message.
*If <math>P</math> is not an integer, Calci rounds up the value (e.g. 4.2 is rounded up to 5).
*If <math>P</math> is not an integer, Calci rounds up the value (e.g. 4.2 is rounded up to 5).
== Examples ==
== Examples ==
1. =DB(20000,2000,5,4.5,2) : Displays '''1338.5030444492834''' as a result.
1. =DB(20000,2000,5,4.5,2) : This example is used to find the yearly depreciation of an asset that costs $20,000 at the start of year 4.5, and has a salvage value of $2,000 after 5 years. The depreciation calculation starts 2 months into year 1. <br/>Displays '''2,757.7148''' as a result.
2. =DB(10000,1000,5,1,6) : Displays '''1338.5030444492834''' as a result.
2. =DB(10000,1000,5,1,6) : This example is used to find the yearly depreciation of an asset that costs $10,000 at the start of year 1, and has a salvage value of $1,000 after 5 years. The depreciation calculation starts 6 months into year 1. <br/>Displays '''1,845.00''' as a result.
==Related Videos==
==Related Videos==