PROIECT INGINERIE

download PROIECT  INGINERIE

of 20

Transcript of PROIECT INGINERIE

  • 7/28/2019 PROIECT INGINERIE

    1/20

    Initial Investment

    Initial investment Quantity Price per unit Total price

    Acquisition of space 1 100,000.00 100,000.00

    Electrical installations 1 2,000.00 2,000.00

    Interior paints 1 2,000.00 2,000.00 Installing air conditioning 1 500.00 500.00

    Installing security system 1 1,000.00 1,000.00

    Purchase and Renovation 105,500.00

    Office computer 20 100.00 2,000.00

    Computer chairs 20 40.00 800.00

    Office 1 350.00 350.00

    Chairs 5 15.00 75.00

    Storage cabinets 3 75.00 225.00

    Sofa 2 50.00 100.00

    Glass shelves 6 80.00 480.00

    Wooden shelves 3 30.00 90.00

    Spots 5 40.00 200.00

    Furniture 4,320.00

    Coffee Machine 2 150.00 300.00

    Fridge 1 200.00 200.00

    Microwave 1 80.00 80.00

    TV LCD 2 1,000.00 2,000.00

    Pack of computers 20 2,000.00 40,000.00

    Wireless Router 1 65.00 65.00

    Switchers 2 60.00 120.00

    Air conditioning 2 500.00 1,000.00

    Multifunction printer 1 100.00 100.00

    Fax 1 70.00 70.00

    Pack POS 1 1,500.00 1,500.00

    Alarm system 1 500.00 500.00

    Surveillance Cameras 6 250.00 1,500.00

    Equipment 47,435.00

    Licenses for Windows 20 150.00 3,000.00

    Licenses for antivirus 10 100.00 1,000.00

    Licenses 4,000.00

    TOTAL 161,255.00

    Own capital (Equity) - 50% of the

    initial investment80,627.50

    Bank Loan - 50% of Initial

    Investment80,627.50

    Amortized

    over 5 years

    Annual rate of

    9%

    IRC = 25%

    IRS = 8%

  • 7/28/2019 PROIECT INGINERIE

    2/20

    Social Security = 23,75%

    Stamp duty = 0.9%

  • 7/28/2019 PROIECT INGINERIE

    3/20

    Table of monthly revenue

    Value without VAT Value of VAT Quantity

    Hours of Gaming 1890

    1,626.02 373.98 Hours of Internet 810

    1,626.02 373.98 Hours of Wireless 180406.50 93.50 Cyber Area

    813.01 186.99 Laptop Minnie 1800

    1,028.46 Laptop Leapfrog Scout 1800

    1,626.02 373.98 Laptop Barbie 1800

    650.41 149.59 Laptop Spiderman 900

    284.55 65.45 Laptop Winnie The Pooh 900

    60.98 14.02 Y-Pads for kids 900

    182.93 42.07 Camera Disney 900

    81.30 18.70 Electronic Kids Area

    390.24 89.76 TOTAL

    73.17 16.83 TOTAL ANNUAL

    162.60 37.40

    807.80 TOTAL ANNUAL

    243.90 56.10

    162.60 37.40

    65.04 14.96 Monthly clients 3600

    1,626.02 373.98

    32,520.33 7,479.67

    52.85 12.15

    97.56 22.44

    813.01 186.99

    81.30 18.70

    56.91 13.09

    1,219.51 280.49

    406.50 93.50

    1,219.51 280.49

    8,869.96

    2,439.02 560.98

    813.01 186.99

    747.97

    11,454.19

  • 7/28/2019 PROIECT INGINERIE

    4/20

  • 7/28/2019 PROIECT INGINERIE

    5/20

    Price per unit Total price Value without VAT Value of VAT

    2.50 4,725.00 3,841.46 883.54

    1.50 1,215.00 987.80 227.20

    1.00 180.00 146.34 33.66 6,120.00 4,975.61 1,144.39

    1.00 1,800.00 1,698.11 101.89

    1.20 2,160.00 1,756.10 403.90

    0.65 1,170.00 951.22 218.78

    2.50 2,250.00 1,991.15 258.85

    1.00 900.00 796.46 103.54

    2.50 2,250.00 1,991.15 258.85

    1.00 900.00 731.71 168.29

    11,430.00 9,915.90 1,514.10

    17,550.00 14,891.51 2,658.49

    210,600.00 178,698.10 31,901.90

    213,800.00 173,821.14 39,978.86

  • 7/28/2019 PROIECT INGINERIE

    6/20

  • 7/28/2019 PROIECT INGINERIE

    7/20

    Monthly costs

    Quantity Price per unit Total price

    Laptop Minnie Pack 6*Unit 400 1.20 480.00

    Laptop LeapFrog Scout Pack 12*Unit 200 6.20 1,240.00

    Laptop Barbie Pack 10*Unit 240 3.70 888.00 Laptop Spiderman 300 3.40 1,020.00

    Laptop Winnie The Pooh Pack 8*Unit 150 1.00 150.00

    Y-Pads for kids Pack 2*Unit 600 3.00 1,800.00

    Camera Disney Pack 6*Unit 200 3.20 640.00

    Electronic Kids Area 6,218.00

    Maintenance Service 1 250.00 250.00

    Vodafone Services 1 70.00 70.00

    Cleaning Service 1 500.00 500.00

    Current expenditure 1 1,800.00 1,800.00

    Salaries 1 1,000.00 1,000.00 14,000.00

    Services / Expenditures / Salaries 3,620.00

    TOTAL 9,838.00

    TOTAL ANNUAL 118,056.00

    120,306.00

  • 7/28/2019 PROIECT INGINERIE

    8/20

  • 7/28/2019 PROIECT INGINERIE

    9/20

    Value without VAT Value of VAT

    452.83 27.17

    1,008.13 231.87

    721.95 166.05 902.65 117.35

    132.74 17.26

    1,592.92 207.08

    520.33 119.67

    5,331.56 886.44

    203.25 46.75

    56.91 13.09

    406.50 93.50

    1,463.41 336.59

    2,130.08 489.92

    1,376.36

    16,516.36

  • 7/28/2019 PROIECT INGINERIE

    10/20

    FINANCIAL CHARGES interest rate is 9%

    Period Outstanding capital Interest rate Amortization

    1 80,627.50 7,256.48 12,408.77

    2 68,218.73 6,139.69 13,525.56

    3 54,693.17 4,922.39 14,742.86

    4 39,950.31 3,595.53 16,069.72

    5 23,880.60 2,149.25 17,515.99

    Amortization

    Initial Investment Quantity Value 3 Years

    Acquisition of space 1 100,000.00 2,000.00

    Remodeling 1 5,500.00 550.00

    Office computer 20 2,000.00 250.00

    Computer chairs 20 800.00 100.00

    Office 1 350.00 43.75

    Chairs 5 75.00 9.38

    Storage cabinets 3 225.00 28.13

    Sofa 2 100.00 12.50

    Glass shelves 6 480.00 60.00

    Wooden shelves 3 90.00 11.25

    Spots 5 200.00 25.00

    Coffee Machine 2 300.00 42.84

    Fridge 1 200.00 28.56

    Microwave 1 80.00 11.42

    TV LCD 2 2,000.00 285.60

    Pack of computers 20 40,000.00 13,332.00

    Wireless Router 1 65.00 9.28

    Switchers 2 120.00 17.14

    Air conditioning 2 1,000.00 142.80

    Multifunction printer 1 100.00 20.00

    Fax 1 70.00 14.00

    Pack POS 1 1,500.00 214.20

    Alarm system 1 500.00 71.40

    Surveillance Cameras 6 1,500.00 214.20

    TOTAL 17,493.44

  • 7/28/2019 PROIECT INGINERIE

    11/20

    Provision Total provision

    19,665.24 26,921.72

    19,665.24 25,804.93

    19,665.24 24,587.63

    19,665.24 23,260.77

    19,665.24 21,814.50

    4 Years 5 Years Rate

    2,000.00 2,000.00 2.00%

    550.00 550.00 10.00%

    250.00 250.00 12.50%

    100.00 100.00 12.50%

    43.75 43.75 12.50%

    9.38 9.38 12.50%

    28.13 28.13 12.50%

    12.50 12.50 12.50%

    60.00 60.00 12.50%

    11.25 11.25 12.50%

    25.00 25.00 12.50%

    42.84 42.84 14.28%

    28.56 28.56 14.28%

    11.42 11.42 14.28%

    285.60 285.60 14.28%

    33.33%

    9.28 9.28 14.28%

    17.14 17.14 14.28%

    142.80 142.80 14.28%

    20.00 20.00 20.00%

    14.00 14.00 20.00%

    214.20 214.20 14.28%

    71.40 71.40 14.28%

    214.20 214.20 14.28%

    4,161.44 4,161.44

  • 7/28/2019 PROIECT INGINERIE

    12/20

    Taxes

    Period 1 2 3 4

    PIT 1,120.00 1,120.00 1,120.00 1,120.00

    Social Security 3,451.00 3,451.00 3,451.00 3,451.00

    CIT 17,186.02 17,465.22 17,769.54 21,434.26

    VAT 12,008.31 23,462.50 23,462.50 23,462.50

    TOTAL 33,765.33 45,498.72 45,803.04 49,467.76

  • 7/28/2019 PROIECT INGINERIE

    13/20

    5

    1,120.00 PIT 8.00%

    3,451.00 TC+IS 24.65%

    21,795.83 CIT 25.00%

    23,462.50

    49,829.33

  • 7/28/2019 PROIECT INGINERIE

    14/20

    Account of exploitation

    Period 0 1 2 3

    Initial investment 161,255.00

    Sales 213,800.00 213,800.00 213,800.00

    Costs 120,306.00 120,306.00 120,306.00

    Gross Income 93,494.00 93,494.00 93,494.00

    Depreciation 17,493.44 17,493.44 17,493.44

    Financial Charges7,256.48 6,139.69 4,922.39

    Income before taxes 68,744.08 69,860.87 71,078.17

    PIT 1,120.00 1,120.00 1,120.00

    Social Security 3,451.00 3,451.00 3,451.00

    VAT 12,008.31 23,462.50 23,462.50

    CIT 17,186.02 17,465.22 17,769.54

    Results after taxes 34,978.75 24,362.15 25,275.13

    CF exploration 59,728.67 47,995.28 47,690.96

    CF investment 161,255.00

    Net CF 161,255.00 59,728.67 47,995.28 47,690.96

  • 7/28/2019 PROIECT INGINERIE

    15/20

    4 5 PIT 8.00%

    SS+IS 24.65%

    213,800.00 213,800.00 CIT 25.00%

    120,306.00 120,306.00

    93,494.00 93,494.00

    4,161.44 4,161.44

    3,595.53 2,149.25

    85,737.03 87,183.30

    1,120.00 1,120.00

    3,451.00 3,451.00

    23,462.50 23,462.50

    21,434.26 21,795.83

    36,269.27 37,353.98

    44,026.24 43,664.67

    44,026.24 43,664.67

  • 7/28/2019 PROIECT INGINERIE

    16/20

    CASH FLOWS

    Period CF CF Updated CF Accumulated

    0 -161,255.00 -161,255.00 -161,255.00

    1 59,728.67 56,083.25 -105,171.75

    2 47,995.28 42,315.49 -62,856.26

    3 47,690.96 39,480.91 -23,375.35

    4 44,026.24 34,222.61 10,847.27

    5 43,664.67 31,870.01 42,717.28

    Recovery period 3 years 8

  • 7/28/2019 PROIECT INGINERIE

    17/20

    i 6.50%

    months

  • 7/28/2019 PROIECT INGINERIE

    18/20

    NPV IRR

    Interest rate 7.00% N of iterations IRR

    1 1.00%

    Rate of update 6.50% 2 2.00%

    3 3.00%

    NPV 42,717.28 4 4.00%

    5 5.00%

    6 6.00%

    7 7.00%

    8 8.00%

    9 9.00%

    10 10.00%

    11 11.00%

    12 12.00%13 13.00%

    14 14.00%

    15 15.00%

    16 16.00%

    17 17.00%

    18 18.00%

    19 19.00%

    20 20.00%

    21 21.00%

    22 22.00%

    23 23.00%

    24 24.00%

    25 25.00%

  • 7/28/2019 PROIECT INGINERIE

    19/20

    NPV

    75,074.04 % Exact of IRR 16.444%

    68,596.22

    62,400.41

    56,470.83

    50,792.73

    45,352.36

    40,136.86

    35,134.20

    30,333.12

    25,723.07

    21,294.18

    17,037.17 12,943.35

    9,004.55

    5,213.08

    1,561.74

    -1,956.28

    -5,347.36

    -8,617.53

    -11,772.48

    -14,817.55

    -17,757.81

    -20,598.03

    -23,342.71

    -25,996.13

  • 7/28/2019 PROIECT INGINERIE

    20/20

    Profitability index

    Liquid 2.41

    Gross 1.34