Maloney’s ACV Calculators
About: Maloney’s ACV Calculators consists of a set of three Excel spreadsheets designed to facilitate the calculation of Actual Cash Value (a.k.a., depreciated cost (new)) for a large number of items of depreciable personal property. Typical scenarios in which Maloney’s ACV Calculators are used include claims or litigation resulting from casualties such as flooding or fire in which a large number of property types are lost of damaged.
The ACV Calculators make use of the rates of depreciation for different property types found in the Joint Military/Industry Table of Weights and Depreciation Guide (JMITWDG) a jointly agreed upon table reached by consensus between the carrier industry and the military services. The JMITWDG is unique in that it lists percentage depreciation for the first year of use, for subsequent years, and a maximum depreciation allowed regardless of years in service. Some articles are assigned a flat rate of depreciation.
Three Excel Files: This product is a downloadable zipped file containing all three Excel files: Maloney’s ACV Calculator – Basic, Maloney’s ACV Calculator – Premium, and Maloney’s ACV Calculator – Premium Plus.
- Basic: Calculates ACV by subtracting total depreciation from total replacement cost (new).
- Premium: Calculates ACV by subtracting total depreciation from total replacement cost (new). Adds options to include thumbnail images. Allows for the use of two replacement costs and then averaging the two. Includes field for hyperlinks to web sites used as the basis for the replacement cost. Provides additional fields for more detailed description of property type and its value-relevant characteristics.
- Premium Plus: Same features as Premium. In addition, designed to make use of multiple worksheets in case property needs to be categorized such as by property type (e.g., electrical and electronic devices vs. upholstered furniture and other items made of fabric; or by claimant where multiple claimants exist).
Simply enter description, quantity, current replacement cost (new), and the rates of depreciation from the JMITWDG. The total ACV is calculated for you! Instructions included.
Author: David J. Maloney. Jr., AOA CM
Cost: $49 US
Delivery: After payment has been made, you will be redirected to a sign-in page. After signing in, you will be emailed a link and password to access the .zip formatted document.