I am trying to build this table in the Lists using a formula
value of 8,350,000 is calculated by doing 16,700,000 / 2 using a (Half-year rule)
value of 15,030,000 is calculated by doing 6,680,000 + 16,700,000 / 2
CCA rate is calculated by taking the Beginning UCC and Multiplying it by the Rate of .20
UCC can be calculated using a formula UCCn = C×(1 – d/2)×(1 – d)n-2 = 16,700,000×(1 – 0.2/2)×(1 – 0.2)^5-2
I was only able to calculate only 1 value output it in the list using {(Ans(1))*(1-(.20/2))} ->L1 (The value of Ans is 16700000)
Installation cost = 16,700,000 CCA Rate = 20%
Year | Beginning UCC | CCA | Ending UCC |
1 | 8,350,000 | 1,670,000 | 6,680,000 |
2 | 15,030,000 | 3,006,000 | 12,024,000 |
3 | 12,024,000 | 2,404,800 | 9,619,200 |
4 | 9,619,200 | 1,923,840 | 7,695,360 |
5 | 7,695,360 | 1,539,072 | 6,156,288 |