Ayudantía 5 Solución Parte 2

Vista previa del material en texto

Sheet1
		Edificio
		Cuotas 	48
		Prima	$4,000,000.00		Comentario:Nelson
		Rate 	0.39150%	Mensual	** recordar que en la respuesta del profesor aparece con dos decimales mas que en el enunciado. 
		PV	174,727,873		En clases para no confundirnos, se realizo igual que el enunciado.
		Vida útil	15
		Terreno
		Cuotas 	20
		Prima	$45,000,000.00
		Rate 	4.80%	anual
		FV inicial	625,000,000
		FV final 	700,000,000
							Capital inicial	Cuota	Intereses	Capital	Saldo
						1	174,727,873	4,000,000	684,060	3,315,940	171,411,932
			EDIFICIO			2	171,411,932	4,000,000	671,078	3,328,922	168,083,010
						3	168,083,010	4,000,000	658,045	3,341,955	164,741,055
			Registro Inicial			4	164,741,055	4,000,000	644,961	3,355,039	161,386,016
						5	161,386,016	4,000,000	631,826	3,368,174	158,017,842
		Activo en Leasing	$174,727,872.61			6	158,017,842	4,000,000	618,640	3,381,360	154,636,482
			Oblig. Leasing	$174,727,872.61		7	154,636,482	4,000,000	605,402	3,394,598	151,241,884
						8	151,241,884	4,000,000	592,112	3,407,888	147,833,996
			Depreciación			9	147,833,996	4,000,000	578,770	3,421,230	144,412,766
						10	144,412,766	4,000,000	565,376	3,434,624	140,978,142
		Depreciación Ejercicio	11,648,525			11	140,978,142	4,000,000	551,929	3,448,071	137,530,072
			Depreciación Acumulada	11,648,525		12	137,530,072	4,000,000	538,430	3,461,570	134,068,502	** incorporar 12 meses.
						13	134,068,502	4,000,000	524,878	3,475,122	130,593,380
			Interés al 31 de diciembre			14	130,593,380	4,000,000	511,273	3,488,727	127,104,653	Intereses	7,340,629
		Gastos financiero	7,340,629			15	127,104,653	4,000,000	497,615	3,502,385	123,602,268	Saldo en $	134,068,502
			Oblig. Leasing	$7,340,629		16	123,602,268	4,000,000	483,903	3,516,097	120,086,171
						17	120,086,171	4,000,000	470,137	3,529,863	116,556,308	SI	$174,727,872.61
			Pago cuota			18	116,556,308	4,000,000	456,318	3,543,682	113,012,626	Intereses	$7,340,629
		Oblig. Leasing	48,000,000			19	113,012,626	4,000,000	442,444	3,557,556	109,455,070	Pagos	- 48,000,000
			Caja	$48,000,000.00		20	109,455,070	4,000,000	428,517	3,571,483	105,883,587	Reajuste
						21	105,883,587	4,000,000	414,534	3,585,466	102,298,121		$134,068,501.80
						22	102,298,121	4,000,000	400,497	3,599,503	98,698,618
						23	98,698,618	4,000,000	386,405	3,613,595	95,085,023
						24	95,085,023	4,000,000	372,258	3,627,742	91,457,281
						25	91,457,281	4,000,000	358,055	3,641,945	87,815,337
		Balance				26	87,815,337	4,000,000	343,797	3,656,203	84,159,134
		Saldo Activo Leasing	163,079,348			27	84,159,134	4,000,000	329,483	3,670,517	80,488,617
		Saldo Obligación	134,068,502			28	80,488,617	4,000,000	315,113	3,684,887	76,803,730
						29	76,803,730	4,000,000	300,687	3,699,313	73,104,416
		Resultado				30	73,104,416	4,000,000	286,204	3,713,796	69,390,620
		Gasto Financiero	($7,340,629)			31	69,390,620	4,000,000	271,664	3,728,336	65,662,284
		Depreciación ejercicio	($11,648,525)			32	65,662,284	4,000,000	257,068	3,742,932	61,919,352
		Gasto arriendo	$45,000,000			33	61,919,352	4,000,000	242,414	3,757,586	58,161,766
						34	58,161,766	4,000,000	227,703	3,772,297	54,389,470
						35	54,389,470	4,000,000	212,935	3,787,065	50,602,404
			TERRENO			36	50,602,404	4,000,000	198,108	3,801,892	46,800,513
						37	46,800,513	4,000,000	183,224	3,816,776	42,983,737
		Gasto arriendo	$45,000,000.00			38	42,983,737	4,000,000	168,281	3,831,719	39,152,018
			Caja	$45,000,000.00		39	39,152,018	4,000,000	153,280	3,846,720	35,305,298
						40	35,305,298	4,000,000	138,220	3,861,780	31,443,519
						41	31,443,519	4,000,000	123,101	3,876,899	27,566,620
						42	27,566,620	4,000,000	107,923	3,892,077	23,674,543
						43	23,674,543	4,000,000	92,686	3,907,314	19,767,229
						44	19,767,229	4,000,000	77,389	3,922,611	15,844,618
						45	15,844,618	4,000,000	62,032	3,937,968	11,906,650
						46	11,906,650	4,000,000	46,615	3,953,385	7,953,264
						47	7,953,264	4,000,000	31,137	3,968,863	3,984,401
						48	3,984,401	4,000,000	15,599	3,984,401	- 0
		Desde el punto de vista del arrendatario:
		Edificio 	$174,727,872.61
			Caja	$174,727,872.61
		Cuenta x Cobrar leasing	$174,727,872.61
			Edificio	$174,727,872.61
		Mensualmente
		Mes 1
		Cuenta x Cobrar leasing	684,060
			Ingresos operacional	684,060
		Caja	4,000,000
			Cuenta x Cobrar (interés)	684,060		Saldo	171,411,932
			Cuenta x Cobrar (capital)	3,315,940
		Mensualmente
		Mes 2
		Cuenta x Cobrar leasing	671,078
			Ingresos operacional	671,078
		Caja	4,000,000
			Cuenta x Cobrar (interés)	671,078		Saldo	168,083,010
			Cuenta x Cobrar (capital)	3,328,922
Sheet2
Sheet3