InicialDATOSSUPUESTOSValor terreno$30,000.00Ingreso por alquileres$35,000Valor edificaciones y mejoras$140,000.00Inflacin anual0.04SEMESTRE 1-2011Precio de propiedad$170,000.00Cargos V&C0.03Pago al contado$40,000.00Gastos operativos0.45Prstamo$130,000.00Tasa impositiva0.28Tasa de inters anual0.11Crecim. valor propiedad0.025Plazo en aos20Comisin sobre venta0.05Tasa de descuento0.12DETALLE / AOS12345Precio de venta$192,339.40Ingresos brutos$35,000.00$36,400.00$37,856.00$39,370.24$40,945.05- Comisin ventas$9,616.97Menos= Precio neto$182,722.43Cargos V&C$1,050.00$1,092.00$1,135.68$1,181.11$1,228.35Gastos de operacin$15,750.00$16,380.00$17,035.20$17,716.61$18,425.27- Valor Residual$144,545.45Ingreso neto$18,200.00$18,928.00$19,685.12$20,472.52$21,291.43= Ganancia imponible$38,176.97MenosDepreciacin$5,090.91$5,090.91$5,090.91$5,090.91$5,090.91Precio Neto$182,722.43Intereses$14,300.00$14,077.27$13,830.04$13,555.61$13,250.99- Impuestos$10,689.55Utilidad imponible-$1,190.91-$240.18$764.17$1,826.01$2,949.52- Pago prstamo$117,389.74= Ingreso lquido$54,643.13Impuestos pagados (ahorrados)-$333.45-$67.25$213.97$511.28$825.87VAN del Ingreso Lquido$31,005.98Amortizacin prstamo$2,024.83$2,247.56$2,494.80$2,769.22$3,073.84+ VAN del negocio$11,000.87- Capital inicial$40,000.00Flujo neto$2,208.62$2,670.42$3,146.32$3,636.41$4,140.73= VAN Final$2,006.85VAN del negocio$11,000.87Aos$16,324.83intersAmort.AcumuladoAmort+int$130,00011$14,300.00$2,024.83$2,024.83$16,324.83$7.9621$14,077.27$2,247.56$4,272.40$16,324.8331$13,830.04$2,494.80$6,767.19$16,324.8341$13,555.61$2,769.22$9,536.42$16,324.8351$13,250.99$3,073.84$12,610.26$16,324.8361$12,912.87$3,411.96$16,022.22$16,324.8371$12,537.56$3,787.28$19,809.49$16,324.8381$12,120.96$4,203.88$24,013.37$16,324.8391$11,658.53$4,666.30$28,679.68$16,324.83101$11,145.24$5,179.60$33,859.27$16,324.83111$10,575.48$5,749.35$39,608.62$16,324.83121$9,943.05$6,381.78$45,990.41$16,324.83131$9,241.06$7,083.78$53,074.18$16,324.83141$8,461.84$7,862.99$60,937.18$16,324.83151$7,596.91$8,727.92$69,665.10$16,324.83161$6,636.84$9,687.99$79,353.09$16,324.83171$5,571.16$10,753.67$90,106.77$16,324.83181$4,388.26$11,936.58$102,043.34$16,324.83191$3,075.23$13,249.60$115,292.94$16,324.83201$1,617.78$14,707.06$130,000.00$16,324.83

SimulacinDATOSSUPUESTOSValor terreno30,000.00Ingreso por alquileres35,000Valor edificaciones y mejoras140,000.00Inflacin anual0.04SEMESTRE 1-2011Precio de propiedad170,000.00Cargos V&C0.03Pago al contado40,000.00Gastos operativos0.45Prstamo130,000.00Tasa impositiva0.28Tasa de inters anual0.11Crecim. valor propiedad0.025Plazo en aos20Comisin sobre venta0.05Tasa de descuento0.12Tasa inflacin anual0.040.040.040.04Cargos por V&C0.030.030.030.030.03Gastos de operacin0.450.450.450.450.45DETALLE / AOS12345Precio de venta192,339.40Ingresos brutos35,000.0036,400.0037,856.0039,370.2440,945.05- Comisin ventas9,616.97Menos= Precio neto182,722.43Cargos V&C1,050.001,092.001,135.681,181.111,228.35Gastos de operacin15,750.0016,380.0017,035.2017,716.6118,425.27- Valor Residual144,545.45Ingreso neto18,200.0018,928.0019,685.1220,472.5221,291.43= Ganancia imponible38,176.97MenosDepreciacin5,090.915,090.915,090.915,090.915,090.91Precio Neto182,722.43Intereses14,300.0014,077.2713,830.0413,555.6113,250.99- Impuestos10,689.55Utilidad imponible-1,190.91-240.18764.171,826.012,949.52- Pago prstamo117,389.74= Ingreso lquido54,643.13Impuestos pagados (ahorrados)-333.45-67.25213.97511.28825.87VAN del Ingreso Lquido31,005.98Amortizacin prstamo2,024.832,247.562,494.802,769.223,073.84+ VAN del negocio11,000.87- Capital inicial40,000.00Flujo neto2,208.622,670.423,146.323,636.414,140.73VAN Final2,006.85VAN del negocio11,000.87Aos16,324.83intersAmort.AcumuladoAmort+int130,000.001114,300.002,024.832,024.8316,324.832114,077.272,247.564,272.4016,324.833113,830.042,494.806,767.1916,324.834113,555.612,769.229,536.4216,324.835113,250.993,073.8412,610.2616,324.836112,912.873,411.9616,022.2216,324.837112,537.563,787.2819,809.4916,324.838112,120.964,203.8824,013.3716,324.839111,658.534,666.3028,679.6816,324.8310111,145.245,179.6033,859.2716,324.8311110,575.485,749.3539,608.6216,324.831219,943.056,381.7845,990.4116,324.831319,241.067,083.7853,074.1816,324.831418,461.847,862.9960,937.1816,324.831517,596.918,727.9269,665.1016,324.831616,636.849,687.9979,353.0916,324.831715,571.1610,753.6790,106.7716,324.831814,388.2611,936.58102,043.3416,324.831913,075.2313,249.60115,292.9416,324.832011,617.7814,707.06130,000.0016,324.83

Forecast: VAN Final