Use the VBA Editor to create a new module. Type the following VBA code to createa custom depreciation function (be sure to include the blank lines after the firstline and before the last line). Save and exit the VBA Editor.
Function Depreciation (Value, Rate)
Depreciation = Value * Rate
End Function