Locked lesson.

## About this lesson

How to calculate Tax Depreciation.

## Exercise files

Download this lesson’s related exercise files.

Tax Part 5.xlsm123.7 KB Tax Part 5 - Solution.xlsm

124.7 KB

## Quick reference

### Tax Part 5

Understand Taxation

### When to use

When constructing a basic Financial Model

### Instructions

- To calculate the Tax Depreciation the capital expenditure needs to be entered into row 280 & 281
- The formula to calculate the depreciation on existing assets is
**=($H291-SUM($I291:I291))*IF(J$9=$I$285,1,$I$286)**- The formula to calculate the depreciation on new assets is
**=IF(J$9>=$E292,($H292-SUM($I292:I292))*IF(J$9=$I$288+$E292-1,1,$I$289),0)**- The Tax Depreciation is the sum of rows 291-296

Lesson notes are only available for subscribers.