Project Adaptie.xlsx

	A	B	C	D	E	F	G	H	I	J
1	INPUTS
2
3	Assets
4	Asset 1	N
5	40-foot Container	600,000.00
6	Foundation	150,000.00
7	Partitions	200,000.00
8	Glass Wall	120,000.00
9	Windows	15,000.00
10	Doors	90,000.00
11	Total:	1,175,000.00
12	Asset 2
13	Printer	50,000.00
14	Table & Chairs	100,000.00
15	Display Screen (TV)	70,000.00
16	Fans	40,000.00
17	Air conditioners	100,000.00
18	Prototypes (Display items)	265,000.00
19	Generator	100,000.00
20	Total:	725,000.00
21
22	Stationeries	5,000.00
23	Ground rent (Yearly)	250,000.00
24	Plumbing works	50,000.00
25	Electrical works	50,000.00
26	Advertisement	250,000.00
27		605,000.00
28
29	Working Capital (3-month Opex)	645,750.00
30	Total Budget:	3,150,750.00
31	Contigencies (10% of Total budget)	315,075.00
32	Grand Total Budget :	3,465,825.00
33
34	OPEX:
35	Salaries/ Month		N
36	Manager	1	120,000.00
37	Operational Staff	1	50,000.00
38		Total:	170,000.00
39	Stationeries		5,000.00
40	Utility/month: Diesel & Lighting		30,000.00			ADJUSTED SELLING PRICES OVER PROJECTION HORIZON
41		Total:	205,000.00		Years	1	2	3	4	5
42	Other Opex (5% of Actual Opex)	5%	10,250.00			110,000.00	115,500.00	121,275.00	127,338.75	133,705.69
43		Grand Total Opex:	215,250.00			80,000.00	84,000.00	88,200.00	92,610.00	97,240.50
44						80,000.00	84,000.00	88,200.00	92,610.00	97,240.50
45						150,000.00	157,500.00	165,375.00	173,643.75	182,325.94
46	Source of Fund	100% Equity	3,465,825.00			210,000.00	220,500.00	231,525.00	243,101.25	255,256.31
47			3,190,825 shares @ =N=1 each		Total:	630,000.00	661,500.00	694,575.00	729,303.75	765,768.94
48						PROJECTED SALES FIGURES
49	Revenue Model:	N	Monthly Projected Sales Figures		Years	1	2	3	4	5
50	ARMARI	110,000.00	2.00			24	25	27	29	30
51	TSUKUE	80,000.00	2.00			24	25	27	29	30
52	GRAFEIO	80,000.00	2.00			24	25	27	29	30
53	BETT	150,000.00	2.00			24	25	27	29	30
54	SENG	210,000.00	2.00			24	25	27	29	30
55	Total:	630,000.00	Av. Sales growth rate	6%	Total:	120	127	135	143	151
56			Av. Selling Price Co-efficient	5%
57
58						ADJUSTED COST PRICES OVER PROJECTION HORIZON
59	Cost Model:	N			Years	1	2	3	4	5
60	ARMARI	60,000.00				60,000.00	66,000.00	72,600.00	79,860.00	87,846.00
61	TSUKUE	40,000.00				40,000.00	44,000.00	48,400.00	53,240.00	58,564.00
62	GRAFEIO	40,000.00				40,000.00	44,000.00	48,400.00	53,240.00	58,564.00
63	BETT	90,000.00				90,000.00	99,000.00	108,900.00	119,790.00	131,769.00
64	SENG	120,000.00				120,000.00	132,000.00	145,200.00	159,720.00	175,692.00
65	Total:	350,000.00	Av. Inflation rate	10%		350,000.00	385,000.00	423,500.00	465,850.00	512,435.00
66
67
68	Number of Days in a year	365
69	Number of Months in a year	12
70
71
72	Depreciation
73	Container-Facility	5%
74	Printer	25%
75	Table & Chairs	20%
76	Display Screen (TV)	25%
77	Fans	25%
78	Air conditioners	25%
79	Prototypes (Display items)	20%
80	Generator	25%
81
82	Taxes
83	Company Income Tax	30%
84	Education Tax	2%
85	Total Tax Liability	32%
86
87	Dividend pay out	30%
88
89	Cost of Equity	15%
90
91
92
93
94
95
96
97
98
99
100