PROIECT INGINERIE
-
Upload
miha-loredana-stoica -
Category
Documents
-
view
244 -
download
0
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