Replies to post #18805 on SPOOZ Inc (SPZI)

[CapnDon]

I put it into Excel (what else ;-) and came up with this:

Year n I x Y Y annual
compounding monthly
1 12 250000 20 2,200,000.00 2,200,000.00
2 24 250000 20 20,000,000.00 18,000,000.00
3 36 250000 20 180,000,000.00 160,000,000.00
4 48 250000 20 1,600,000,000.00 1,400,000,000.00
5 60 250000 20 14,000,000,000.00 13,000,000,000.00
6 72 250000 20 130,000,000,000.00 110,000,000,000.00

1 12 1000000 20 8,900,000.00 8,900,000.00
2 24 1000000 20 79,000,000.00 71,000,000.00
3 36 1000000 20 710,000,000.00 630,000,000.00
4 48 1000000 20 6,300,000,000.00 5,600,000,000.00
5 60 1000000 20 56,000,000,000.00 50,000,000,000.00
6 72 1000000 20 500,000,000,000.00 450,000,000,000.00
compounding each trading day
1 260 250000 1 3,300,000.00 3,300,000.00
2 520 250000 1 44,000,000.00 41,000,000.00
3 780 250000 1 590,000,000.00 540,000,000.00
4 1040 250000 1 7,800,000,000.00 7,200,000,000.00
5 1300 250000 1 100,000,000,000.00 96,000,000,000.00
6 1560 250000 1 1,400,000,000,000.00 1,300,000,000,000.00

1 260 1000000 1 13,000,000.00 13,000,000.00
2 520 1000000 1 180,000,000.00 160,000,000.00
3 780 1000000 1 2,300,000,000.00 2,200,000,000.00
4 1040 1000000 1 31,000,000,000.00 29,000,000,000.00
5 1300 1000000 1 410,000,000,000.00 380,000,000,000.00
6 1560 1000000 1 5,500,000,000,000.00 5,100,000,000,000.00