model bvc+cash flow+vnp

BVCPROIECIA CONTULUI DE PROFIT I PIERDERE -SC Rom Dinarom SRL(lei)11.031.031.0111111111111Nr. Crt.CATEGORIA31.12.201030.06.201131.12.2011AN 1AN 2AN 3AN 4AN 5AN 6AN 7AN 8AN 9AN 10AN 11AN 12AN 13AN 14AN 15VENITURI DIN EXPLOATARE1Cifra de afaceri5,437,845.007,291,795.0014,948,179.7517,937,815.7018,475,950.1719,030,228.6819,220,530.9619,220,530.9619,220,530.9619,220,530.9619,220,530.9619,220,530.9619,220,530.9619,220,530.9619,220,530.9619,220,530.9619,220,530.9619,220,530.962Variatia stocurilor (+ pentru C; - pentru D)(312,257.00)(670,105.00)(1,373,715.25)(1,785,829.83)(1,839,404.72)(1,894,586.86)(1,913,532.73)(1,913,532.73)(1,913,532.73)(1,913,532.73)(1,913,532.73)(1,913,532.73)(1,913,532.73)(1,913,532.73)(1,913,532.73)(1,913,532.73)(1,913,532.73)(1,913,532.73)3Venituri din productia realizata pentru scopuri proprii si capitalizata97,684.00137,381.00281,631.05366,120.37377,103.98388,417.10392,301.27392,301.27392,301.27392,301.27392,301.27392,301.27392,301.27392,301.27392,301.27392,301.27392,301.27392,301.274Alte venituri din exploatare53,687.0032,541.0066,709.0586,721.7789,323.4292,003.1292,923.1592,923.1592,923.1592,923.1592,923.1592,923.1592,923.1592,923.1592,923.1592,923.1592,923.1592,923.15Total venituri din exploatare5,276,959.006,791,612.0013,922,804.6016,604,828.0117,102,972.8517,616,062.0317,792,222.6517,792,222.6517,792,222.6517,792,222.6517,792,222.6517,792,222.6517,792,222.6517,792,222.6517,792,222.6517,792,222.6517,792,222.6517,792,222.65CHELTUIELI DE EXPLOATARE5Cheltuieli materiale total3,247,103.004,141,865.008,490,823.2511,038,070.2311,369,212.3311,710,288.7011,827,391.5911,827,391.5911,827,391.5911,827,391.5911,827,391.5911,827,391.5911,827,391.5911,827,391.5911,827,391.5911,827,391.5911,827,391.5911,827,391.596Cheltuieli cu personalul total197,608.00320,199.00656,407.95853,330.34878,930.25905,298.15914,351.13914,351.13914,351.13914,351.13914,351.13914,351.13914,351.13914,351.13914,351.13914,351.13914,351.13914,351.137Cheltuieli cu amortizarile175,090.00203,703.00407,406.00547,156.00547,156.00547,156.00547,156.00547,156.00547,156.00547,156.00547,156.00547,156.00547,156.00547,156.00547,156.00547,156.00547,156.00547,156.008Alte cheltuieli de exploatare1,248,050.001,271,951.002,607,499.553,389,749.423,491,441.903,596,185.153,632,147.013,632,147.013,632,147.013,632,147.013,632,147.013,632,147.013,632,147.013,632,147.013,632,147.013,632,147.013,632,147.013,632,147.01Total cheltuieli de exploatare4,867,851.005,937,718.0012,162,136.7515,828,305.9816,286,740.4716,758,928.0116,921,045.7316,921,045.7316,921,045.7316,921,045.7316,921,045.7316,921,045.7316,921,045.7316,921,045.7316,921,045.7316,921,045.7316,921,045.7316,921,045.73Rezultatul din exploatare409,108.00853,894.001,760,667.85776,522.03816,232.37857,134.02871,176.92871,176.92871,176.92871,176.92871,176.92871,176.92871,176.92871,176.92871,176.92871,176.92871,176.92871,176.92TOTAL VENITURI FINANCIARETotal venituri financiare23,248.0077,055.00157,962.75205,351.58211,512.12217,857.49220,036.06220,036.06220,036.06220,036.06220,036.06220,036.06220,036.06220,036.06220,036.06220,036.06220,036.06220,036.06CHELTUIELI FINANCIARE DIN CARE9Cheltuieli din diferente de curs valutar162,948.0068,040.00139,482.00181,326.60186,766.40192,369.39194,293.08194,293.08194,293.08194,293.08194,293.08194,293.08194,293.08194,293.08194,293.08194,293.08194,293.08194,293.0810Cheltuielile privind dobanzile65,983.0065,157.00133,571.85173,643.41178,852.71184,218.29186,060.47186,060.47186,060.47186,060.47186,060.47186,060.47186,060.47186,060.47186,060.47186,060.47186,060.47186,060.4711Cheltuieli privind sconturile acordate0.00.012Alte cheltuieli financiare0.00.0Total cheltuieli financiare228,931.00133,197.00273,053.85354,970.01365,619.11376,587.68380,353.56380,353.56380,353.56380,353.56380,353.56380,353.56380,353.56380,353.56380,353.56380,353.56380,353.56380,353.56Rezultatul financiar(205,683.00)(56,142.00)(115,091.10)(149,618.43)(154,106.98)(158,730.19)(160,317.49)(160,317.49)(160,317.49)(160,317.49)(160,317.49)(160,317.49)(160,317.49)(160,317.49)(160,317.49)(160,317.49)(160,317.49)(160,317.49)REZULTATUL BRUT AL EXERCIIULUI FINANCIAR203,425.00797,752.001,645,576.75626,903.60662,125.39698,403.83710,859.43710,859.43710,859.43710,859.43710,859.43710,859.43710,859.43710,859.43710,859.43710,859.43710,859.43710,859.4313Impozit pe profit/cifra de afaceri34,290.00132,521.00263,292.28100,304.58105,940.06111,744.61113,737.51113,737.51113,737.51113,737.51113,737.51113,737.51113,737.51113,737.51113,737.51113,737.51113,737.51113,737.51REZULTATUL NET AL EXERCIIULUI FINANCIAR169,135.00665,231.001,382,284.47526,599.02556,185.33586,659.22597,121.92597,121.92597,121.92597,121.92597,121.92597,121.92597,121.92597,121.92597,121.92597,121.92597,121.92597,121.92

cash-flowCash Flow - Compania SC Rom Dinarom SRLSe va completa in echivalent euro si va fi corelat cu perioada de creditarean 0 (31.12.2011)an 1an 2an 3an 4an 5an 6an 7an 8an 9an 10an 11an 12an 13an 14an 15Cash at the beginning of the period / Cash la inceputul perioadei1,46513,00047,67750,64581,42593,302144,925206,293207,408248,26928,87549,227109,324169,167223,754273,088INFLOWS / INCASARI6,212,6385,774,7655,938,9486,108,0576,166,1176,166,1176,166,1176,166,1176,166,1177,666,1176,166,1176,166,1176,166,1176,166,1176,166,1176,166,117Cash Sales / Vanzari in numerar4,310,6385,172,7655,327,9485,487,7875,542,6655,542,6655,542,6655,542,6655,542,6655,542,6655,542,6655,542,6655,542,6655,542,6655,542,6655,542,665Incash of the receivables from previous and current year/ Incasari aferente creantelor din anul precedent si din anul curent curent300,000300,000309,000318,270321,453321,453321,453321,453321,453321,453321,453321,453321,453321,453321,453321,453Investment loans / Credite pt investitii1,300,0001,500,000Working capital loans/ Credite pt capital de lucru302,000302,000302,000302,000302,000302,000302,000302,000302,000302,000302,000302,000302,000302,000302,000302,000Due to affiliated / Credite actionari / asociati / companii din grupOUTFLOWS / PLATI6,201,1035,740,0895,935,9806,077,2786,154,2406,114,4946,104,7496,165,0036,125,2577,885,5116,145,7656,106,0206,106,2756,111,5306,116,7846,117,039Cash Operational Expenses, from which: / Alte datorii curente platibile imediat (ex:salarii, dividende, rambursari imprumuturi asociati, firme din grup*)100,000100,0005,00050,000120,000120,000150,000250,000250,00045,000145,000145,000185,000230,000275,000315,000Corporate tax and other taxes / Impozit pe profit si alte taxe (plati catre buget)65,81923,32724,63725,98726,45126,45126,45126,45126,45126,45126,45126,45126,45126,45126,45126,451Payments for due suppliers from previous and current year/ Plati furnizori din anii precedenti si din anul curent scadenti in anul curent4,170,2844,516,8144,647,5854,782,2794,828,5244,828,5244,828,5244,828,5244,828,5244,828,5244,828,5244,828,5244,828,5244,828,5244,828,5244,828,524Purchase / investments in fixed assets / Cumparari / investitii in active fixe1,530,0001,800,000Loans reimbursements / Rambursari credite 1 (inclusiv dobanda)**764,948923,758884,012844,266804,520764,774725,028685,283645,537605,791566,045526,299486,553446,808407,062Loans reimbursements / Rambursari credite 2 (inclusiv dobanda)**335,000335,000335,000335,000335,000335,000335,000335,000335,000335,000335,000335,000335,000335,000335,000335,000Loans reimbursements / Rambursari credite 3 (inclusiv dobanda)**205,000205,000205,001205,001205,002205,002205,003Loans reimbursements TOTAL / Rambursari credite TOTAL335,0001,099,9481,258,7581,219,0121,179,2661,139,5201,099,7741,060,0281,020,2831,185,5371,145,7911,106,0461,066,3001,026,555986,810947,065Leasing reimbursements / Rambursari leasing 1 (inclusiv dobanda, val reziduala- daca e cazul)Leasing reimbursements / Rambursari leasing 2 (inclusiv dobanda, val reziduala- daca e cazul))Leasing reimbursements / Rambursari leasing 3 (inclusiv dobanda, val reziduala- daca e cazul)Leasing reimbursements TOTAL / Rambursari leasing TOTAL0000000000000000Balance (Inflows - Outflows) / Sold (Incasari - Plati)11,53534,6772,96930,77911,87751,62361,3691,11540,860(219,394)20,35260,09759,84354,58849,33349,078Cash at the end of the period / Cash la sfarsitul perioadei13,00047,67750,64581,42593,302144,925206,293207,408248,26928,87549,227109,324169,167223,754273,088322,166130000

R621829:Va rugam introduceti valoarea cash-ului la inceputul perioadei

NPVCompany nameAAARelationship Manager nameHanu Mircea DanielInterest rate6.00%Investment value (eur)1,000,000No of years (loan period)15thousand euryear 1year 2year 3year 4year 5year 6year 7year 8year 9year 10year 11year 12year 13year 14year 15Net profit122.46129.35136.43138.87138.87138.87138.87138.87138.87138.87138.87138.87138.87138.87138.87Depreciation127.25127.25127.25127.25127.25127.25127.25127.25127.25127.25127.25127.25127.25127.25127.25Annual installments to be paid (interest is not included)44.8389.6689.6689.6689.6689.6689.6689.6689.6689.6689.6689.6689.6689.6689.66P/L cash flow204.88166.94174.02176.46176.46176.46176.46176.46176.46176.46176.46176.46176.46176.46176.46Investment value-100000000000000000Discounted Cash Flow(806.71)148.57146.11139.77131.86124.39117.35110.71104.4498.5392.9587.6982.7378.0573.63Investment valueNet Present Value730.09Repayment period (years)Y7Discounted CFY1204.88204.88(795.12)Y2148.57353.46(646.54)Y3146.11499.57(500.43)Y4139.77639.34(360.66)Y5131.86771.20(228.80)Y6124.39895.59(104.41)Y7117.351,012.9412.94Y8110.711,123.65123.65Y9104.441,228.10228.10Y1098.531,326.63326.63Y1192.951,419.59419.59Y1287.691,507.28507.28Y1382.731,590.01590.01Y1478.051,668.05668.05Y1573.631,741.68741.68Repayment period = 1st year with value zero on column D

Sheet4Credite BTsoldgarantiiGrafic de rambursareinvestitii27217117,033.10IpotecaEURSuma5,590,000.00Cheltuieli generale250,000.00FNGCIMM 80% + depozit colateral200,000.00RONDobinda9.71Linie de credit502,315.00ipotecanr. crt.Cheltuieli generale74,520.00ipotecaSoldPlata PrincipalDobinda de plataComision de administrare12345678910111213141515,590,000.0045,232.422,795.0032,126.44Rate192,758.62385,517.24385,517.24385,517.24385,517.24385,517.24385,517.24385,517.24385,517.24385,517.24385,517.24385,517.24385,517.24385,517.24385,517.242943,868.102200009460004730005,590,000.0045,232.422,795.00dobinzi538,889.65506,915.01469,481.29432,047.57394,613.84357,180.12319,746.39282,312.67244,878.95207,445.22170,011.50132,577.7795,144.0557,710.3220,276.603693,868.105,590,000.0045,232.422,795.00comisioane33,299.0531,323.2829,010.1726,697.0724,383.9722,070.8619,757.7617,444.6615,131.5512,818.4510,505.348,192.245,879.143,566.031,252.9345,590,000.0045,232.422,795.00764,948.33923,757.53884,011.70844,265.88804,520.05764,774.22725,028.39685,282.57645,536.74605,790.91566,045.08526,299.26486,553.43446,807.60407,061.775ipoteca828,966.9013000005,590,000.0045,232.422,795.0065,590,000.0045,232.422,795.0075,590,000.0032,126.4445,232.422,795.008refinantare826,835.005,557,873.5632,126.4444,972.462,778.949626,835.005,525,747.1332,126.4444,712.502,762.87105,493,620.6932,126.4444,452.552,746.8111202,131.905,461,494.2532,126.4444,192.592,730.7512200,000.005,429,367.8232,126.4443,932.632,714.68192,758.62538,889.6533,299.0513majorare402,131.905,397,241.3832,126.4443,672.682,698.62538,889.65141,228,966.905,365,114.9432,126.4443,412.722,682.5633,299.05155,332,988.5132,126.4443,152.772,666.49165,300,862.0732,126.4442,892.812,650.43175,268,735.6332,126.4442,632.852,634.37185,236,609.2032,126.4442,372.902,618.30195,204,482.7632,126.4442,112.942,602.24205,172,356.3232,126.4441,852.982,586.18215,140,229.8932,126.4441,593.032,570.11225,108,103.4532,126.4441,333.072,554.05235,075,977.0132,126.4441,073.112,537.99245,043,850.5732,126.4440,813.162,521.93385,517.24506,915.0131,323.28255,011,724.1432,126.4440,553.202,505.86506,915.01264,979,597.7032,126.4440,293.242,489.8031,323.28274,947,471.2632,126.4440,033.292,473.74284,915,344.8332,126.4439,773.332,457.67294,883,218.3932,126.4439,513.382,441.61304,851,091.9532,126.4439,253.422,425.55314,818,965.5232,126.4438,993.462,409.48324,786,839.0832,126.4438,733.512,393.42334,754,712.6432,126.4438,473.552,377.36344,722,586.2132,126.4438,213.592,361.29354,690,459.7732,126.4437,953.642,345.23364,658,333.3332,126.4437,693.682,329.17385,517.24469,481.2929,010.17374,626,206.9032,126.4437,433.722,313.10469,481.29384,594,080.4632,126.4437,173.772,297.0429,010.17394,561,954.0232,126.4436,913.812,280.98404,529,827.5932,126.4436,653.852,264.91414,497,701.1532,126.4436,393.902,248.85424,465,574.7132,126.4436,133.942,232.79434,433,448.2832,126.4435,873.992,216.72444,401,321.8432,126.4435,614.032,200.66454,369,195.4032,126.4435,354.072,184.60464,337,068.9732,126.4435,094.122,168.53474,304,942.5332,126.4434,834.162,152.47484,272,816.0932,126.4434,574.202,136.41385,517.24432,047.5726,697.07494,240,689.6632,126.4434,314.252,120.34432,047.57504,208,563.2232,126.4434,054.292,104.2826,697.07514,176,436.7832,126.4433,794.332,088.22524,144,310.3432,126.4433,534.382,072.16534,112,183.9132,126.4433,274.422,056.09544,080,057.4732,126.4433,014.472,040.03554,047,931.0332,126.4432,754.512,023.97564,015,804.6032,126.4432,494.552,007.90573,983,678.1632,126.4432,234.601,991.84583,951,551.7232,126.4431,974.641,975.78593,919,425.2932,126.4431,714.681,959.71603,887,298.8532,126.4431,454.731,943.65385,517.24394,613.8424,383.97613,855,172.4132,126.4431,194.771,927.59394,613.84623,823,045.9832,126.4430,934.811,911.5224,383.97633,790,919.5432,126.4430,674.861,895.46643,758,793.1032,126.4430,414.901,879.40653,726,666.6732,126.4430,154.941,863.33663,694,540.2332,126.4429,894.991,847.27673,662,413.7932,126.4429,635.031,831.21683,630,287.3632,126.4429,375.081,815.14693,598,160.9232,126.4429,115.121,799.08703,566,034.4832,126.4428,855.161,783.02713,533,908.0532,126.4428,595.211,766.95723,501,781.6132,126.4428,335.251,750.89385,517.24357,180.1222,070.86733,469,655.1732,126.4428,075.291,734.83357,180.12743,437,528.7432,126.4427,815.341,718.7622,070.86753,405,402.3032,126.4427,555.381,702.70763,373,275.8632,126.4427,295.421,686.64773,341,149.4332,126.4427,035.471,670.57783,309,022.9932,126.4426,775.511,654.51793,276,896.5532,126.4426,515.551,638.45803,244,770.1132,126.4426,255.601,622.39813,212,643.6832,126.4425,995.641,606.32823,180,517.2432,126.4425,735.691,590.26833,148,390.8032,126.4425,475.731,574.20843,116,264.3732,126.4425,215.771,558.13385,517.24319,746.3919,757.76853,084,137.9332,126.4424,955.821,542.07319,746.39863,052,011.4932,126.4424,695.861,526.0119,757.76873,019,885.0632,126.4424,435.901,509.94882,987,758.6232,126.4424,175.951,493.88892,955,632.1832,126.4423,915.991,477.82902,923,505.7532,126.4423,656.031,461.75912,891,379.3132,126.4423,396.081,445.69922,859,252.8732,126.4423,136.121,429.63932,827,126.4432,126.4422,876.161,413.56942,795,000.0032,126.4422,616.211,397.50952,762,873.5632,126.4422,356.251,381.44962,730,747.1332,126.4422,096.301,365.37385,517.24282,312.6717,444.66972,698,620.6932,126.4421,836.341,349.31282,312.67982,666,494.2532,126.4421,576.381,333.2517,444.66992,634,367.8232,126.4421,316.431,317.181002,602,241.3832,126.4421,056.471,301.121012,570,114.9432,126.4420,796.511,285.061022,537,988.5132,126.4420,536.561,268.991032,505,862.0732,126.4420,276.601,252.931042,473,735.6332,126.4420,016.641,236.871052,441,609.2032,126.4419,756.691,220.801062,409,482.7632,126.4419,496.731,204.741072,377,356.3232,126.4419,236.771,188.681082,345,229.8932,126.4418,976.821,172.61385,517.24244,878.9515,131.551092,313,103.4532,126.4418,716.861,156.55244,878.951102,280,977.0132,126.4418,456.911,140.4915,131.551112,248,850.5732,126.4418,196.951,124.431122,216,724.1432,126.4417,936.991,108.361132,184,597.7032,126.4417,677.041,092.301142,152,471.2632,126.4417,417.081,076.241152,120,344.8332,126.4417,157.121,060.171162,088,218.3932,126.4416,897.171,044.111172,056,091.9532,126.4416,637.211,028.051182,023,965.5232,126.4416,377.251,011.981191,991,839.0832,126.4416,117.30995.921201,959,712.6432,126.4415,857.34979.86385,517.24207,445.2212,818.451211,927,586.2132,126.4415,597.39963.79207,445.221221,895,459.7732,126.4415,337.43947.7312,818.451231,863,333.3332,126.4415,077.47931.671241,831,206.9032,126.4414,817.52915.601251,799,080.4632,126.4414,557.56899.541261,766,954.0232,126.4414,297.60883.481271,734,827.5932,126.4414,037.65867.411281,702,701.1532,126.4413,777.69851.351291,670,574.7132,126.4413,517.73835.291301,638,448.2832,126.4413,257.78819.221311,606,321.8432,126.4412,997.82803.161321,574,195.4032,126.4412,737.86787.10385,517.24170,011.5010,505.341331,542,068.9732,126.4412,477.91771.03170,011.501341,509,942.5332,126.4412,217.95754.9710,505.341351,477,816.0932,126.4411,958.00738.911361,445,689.6632,126.4411,698.04722.841371,413,563.2232,126.4411,438.08706.781381,381,436.7832,126.4411,178.13690.721391,349,310.3432,126.4410,918.17674.661401,317,183.9132,126.4410,658.21658.591411,285,057.4732,126.4410,398.26642.531421,252,931.0332,126.4410,138.30626.471431,220,804.6032,126.449,878.34610.401441,188,678.1632,126.449,618.39594.34385,517.24132,577.778,192.241451,156,551.7232,126.449,358.43578.28132,577.771461,124,425.2932,126.449,098.47562.218,192.241471,092,298.8532,126.448,838.52546.151481,060,172.4132,126.448,578.56530.091491,028,045.9832,126.448,318.61514.02150995,919.5432,126.448,058.65497.96151963,793.1032,126.447,798.69481.90152931,666.6732,126.447,538.74465.83153899,540.2332,126.447,278.78449.77154867,413.7932,126.447,018.82433.71155835,287.3632,126.446,758.87417.64156803,160.9232,126.446,498.91401.58385,517.2495,144.055,879.14157771,034.4832,126.446,238.95385.5295,144.05158738,908.0532,126.445,979.00369.455,879.14159706,781.6132,126.445,719.04353.39160674,655.1732,126.445,459.08337.33161642,528.7432,126.445,199.13321.26162610,402.3032,126.444,939.17305.20163578,275.8632,126.444,679.22289.14164546,149.4332,126.444,419.26273.07165514,022.9932,126.444,159.30257.01166481,896.5532,126.443,899.35240.95167449,770.1132,126.443,639.39224.89168417,643.6832,126.443,379.43208.82385,517.2457,710.323,566.03169385,517.2432,126.443,119.48192.7657,710.32170353,390.8032,126.442,859.52176.703,566.03171321,264.3732,126.442,599.56160.63172289,137.9332,126.442,339.61144.57173257,011.4932,126.442,079.65128.51174224,885.0632,126.441,819.69112.44175192,758.6232,126.441,559.7496.38176160,632.1832,126.441,299.7880.32177128,505.7532,126.441,039.8364.2517896,379.3132,126.44779.8748.1917964,252.8732,126.44519.9132.1318032,126.4432,126.44259.9616.06385,517.2420,276.601,252.9320,276.601,252.93