Transcript

Analiza financiaraCalculul indicatorilor incrementali de performan financiar - model simplificatDATE DE CALCULleiN0+1N0+2N0+3N+1N+2N+3N+4N+5N+6N+7IctotValoarea total a investiiei1,752,0001,400,000632,0002,0001,6001,8001,000000IptotValoarea total a proiectului1,752,0001,400,000632,000IpfCheltuieli de pregtire a fabricaieiIcapCreterea nevoii de capital circulant2,0001,6001,8001,000000VctotVenituri incrementale din exploatare*0002,0002,8003,6404,1864,1864,1864,186VproVenituri din exploatare - situaia cu proiect2,0002,8003,6404,1864,1864,1864,186VfprVenituri din exploatare - situaia fr proiectCctotCheltuieli incrementale de exploatare**0001,7002,2952,8693,1563,1563,1563,156CproCheltuieli de exploatare - situaia cu proiect1,7002,2952,8693,1563,1563,1563,156CfprCheltuieli de exploatare - situaia fr proiectVrValoarea rezidual***0000000000aRata de actualizare7%* calculate ca diferen ntre veniturile din exploatare din situaia cu proiect i cea fr proiect** calculate ca diferen ntre cheltuielile de exploatare din situaia cu proiect i cea fr proiect- n situaia n care proiectul nu este dependent de o situjaieanterioar, valorile pentru situaia fr proiect vor fi zero.REZULTATElei; %N0+1N0+2N0+3N+1N+2N+3N+4N+5N+6N+7FctotFluxuri totale anuale incrementale-1,752,000-1,400,000-632,000-1,700-1,095-1,029301,0301,0301,030Indicatori de performan financiarVactValoarea actualizat net a veniturilor totale incrementale15,396CactValoarea actualizat net a cheltuielilor totale incrementale11,967VNA/CVenitul net actualizat VNA/C-3,377,158RIRF/CRata intern de rentabilitate financiar RIRF/C0%Vact/CactRaportul ntre veniturile i cheltuielile de exploatare nete, actualizate1.29INVESTIIE-30%-20%-10%0%10%20%30%VNA =-2.36-2.70-3.04-3.38-3.72-4.05-4.39CHELTUIELI-30%-20%-10%0%10%20%30%VNA =-3.37-3.37-3.38-3.38-3.38-3.38-3.38VENITURI-30%-20%-10%0%10%20%30%VNA =-3.38-3.38-3.38-3.38-3.38-3.37-3.37Variaia costurilor-30%-20%-10%0%10%20%30%Variaia veniturilor-30%-3.38-3.38-3.38-3.38-3.38-3.38-3.39-20%-3.38-3.38-3.38-3.38-3.38-3.38-3.38-10%-3.38-3.38-3.38-3.38-3.38-3.38-3.380%-3.37-3.37-3.38-3.38-3.38-3.38-3.3810%-3.37-3.37-3.37-3.38-3.38-3.38-3.3820%-3.37-3.37-3.37-3.37-3.38-3.38-3.3830%-3.37-3.37-3.37-3.37-3.37-3.37-3.38

Analiza financiara-2.36298203-3.3735677952-3.3817766313-2.701040669-3.3747645124-3.3802370698-3.0390993079-3.3759612296-3.3786975083-3.3771579469-3.3771579469-3.3771579469-3.7152165858-3.3783546641-3.3756183854-4.0532752247-3.3795513813-3.3740788239-4.3913338637-3.3807480985-3.3725392624

Variaia valorii investiieiVariaia costurilorVariaia veniturilormilioane leiVNA la variaii: cost investiie, cost operare, venit

Sheet2-3.3781864796-3.3766469181-3.3751073567-3.3735677952-3.3720282337-3.3704886722-3.3689491108-3.3793831968-3.3778436354-3.3763040739-3.3747645124-3.3732249509-3.3716853895-3.370145828-3.3805799141-3.3790403526-3.3775007911-3.3759612296-3.3744216682-3.3728821067-3.3713425452-3.3817766313-3.3802370698-3.3786975083-3.3771579469-3.3756183854-3.3740788239-3.3725392624-3.3829733485-3.381433787-3.3798942255-3.3783546641-3.3768151026-3.3752755411-3.3737359796-3.3841700657-3.3826305042-3.3810909428-3.3795513813-3.3780118198-3.3764722583-3.3749326969-3.3853667829-3.3838272215-3.38228766-3.3807480985-3.379208537-3.3776689756-3.3761294141

-30%-20%-10%0%10%20%30%Variaia veniturilormilioane leiVariaia costurilorVNA la variaia combinat a veniturilor i cheltuielilor

Sheet3Calculul indicatorilor incrementali de performan financiarLEIN0+1N0+2N0+3N+1N+2N+3N+4N+5N+6N+7IctotValoarea total a investiiei1,752,0001,400,000632,0002,0001,6001,8001,000000IptotValoarea total a proiectului1,752,0001,400,000632,0000000000IpfCheltuieli de pregtire a fabricaiei0000000000IcapCreterea nevoii de capital circulant0002,0001,6001,8001,000000VctotVenituri incrementale din exploatare*0002,0002,8003,6404,1864,1864,1864,186VproVenituri din exploatare - situaia cu proiect0002,0002,8003,6404,1864,1864,1864,186VfprVenituri din exploatare - situaia fr proiect0000000000CctotCheltuieli incrementale de exploatare**000170022952868.753155.6253155.6253155.6253155.625CproCheltuieli de exploatare - situaia cu proiect0001,7002,2952,8693,1563,1563,1563,156CfprCheltuieli de exploatare - situaia fr proiect0000000000VrValoarea rezidual***0000000000FctotFluxuri totale anuale incrementale-1,752,000-1,400,000-632,000-1,700-1,095-1,029301,0301,0301,030Indicatori de performan financiaraRata de actualizare7%VactValoarea actualizat net a veniturilor totale incrementale15,396CactValoarea actualizat net a cheltuielilor totale incrementale11,967VNA/CVenitul net actualizat VNA/C-3,377,158RIRF/CRata intern de rentabilitate financiar RIRF/C0%Vact/CactRaportul ntre veniturile i cheltuielile de exploatare nete, actualizate1.29* calculate ca diferen ntre veniturile din exploatare din situaia cu proiect i cea fr proiect** calculate ca diferen ntre cheltuielile de exploatare din situaia cu proiect i cea fr proiect*** Ca urmare a decontrii amortizrii pe durata de utilizare n proiect i a utilizrii ulterioare n alt scop a mijloacelor fixe, valoarea rezidual se consider 0.

ANALIZA SENSIBILITII PROIECTULUImilioane leiPoz.IndicatoriAnii de evaluareN0+1N0+2N0+3N+1N+2N+3N+4N+5N+6N+7A.Valoarea total a investiiei1.751.400.630.000.000.000.000.000.000.00B.Cheltuieli incrementale de exploatare**0.000.000.000.000.000.000.000.000.000.00C.Venituri incrementale din exploatare*0.000.000.000.000.000.000.000.000.000.00C-A-BFluxuri totale anuale incrementale-1.75-1.40-0.63-0.00-0.00-0.000.000.000.000.00Coeficieni:Investiie0Cheltuieli0Venituri0Investiie-30%-20%-10%0%10%20%30%VNA =-3.38-2.36-2.70-3.04-3.38-3.72-4.05-4.39Cheltuieli-30%-20%-10%0%10%20%30%VNA =-3.38-3.37-3.37-3.38-3.38-3.38-3.38-3.38Venituri-30%-20%-10%0%10%20%30%VNA =-3.38-3.38-3.38-3.38-3.38-3.38-3.37-3.37VNA =-3.38-30%-20%-10%0%10%20%30%-30%-3.38-3.38-3.38-3.38-3.38-3.38-3.39-20%-3.38-3.38-3.38-3.38-3.38-3.38-3.38-10%-3.38-3.38-3.38-3.38-3.38-3.38-3.380%-3.37-3.37-3.38-3.38-3.38-3.38-3.3810%-3.37-3.37-3.37-3.38-3.38-3.38-3.3820%-3.37-3.37-3.37-3.37-3.38-3.38-3.3830%-3.37-3.37-3.37-3.37-3.37-3.37-3.38Variaia costurilor-30%-20%-10%0%10%20%30%Variaia veniturilor-30%-3.38-3.38-3.38-3.38-3.38-3.38-3.39-20%-3.38-3.38-3.38-3.38-3.38-3.38-3.38-10%-3.38-3.38-3.38-3.38-3.38-3.38-3.380%-3.37-3.37-3.38-3.38-3.38-3.38-3.3810%-3.37-3.37-3.37-3.38-3.38-3.38-3.3820%-3.37-3.37-3.37-3.37-3.38-3.38-3.3830%-3.37-3.37-3.37-3.37-3.37-3.37-3.38-30%-20%-10%0%10%20%30%Variaia valorii investiiei-2.36-2.70-3.04-3.38-3.72-4.05-4.39Variaia costurilor-3.37-3.37-3.38-3.38-3.38-3.38-3.38Variaia veniturilor-3.38-3.38-3.38-3.38-3.38-3.37-3.37


Top Related