You can view the original article this reader is referring to here. You can use a built-in Excel function to calculate the modified accelerated cost recovery system (MACRS) depreciation, but you need ...

Exhibit 1 shows how the LOOKUP command could extract the appropriate depreciation rate from a MACRS rate table and place it in cell I5: The choice of VLOOKUP shows the table is organized vertically.

Microsoft Excel has built-in functions for multiple depreciation methods ... function), and units of production method (requiring a template outside the Excel brand). Suppose company XYZ bought ...