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 |