meniu

DeprotejareProtejare

FNOhttp://www.levier.roTablou simplificat al fluxurilor de numerar operationalecontact@levier.roleiBrndescu Olariu DanielNr.crt.Categorie / an234561+Venituri din exploatare1,8001,8001,8001,8001,8002+Diminuarea creantelor000003-Sporirea creantelor25000004=Incasari operationale1,5501,8001,8001,8001,8005+Cheltuieli din exploatare1,5001,5001,5001,5001,5006-Cheltuieli cu amortizarea2002002002002007+Sporirea stocurilor20000008-Diminuarea stocurilor000009-Sporirea datoriilor curente300000010+Diminuarea datoriilor curente0000011+Impozit pe profit484848484812=Plati operationale1,2481,3481,3481,3481,34813= 4 - 12Flux de numerar operational net302452452452452

http://www.levier.rocontact@levier.ro

VANVALOAREA ACTUALIZATA NETAleiNr.crt.Categorie123456http://www.levier.ro1Investitie5,000contact@levier.ro2Incasari operationale01,5501,8001,8001,8001,800Brndescu Olariu Daniel3Plati operationale01,2481,3481,3481,3481,3484Flux de numerar operational net03024524524524525Valoarea reziduala5,6508%6Flux de numerar operational net ajustat (FNONA)03024524524526,1027Flux de numerar net ajustat (FNNA)-5,0003024524524526,1028Rata de actualizare8.00%8.00%8.00%8.00%8.00%8.00%9Factorul de actualizare0.9260.8570.7940.7350.6810.63010Flux de numerar net ajustat actualizat (FNNAA)-4,6302593593323083,84511Valoarea actualizata neta473

http://www.levier.rocontact@levier.ro

RIRRATA INTERNA DE RENTABILITATEleiNr.crt.Categorie123456http://www.levier.ro1Investitie5,000contact@levier.ro2Incasari operationale01,5501,8001,8001,8001,800Brndescu Olariu Daniel3Plati operationale01,2481,3481,3481,3481,3484Flux de numerar operational net03024524524524525Valoarea reziduala5,6506Flux de numerar net ajustat (FNNA)-5,0003024524524526,1027Rata interna de rentabilitate10.43%

http://www.levier.rocontact@levier.ro

IPINDICELE DE PROFITABILITATEleiNr.crt.Categorie123456http://www.levier.ro1Investitie5,000contact@levier.ro2Incasari operationale01,5501,8001,8001,8001,800Brndescu Olariu Daniel3Plati operationale01,2481,3481,3481,3481,3484Flux de numerar operational net03024524524524525Valoarea reziduala5,6506Flux de numerar operational net ajustat (FNONA)03024524524526,1028Rata de actualizare8.00%8.00%8.00%8.00%8.00%8.00%9Factorul de actualizare0.9260.8570.7940.7350.6810.63010Flux de numerar operational net actualizat (FNONa)02593593323083,84511Investitie actualizata4,6300000012Indicele de profitabilitate1.10

http://www.levier.rocontact@levier.ro

RaportRAPORTUL INCASARI ACTUALIZATE / PLATI ACTUALIZATEleiNr.crt.Categorie123456http://www.levier.ro1Investitie5,000contact@levier.ro2Incasari operationale01,5501,8001,8001,8001,800Brndescu Olariu Daniel3Plati operationale01,2481,3481,3481,3481,3485Valoarea reziduala5,6507Rata de actualizare8.00%8.00%8.00%8.00%8.00%8.00%8Factorul de actualizare0.9260.8570.7940.7350.6810.6309Incasari operationale ajustate actualizate01,3291,4291,3231,2254,69510Plati operationale ajustate actualizate01,0701,07099191784916Raportul incasari actualizate / plati actualizate2.04

http://www.levier.rocontact@levier.ro

RecuperarePERIOADA DE RECUPERARE A INVESTITIEIleiNr.crt.Categorie123456http://www.levier.ro1Investitie5,000contact@levier.ro2Incasari operationale01,5501,8001,8001,8001,800Brndescu Olariu Daniel3Plati operationale01,2481,3481,3481,3481,3484Flux de numerar operational net (FNON)03024524524524526Flux de numerar operational net ajustat (FNONA)03024524524524525Investitia5,000Flux de numerar operational net ajustat (FNONA)03024524524524526Flux de numerar operational net cumulat03027541,2061,6582,1107Perioada de recuperare a investitiei din FNON11,39 ani----7.398Rata de actualizare8.00%8.00%8.00%8.00%8.00%8.00%9Factorul de actualizare0.9260.8570.7940.7350.6810.63010Investitie actualizata4,63011Flux de numerar operational net actualizat (FNONA)025935933230828512Flux de numerar operational net actualizat cumulat02596189501,2581,54213Perioada de recuperare a investitiei din FNONA15,84 ani----11.8414Flux de numerar operational net mediu (FNONM)42215Perioada de recuperare a investitiei din FNONM11,85 ani16Flux de numerar operational net actualizat mediu (FNONAM)30817Perioada de recuperare a investitiei din FNONAM15,01 ani

http://www.levier.rocontact@levier.ro

SenzitivitateANALIZA SENZITIVITII INVESTIIEIleiNr.crt.Categorie1234561Investitie5,0002ncasri operaionale1,5501,8001,8001,8001,8003Pli operaionale1,2481,3481,3481,3481,3484Flux de numerar operational net3024524524524525Valoarea rezidual5,6506Flux de numerar operational net ajustat3024524524526,1027Flux de numerar net ajustat-5,0003024524524526,1028Rata de actualizare8.00%8.00%8.00%8.00%8.00%8.00%9Factor de actualizare0.9260.8570.7940.7350.6810.63010Valoarea actualizat net47311Rata intern de rentabilitate10.43%12Indicele de profitabilitate1.1013Raportul ncasri actualizate / pli actualizate2.0414Perioada de recuperare din FNONM11.85Variaia ratei de actualizare15Diminuarea ratei de actualizare cu-10.0%a = 7,2%VAN = 648RIR = 10,43%IP = 1,14R = 2,05Pr = 11,85 aniRata de actualizare modificata7.20%7.20%7.20%7.20%7.20%7.20%Factor de actualizare modificat0.9330.8700.8120.7570.7060.659Indicatori7.20%64810.43%1.142.0511.8516Abaterea relativ a parametrilor-10.00%36.88%0.00%3.33%0.58%0.00%17Diminuarea ratei de actualizare cu-5.0%a = 7,6%VAN = 559RIR = 10,43%IP = 1,12R = 2,05Pr = 11,85 aniRata de actualizare modificata7.60%7.60%7.60%7.60%7.60%7.60%Factor de actualizare modificat0.9290.8640.8030.7460.6930.644Indicatori7.60%55910.43%1.122.0511.8518Abaterea relativ a parametrilor-5.00%18.18%0.00%1.65%0.29%0.00%19Diminuarea ratei de actualizare cu-1.0%a = 7,92%VAN = 490RIR = 10,43%IP = 1,11R = 2,04Pr = 11,85 aniRata de actualizare modificata7.92%7.92%7.92%7.92%7.92%7.92%Factor de actualizare modificat0.9270.8590.7960.7370.6830.633Indicatori7.92%49010.43%1.112.0411.8520Abaterea relativ a parametrilor-1.00%3.59%0.00%0.33%0.06%0.00%21Creterea ratei de actualizare cu1.0%a = 8,08%VAN = 456RIR = 10,43%IP = 1,1R = 2,04Pr = 11,85 aniRata de actualizare modificata8.08%8.08%8.08%8.08%8.08%8.08%Factor de actualizare modificat0.9250.8560.7920.7330.6780.627Indicatori8.08%45610.43%1.102.0411.8522Abaterea relativ a parametrilor1.00%-3.57%0.00%-0.32%-0.06%0.00%23Creterea ratei de actualizare cu5.0%a = 8,4%VAN = 390RIR = 10,43%IP = 1,08R = 2,04Pr = 11,85 aniRata de actualizare modificata8.40%8.40%8.40%8.40%8.40%8.40%Factor de actualizare modificat0.9230.8510.7850.7240.6680.616Indicatori8.40%39010.43%1.082.0411.8524Abaterea relativ a parametrilor5.00%-17.67%0.00%-1.61%-0.29%0.00%25Creterea ratei de actualizare cu10.0%a = 8,8%VAN = 308RIR = 10,43%IP = 1,07R = 2,03Pr = 11,85 aniRata de actualizare modificata8.80%8.80%8.80%8.80%8.80%8.80%Factor de actualizare modificat0.9190.8450.7760.7140.6560.603Indicatori8.80%30810.43%1.072.0311.8526Abaterea relativ a parametrilor10.00%-34.86%0.00%-3.19%-0.57%0.00%Variaia ncasrilor operaionale (fr modificarea valorii reziduale)27Diminuarea ncasrilor operaionale cu-10.0%a = 8%VAN = -171RIR = 7,12%IP = 0,96R = 1,91Pr = 20,24 anincasri operaionale modificate1,3951,6201,6201,6201,620Flux de numerar operational net modificat147272272272272Flux de numerar net ajustat modificat-5,0001472722722725,922Indicatori8.00%-1717.12%0.961.9120.2428Abaterea relativ a parametrilor0.00%-136.08%-31.68%-12.62%-6.44%70.80%29Diminuarea ncasrilor operaionale cu-5.0%a = 8%VAN = 151RIR = 8,78%IP = 1,03R = 1,98Pr = 14,95 anincasri operaionale modificate1,4731,7101,7101,7101,710Flux de numerar operational net modificat225362362362362Flux de numerar net ajustat modificat-5,0002253623623626,012Indicatori8.00%1518.78%1.031.9814.9530Abaterea relativ a parametrilor0.00%-68.04%-15.84%-6.31%-3.22%26.16%31Diminuarea ncasrilor operaionale cu-1.0%a = 8%VAN = 409RIR = 10,1%IP = 1,09R = 2,03Pr = 12,36 anincasri operaionale modificate1,5351,7821,7821,7821,782Flux de numerar operational net modificat287434434434434Flux de numerar net ajustat modificat-5,0002874344344346,084Indicatori8.00%40910.10%1.092.0312.3632Abaterea relativ a parametrilor0.00%-13.61%-3.17%-1.26%-0.64%4.30%33Creterea ncasrilor operaionale cu1.0%a = 8%VAN = 538RIR = 10,76%IP = 1,12R = 2,06Pr = 11,38 anincasri operaionale modificate1,5661,8181,8181,8181,818Flux de numerar operational net modificat318470470470470Flux de numerar net ajustat modificat-5,0003184704704706,120Indicatori8.00%53810.76%1.122.0611.3834Abaterea relativ a parametrilor0.00%13.61%3.17%1.26%0.64%-3.97%35Creterea ncasrilor operaionale cu5.0%a = 8%VAN = 795RIR = 12,08%IP = 1,17R = 2,11Pr = 9,81 anincasri operaionale modificate1,6281,8901,8901,8901,890Flux de numerar operational net modificat380542542542542Flux de numerar net ajustat modificat-5,0003805425425426,192Indicatori8.00%79512.08%1.172.119.8136Abaterea relativ a parametrilor0.00%68.04%15.83%6.31%3.22%-17.22%37Creterea ncasrilor operaionale cu10.0%a = 8%VAN = 1117RIR = 13,73%IP = 1,24R = 2,17Pr = 8,38 anincasri operaionale modificate1,7051,9801,9801,9801,980Flux de numerar operational net modificat457632632632632Flux de numerar net ajustat modificat-5,0004576326326326,282Indicatori8.00%1,11713.73%1.242.178.3838Abaterea relativ a parametrilor0.00%136.08%31.65%12.62%6.44%-29.28%Variaia plilor operaionale (fr modificarea valorii reziduale)39Diminuarea plilor operaionale cu-10.0%a = 8%VAN = 963RIR = 12,94%IP = 1,21R = 2,27Pr = 9,01 aniPli operaionale modificate1,1231,2131,2131,2131,213Flux de numerar operational net modificat427587587587587Flux de numerar net ajustat modificat-5,0004275875875876,237Indicatori8.00%96312.94%1.212.279.0140Abaterea relativ a parametrilor0.00%103.49%24.10%9.60%11.11%-23.97%41Diminuarea plilor operaionale cu-5.0%a = 8%VAN = 718RIR = 11,68%IP = 1,16R = 2,15Pr = 10,24 aniPli operaionale modificate1,1861,2811,2811,2811,281Flux de numerar operational net modificat364519519519519Flux de numerar net ajustat modificat-5,0003645195195196,169Indicatori8.00%71811.68%1.162.1510.2442Abaterea relativ a parametrilor0.00%51.75%12.05%4.80%5.26%-13.59%43Diminuarea plilor operaionale cu-1.0%a = 8%VAN = 522RIR = 10,68%IP = 1,11R = 2,06Pr = 11,49 aniPli operaionale modificate1,2361,3351,3351,3351,335Flux de numerar operational net modificat314465465465465Flux de numerar net ajustat modificat-5,0003144654654656,115Indicatori8.00%52210.68%1.112.0611.4944Abaterea relativ a parametrilor0.00%10.35%2.41%0.96%1.01%-3.04%45Creterea plilor operaionale cu1.0%a = 8%VAN = 424RIR = 10,18%IP = 1,09R = 2,02Pr = 12,23 aniPli operaionale modificate1,2601,3611,3611,3611,361Flux de numerar operational net modificat290439439439439Flux de numerar net ajustat modificat-5,0002904394394396,089Indicatori8.00%42410.18%1.092.0212.2346Abaterea relativ a parametrilor0.00%-10.35%-2.41%-0.96%-0.99%3.21%47Creterea plilor operaionale cu5.0%a = 8%VAN = 228RIR = 9,17%IP = 1,05R = 1,94Pr = 14,06 aniPli operaionale modificate1,3101,4151,4151,4151,415Flux de numerar operational net modificat240385385385385Flux de numerar net ajustat modificat-5,0002403853853856,035Indicatori8.00%2289.17%1.051.9414.0648Abaterea relativ a parametrilor0.00%-51.75%-12.05%-4.80%-4.76%18.65%49Creterea plilor operaionale cu10.0%a = 8%VAN = -17RIR = 7,92%IP = 1R = 1,86Pr = 17,29 aniPli operaionale modificate1,3731,4831,4831,4831,483Flux de numerar operational net modificat177317317317317Flux de numerar net ajustat modificat-5,0001773173173175,967Indicatori8.00%-177.92%1.001.8617.2950Abaterea relativ a parametrilor0.00%-103.49%-24.09%-9.60%-9.09%45.91%http://www.levier.rocontact@levier.roBrndescu Olariu Daniel

Senzitivitate

Variaie relativ VANvariaia ratei de actualizare (a)variaia VANSenzitivitatea VAN la modificarea ratei de actualizare

Variaie relativ VANvariaia ncasrilor operaionalevariaia VANSenzitivitatea VAN la modificarea ncasrilor operaionale

Variaie relativ VANvariaia plilor operaionalevariaia VANSenzitivitatea VAN la modificarea plilor operaionale

Attribute VB_Name = "Sheet9"Attribute VB_Base = "0{00020820-0000-0000-C000-000000000046}"Attribute VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute VB_TemplateDerived = FalseAttribute VB_Customizable = True

Attribute VB_Name = "Sheet8"Attribute VB_Base = "0{00020820-0000-0000-C000-000000000046}"Attribute VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute VB_TemplateDerived = FalseAttribute VB_Customizable = True

Attribute VB_Name = "Sheet7"Attribute VB_Base = "0{00020820-0000-0000-C000-000000000046}"Attribute VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute VB_TemplateDerived = FalseAttribute VB_Customizable = True

Attribute VB_Name = "Module1"Sub Button1_Click()For i = 2 To 8Sheets(i).Unprotect ("masterlevier")Next iEnd SubSub Button2_Click()For i = 2 To 8Sheets(i).Protect ("masterlevier")Next iEnd Sub

Attribute VB_Name = "Sheet2"Attribute VB_Base = "0{00020820-0000-0000-C000-000000000046}"Attribute VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute VB_TemplateDerived = FalseAttribute VB_Customizable = True

Attribute VB_Name = "Sheet1"Attribute VB_Base = "0{00020820-0000-0000-C000-000000000046}"Attribute VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute VB_TemplateDerived = FalseAttribute VB_Customizable = True

Attribute VB_Name = "ThisWorkbook"Attribute VB_Base = "0{00020819-0000-0000-C000-000000000046}"Attribute VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute VB_TemplateDerived = FalseAttribute VB_Customizable = True

Attribute VB_Name = "Sheet6"Attribute VB_Base = "0{00020820-0000-0000-C000-000000000046}"Attribute VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute VB_TemplateDerived = FalseAttribute VB_Customizable = True

Attribute VB_Name = "Sheet5"Attribute VB_Base = "0{00020820-0000-0000-C000-000000000046}"Attribute VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute VB_TemplateDerived = FalseAttribute VB_Customizable = True

Attribute VB_Name = "Sheet4"Attribute VB_Base = "0{00020820-0000-0000-C000-000000000046}"Attribute VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute VB_TemplateDerived = FalseAttribute VB_Customizable = True