ramboll_dec 2014 - lucru echipa

Exercitiu - Realizare forecast- Decembrie 2014- RAMBOLL

P a g e | 2 P a g e | 2 2014 The ExP Group. Nicio parte din acest material nu poate fi reprodusa sau distribuita sub nicio forma electronica sau fizica fara

permisiunea scrisa a ExP Group. Aceste note reprezinta rezumate si fragmente ce au ca unic scop indrumare educationala si suport de studiu limitat, neavand prin urmare drept scop acela de a reda realitatea specifica de business a vreunei companii sau de a prezenta tratamente contabile relationate sau de a oferi solutii aplicabile in practica, prin urmare Exp nu se face raspunzatoare de completitudinea si

acuratetea acestora. A se consulta textul integral actualizat al legislatiei, standardelor si politicilor contabile relevante pentru dobandirea unor cunostinte si intelegeri corecte si complete, precum si sfatul unui specialist inainte de a se aplica orice concept in practica. The ExP

Group nu este raspunzatoare de niciun prejudiciu cauzat de folosirea acestui material.

.

ian cumulat feb cumulat martie cumulat aprilie cumulat mai cumulat

Forcast venituri si cheltuieli

Proiect A

Venituri 106,666.67 106,666.67 120,000.00 226,666.67 133,333.33 360,000.00 146,666.67 506,666.67 160,000.00 666,666.67

Stadiul de executie 5% 11% 18% 25% 33%

Costuri directe 40,000.00 40,000.00 45,000.00 85,000.00 50,000.00 135,000.00 55,000.00 190,000.00 60,000.00 250,000.00

Cheltuieli cu salariile 25,000.00 25,000.00 27,500.00 52,500.00 30,000.00 82,500.00 32,500.00 115,000.00 35,000.00 150,000.00

Cheltuieli cu subcontractori 15,000.00 15,000.00 17,500.00 32,500.00 20,000.00 52,500.00 22,500.00 75,000.00 25,000.00 100,000.00

Alte costuri 9,333.33 9,333.33 9,833.33 19,166.67 10,333.33 29,500.00 10,833.33 40,333.33 11,333.33 51,666.67

Cheltuieli cu chiria 5,000.00 5,000.00 5,000.00 10,000.00 5,000.00 15,000.00 5,000.00 20,000.00 5,000.00 25,000.00

Cheltuieli cu deplasari convorbiri 1,000.00 1,000.00 1,500.00 2,500.00 2,000.00 4,500.00 2,500.00 7,000.00 3,000.00 10,000.00

Amortizare 3,333.33 3,333.33 3,333.33 6,666.67 3,333.33 10,000.00 3,333.33 13,333.33 3,333.33 16,666.67

Profit inaintea platii impozitului 57,333.33 57,333.33 65,166.67 122,500.00 73,000.00 195,500.00 80,833.33 276,333.33 88,666.67 365,000.00

Impozit pe profit 9,173.33 9,173.33 10,426.67 19,600.00 11,680.00 31,280.00 12,933.33 44,213.33 14,186.67 58,400.00

Profitul perioadei 48,160.00 48,160.00 54,740.00 102,900.00 61,320.00 164,220.00 67,900.00 232,120.00 74,480.00 306,600.00






.

iunie cumulat iulie cumulat aug cumulat sep cumulat oct cumulat nov cumulat dec cumulat

173,333.33 840,000.00 186,666.67 1,026,666.67 200,000.00 1,226,666.67 213,333.33 1,440,000.00 200,000.00 1,640,000.00 186,666.67 1,826,666.67 173,333.33 2,000,000.00

42% 51% 61% 72% 82% 91% 100%

65,000.00 315,000.00 70,000.00 385,000.00 75,000.00 460,000.00 80,000.00 540,000.00 75,000.00 615,000.00 70,000.00 685,000.00 65,000.00 750,000.00

37,500.00 187,500.00 40,000.00 227,500.00 42,500.00 270,000.00 45,000.00 315,000.00 42,500.00 357,500.00 40,000.00 397,500.00 37,500.00 435,000.00

27,500.00 127,500.00 30,000.00 157,500.00 32,500.00 190,000.00 35,000.00 225,000.00 32,500.00 257,500.00 30,000.00 287,500.00 27,500.00 315,000.00

11,833.33 63,500.00 12,333.33 75,833.33 12,833.33 88,666.67 13,333.33 102,000.00 12,833.33 114,833.33 12,333.33 127,166.67 11,833.33 139,000.00

5,000.00 30,000.00 5,000.00 35,000.00 5,000.00 40,000.00 5,000.00 45,000.00 5,000.00 50,000.00 5,000.00 55,000.00 5,000.00 60,000.00

3,500.00 13,500.00 4,000.00 17,500.00 4,500.00 22,000.00 5,000.00 27,000.00 4,500.00 31,500.00 4,000.00 35,500.00 3,500.00 39,000.00

3,333.33 20,000.00 3,333.33 23,333.33 3,333.33 26,666.67 3,333.33 30,000.00 3,333.33 33,333.33 3,333.33 36,666.67 3,333.33 40,000.00

96,500.00 461,500.00 104,333.33 565,833.33 112,166.67 678,000.00 120,000.00 798,000.00 112,166.67 910,166.67 104,333.33 1,014,500.00 96,500.00 1,111,000.00

15,440.00 73,840.00 16,693.33 90,533.33 17,946.67 108,480.00 19,200.00 127,680.00 17,946.67 145,626.67 16,693.33 162,320.00 15,440.00 177,760.00

81,060.00 387,660.00 87,640.00 475,300.00 94,220.00 569,520.00 100,800.00 670,320.00 94,220.00 764,540.00 87,640.00 852,180.00 81,060.00 933,240.00






.

Buget de incasari si plati

Incasari fonduri 400,000.00 200,000.00 200,000.00 300,000.00 900,000.00

Total

Plati 40,000.00 51,000.00 127,780.00 62,000.00 67,500.00 115,560.00 78,500.00 84,000.00 143,340.00 85,000.00 79,500.00 124,080.00

Furnizori

(luna urmatoare) 6,000.00 6,500.00 7,000.00 7,500.00 8,000.00 8,500.00 9,000.00 9,500.00 10,000.00 9,500.00 9,000.00 8,500.00

Costuri salarii Directe si

subcontractori 40,000.00 45,000.00 50,000.00 55,000.00 60,000.00 65,000.00 70,000.00 75,000.00 80,000.00 75,000.00 70,000.00 65,000.00

Plata

echipament 40,000.00

Plata impozit

pe profit 31,280.00 42,560.00 53,840.00 50,080.00

Incasari

minus plati in luna 360,000.00 -51,000.00 72,220.00 -62,000.00 -67,500.00 84,440.00 -78,500.00 -84,000.00 156,660.00 -85,000.00 -79,500.00 775,920.00

Sold

numerar la sfarsit de luna 360,000.00 309,000.00 381,220.00 319,220.00 251,720.00 336,160.00 257,660.00 173,660.00 330,320.00 245,320.00 165,820.00 941,740.00 933,240.00

ramboll_dec 2014 - lucru echipa

Documents