Caso El SOL 1 producto VAN

Vista previa del material en texto

Examen
		1. Tabla de evolución de valor venta del producto 
			2013	2014	2015	2016	2017
		Argelia	322.03	338.14	355.04	372.79	391.43
		2. Tabla de evolución de ventas en unidades 
			2013	2014	2015	2016	2017
	35%	Argelia	18,340.00	19,340.00	20,161.00	20,100.00	21,220.00
		3. Tabla de evolución de cantidad total vendida en moneda					Ingresos = P*Q
			2013	2014	2015	2016	2017
		Valor Venta	5,906,102	6,539,542	7,158,009	7,493,169	8,306,234
		Argelia	5,906,102	6,539,542	7,158,009	7,493,169	8,306,234
		4. Tabla defabricación y evolución de costos de MP
				Evolución de Costos							Cant (Kg)	Valor compra	Valor total 
		Argelia	Cantidad	2013	2014	2015	2016	2017		Acero	12.00	6.78	81.36
		Acero		6.78	7.12	7.47	7.85	8.24		Aluminio	3.00	15.25	45.76
		Aluminio		15.25	16.02	16.82	17.66	18.54		Metanol	0.12	50.85	6.10
		Metanol		50.85	53.39	56.06	58.86	61.81		Soldadura	0.20	127.12	25.42
		Soldadura		127.12	133.47	140.15	147.16	154.51					158.64
		4.1 Tabla de evolución de consumo MP Unidades
		Argelia		2013	2014	2015	2016	2017
	Kg	Acero	12.000	220,080.00	232,080.00	241,932.00	241,200.00	254,640.00
	kg	Aluminio	3.000	55,020.00	58,020.00	60,483.00	60,300.00	63,660.00
	kg	Metanol	0.120	2,200.80	2,320.80	2,419.32	2,412.00	2,546.40
	kg	Soldadura	0.200	3,668.00	3,868.00	4,032.20	4,020.00	4,244.00
		4.2 Tabla de evolución de consumo MP Moneda
		Argelia		2013	2014	2015	2016	2017
		Acero		1,492,067.80	1,652,094.92	1,808,339.19	1,893,011.19	2,098,417.03
		Aluminio		839,288.14	929,303.39	1,017,190.79	1,064,818.79	1,180,359.58	MP
		Metanol		111,905.08	123,907.12	135,625.44	141,975.84	157,381.28	MOD
		Soldadura		466,271.19	516,279.66	565,106.00	591,566.00	655,755.32	CIF
			Materia Prima	2,909,532.20	3,221,585.08	3,526,261.41	3,691,371.81	4,091,913.20
		5. Tabla de fabricación de cocinas y evolución de costos de CIF1
				Evolución de Costos
				2013	2014	2015	2016	2017
		Caja	1.00	18,340.00	19,340.00	20,161.00	20,100.00	21,220.00
		Bolsa	1.00	18,340.00	19,340.00	20,161.00	20,100.00	21,220.00
		5.1 Tabla de evolución de consumo CIF1 Unidades
			2013	2014	2015	2016	2017
		Envase	18.64	19.58	20.56	21.58	22.66
		Embalaje	2.54	2.67	2.80	2.94	3.09
		5.2 Tabla de evolución de consumo CIF1 Moneda
			2013	2014	2015	2016	2017
		Envase	341,932.20	378,605.08	414,411.06	433,815.06	480,887.24
		Embalaje	46,627.12	51,627.97	56,510.60	59,156.60	65,575.53
			388,559.32	430,233.05	470,921.66	492,971.66	546,462.77
		5.3 Tabla de evolución de consumo CIF2 Moneda
			Gastos Mensuales	2013	2014	2015	2016	2017
		Electricidad	800.000	8,135.59	8,542.37	8,969.49	9,417.97	9,888.86
		Mantenimiento	250.000	2,542.37	2,669.49	2,802.97	2,943.11	3,090.27
		Herramientas 	116.667	1,186.44	1,245.76	1,308.05	1,373.45	1,442.13		1,186.44
		EPPS	108.333	1,101.69	1,156.78	1,214.62	1,275.35	1,339.12		423.73
				12,966.10	13,614.41	14,295.13	15,009.88	15,760.38
				1,186.44
		5.4 Tabla de evolución de consumo CIF consolidado
			2013	2014	2015	2016	2017
		CIF 1	388,559.32	430,233.05	470,921.66	492,971.66	546,462.77
		CIF 2	12,966.10	13,614.41	14,295.13	15,009.88	15,760.38
			401,525.42	443,847.46	485,216.79	507,981.55	562,223.15
		6 Tabla de evolución de MOD 							MOD 1
			2013	2014	2015	2016	2017			Unidades	Costo
		Sueldo Base	72,000.00	75,600.00	79,380.00	83,349.00	87,516.45
		Beneficios	30,477.60	32,001.48	33,601.55	35,281.63	37,045.71
		Asignación Familiar 	5,580.00	5,580.00	5,580.00	5,580.00	5,580.00
		TOTAL MOD	108,057.60	113,181.48	118,561.55	124,210.63	130,142.16		Base		1,200.00
									Beneficios		507.96
		7 Tabla de evolución de gastos administrativos 							Asig Fam		93.00
									Total 		1,800.96
			2013	2014	2015	2016	2017
		Sueldos	42,699.00	44,833.95	47,075.65	49,429.43	51,900.90
		Servicios	8,644.07	9,076.27	9,530.08	10,006.59	10,506.92
		Alquiler 	13,200.00	13,860.00	14,553.00	15,280.65	16,044.68
		Vigilancia	9,661.02	10,144.07	10,651.27	11,183.83	11,743.03
		Papelería	3,559.32	3,737.29	3,924.15	4,120.36	4,326.38
		Limpieza	2,542.37	2,669.49	2,802.97	2,943.11	3,090.27
			80,305.78	84,321.07	88,537.12	92,963.98	97,612.18
		8 Tabla de evolución de gastos de ventas 
			2013	2014	2015	2016	2017
		Sueldos	61,486.56	64,560.89	67,788.93	71,178.38	74,737.30
		Publicidad	106,309.83	117,711.76	128,844.17	134,877.05	149,512.21
			167,796.39	182,272.65	196,633.10	206,055.43	224,249.51
		9 Tabla de inversiones y depreciaciones
			Depreciación
				2013	2014	2015	2016	2017
	10.00%	Maquinaria	144,067.80	14,406.78	14,406.78	14,406.78	14,406.78	14,406.78	72,033.90
				14,406.78	14,406.78	14,406.78	14,406.78	14,406.78
				1	2	3	4	5
			Io	2013	2014	2015	2016	2017
	Ingresos 	Ventas		5,906,101.69	6,539,542.37	7,158,009.28	7,493,169.28	8,306,234.07	S/ 20,557,159.95
	Costos 	Costo de ventas		- 3,424,239.11	- 3,783,994.10	- 4,135,688.84	- 4,329,495.52	- 4,654,136.35	-S/11,832,950.31
		Gastos Administr		- 80,305.78	- 84,321.07	- 88,537.12	- 92,963.98	- 97,612.18	-S/260,774.85
		Gastos ventas 		- 167,796.39	- 182,272.65	- 196,633.10	- 206,055.43	- 224,249.51	-S/569,692.57
		Gastos no desembolsables		- 14,406.78	- 14,406.78	- 14,406.78	- 14,406.78	- 14,406.78
		Utilidad Antes de Impuestos		2,219,353.64	2,474,547.78	2,722,743.44	2,850,247.57	3,315,829.25
		Impuesto Renta		- 654,709.32	- 729,991.59	- 803,209.32	- 840,823.03	- 978,169.63
		Utilidad después de impuestos		1,564,644.31	1,744,556.18	1,919,534.13	2,009,424.54	2,337,659.62
		Inversión 	- 144,067.80
		Gastos no desembolsables		14,406.78	14,406.78	14,406.78	14,406.78	14,406.78
		Valor de Salvamento						72,033.90
	Utilidad	Flujo de caja Económico	- 144,067.80	1,579,051.09	1,758,962.96	1,933,940.91	2,023,831.32	2,424,100.30
		Capital 
		Intereses
		Ahorros por intereses
	Utilidad	Flujo de caja Financiero
		KE	20%			Ke
						Kd
		WACC	Ke y Kd			WACC
		VAN	5,462,679.38
		TIR	1107%
		B/C	1.62