Depreciation: SLN, DB, DDB and SYD
This lesson is part of the course
In this lesson
You build a depreciation schedule for Juniper's new roaster with four Excel methods and chart how they spread the cost over six years.
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
- FV, PV and Excel's Sign Convention Locked
- PMT, IPMT, PPMT and an Amortisation Table Locked
- RATE and NPER: Solve for the Rate and the Term Locked
- NPV vs XNPV: Discounting Dated Cash Flows Locked
- IRR vs XIRR vs MIRR Locked
- Depreciation: SLN, DB, DDB and SYD Locked
- EFFECT, NOMINAL and Day-Count Basics Locked
- Capstone: Investment Comparison Dashboard Locked