Calculating using Lists

Forum Attachments

Summary:

Trying to used a formula and output the values in the Lists to create the table

Calculating using Lists

cyp2k 13 Nov 2009 21:50

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

Re: Calculating using Lists

Sleight 14 Nov 2009 03:17

I'm not quite sure what you are trying to find, so I wrote a program that calculates the whole table, if you give it that starting number. (16,700,000 in your case) It stores it into matrix [A], in the same format as the table that you posted. To view the results, simply choose "Edit" matrix [A] under the matrix menu. Or you could just select matrix [A] from the menu and hit enter to view it on the home screen.

Input "Installation cost?",I
Input "# of years?",Y
Input "CCA Rate?",C
{Y,3}→dim([A]
0→B
For(A,1,Y
B+I/2→[A](A,1)
[A](A,1)C→[A](A,2)
[A](A,1)-[A](A,2)→[A](A,3)
[A](A,3)→B
End

I punched this into my calculator and it works great!

It seems that you made a mistake in the table that you posted: for years 3, 4, and 5 you made the "Beginning UCC" the same as the previous year's Ending UCC, whereas in the post and for years 1 and 2 by taking the previous year's Ending UCC [phone]/2. My program uses this latter method. Please correct me if I'm wrong.

… not that I know anything about what a UCC or CCA is.

Hope this helps!

---

"Reality is that which, when you stop believing in it, doesn't go away."
-Philip K. Dick

Re: Calculating using Lists

cyp2k 14 Nov 2009 19:36

Thanks for the program, i was able to run this application but the table as posted is not an error as you mentioned. years 3, 4, and 5 which are the "Beginning UCC" are suppose to be the same as the previous year's Ending UCC. That is the way the table works.

Re: Calculating using Lists

Sleight 15 Nov 2009 00:36

So from year 3 on, the beginning UCC is the previous year's ending UCC? If that is so then this program should give a more accurate table.

Input "Installation cost?",I
Input "# of years?",Y
Input "CCA Rate?",C
{Y,3}→dim([A]
0→B
For(A,1,Y
If A<3
B+I/2→[A](A,1)
If A>2
[A](A-1,3)→[A](A,1)
[A](A,1)C→[A](A,2)
[A](A,1)-[A](A,2)→[A](A,3)
[A](A,3)→B
End

By the way, what are UCC's and CCA's anyway?

---

"Reality is that which, when you stop believing in it, doesn't go away."
-Philip K. Dick

Last edited on 15 Nov 2009 00:37 by Sleight Show more