Grafic VAN 2
3
Calcul de eficienta a investitiei (Explicatii in pagina anexata) ____________________________ DATE INITIALE CALCUL RIR VERIFICARE / INTERPRETARE CALCUL % dob./an 15.00% VAN actualiza 4,423.6 RIR: 43.21% Total sume: 8,000.0 0.0 Sold: 0.0 Luna Investitia Intrari Alte intrari Total sume VAN VAN 0 Credit Sold Rata Dobanda R+d 0 -10,000.0 -10,000.0 -10,000.0 -10,000.0 10,000.0 10,000.0 0.0 1 0.0 0.0 500.0 500.0 493.8 482.6 10,000.0 139.9 360.1 500.0 2 0.0 0.0 500.0 500.0 487.7 465.8 9,860.1 145.0 355.0 500.0 3 0.0 0.0 500.0 500.0 481.7 449.7 9,715.1 150.2 349.8 500.0 4 0.0 0.0 500.0 500.0 475.8 434.0 9,564.9 155.6 344.4 500.0 5 0.0 0.0 500.0 500.0 469.9 418.9 9,409.3 161.2 338.8 500.0 6 0.0 0.0 500.0 500.0 464.1 404.4 9,248.1 167.0 333.0 500.0 7 0.0 0.0 500.0 500.0 458.4 390.3 9,081.1 173.0 327.0 500.0 8 0.0 0.0 500.0 500.0 452.7 376.8 8,908.1 179.2 320.8 500.0 9 0.0 0.0 500.0 500.0 447.1 363.7 8,728.8 185.7 314.3 500.0 10 0.0 0.0 500.0 500.0 441.6 351.0 8,543.1 192.4 307.6 500.0 11 0.0 0.0 500.0 500.0 436.1 338.8 8,350.7 199.3 300.7 500.0 12 0.0 0.0 500.0 500.0 430.8 327.1 8,151.4 206.5 293.5 500.0 13 0.0 0.0 500.0 500.0 425.4 315.7 7,944.9 213.9 286.1 500.0 14 0.0 0.0 500.0 500.0 420.2 304.7 7,731.0 221.6 278.4 500.0 15 0.0 0.0 500.0 500.0 415.0 294.1 7,509.4 229.6 270.4 500.0 16 0.0 0.0 500.0 500.0 409.9 283.9 7,279.8 237.9 262.1 500.0 17 0.0 0.0 500.0 500.0 404.8 274.0 7,041.9 246.4 253.6 500.0 18 0.0 0.0 500.0 500.0 399.8 264.5 6,795.5 255.3 244.7 500.0 19 0.0 0.0 500.0 500.0 394.9 255.3 6,540.1 264.5 235.5 500.0 20 0.0 0.0 500.0 500.0 390.0 246.4 6,275.6 274.0 226.0 500.0 21 0.0 0.0 500.0 500.0 385.2 237.9 6,001.6 283.9 216.1 500.0 22 0.0 0.0 500.0 500.0 380.4 229.6 5,717.7 294.1 205.9 500.0 23 0.0 0.0 500.0 500.0 375.7 221.6 5,423.6 304.7 195.3 500.0 24 0.0 0.0 500.0 500.0 371.1 213.9 5,118.8 315.7 184.3 500.0 25 0.0 0.0 500.0 500.0 366.5 206.5 4,803.2 327.1 172.9 500.0 26 0.0 0.0 500.0 500.0 362.0 199.3 4,476.1 338.8 161.2 500.0 27 0.0 0.0 500.0 500.0 357.5 192.4 4,137.3 351.0 149.0 500.0 28 0.0 0.0 500.0 500.0 353.1 185.7 3,786.2 363.7 136.3 500.0 29 0.0 0.0 500.0 500.0 348.7 179.2 3,422.6 376.8 123.2 500.0 30 0.0 0.0 500.0 500.0 344.4 173.0 3,045.8 390.3 109.7 500.0 31 0.0 0.0 500.0 500.0 340.2 167.0 2,655.5 404.4 95.6 500.0 32 0.0 0.0 500.0 500.0 336.0 161.2 2,251.1 418.9 81.1 500.0 33 0.0 0.0 500.0 500.0 331.8 155.6 1,832.2 434.0 66.0 500.0 34 0.0 0.0 500.0 500.0 327.7 150.2 1,398.1 449.7 50.3 500.0 35 0.0 0.0 500.0 500.0 323.7 145.0 948.5 465.8 34.2 500.0 36 0.0 0.0 500.0 500.0 319.7 139.9 482.6 482.6 17.4 500.0 37 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 38 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 39 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 40 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 41 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 42 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 43 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 44 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 45 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 46 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 47 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 48 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 49 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 50 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 51 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 52 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 53 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 54 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 55 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 56 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 57 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 58 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 59 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 60 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 8,000.0 4,423.6 0.0 0.0 CALCUL VAN la un anumit procent VAN0: cu investitia
-
Upload
marian-bogdan -
Category
Documents
-
view
8 -
download
0
description
Acest fisier ilustreaza calculul de verificare a eficientei unei investitii
Transcript of Grafic VAN 2
Calcul de eficienta a investitiei (Explicatii in pagina anexata)
____________________________
DATE INITIALE CALCUL RIR VERIFICARE / INTERPRETARE CALCUL
% dob./an 15.00% VAN actualizat: 4,423.6 RIR: 43.21%
Total sume: 8,000.0 0.0 Sold: 0.0
Luna Investitia Intrari Alte intrari Total sume VAN VAN 0 Credit Sold Rata Dobanda R+d0 -10,000.0 -10,000.0 -10,000.0 -10,000.0 10,000.0 10,000.0 0.01 0.0 0.0 500.0 500.0 493.8 482.6 10,000.0 139.9 360.1 500.02 0.0 0.0 500.0 500.0 487.7 465.8 9,860.1 145.0 355.0 500.03 0.0 0.0 500.0 500.0 481.7 449.7 9,715.1 150.2 349.8 500.04 0.0 0.0 500.0 500.0 475.8 434.0 9,564.9 155.6 344.4 500.05 0.0 0.0 500.0 500.0 469.9 418.9 9,409.3 161.2 338.8 500.06 0.0 0.0 500.0 500.0 464.1 404.4 9,248.1 167.0 333.0 500.07 0.0 0.0 500.0 500.0 458.4 390.3 9,081.1 173.0 327.0 500.08 0.0 0.0 500.0 500.0 452.7 376.8 8,908.1 179.2 320.8 500.09 0.0 0.0 500.0 500.0 447.1 363.7 8,728.8 185.7 314.3 500.0
10 0.0 0.0 500.0 500.0 441.6 351.0 8,543.1 192.4 307.6 500.011 0.0 0.0 500.0 500.0 436.1 338.8 8,350.7 199.3 300.7 500.012 0.0 0.0 500.0 500.0 430.8 327.1 8,151.4 206.5 293.5 500.013 0.0 0.0 500.0 500.0 425.4 315.7 7,944.9 213.9 286.1 500.014 0.0 0.0 500.0 500.0 420.2 304.7 7,731.0 221.6 278.4 500.015 0.0 0.0 500.0 500.0 415.0 294.1 7,509.4 229.6 270.4 500.016 0.0 0.0 500.0 500.0 409.9 283.9 7,279.8 237.9 262.1 500.017 0.0 0.0 500.0 500.0 404.8 274.0 7,041.9 246.4 253.6 500.018 0.0 0.0 500.0 500.0 399.8 264.5 6,795.5 255.3 244.7 500.019 0.0 0.0 500.0 500.0 394.9 255.3 6,540.1 264.5 235.5 500.020 0.0 0.0 500.0 500.0 390.0 246.4 6,275.6 274.0 226.0 500.021 0.0 0.0 500.0 500.0 385.2 237.9 6,001.6 283.9 216.1 500.022 0.0 0.0 500.0 500.0 380.4 229.6 5,717.7 294.1 205.9 500.023 0.0 0.0 500.0 500.0 375.7 221.6 5,423.6 304.7 195.3 500.024 0.0 0.0 500.0 500.0 371.1 213.9 5,118.8 315.7 184.3 500.025 0.0 0.0 500.0 500.0 366.5 206.5 4,803.2 327.1 172.9 500.026 0.0 0.0 500.0 500.0 362.0 199.3 4,476.1 338.8 161.2 500.027 0.0 0.0 500.0 500.0 357.5 192.4 4,137.3 351.0 149.0 500.028 0.0 0.0 500.0 500.0 353.1 185.7 3,786.2 363.7 136.3 500.029 0.0 0.0 500.0 500.0 348.7 179.2 3,422.6 376.8 123.2 500.030 0.0 0.0 500.0 500.0 344.4 173.0 3,045.8 390.3 109.7 500.031 0.0 0.0 500.0 500.0 340.2 167.0 2,655.5 404.4 95.6 500.032 0.0 0.0 500.0 500.0 336.0 161.2 2,251.1 418.9 81.1 500.033 0.0 0.0 500.0 500.0 331.8 155.6 1,832.2 434.0 66.0 500.034 0.0 0.0 500.0 500.0 327.7 150.2 1,398.1 449.7 50.3 500.035 0.0 0.0 500.0 500.0 323.7 145.0 948.5 465.8 34.2 500.036 0.0 0.0 500.0 500.0 319.7 139.9 482.6 482.6 17.4 500.037 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.038 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.039 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.040 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.041 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.042 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.043 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.044 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.045 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.046 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.047 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.048 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.049 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.050 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.051 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.052 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.053 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.054 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.055 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.056 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.057 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.058 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.059 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.060 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
8,000.0 4,423.6 0.0 0.0
CALCUL VAN la un anumit procent
VAN0:
Alte platicu investitia
Explicatie calcul de eficienta a investitiei
1) . DATE INITIALE Se completeaza sumele investite, respectiv alte cheltuieli cu investitia.Alte cheltuieli cu investitia pot cuprinde inclusiv cheltuielile direct legate de exploatarea acesteia cum ar fi cheltuieli materiale aferente, salarii ale persoanelor.Cheltuiala nu se ia in calcul deoarece aici este vorba de fluxuri de numerar.Dobanda anuala de actualizare ar trebui sa fie costul capitalurilor proprii ale afacerii respective, respectiv rata fara risc + marja de risc a companiei pentru afacerea in cauza.Este un calcul la valori brute (nu se in calcul impozitul pe profit).
2). CALCUL VAN (VALOARE ACTUALIZATA NETA)Aici se calculeaza VAN care reprezinta valoarea actualizata a intrarilor de numerar pe perioada de viata a investitiei, actualizate la dobanda anuala de actualizare.Reprezinta surplusul valorii actualizate a acestor sume la data investitiei cu investitia efectuata, respectiv cu valoarea actualizata a investitiei in cazul in care exista iesiri de sume ale investitiei si pe durata de viata a acesteia.Practic aceasta metoda permite compararea unor intrari si iesiri de disponibilitati la momente diferite de timp.
3) CALCUL RIR (RATA INTERNA DE RANDAMENT)Reprezinta acea dobanda de actualizare la care VAN este zero. Reprezinta deci rentabilitatea investitiei in termeni de dobanda anuala cu calcul de dobanda lunar.
4) VERIFICARE / INTERPRETARE CALCULRIR calculat corect si semnificatia acestuia calcul este urmatoarea:Daca s-ar contracta un credit de la banca egal cu investitia si s-ar plati rate si dobanzi astfel incat: rata + dobanda = Sumele totale de pe coloana G, iar dobanda este calculata intotdeauna la sold, dobanda = RIR, soldul acestui credit la sfarsitul perioadei trebuie sa fie zero, adica creditul sa fie rambursat integral si exact pentru suma contractata (nu mai mult, nu mai putin).
