Anexa 5_Model Cash Flow

download Anexa 5_Model Cash Flow

of 12

Transcript of Anexa 5_Model Cash Flow

Sheet1Anexa 5MODEL PENTRU SIMULARE CASH FLOWDurata proiectului n luni18DMI3.1.Valoare total eligibil3510805Valoare total contribuie proprie70216.0976Valoare total nerambursabil3440588.7824Valoare TVA eligibil258693Prefinanare 1175540.244Prefinanare 2175540.244va putea fi solicitat dup autorizarea/validarea unor cheltuieli n valoare de105324.1464Total prefinanare acordat351080.488mart/1apr/2mai/3iun/4iul/5aug/6sept/7oct/8noi/9dec/10ian/11febr/12mart/13apr/14mai/15iun/16iul/17aug/18TOTAL cheltuitsept/19oct/20Sold iniial de numerar3901117066-149296-257260-414823-118012-434780-354301-559470-357527-562696-442113-647282-450320-655489-458527-663695-466733-552346-150216ncasare prefinanare 1175540.24Deducere/ prefinanare12474.9384595.6673243.06104387.4676379.39Cereri de rambursare depuse la AM/OI62374.64422978.28366215.28521937.28410337.28410337.28410337.28410337.28410337.2885613.00ncasri Cereri de Rambursare48652.22329923.06285647.92407111.08325751.14402130.53402130.53402130.53402130.5383900.74ncasare prefinanare 2175540.24Total ncasri175540.240.0048652.220.00505463.300.00285647.920.00407111.080.00325751.140.00402130.530.00402130.530.00402130.530.00402130.5383900.74Plati1. Resurse UmaneManager Proiect850085008500850085008500850085008500850085008500850085008500850085008500153000Responsabil financiar700070007000700070007000700070007000700070007000700070007000700070007000126000Consilier juridic40004000400040004000400040004000400040004000400040004000400040004000400072000Responsabil monitorizare act. Operatori grup int1000010000100001000010000100001000010000100001000010000100001000010000100001000010000100001800007 operatori grup int regionali80008000800080008000800080008000800080008000800080008000800080001280002 experi loc. termen scurt - lectori conf motivare1000010000200001 expert PR70007000700070007000700070007000700070007000700070007000700070007000700012600010 profesori-traineri formare550005500055000550005500055000550005500055000550005500055000660000Expert IT Hardware800080008000800080008000800080008000800080008000800080008000800080008000144000Coordonator activ. Formare650065006500650065006500650065006500650065006500650065006500650065006500117000Total salarii resurse umane5100051000590006900069000114000114000114000114000114000114000114000114000114000114000114000114000590001726000Diurne personal proiect 100 uniti2289898982282282282282282282282282282282282283250Cazare personal proiect105045045045010501050105010501050105010501050105010501050105015000TVA aferent cazrii0954141419595959595959595959595951350Transport sesiuni training pers proiect (3 pers = 1 masina x 600 km x 24 sesiuni training + 7 pers=2 masini x 600 km x 2 conf de motivare)-combustibil4504502252252252252252252252252252252252253600Combustibil pt alte deplasari ale pers. din echipa de management (1 main x 600 km x 16 luni)2252252252252252252252252252252252252252252252253600TVA aferent transportului (combustibilului)054541621621081081081081081081081081081081081081728Total diurne, transport, cazare015037731223122317281728172817281728172817281728172817281728172825450Total TVA eligibil aferent transport, cazare01499520320320320320320320320320320320320320320330781.Total General resurse umane5100052503597737022370223115728115728115728115728115728115728115728115728115728115728115728115728590001751450Total RU , inclusiv TVA eligibil aferent51000526515986770425704251159301159301159301159301159301159301159301159301159301159301159301159305900017545282. Participani/subvenii (550 pers x 600 RON/pers)3000030000300003000030000300003000030000300003000030000300003600003. Alte tipuri de costuriSubcontractri/achiziiiConferine motivare (2 x 225 pers)225002250045000Conferine diseminare (2 x 85 pers)6375637512750Sesiuni Training 24 sesiuni x 25 pers100001000010000100001000010000100001000010000100001000010000120000Servicii studii de pia350003500070000Aplicaii de dezvoltare i raportare2000020000Materiale consumabile i ob de inventar100010001000100010001000100010001000100010001000100013000Autoturism (rate leasing i doband)52005200520052005200520052005200520052005200520052005200520078000nchirieri 7 birouri210002100021000210002100021000210002100021000210002100021000210002100021000315000Contabilitate1320132013201320132013201320132013201320132013201320132013201320132022440Audit4166416641664166416641664166416641664166416641664166416641664166416670822Promovare62505500061250Subtotal Alte tipuri de costuri/subcontractari54863186172936551865418613268642686426864268642686426864268642686426864268642686426866375828262TVA eligibil aferent subcontarctrilor1317764717505132451300531845102451024510245102451024510245102451024510245102451024515301987833.1 Din care FEDRCalculatoare portabile310001720048200Telefoane mobile26000260001 Server Web i baze de date3100031000Mobil2240022400Multifuncionale dotari birouri locale i central5600056000Camera video40004000Videoproiector1000010000Subtotal FEDR1354001000052200197600TVA eligibil aferent FEDR3249624001252847424Total Alte tipuri de costuri54861672617293665186106386132686426864268642686426864268642686426864268642686426864268663751025862TVA eligibil aferente altor tipuri de costuri13174014317505156452553331845102451024510245102451024510245102451024510245102451024515302462075. Total cheltuieli directe proiect, inclusiv TVA eligibil aferent578032600551503081512562023443104611988611988611988611988611988611988611988611988611988611988611988616690533865972199106. Cheltuieli generale de adm./max7% din cheltuielile directe - FEDR , resp. max.219910Personal administrativ40004000400040004000400040004000400040004000400040004000400040004000400072000Utiliti sedii1400140014001400140014001400140014001400140014001400140014001400140023800Arhivare1000010000Comisioane bancare2002002002002002002002002002002002002002002002002002003600Consumabile sediu3003003003003003003003003003003003003003003003003003005400TVA eligibil aferent cheltuielilor indirecte72408408408408408408408408408408408408408408408408280894086. Total Cheltuieli indirecte (inclusiv TVA aferent)4572630863086308630863086308630863086308630863086308630863086308630818708124208Total pli Solicitant Principal6237526636315661615756420865231676920516920516920516920516920516920516920516920516920516920516920516985613351080500Flux net de numerar (+/-)113166-266363-107963-157564296812-31676980479-205169201942-205169120583-205169196962-205169196962-205169196962-8561340213183901Sold final de numerar117066-149296-257260-414823-118012-434780-354301-559470-357527-562696-442113-647282-450320-655489-458527-663695-466733-552346-150216-66315suma max de finantatContributie propie12475327313231514173633541034103410341034103410341034103410341034103171270216

Sheet2

Sheet3