Hi Everyone, how would you structure a depreciation formula with the below?
Asset = $1,000,000
• Year 1: 0
• Year 2: 30% ($300,000)
• Year 3: 30% ($300,000)
• Year 4: 30% ($300,000)
• Year 5: 10% ($100,000)
I'm thinking of using the End Period Number and Next Depreciation Method to do it, but was wondering if there is a simpler way?