Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Intermediate
In Tax Depreciation calculations, what function could be used easily to transpose the capital expenditure amounts (sections highlighted in red)?
OFFSET
MATCH
IF
Don’t know
2
Intermediate
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
Total accounting depreciation charged so far
Opening Tax Written Down Value
Don’t know
3
Intermediate
What is the purpose of the cell highlighted in red?
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
It represents the total asset value remaining at the end of the forecast period of the model
It calculates the aggregate Tax Written Down Values
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement