Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Balance Depreciation - how many years?
Hi!
I need a formula that could calculate how many years it will take for a balanced depreciation to reach a certain target. My example I but a machine for $1.000. It's depreciated with 10% of it's balance annually. The end value is $1500. How many years will it take before it reaches this level? Best regards and thanks in advance for your help! Ricard |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Balance Depreciation - how many years?
"zalle78" wrote:
I but a machine for $1.000. It's depreciated with 10% of it's balance annually. The end value is $1500. How many years will it take before it reaches this level? I assume you meant the purchase price to be $10,000 or something else much greater than 1500. Put the following into C1, for example: =NPER(-10%,0,-10000,1500) Note the opposite signs used for PV (-10000) and FV (1500). Note that the annual rate is negative (-10%). As a check, put 10000 into B1, put =A1+1 into A2, and put =B1*(1-10%) into B2. Copy A2:B2 down through A18:B18 or until you see close to 1500, but slightly more (probably). In fact, you will get "exactly" 1500 (with some infinitesimal rounding error) if you put the following formula into B19: =B18*(1-10%)^(C1-A18). |
#3
|
|||
|
|||
Hello!
First - It's correct - it was supposed to say 10000, not 1000 That was exactly the formula I was looking for - I had found the control version that you post in the end, but didn't manage to figure out how to use the NPER-formula. Thanks a lot! Cheers, Ricard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is straight line depreciation and double line depreciation? | New Users to Excel | |||
Table w/straight-line depreciation & annual rate depreciation for. | Excel Worksheet Functions | |||
How do I subtract dates to get a number in years or years & month | Excel Discussion (Misc queries) | |||
rent received/balance owed/running balance spreadsheet | Excel Discussion (Misc queries) | |||
Overlay 4 years of data as a line on 4 years of columns for several x category labels | Charts and Charting in Excel |