Back to lesson
1. In Tax Depreciation calculations, what function could be used easily to transpose the capital expenditure amounts (sections highlighted in red)?
2. In the illustration, cell J291 (highlighted in red) contains the formula =($H291-SUM($I291:I291))*IF(J$9=$I$285,1,$I$286). What does the reference $H291-SUM($I291:I291) represent?
Total tax depreciation charged so far
Opening Tax Written Down Value
Total accounting depreciation charged so far
3. What is the purpose of the cell highlighted in red?
It calculates the aggregate Tax Written Down Values
It represents the total asset value remaining at the end of the forecast period of the model
It is a row total summing all the depreciation charges for each period. It acts as a crude check and is compared to the total in the column to the left to ensure there is no over-depreciation
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement