To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109420 Issue #|109420 Summary|financial function VDB returns incorrect values Component|Spreadsheet Version|OOo 3.2 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|dcameron
------- Additional comments from [email protected] Thu Feb 18 22:19:21 +0000 2010 ------- The financial function VDB incorrectly calculates depreciation amounts under the following conditions: Cost = $10,000 Salvage = $0 Life = 7 Factor = 1.5 (150% Declining Balance Half Year Convention) A comparison between the results given by the VDB function and that found using Excel or the Table A-14 from IRS Publication 946 is shown below. Year Start End VDB Excel IRS 1 0.0 0.5 $1017.43 $1071.43 $1071 2 0.5 1.5 $1913.27 $1913.27 $1913 3 1.5 2.5 $1503.28 $1503.28 $1503 4 2.5 3.5 $1224.89 $1224.89 $1225 5 3.5 4.5 $1237.39 $1224.89 $1225 6 4.5 5.5 $1237.39 $1224.89 $1225 7 5.5 6.5 $1237.39 $1224.89 $1225 8 6.5 7.0 $618.70 $612.45 $613 The total depreciation over the life of the asset calculated by VDB (openoffice) is $10043.75, it should be $10000.00. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
