FINANCIAL PLAN OF CHONTADURO JAM
MARISOL MEDINA CASTRILLON
SERVICIO NACIONAL DE APRENDIZAJE GESTION LOGISTICA FICHA (1017082) 2017
FINANCIAL PLAN OF CHONTADURO JAM
MARISOL MEDINA CASTRILLON
SERVICIO NACIONAL DE APRENDIZAJE GESTION LOGISTICA FICHA (1017082 2017
INTRODUCTION.
This study is carried out in order to investigate the financial items attributed to our project, since they will show us what to expect from this with respect to small, medium and long term costs, thus observing the viability of our business plan carried out in the past, .
Financial analysis.
It was observed as the final cash flow was realized, which is a classic structure in an agricultural investment project, in which investment shows a positive flow in all the periods of the fiscal year, which is a logical reflection If we compare the initial cash flow you have. We must also see that the projections of the following years are positive based on the investments that will be made to obtain better quality with appropriate technologies and better facilities. The project IRR is positive since it shows a result of 2.16%, which shows that the project in time will make the return on investment, in addition its Net Present Value is $ 24,573,621.59 being greater than zero It means that our project is profitable.
Investment plan
UNIT VALUE UNIT
INVESTMENT SHEET DESCRIPTION
JAR GLOBAL UNITY GLOBAL GLOBAL
RAW MATERIAL (DIRECT COSTS)
ADEQUACY MACHINERY AND EQUIPMENT RENTING 1 FIRST MONTH (DIRECT COST) PREOPERATIVES (CAMERA AND C, INVIMA REGISTRY, ADVERTISING, ETC) MANUAL OF WORK (Direct Cost) INCIDENTS (Assuming the first month of public services) TOTAL INVESTMENT
UNITY GLOBAL
NUMBER UNITS
TOT AL VAL UE
1.200
2.889.600
2.408 5.000.000
5.000.000
8.000.000
8.000.000
700.000
1
700.000
5.000.000
5.000.000
600.000
810.000 2.239.960 24.639.560
Costs and expenses UNITS
DIRECT (Variables) MATERIA PRIMA (Inputs) WORKFORCE SUPERVISION MAINTENANCE
2.408 225
56
quantity
MONTH
1 YEAR
2 YEARS
3 YEARS
3.6 00 3.6 00
8.668.800
104.025.600
110.267.136
116.883.164
810.000
9.720.000
10.303.200
10.921.392
3.6 00
200.000
2.400.000
2.544.000
2.696.640
PUBLIC SERVICES PARTIAL
61
3.6 00
219.600
2.635.200
2.793.312
2.960.911
9.898.400
118.780.800
125.907.648
133.462.107
700.000
700.000
8.400.000
8.904.000
9.438.240
116.000
116.000
1.392.000
1.475.520
1.564.051
200.000
200.000
2.400.000
2.544.000
2.696.640
150.000
150.000
1.800.000
1.908.000
2.022.480
2.010.000
2.010.000
24.120.000
25.567.200
27.101.232
500.000
500.000
6.000.000
6.360.000
6.741.600
2.976.000
44.112.000
46.758.720
49.564.243
2 YEARS 228.960.00
3 YEARS 242.697.600
2.750
INDIRECT (Fixed) RENT TAXES DEPRECIATION INVESTIGATION AND DEVELOPMENT (technical assistance) ADVERTISING ADMINISTRATION SALES
LOSSES AND PROFITS MONTH
SALES (-) Returns and Discounts
18.000.000
(-) Admission expenses.
0
17.280.000
207.360.000
219.801.60
232.989.696
0
9.898.400
OPERATIONAL GROSS PROFIT (-) Sales Operating Expenses
216.000.000
720.000
OPERATING INCOME (-) Costs of sale
1 YEAR
7.381.600
88.579.200
93.893.952
99.527.589
3.705.600
44.467.200
47.135.232
49.963.346
3.705.600
44.467.200
47.135.232
49.963.346
3.705.600
44.467.200
88.934.400
94.270.464
766.000 2.910.000
OPERATIONAL UTILITY (+) Non-operating income (-) Non-operating expenses NET INCOME BEFORE IMPTO (-) Tax. Of income and complementary NET INCOME (-) Reservations (10%)
370.560
EXERCISE UTILITY
3.335.040
40.020.480
80.040.960
84.843.418
COST ANALYSIS: The costs described above were based on sales of $ 5,000 per bottle, which increased profits. It is recommended to do a more exhaustive analysis for the city of Bogotá since it is seen that it should be launched in a city with greater purchasing power and also in a neighborhood stratum 5 or 6 where it proves that our product is totally innovative.