Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DB Function?
I have a list of assets in column A.
Column B contains a historical date (Jan, 2008) Column C contains current months date (Nov, 2009). Column D shows the period difference (B-C) = 21 Now here comes the fun part, I need to know what the NBV of the asset is using 20% declining balance). This formula will be copied to multiple assets, so it needs to be dynamic. I've tried everything I can think of :S Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DB Function?
cjwenngatz,
NBV should be simply the price you paid reduced by the decline multiplied by the number of years that you have had it, limited to the life of the asset (since you have age in months, you would use months). For a 20% annual decline, that would be a 5 year life, so perhaps =E2*(1-0.2*(MIN(D2,60)/12)) where E2 has the initial book value, and D has the age of the asset in months. 60 is five years in months. Of course, you should look at what this returns versus what you expect.... HTH, Bernie MS Excel MVP wrote in message ... I have a list of assets in column A. Column B contains a historical date (Jan, 2008) Column C contains current months date (Nov, 2009). Column D shows the period difference (B-C) = 21 Now here comes the fun part, I need to know what the NBV of the asset is using 20% declining balance). This formula will be copied to multiple assets, so it needs to be dynamic. I've tried everything I can think of :S Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |