0% found this document useful (0 votes)
11 views3 pages

Monthly Financial Target Report

- The document shows target and realized profits and balances over a period from May 2008 to March 2012 for an initial balance of 1,000,000. - It tracks the target profits at minimum and maximum rates each month as well as the realized amounts, which remain at 1,000,000 profit and balance. - The target balances and profits increase each month as the interest compounds, reaching over 3.6 million by the end of the period.

Uploaded by

anto donlot
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
11 views3 pages

Monthly Financial Target Report

- The document shows target and realized profits and balances over a period from May 2008 to March 2012 for an initial balance of 1,000,000. - It tracks the target profits at minimum and maximum rates each month as well as the realized amounts, which remain at 1,000,000 profit and balance. - The target balances and profits increase each month as the interest compounds, reaching over 3.6 million by the end of the period.

Uploaded by

anto donlot
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Tgl. Saldo Awal : 1-May-08 Minimum Rate Target Bawah : 10.

00%
Saldo Awal : 1,000,000 Minimum Rate Target Atas : 20.00%
TARGET BULAN DEPAN DEPOSIT
TARGET AWAL REALISASI TARGET RATE TARGET BAWAH RATE TARGET ATAS OR
BULAN
Net Proft Saldo Balance Net Profit Saldo Balance Rate Net Profit Saldo Balance Net Profit Saldo Balance WITHDRAWAL
1 30-Jun-08 100,000 1,100,000 1,000,000 0.00% 100,000 1,100,000 200,000 1,200,000
2 31-Jul-08 110,000 1,210,000 1,000,000 0.00% 110,000 1,210,000 240,000 1,440,000
3 31-Aug-08 121,000 1,331,000 1,000,000 0.00% 121,000 1,331,000 288,000 1,728,000
4 30-Sep-08 133,100 1,464,100 1,000,000 0.00% 133,100 1,464,100 345,600 2,073,600
5 31-Oct-08 146,410 1,610,510 1,000,000 0.00% 146,410 1,610,510 414,720 2,488,320
6 30-Nov-08 161,051 1,771,561 1,000,000 0.00% 161,051 1,771,561 497,664 2,985,984
7 31-Dec-08 177,156 1,948,717 1,000,000 0.00% 177,156 1,948,717 597,197 3,583,181
8 31-Jan-09 194,872 2,143,589 1,000,000 0.00% 194,872 2,143,589 716,636 4,299,817
9 28-Feb-09 214,359 2,357,948 1,000,000 0.00% 214,359 2,357,948 859,963 5,159,780
10 31-Mar-09 235,795 2,593,742 1,000,000 0.00% 235,795 2,593,742 1,031,956 6,191,736
11 30-Apr-09 259,374 2,853,117 1,000,000 0.00% 259,374 2,853,117 1,238,347 7,430,084
12 31-May-09 285,312 3,138,428 1,000,000 0.00% 285,312 3,138,428 1,486,017 8,916,100
13 30-Jun-09 313,843 3,452,271 1,000,000 0.00% 313,843 3,452,271 1,783,220 10,699,321
14 31-Jul-09 345,227 3,797,498 1,000,000 0.00% 345,227 3,797,498 2,139,864 12,839,185
15 31-Aug-09 379,750 4,177,248 1,000,000 0.00% 379,750 4,177,248 2,567,837 15,407,022
16 30-Sep-09 417,725 4,594,973 1,000,000 0.00% 417,725 4,594,973 3,081,404 18,488,426
17 31-Oct-09 459,497 5,054,470 1,000,000 0.00% 459,497 5,054,470 3,697,685 22,186,111
18 30-Nov-09 505,447 5,559,917 1,000,000 0.00% 505,447 5,559,917 4,437,222 26,623,333
19 31-Dec-09 555,992 6,115,909 1,000,000 0.00% 555,992 6,115,909 5,324,667 31,948,000
20 31-Jan-10 611,591 6,727,500 1,000,000 0.00% 611,591 6,727,500 6,389,600 38,337,600
21 28-Feb-10 672,750 7,400,250 1,000,000 0.00% 672,750 7,400,250 7,667,520 46,005,120
22 31-Mar-10 740,025 8,140,275 1,000,000 0.00% 740,025 8,140,275 9,201,024 55,206,144
23 30-Apr-10 814,027 8,954,302 1,000,000 0.00% 814,027 8,954,302 11,041,229 66,247,373
24 31-May-10 895,430 9,849,733 1,000,000 0.00% 895,430 9,849,733 13,249,475 79,496,847
25 30-Jun-10 984,973 10,834,706 1,000,000 0.00% 984,973 10,834,706 15,899,369 95,396,217
26 31-Jul-10 1,083,471 11,918,177 1,000,000 0.00% 1,083,471 11,918,177 19,079,243 114,475,460
27 31-Aug-10 1,191,818 13,109,994 1,000,000 0.00% 1,191,818 13,109,994 22,895,092 137,370,552
28 30-Sep-10 1,310,999 14,420,994 1,000,000 0.00% 1,310,999 14,420,994 27,474,110 164,844,662
29 31-Oct-10 1,442,099 15,863,093 1,000,000 0.00% 1,442,099 15,863,093 32,968,932 197,813,595
30 30-Nov-10 1,586,309 17,449,402 1,000,000 0.00% 1,586,309 17,449,402 39,562,719 237,376,314
31 31-Dec-10 1,744,940 19,194,342 1,000,000 0.00% 1,744,940 19,194,342 47,475,263 284,851,577
32 31-Jan-11 1,919,434 21,113,777 1,000,000 0.00% 1,919,434 21,113,777 56,970,315 341,821,892
33 28-Feb-11 2,111,378 23,225,154 1,000,000 0.00% 2,111,378 23,225,154 68,364,378 410,186,270
34 31-Mar-11 2,322,515 25,547,670 1,000,000 0.00% 2,322,515 25,547,670 82,037,254 492,223,524
35 30-Apr-11 2,554,767 28,102,437 1,000,000 0.00% 2,554,767 28,102,437 98,444,705 590,668,229
36 31-May-11 2,810,244 30,912,681 1,000,000 0.00% 2,810,244 30,912,681 118,133,646 708,801,875
37 30-Jun-11 3,091,268 34,003,949 1,000,000 0.00% 3,091,268 34,003,949 141,760,375 850,562,250
38 31-Jul-11 3,400,395 37,404,343 1,000,000 0.00% 3,400,395 37,404,343 170,112,450 1,020,674,700
39 31-Aug-11 3,740,434 41,144,778 1,000,000 0.00% 3,740,434 41,144,778 204,134,940 1,224,809,640
40 30-Sep-11 4,114,478 45,259,256 1,000,000 0.00% 4,114,478 45,259,256 244,961,928 1,469,771,568
41 31-Oct-11 4,525,926 49,785,181 1,000,000 0.00% 4,525,926 49,785,181 293,954,314 1,763,725,882
42 30-Nov-11 4,978,518 54,763,699 1,000,000 0.00% 4,978,518 54,763,699 352,745,176 2,116,471,058
Tgl. Saldo Awal : 1-May-08 Minimum Rate Target Bawah : 10.00%
Saldo Awal : 1,000,000 Minimum Rate Target Atas : 20.00%
TARGET BULAN DEPAN DEPOSIT
TARGET AWAL REALISASI TARGET RATE TARGET BAWAH RATE TARGET ATAS OR
BULAN
Net Proft Saldo Balance Net Profit Saldo Balance Rate Net Profit Saldo Balance Net Profit Saldo Balance WITHDRAWAL
43 31-Dec-11 5,476,370 60,240,069 1,000,000 0.00% 5,476,370 60,240,069 423,294,212 2,539,765,269
44 31-Jan-12 6,024,007 66,264,076 1,000,000 0.00% 6,024,007 66,264,076 507,953,054 3,047,718,323
45 29-Feb-12 6,626,408 72,890,484 1,000,000 0.00% 6,626,408 72,890,484 609,543,665 3,657,261,988
46 31-Mar-12 7,289,048 80,179,532 1,000,000 0.00% 7,289,048 80,179,532 731,452,398 4,388,714,386
47 30-Apr-12 8,017,953 88,197,485 1,000,000 0.00% 8,017,953 88,197,485 877,742,877 5,266,457,263
48 31-May-12 8,819,749 97,017,234 1,000,000 0.00% 8,819,749 97,017,234 1,053,291,453 6,319,748,715
49 30-Jun-12 9,701,723 106,718,957 1,000,000 0.00% 9,701,723 106,718,957 1,263,949,743 7,583,698,458
50 31-Jul-12 10,671,896 117,390,853 1,000,000 0.00% 10,671,896 117,390,853 1,516,739,692 9,100,438,150
51 31-Aug-12 11,739,085 129,129,938 1,000,000 0.00% 11,739,085 129,129,938 1,820,087,630 10,920,525,780
52 30-Sep-12 12,912,994 142,042,932 1,000,000 0.00% 12,912,994 142,042,932 2,184,105,156 13,104,630,936
53 31-Oct-12 14,204,293 156,247,225 1,000,000 0.00% 14,204,293 156,247,225 2,620,926,187 15,725,557,123
54 30-Nov-12 15,624,723 171,871,948 1,000,000 0.00% 15,624,723 171,871,948 3,145,111,425 18,870,668,548
55 31-Dec-12 17,187,195 189,059,142 1,000,000 0.00% 17,187,195 189,059,142 3,774,133,710 22,644,802,257
56 31-Jan-13 18,905,914 207,965,057 1,000,000 0.00% 18,905,914 207,965,057 4,528,960,451 27,173,762,709
57 28-Feb-13 20,796,506 228,761,562 1,000,000 0.00% 20,796,506 228,761,562 5,434,752,542 32,608,515,251
58 31-Mar-13 22,876,156 251,637,719 1,000,000 0.00% 22,876,156 251,637,719 6,521,703,050 39,130,218,301
59 30-Apr-13 25,163,772 276,801,490 1,000,000 0.00% 25,163,772 276,801,490 7,826,043,660 46,956,261,961
60 31-May-13 27,680,149 304,481,640 1,000,000 0.00% 27,680,149 304,481,640 9,391,252,392 56,347,514,353
BUY SIMULATION Price Profit & Loss Net P/L Price Profit & Loss Net P/L Price Profit & Loss Net P/L
Buy Commission : 0.18% Average : 103 50 (42,849) -51.78% 95 (6,939) -8.39% 140 28,971 35.01%
Quantity Price Total Fee Grand Total 51 (42,051) -50.82% 96 (6,141) -7.42% 141 29,769 35.98%
500 107 53,500 96 53,596 52 (41,253) -49.85% 97 (5,343) -6.46% 142 30,567 36.94%
100 99 9,900 18 9,918 53 (40,455) -48.89% 98 (4,545) -5.49% 143 31,365 37.90%
200 96 19,200 35 19,235 54 (39,657) -47.92% 99 (3,747) -4.53% 144 32,163 38.87%
0 0 0 55 (38,859) -46.96% 100 (2,949) -3.56% 145 32,961 39.83%
0 0 0 56 (38,061) -46.00% 101 (2,151) -2.60% 146 33,759 40.80%
0 0 0 57 (37,263) -45.03% 102 (1,353) -1.63% 147 34,557 41.76%
0 0 0 58 (36,465) -44.07% 103 (555) -0.67% 148 35,355 42.73%
0 0 0 59 (35,667) -43.10% 104 243 0.29% 149 36,153 43.69%
0 0 0 60 (34,869) -42.14% 105 1,041 1.26% 150 36,951 44.65%
0 0 0 61 (34,071) -41.17% 106 1,839 2.22% 151 37,749 45.62%
800 82,600 149 82,749 62 (33,273) -40.21% 107 2,637 3.19% 152 38,547 46.58%
63 (32,475) -39.24% 108 3,435 4.15% 153 39,345 47.55%
SELL SIMULATION 64 (31,677) -38.28% 109 4,233 5.12% 154 40,143 48.51%
Sell Commission : 0.25% Average : 120 65 (30,879) -37.32% 110 5,031 6.08% 155 40,941 49.48%
Quantity Price Total Fee Grand Total 66 (30,081) -36.35% 111 5,829 7.04% 156 41,739 50.44%
10 120 1,200 3 1,197 67 (29,283) -35.39% 112 6,627 8.01% 157 42,537 51.41%
0 0 0 68 (28,485) -34.42% 113 7,425 8.97% 158 43,335 52.37%
0 0 0 69 (27,687) -33.46% 114 8,223 9.94% 159 44,133 53.33%
0 0 0 70 (26,889) -32.49% 115 9,021 10.90% 160 44,931 54.30%
0 0 0 71 (26,091) -31.53% 116 9,819 11.87% 161 45,729 55.26%
0 0 0 72 (25,293) -30.57% 117 10,617 12.83% 162 46,527 56.23%
0 0 0 73 (24,495) -29.60% 118 11,415 13.80% 163 47,325 57.19%
0 0 0 74 (23,697) -28.64% 119 12,213 14.76% 164 48,123 58.16%
0 0 0 75 (22,899) -27.67% 120 13,011 15.72% 165 48,921 59.12%
0 0 0 76 (22,101) -26.71% 121 13,809 16.69% 166 49,719 60.08%
10 1,200 3 1,197 77 (21,303) -25.74% 122 14,607 17.65% 167 50,517 61.05%
78 (20,505) -24.78% 123 15,405 18.62% 168 51,315 62.01%
Net Profit/Loss : 163 15.72% 79 (19,707) -23.82% 124 16,203 19.58% 169 52,113 62.98%
80 (18,909) -22.85% 125 17,001 20.55% 170 52,911 63.94%
81 (18,111) -21.89% 126 17,799 21.51% 171 53,709 64.91%
82 (17,313) -20.92% 127 18,597 22.47% 172 54,507 65.87%
83 (16,515) -19.96% 128 19,395 23.44% 173 55,305 66.84%
84 (15,717) -18.99% 129 20,193 24.40% 174 56,103 67.80%
85 (14,919) -18.03% 130 20,991 25.37% 175 56,901 68.76%
86 (14,121) -17.06% 131 21,789 26.33% 176 57,699 69.73%
87 (13,323) -16.10% 132 22,587 27.30% 177 58,497 70.69%
88 (12,525) -15.14% 133 23,385 28.26% 178 59,295 71.66%
89 (11,727) -14.17% 134 24,183 29.23% 179 60,093 72.62%
90 (10,929) -13.21% 135 24,981 30.19% 180 60,891 73.59%
91 (10,131) -12.24% 136 25,779 31.15% 181 61,689 74.55%
92 (9,333) -11.28% 137 26,577 32.12% 182 62,487 75.51%
93 (8,535) -10.31% 138 27,375 33.08% 183 63,285 76.48%
94 (7,737) -9.35% 139 28,173 34.05% 184 64,083 77.44%

You might also like