PLANILHA PARA CÁLCULO DE FINANCIAMENTO PÓS-FIXADO PLANILHA PARA CÁLCULO DE FINANCIAMENTO PÓS-FIXADO
Banco ItauBBA S/A Banco ItauBBA S/A
CCE - NOTA
CCE - NOTA CRÉDITO EXPORTAÇÃOCRÉDITO EXPORTAÇÃO D
Daatta a IInniicciiaall:: 1122//1177//22001100 TTaaxxaa: : CCDDI I ++ 22..4455%% 11ª ª AAmmoorrttiizzaaççããoo 1122//1177//22001122
11ªªjjuurrooss 66//1177//22001111 Data
Data Vencimento: Vencimento: 12/17/201512/17/2015 V
Vaalloor r IInniicciiaal l 1166,,000000,,000000..0000 N
Nººppaarrcceellaa 44
P
PaarrcceellaassPPaaggaass
--S Saallddo o dde e PPaarrcceellaas s 4 4 44,,000000,,000000..0000 ANO/MÊS ANO/MÊS ÍÍNNDDIICCEE CCDDII 22..4455%% VVLLRR. . JJUURROOSS++CCDDII VVLLRR. . PPRRIINNCCIIPPAALL C CDDII ((RR$$)) JJUURROOS S ((RR$$)) ((RR$$)) ((RR$$)) 17/12/10 17/12/10 9.2054448359.205444835 30/12/10 30/12/10 9.2387469409.238746940 57,882.45 57,882.45 14,041.6614,041.66 71,924.1171,924.11 --31/01/11 31/01/11 9.3169211229.316921122 135,993.50 135,993.50 34,909.3334,909.33 170,902.83170,902.83 --28/02/11 28/02/11 9.3919876189.391987618 130,868.57 130,868.57 30,853.9430,853.94 161,722.50161,722.50 --31/03/11 31/03/11 9.4714584549.471458454 138,808.03 138,808.03 34,517.1634,517.16 173,325.18173,325.18 --30/04/11 30/04/11 9.5477700599.547770059 133,568.05 133,568.05 33,741.9633,741.96 167,310.00167,310.00 --31/05/11 31/05/11 9.6285590579.628559057 141,690.33 141,690.33 35,233.9035,233.90 176,924.23176,924.23 --17/06/11 17/06/11 9.6789135029.678913502 88,497.50 88,497.50 19,454.2319,454.23 107,951.73107,951.73 --30/06/11 30/06/11 9.7100316569.710031656 51,440.74 51,440.74 14,036.0314,036.03 65,476.7665,476.76 --31/07/11 31/07/11 9.7961234109.796123410 142,440.84 142,440.84 33,817.2733,817.27 176,258.11176,258.11 --31/08/11 31/08/11 9.8829784769.882978476 144,003.59 144,003.59 34,188.2934,188.29 178,191.88178,191.88 --30/09/11 30/09/11 9.9666038599.966603859 138,938.14 138,938.14 33,433.8933,433.89 172,372.03172,372.03 --31/10/11 31/10/11 10.04690485410.046904854 133,684.26 133,684.26 34,898.2034,898.20 168,582.46168,582.46 --30/11/11 30/11/11 10.13191730910.131917309 141,823.15 141,823.15 34,128.1334,128.13 175,951.28175,951.28 --19/12/11 19/12/11 10.18490416610.184904166 88,574.50 88,574.50 21,763.3421,763.34 110,337.84110,337.84 --31/12/11 31/12/11 10.22585177310.225851773 64,326.74 64,326.74 12,966.3012,966.30 77,293.0477,293.04 --31/01/12 31/01/12 10.31237839810.312378398 136,038.93 136,038.93 33,828.5733,828.57 169,867.50169,867.50 --28/02/12 28/02/12 10.38712657410.387126574 117,765.81 117,765.81 30,837.4130,837.41 148,603.23148,603.23 --31/03/12 31/03/12 10.48763429310.487634293 158,648.38 158,648.38 35,655.6235,655.62 194,304.00194,304.00 --30/04/12 30/04/12 10.56789216210.567892162 126,957.47 126,957.47 33,753.2333,753.23 160,710.70160,710.70 --31/05/12 31/05/12 10.66158993810.661589938 148,516.91 148,516.91 35,259.8135,259.81 183,776.72183,776.72 --18/06/12 18/06/12 10.70874989910.708749899 74,907.49 74,907.49 20,597.9020,597.90 95,505.3995,505.39 --30/06/12 30/06/12 10.75180358710.751803587 64,326.74 64,326.74 12,966.3012,966.30 77,293.0477,293.04 --31/07/12 31/07/12 10.84278058310.842780583 136,038.93 136,038.93 33,828.5733,828.57 169,867.50169,867.50 --31/08/12 31/08/12 10.94330556210.943305562 150,629.76 150,629.76 34,213.4434,213.44 184,843.20184,843.20 --30/09/12 30/09/12 11.03147584911.031475849 132,392.76 132,392.76 33,445.0633,445.06 165,837.82165,837.82 --31/10/12 31/10/12 11.12481930811.124819308 140,443.58 140,443.58 34,923.8734,923.87 175,367.45175,367.45 --30/11/12 30/11/12 11.21445205211.214452052 135,141.86 135,141.86 34,139.5334,139.53 169,281.39169,281.39 --17/12/12 17/12/12 11.26405751511.264057515 74,942.59 74,942.59 19,462.0319,462.03 94,404.6294,404.62 4,000,000.004,000,000.00 31/12/12 31/12/12 11.30480696711.304806967 43,411.84 43,411.84 11,341.7211,341.72 54,753.5654,753.56 --31/01/13 31/01/13 11.40503842811.405038428 106,880.69 106,880.69 25,374.8425,374.84 132,255.53132,255.53 --28/02/13 28/02/13 11.48770663411.487706634 88,336.24 88,336.24 23,131.1723,131.17 111,467.41111,467.41 --31/03/13 31/03/13 11.58491051511.584910515 104,064.26 104,064.26 25,877.4825,877.48 129,941.74129,941.74 --30/04/13 30/04/13 11.68293689311.682936893 105,163.77 105,163.77 25,306.4725,306.47 130,470.23130,470.23
--31/05/13 11.781792727 106,267.75 26,425.42 132,693.17 -17/06/13 11.833907738 56,139.33 14,578.97 70,718.29 -30/06/13 11.881485034 48,245.06 10,535.47 58,780.53 -31/07/13 11.986829478 106,916.39 25,383.32 132,299.71 -31/08/13 12.097961100 113,025.26 25,672.10 138,697.36 -30/09/13 12.195434454 99,341.10 25,095.55 124,436.65 -31/10/13 12.308500082 115,464.81 26,226.21 141,691.02 -30/11/13 12.412649154 106,580.97 25,647.50 132,228.47 -17/12/13 12.467554665 56,301.01 14,620.95 70,921.96 4,000,000.00 31/12/13 12.512657951 28,941.22 7,561.15 36,502.37 -31/01/14 12.618534517 68,001.32 16,909.77 84,911.09 -28/02/14 12.720202134 65,434.28 15,426.97 80,861.25 -31/03/14 12.817544994 62,768.88 17,244.73 80,013.62 -30/04/14 12.920816040 66,730.45 16,857.45 83,587.90 -31/05/14 13.035375473 74,174.11 17,609.88 91,783.99 -17/06/14 13.093035521 37,411.20 9,715.41 47,126.62 -30/06/14 13.135130234 25,720.37 7,018.01 32,738.38 -31/07/14 13.256907917 74,472.67 16,915.42 91,388.10 -31/08/14 13.374447231 72,030.69 17,101.01 89,131.70 -30/09/14 13.487615875 69,496.95 16,723.65 86,220.60 -31/10/14 13.612661503 76,945.66 17,477.13 94,422.79 -30/11/14 13.727845811 71,025.47 17,091.48 88,116.95 -17/12/14 13.794102481 40,937.98 9,747.30 50,685.28 4,000,000.00 31/12/14 13.844004758 14,470.61 3,780.57 18,251.19 -31/01/15 13.961146589 34,000.66 8,454.89 42,455.55 -28/02/15 14.062342473 29,433.60 7,707.30 37,140.90 -31/03/15 14.181331782 34,674.17 8,622.37 43,296.54 -30/04/15 14.301327925 35,040.53 8,432.11 43,472.63 -31/05/15 14.422339423 35,408.37 8,804.94 44,213.31 -17/06/15 14.491948027 20,410.21 4,859.66 25,269.86 -30/06/15 14.544374867 14,470.61 3,510.41 17,981.03 -31/07/15 14.679217859 37,251.28 8,461.11 45,712.39 -31/08/15 14.803426894 34,385.17 8,550.50 42,935.68 -30/09/15 14.934678061 36,410.48 8,365.18 44,775.66 -31/10/15 15.067092937 36,807.47 8,738.56 45,546.04 -30/11/15 15.194583998 35,512.74 8,545.74 44,058.47 -17/12/15 15.267919797 20,468.99 4,873.65 25,342.64 4,000,000.00 TOTAL 5,838,266.24 1,425,218.47 7,263,484.70 16,000,000.00
a.a. PRESTAÇAO SALDO (R$) (R$) ATUALIZADO 16,000,000.00 - 16,071,924.11 - 16,242,826.93 - 16,404,549.44 - 16,577,874.62 - 16,745,184.62 - 16,922,108.85 1,030,060.58 16,000,000.00 - 16,065,476.76 - 16,241,734.88 - 16,419,926.76 - 16,592,298.79 - 16,760,881.26 - 16,936,832.54 1,047,170.38 16,000,000.00 - 16,077,293.04 - 16,247,160.54 - 16,395,763.76 - 16,590,067.77 - 16,750,778.47 - 16,934,555.19 1,030,060.58 16,000,000.00 - 16,077,293.04 - 16,247,160.54 - 16,432,003.74 - 16,597,841.56 - 16,773,209.01 - 16,942,490.40 5,036,895.02 12,000,000.00 - 12,054,753.56 - 12,187,009.09 - 12,298,476.49 - 12,428,418.23 - 12,558,888.47
- 12,691,581.64 762,299.93 12,000,000.00 - 12,058,780.53 - 12,191,080.24 - 12,329,777.60 - 12,454,214.25 - 12,595,905.27 - 12,728,133.74 4,799,055.70 8,000,000.00 - 8,036,502.37 - 8,121,413.47 - 8,202,274.72 - 8,282,288.34 - 8,365,876.23 - 8,457,660.23 504,786.84 8,000,000.00 - 8,032,738.38 - 8,124,126.48 - 8,213,258.18 - 8,299,478.78 - 8,393,901.57 - 8,482,018.52 4,532,703.80 4,000,000.00 - 4,018,251.19 - 4,060,706.73 - 4,097,847.63 - 4,141,144.17 - 4,184,616.80 - 4,228,830.11 254,099.98 4,000,000.00 - 4,017,981.03 - 4,063,693.41 - 4,106,629.09 - 4,151,404.75 - 4,196,950.78 - 4,241,009.26 4,266,351.90 -23,263,484.70
PLANILHA PARA CÁLCULO DE FINANCIAMENTO PRÉ-FIXADO
Banco ItauBBA S/A
CCE - NOTA CRÉDITO EXPORTAÇÃO
Data Inicial: 12/17/2010 Taxa: CDI + 2.45% a.a.
1ª Amortização 12/17/2012 1ª juros 6/17/2011 Data Vencimento: 12/17/2015 Valor Inicial 16,000,000.00 Nºparcela 4 Parcelas Pagas -Saldo de Parcelas 4 4,000,000.00
ANO/MÊS 2.45% VLR. PRINCIPAL PRESTAÇAO SALDO (R$)
JUROS (R$) (R$) (R$) ATUALIZADO 17/12/10 16,000,000.00 30/12/10 60,878.77 - 60,878.77 16,060,878.77 31/01/11 96,793.26 - 96,793.26 16,157,672.03 28/02/11 88,390.65 - 88,390.65 16,246,062.68 31/03/11 95,567.87 - 95,567.87 16,341,630.56 30/04/11 93,831.17 - 93,831.17 16,435,461.73 31/05/11 96,682.03 - 96,682.03 16,532,143.76 17/06/11 69,298.49 - 69,298.49 16,601,442.25 30/06/11 63,167.25 - 63,167.25 16,664,609.50 31/07/11 98,030.01 - 98,030.01 16,762,639.51 31/08/11 98,606.68 - 98,606.68 16,861,246.19 30/09/11 96,814.76 - 96,814.76 16,958,060.95 31/10/11 99,756.27 - 99,756.27 17,057,817.21 30/11/11 97,943.45 - 97,943.45 17,155,760.66 19/12/11 75,479.50 - 75,479.50 17,231,240.16 31/12/11 63,995.70 - 63,995.70 17,295,235.87 31/01/12 101,739.73 - 101,739.73 17,396,975.59 28/02/12 95,170.35 - 95,170.35 17,492,145.94 31/03/12 105,419.09 - 105,419.09 17,597,565.03 30/04/12 101,042.63 - 101,042.63 17,698,607.67 31/05/12 104,112.60 - 104,112.60 17,802,720.26 18/06/12 76,452.82 - 76,452.82 17,879,173.08 30/06/12 66,402.12 - 66,402.12 17,945,575.20 31/07/12 105,565.40 - 105,565.40 18,051,140.61 31/08/12 106,186.40 - 106,186.40 18,157,327.01 30/09/12 104,256.74 - 104,256.74 18,261,583.75 31/10/12 107,424.35 - 107,424.35 18,369,008.10 30/11/12 105,472.19 - 105,472.19 18,474,480.29 17/12/12 77,440.38 4,000,000.00 4,077,440.38 12,000,000.00 31/12/12 46,777.49 - 46,777.49 12,046,777.49
31/01/13 70,865.21 - 70,865.21 12,117,642.71 28/02/13 66,289.39 - 66,289.39 12,183,932.10 31/03/13 71,672.04 - 71,672.04 12,255,604.14 30/04/13 70,369.58 - 70,369.58 12,325,973.71 31/05/13 72,507.61 - 72,507.61 12,398,481.33 17/06/13 51,970.99 - 51,970.99 12,450,452.32 30/06/13 47,372.79 - 47,372.79 12,497,825.11 31/07/13 73,518.54 - 73,518.54 12,571,343.65 31/08/13 73,951.02 - 73,951.02 12,645,294.67 30/09/13 72,607.14 - 72,607.14 12,717,901.81 31/10/13 74,813.16 - 74,813.16 12,792,714.97 30/11/13 73,453.62 - 73,453.62 12,866,168.59 17/12/13 53,931.44 4,000,000.00 4,053,931.44 8,000,000.00 31/12/13 31,184.66 - 31,184.66 8,031,184.66 31/01/14 47,243.14 - 47,243.14 8,078,427.80 28/02/14 44,192.59 - 44,192.59 8,122,620.39 31/03/14 47,781.02 - 47,781.02 8,170,401.41 30/04/14 46,912.71 - 46,912.71 8,217,314.12 31/05/14 48,338.06 - 48,338.06 8,265,652.19 17/06/14 34,646.99 - 34,646.99 8,300,299.17 30/06/14 31,581.52 - 31,581.52 8,331,880.69 31/07/14 49,012.01 - 49,012.01 8,380,892.70 31/08/14 49,300.33 - 49,300.33 8,430,193.03 30/09/14 48,404.41 - 48,404.41 8,478,597.44 31/10/14 49,875.09 - 49,875.09 8,528,472.53 30/11/14 48,968.72 - 48,968.72 8,577,441.25 17/12/14 35,953.94 4,000,000.00 4,035,953.94 4,000,000.00 31/12/14 15,591.83 - 15,591.83 4,015,591.83 31/01/15 23,621.07 - 23,621.07 4,039,212.90 28/02/15 22,095.79 - 22,095.79 4,061,308.69 31/03/15 23,890.00 - 23,890.00 4,085,198.69 30/04/15 23,455.84 - 23,455.84 4,108,654.53 31/05/15 24,168.52 - 24,168.52 4,132,823.05 17/06/15 17,322.98 - 17,322.98 4,150,146.03 30/06/15 15,790.25 - 15,790.25 4,165,936.28 31/07/15 24,505.48 - 24,505.48 4,190,441.76 31/08/15 24,649.64 - 24,649.64 4,215,091.40 30/09/15 24,201.68 - 24,201.68 4,239,293.07 31/10/15 24,937.01 - 24,937.01 4,264,230.08 30/11/15 24,483.83 - 24,483.83 4,288,713.91 17/12/15 17,976.44 4,000,000.00 4,017,976.44 -TOTAL 4,392,106.25 16,000,000.00
