Fixed Asset Register: SLN, Accumulated Depreciation, NBV & DB
This lesson is part of the course
In this lesson
You complete Quillmark's fixed asset register (annual straight-line charge, accumulated depreciation capped at the depreciable amount, net book value) and build a declining-balance schedule for the van.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Trial Balance from a GL Export: SUMIFS & the Debits = Credits Check Locked
- Mapping Accounts to Financial Statement Lines with XLOOKUP Locked
- Bank Reconciliation with Matching Flags: COUNTIFS on Reference and Amount Locked
- Accounts Receivable Ageing: Days Past Due, Buckets with IFS & a Chart Locked
- Prepayments & Accruals: a Monthly Release Schedule Locked
- Fixed Asset Register: SLN, Accumulated Depreciation, NBV & DB Locked
- Budget vs Actual: Variance %, Favourable / Unfavourable & Materiality Flags Locked
- Month-End Close: Checklist Deadlines with WORKDAY & the Intercompany Check Locked