34093 2018015642 revisado

Prévia do material em texto

Fonte de recursos do investimento 
Capital próprio - 20,000,000- tx 0
Ação - 10,000,000- tx 0 expectativa 
BNDES - 70,000,000-100% TJLP 2012 5.90% carência 4 anos amortização SAC 10 anos 
Banco de investimento - 40,000,000- 130% CDI 2012 10.92% carência 5 anos amortização SAC 6 anos 
Total - 140,000,000-
TMA 6.07083%
vida útil - 30- anos 
receita - 30,000,000- tx. 1.10% aa
despesa - 10,000,000- tx. 0.98% aa
Aportes OPEX - BNDES
ano valor 
10 - 5,500,000- 
18 - 8,000,000- 
25 - 20,000,000-
Terreno - 7,000,000- 
Valor de obra - 119,000,000-
Despesas de projeto - 2,800,000- 
Capital de giro - 11,200,000- 0.08
Aporte dos recursos 
ano - 5- -4 - 3- -2 - 1- 0.00 total 
Terreno - 7,000,000- - 7,000,000- 
Obra - 17,850,000- - 33,320,000- - 29,750,000- - 17,850,000- - 11,900,000- - 8,330,000- - 119,000,000-
Despesa de projeto - 2,800,000- - 2,800,000- 
Capital de giro - 11,200,000- - 11,200,000-
tota - 27,650,000- - 33,320,000- - 29,750,000- - 17,850,000- - 11,900,000- - 19,530,000- - 140,000,000-
estruturação financeira 
anos 
 Capital próprio Ação BNDES Banco de investimento Valores correntes Valores presentes 
Terreno Obra Despesa de 
projeto 
Capital de giro Terreno Obra Despesa de projeto Capital de giro Terreno Obra Despesa de projeto Capital de giro Terreno Obra Despesa de projeto Capital de giro Despesa investimento investimento BNDES BI
-5 - 7,000,000- - 10,200,000- - 2,800,000- - 7,650,000- - 27,650,000- - 27,650,000- 
-4 - 2,350,000- - 30,970,000- - 33,320,000- - 41,307,462- - 38,957,462- 
-3 - 29,750,000- - 29,750,000- - 35,336,543- - 35,336,543- 
-2 - 9,280,000- - 8,570,000- - 17,850,000- - 20,951,233- - 10,408,130- - 10,543,103-
-1 - 11,900,000- - 11,900,000- - 13,198,992- - 13,198,992-
0 - 8,330,000- - 11,200,000- - 19,530,000- - 19,530,000- - 19,530,000-
total - 20,000,000- - 10,000,000- - 70,000,000- - 140,000,000- - 157,974,230- - 84,702,135- - 43,272,095-
depreciar-> - 127,974,230- 
Alocação dos recursos 
Capital próprio Ação BNDES Banco de investimento total atualizado 
Terreno - 7,000,000- - -  - - -  - - -  - - 7,000,000- 
Obra - 10,200,000- - 10,000,000- - 70,000,000- - 28,800,000- -118,236,100- - 136,974,230- 
Despesa de projeto - 2,800,000- - -  - - -  - - -  - - 2,800,000- 
Capital de giro - -  - - -  - - -  - - 11,200,000- - 11,200,000- 
total - 20,000,000- - 10,000,000- - 70,000,000- - 40,000,000- -139,236,100-
ANOS INVESTIMENTOS RECEITAS DESPESAS
-6 - -  - - -  - - -  - 
-5 - 27,650,000- 
-4 - 33,320,000- 
-3 - 29,750,000- 
-2 - 17,850,000- 
-1 - 11,900,000- 
0 - 19,530,000- 
1 - 30,000,000- - 10,000,000-
2 - 30,330,000- - 10,098,000-
3 - 30,663,630- - 10,196,960-
4 - 31,000,930- - 10,296,891-
5 - 31,341,940- - 10,397,800-
6 - 31,686,702- - 10,499,699-
7 - 32,035,255- - 10,602,596-
8 - 32,387,643- - 10,706,501-
9 - 32,743,907- - 10,811,425-
10 - 33,104,090- - 10,917,377-
11 - 33,468,235- - 11,024,367-
12 - 33,836,386- - 11,132,406-
13 - 34,208,586- - 11,241,503-
14 - 34,584,880- - 11,351,670-
15 - 34,965,314- - 11,462,917-
16 - 35,349,932- - 11,575,253-
17 - 35,738,782- - 11,688,691-
18 - 36,131,908- - 11,803,240-
19 - 36,529,359- - 11,918,911-
20 - 36,931,182- - 12,035,717-
21 - 37,337,425- - 12,153,667-
22 - 37,748,137- - 12,272,773-
23 - 38,163,366- - 12,393,046-
24 - 38,583,163- - 12,514,498-
25 - 39,007,578- - 12,637,140-
26 - 39,436,662- - 12,760,984-
27 - 39,870,465- - 12,886,041-
28 - 40,309,040- - 13,012,325-
29 - 40,752,439- - 13,139,845-
30 - 41,200,716- - 13,268,616-
31 - 41,653,924- - 13,398,648-
Ano investimento receita despesa 
11 anos e 3 meses - 151,026,405- 13.409%
Payback VPL TIR 
0 - 157,974,230- - 157,974,230- - 157,974,230- - 157,974,230-
1 - 30,000,000- - 10,000,000- - 147,564,575- - 18,855,326- - 17,635,242-
2 - 30,330,000- - 10,098,000- - 136,290,967- - 17,982,369- - 15,730,470-
3 - 30,663,630- - 10,196,960- - 124,098,289- - 17,149,809- - 14,031,416-
4 - 31,000,930- - 10,296,891- - 110,928,044- - 16,355,779- - 12,515,864-
5 - 31,341,940- - 10,397,800- - 96,718,155- - 15,598,496- - 11,163,997-
6 - 31,686,702- - 10,499,699- - 81,402,746- - 14,876,260- - 9,958,138- 
7 - 32,035,255- - 10,602,596- - 64,911,907- - 14,187,450- - 8,882,518- 
8 - 32,387,643- - 10,706,501- - 47,171,456- - 13,530,519- - 7,923,073- 
9 - 32,743,907- - 10,811,425- - 28,102,672- - 12,903,994- - 7,067,254- 
10 - 33,104,090- - 10,917,377- - 7,622,023- - 12,306,466- - 6,303,871- 
11 - 33,468,235- - 11,024,367- - 14,359,125- - 11,736,595- - 5,622,941- 
12 - 33,836,386- - 11,132,406- - 37,934,822- - 11,193,102- - 5,015,558- 
13 - 34,208,586- - 11,241,503- - 10,674,765- - 4,473,779- 
14 - 34,584,880- - 11,351,670- - 10,180,422- - 3,990,518- 
15 - 34,965,314- - 11,462,917- - 9,708,961- - 3,559,457- 
16 - 35,349,932- - 11,575,253- - 9,259,324- - 3,174,956- 
17 - 35,738,782- - 11,688,691- - 8,830,502- - 2,831,986- 
18 - 36,131,908- - 11,803,240- - 8,421,531- - 2,526,063- 
19 - 36,529,359- - 11,918,911- - 8,031,492- - 2,253,185- 
20 - 36,931,182- - 12,035,717- - 7,659,511- - 2,009,782- 
21 - 37,337,425- - 12,153,667- - 7,304,750- - 1,792,671- 
22 - 37,748,137- - 12,272,773- - 6,966,414- - 1,599,013- 
23 - 38,163,366- - 12,393,046- - 6,643,741- - 1,426,274- 
24 - 38,583,163- - 12,514,498- - 6,336,008- - 1,272,194- 
25 - 39,007,578- - 12,637,140- - 6,042,523- - 1,134,758- 
26 - 39,436,662- - 12,760,984- - 5,762,626- - 1,012,168- 
27 - 39,870,465- - 12,886,041- - 5,495,689- - 902,822- 
28 - 40,309,040- - 13,012,325- - 5,241,112- - 805,287- 
29 - 40,752,439- - 13,139,845- - 4,998,323- - 718,288- 
30 - 41,200,716- - 13,268,616- - 4,766,776- - 640,688- 
- 0- 
ano investimento receita despesa 
Amortização BNDES (SAC) Amortização B. Investidores (SAC)
depreciação civil depreciação M&E LAIR IR CSLL lucro líquido saldo juros valor amortizado prestação saldo devedor juros valor amortizado prestação saldo devedor 
0 - 157,974,230- - 84,702,135- - 43,272,095- - -  - 
1 - 30,000,000- - 10,000,000- - 4,723,539- - 4,723,539- - 3,835,278- - 4,109,227- - 7,331,956- - 745,196- - 659,876- - 13,871,390- - 9,147,851- 
2 - 30,330,000- - 10,098,000- - 4,723,539- - 4,723,539- - 3,835,278- - 4,109,227- - 7,563,956- - 768,396- - 680,756- - 14,059,310- - 19,038,973- 
3 - 30,663,630- - 10,196,960- - 4,723,539- - 4,723,539- - 3,835,278- - 4,109,227- - 7,798,626- - 791,863- - 701,876- - 14,249,392- - 29,720,650- 
4 - 31,000,930- - 10,296,891- - 106,547,635- - 4,723,539- - 4,723,539- - 3,835,278- - 4,109,227- - 8,035,995- - 815,600- - 723,240- - 14,441,662- - 41,243,062- 
5 - 31,341,940- - 10,397,800- - 6,290,572- - 10,654,764- - 16,945,336- - 95,892,872- - 4,723,539- - 4,723,539- - 43,272,095- - 3,835,278- - 4,109,227- - 1,985,524- - 210,552- - 178,697- - 9,540,780- - 31,618,763- 
6 - 31,686,702- - 10,499,699- - 5,661,515- - 10,654,764-- 16,316,279- - 85,238,108- - 4,723,539- - 7,212,016- - 11,935,554- - 36,060,079- - 3,835,278- - 4,109,227- - 2,857,444- - 297,744- - 257,170- - 10,247,035- - 15,533,486- 
inadimplência 
7 - 32,035,255- - 10,602,596- - 5,032,458- - 10,654,764- - 15,687,221- - 74,583,345- - 3,936,282- - 7,212,016- - 11,148,298- - 28,848,063- - 3,835,278- - 4,109,227- - 4,519,414- - 463,941- - 406,747- - 11,593,231- - 1,234,208- 
8 - 32,387,643- - 10,706,501- - 4,403,401- - 10,654,764- - 15,058,164- - 63,928,581- - 3,149,026- - 7,212,016- - 10,361,042- - 21,636,047- - 3,835,278- - 4,109,227- - 6,184,210- - 630,421- - 556,579- - 12,941,716- - 11,168,355- 
9 - 32,743,907- - 10,811,425- - 3,774,343- - 10,654,764- - 14,429,107- - 53,273,818- - 2,361,769- - 7,212,016- - 9,573,785- - 14,424,032- - 3,835,278- - 4,109,227- - 7,851,864- - 797,186- - 706,668- - 14,292,515- - 21,556,743- 
10 - 33,104,090- - 10,917,377- - 3,145,286- - 10,654,764- - 13,800,050- - 42,619,054- - 1,574,513- - 7,212,016- - 8,786,529- - 7,212,016- - 3,835,278- - 4,109,227- - 9,522,409- - 964,241- - 857,017- - 15,645,657- - 29,806,338- 
11 - 33,468,235- - 11,024,367- - 2,516,229- - 10,654,764- - 13,170,992- - 31,964,291- - 787,256- - 7,212,016- - 7,999,272- - 0- - 3,835,278- - 15,305,104- - 1,542,510- - 1,377,459- - 16,220,413- - 36,565,681- 
12 - 33,836,386- - 11,132,406- - 1,887,172- - 10,654,764- - 12,541,935- - 21,309,527- - 3,835,278- - 16,981,530- - 1,710,153- - 1,528,338- - 17,578,317- - 33,749,139- 
13 - 34,208,586- - 11,241,503- - 1,258,114- - 10,654,764- - 11,912,878- - 10,654,764- - 3,835,278- - 17,873,690- - 1,799,369- - 1,608,632- - 18,300,967- - 29,409,902- 
14 - 34,584,880- - 11,351,670- - 629,057- - 10,654,764- - 11,283,821- - 0- - 3,835,278- - 18,768,875- - 1,888,887- - 1,689,199- - 19,026,067- - 23,453,081- 
15 - 34,965,314- - 11,462,917- - 3,835,278- - 19,667,119- - 1,978,712- - 1,770,041- - 19,753,645- - 5,123,233- 
16 - 35,349,932- - 11,575,253- - 3,835,278- - 19,939,401- - 2,005,940- - 1,794,546- - 19,974,193- - 14,539,938- 
17 - 35,738,782- - 11,688,691- - 3,835,278- - 20,214,813- - 2,033,481- - 1,819,333- - 20,197,277- - 35,619,909- 
18 - 36,131,908- - 11,803,240- - 3,835,278- - 20,493,390- - 2,061,339- - 1,844,405- - 20,422,924- - 58,205,258- 
19 - 36,529,359- - 11,918,911- - 3,835,278- - 20,775,169- - 2,089,517- - 1,869,765- - 20,651,166- - 82,389,965- 
20 - 36,931,182- - 12,035,717- - 3,835,278- - 21,060,187- - 2,118,019- - 1,895,417- - 20,882,030- - 108,273,748-
21 - 37,337,425- - 12,153,667- - 3,835,278- - 21,348,480- - 2,146,848- - 1,921,363- - 21,115,547- - 135,962,409-
22 - 37,748,137- - 12,272,773- - 3,835,278- - 21,640,086- - 2,176,009- - 1,947,608- - 21,351,748- - 165,568,202-
23 - 38,163,366- - 12,393,046- - 3,835,278- - 21,935,042- - 2,205,504- - 1,974,154- - 21,590,663- - 197,210,226-
24 - 38,583,163- - 12,514,498- - 3,835,278- - 22,233,387- - 2,235,339- - 2,001,005- - 21,832,322- - 231,014,843-
25 - 39,007,578- - 12,637,140- - 3,835,278- - 22,535,160- - 2,265,516- - 2,028,164- - 22,076,758- - 267,116,116-
26 - 39,436,662- - 12,760,984- - 26,675,678- - 2,679,568- - 2,400,811- - 21,595,299- - 304,927,576-
27 - 39,870,465- - 12,886,041- - 26,984,423- - 2,710,442- - 2,428,598- - 21,845,383- - 345,284,590-
28 - 40,309,040- - 13,012,325- - 27,296,715- - 2,741,672- - 2,456,704- - 22,098,339- - 388,344,565-
29 - 40,752,439- - 13,139,845- - 27,612,594- - 2,773,259- - 2,485,133- - 22,354,201- - 434,274,499-
30 - 41,200,716- - 13,268,616- - 27,932,100- - 2,805,210- - 2,513,889- - 22,613,001- - 483,251,560-
ano investimento receita despesa 
Amortização BNDES (SAC) Amortização B. Investidores (SAC)
depreciação civil depreciação M&E LAIR IR CSLL lucro líquido saldo juros valor amortizado prestação saldo devedor juros valor amortizado prestação saldo devedor 
0 - 157,974,230- - 84,702,135- - 43,272,095- - -  - 
1 - 30,000,000- - 7,123,932- - 4,723,539- - 4,723,539- - 3,835,278- - 4,109,227- - 10,208,024- - 1,032,802- - 918,722- - 16,201,005- - 11,477,466- 
2 - 30,330,000- - 7,193,747- - 4,723,539- - 4,723,539- - 3,835,278- - 4,109,227- - 10,468,209- - 1,058,821- - 942,139- - 16,411,755- - 23,862,460- 
3 - 30,663,630- - 7,264,245- - 4,723,539- - 4,723,539- - 3,835,278- - 4,109,227- - 10,731,341- - 1,085,134- - 965,821- - 16,624,891- - 37,212,461- 
4 - 31,000,930- - 7,335,435- - 106,547,635- - 4,723,539- - 4,723,539- - 3,835,278- - 4,109,227- - 10,997,451- - 1,111,745- - 989,771- - 16,840,441- - 51,588,468- 
5 - 31,341,940- - 7,407,322- - 6,290,572- - 10,654,764- - 16,945,336- - 95,892,872- - 4,723,539- - 4,723,539- - 43,272,095- - 3,835,278- - 4,109,227- - 4,976,002- - 509,600- - 447,840- - 11,963,067- - 45,014,508- 
6 - 31,686,702- - 7,479,914- - 5,661,515- - 10,654,764- - 16,316,279- - 85,238,108- - 4,723,539- - 7,212,016- - 11,935,554- - 36,060,079- - 3,835,278- - 4,109,227- - 5,877,228- - 599,723- - 528,951- - 12,693,060- - 32,188,489- 
7 - 32,035,255- - 7,553,217- - 5,032,458- - 10,654,764- - 15,687,221- - 74,583,345- - 3,936,282- - 7,212,016- - 11,148,298- - 28,848,063- - 3,835,278- - 4,109,227- - 7,568,793- - 768,879- - 681,191- - 14,063,227- - 21,370,305- 
8 - 32,387,643- - 7,627,239- - 4,403,401- - 10,654,764- - 15,058,164- - 63,928,581- - 3,149,026- - 7,212,016- - 10,361,042- - 21,636,047- - 3,835,278- - 4,109,227- - 9,263,473- - 938,347- - 833,713- - 15,435,918- - 12,684,372- 
9 - 32,743,907- - 7,701,986- - 3,774,343- - 10,654,764- - 14,429,107- - 53,273,818- - 2,361,769- - 7,212,016- - 9,573,785- - 14,424,032- - 3,835,278- - 4,109,227- - 10,961,303- - 1,108,130- - 986,517- - 16,811,161- - 6,262,687- 
10 - 33,104,090- - 7,777,465- - 3,145,286- - 10,654,764- - 13,800,050- - 42,619,054- - 1,574,513- - 7,212,016- - 8,786,529- - 7,212,016- - 3,835,278- - 4,109,227- - 12,662,321- - 1,278,232- - 1,139,609- - 18,188,985- - 2,245,291- 
11 - 33,468,235- - 7,853,684- - 2,516,229- - 10,654,764- - 13,170,992- - 31,964,291- - 787,256- - 7,212,016- - 7,999,272- - 0- - 3,835,278- - 18,475,787- - 1,859,579- - 1,662,821- - 18,788,666- - 0- 
12 - 33,836,386- - 7,930,650- - 1,887,172- - 10,654,764- - 12,541,935- - 21,309,527- - 3,835,278- - 20,183,285- - 2,030,329- - 1,816,496- - 20,171,739- - 7,629,804- 
13 - 34,208,586- - 8,008,371- - 1,258,114- - 10,654,764- - 11,912,878- - 10,654,764- - 3,835,278- - 21,106,822- - 2,122,682- - 1,899,614- - 20,919,804- - 17,099,923- 
14 - 34,584,880- - 8,086,853- - 629,057- - 10,654,764- - 11,283,821- - 0- - 3,835,278- - 22,033,692- - 2,215,369- - 1,983,032- - 21,670,569- - 28,524,778- 
15 - 34,965,314- - 8,166,104- - 3,835,278- - 22,963,932- - 2,308,393- - 2,066,754- - 22,424,063- - 52,680,532- 
16 - 35,349,932- - 8,246,132- - 3,835,278-- 23,268,522- - 2,338,852- - 2,094,167- - 22,670,781- - 78,549,458- 
17 - 35,738,782- - 8,326,944- - 3,835,278- - 23,576,559- - 2,369,656- - 2,121,890- - 22,920,292- - 106,238,352-
18 - 36,131,908- - 8,408,548- - 3,835,278- - 23,888,082- - 2,400,808- - 2,149,927- - 23,172,625- - 135,860,525-
19 - 36,529,359- - 8,490,952- - 3,835,278- - 24,203,129- - 2,432,313- - 2,178,282- - 23,427,813- - 167,536,198-
20 - 36,931,182- - 8,574,163- - 3,835,278- - 24,521,741- - 2,464,174- - 2,206,957- - 23,685,889- - 201,392,922-
21 - 37,337,425- - 8,658,190- - 3,835,278- - 24,843,957- - 2,496,396- - 2,235,956- - 23,946,884- - 237,566,025-
22 - 37,748,137- - 8,743,040- - 0.79- - 3,835,278- - 25,169,819- - 2,528,982- - 2,265,284- - 24,210,832- - 276,199,083-
23 - 38,163,366- - 8,828,722- - 3,835,278- - 25,499,366- - 2,561,937- - 2,294,943- - 24,477,765- - 317,444,421-
24 - 38,583,163- - 8,915,243- - 3,835,278- - 25,832,642- - 2,595,264- - 2,324,938- - 24,747,718- - 361,463,646-
25 - 39,007,578- - 9,002,613- - 3,835,278- - 26,169,687- - 2,628,969- - 2,355,272- - 25,020,725- - 408,428,209-
26 - 39,436,662- - 9,090,838- - 30,345,823- - 3,046,582- - 2,731,124- - 24,568,117- - 457,791,302-
27 - 39,870,465- - 9,179,929- - 30,690,536- - 3,081,054- - 2,762,148- - 24,847,335- - 510,430,362-
28 - 40,309,040- - 9,269,892- - 31,039,148- - 3,115,915- - 2,793,523- - 25,129,710- - 566,547,424-
29 - 40,752,439- - 9,360,737- - 31,391,703- - 3,151,170- - 2,825,253- - 25,415,279- - 626,356,827-
30 - 41,200,716- - 9,452,472- - 31,748,244- - 3,186,824- - 2,857,342- - 25,704,078- - 690,085,954-