CCA_Present_Value_Custom_Function_Excel_Developer Go to the developer tab in Excel. If you don't have it, right click on the ribbon in Excel, choose 'Customize Ribbon', check the Developer tab and click OK.

-> Go to the Developer tab -> click Visual Basic -> to Insert toolbar -> click Module ->

-> Then copy and paste the code into the window.

The custom function should work at that point.

-> When saving, you must save it as a macro enabled workbook to access the custom formula in other workbooks

Cost_Of_Asset = Initial Cost of Asset

Corp_Tax_Rate = Marginal Tax Rate

Salvage_Value = Salvage Value of Asset

CCA_Tax_Rate = Capital Cost Allowance Rate

Discount_Rate = Required Rate of Return

Number_Of_Periods = How long you plan to use the Asset