7
TMAR 10% DE 371 DIAS Y CAPITALIZABLE CADA 1500 S A B Inversión -15000 -25000 Ingresos anuales 3210 5647 Ingresos semestrales 1800 2300 Egresos Mensuales 354 412 Valor de salvamento 2000 3400 Plazo 5 años 5 años TASA= VAN TIR PERIODO FLUJO VP 0 -15000 1 2856 2 2856 3 2856 4 2856 5 2856 6 4656 7 2856 8 2856 9 2856 10 2856 11 2856 12 4656 13 2856 14 2856 15 2856 16 2856 17 2856 18 4656

TIR Y VAN

Embed Size (px)

DESCRIPTION

TIR Y VAN

Citation preview

Page 1: TIR Y VAN

TMAR 10% DE 371 DIAS Y CAPITALIZABLE CADA 1500 SEGUNDOS

A BInversión -15000 -25000Ingresos anuales 3210 5647Ingresos semestrales 1800 2300Egresos Mensuales 354 412Valor de salvamento 2000 3400 SEGUNDOSPlazo 5 años 5 años TASA= 0.404312618

VANTIR

PERIODO FLUJO VP0 -150001 28562 28563 28564 28565 28566 46567 28568 28569 2856

10 285611 285612 465613 285614 285615 285616 285617 285618 465619 285620 285621 2856

Page 2: TIR Y VAN

22 285623 285624 465625 285626 285627 285628 285629 285630 465631 285632 285633 285634 285635 285636 465637 285638 285639 285640 285641 285642 465643 285644 285645 285646 285647 285648 465649 285650 285651 285652 285653 285654 465655 285656 285657 285658 285659 285660 4656

Page 3: TIR Y VAN

25 MINUTOS0.41666667 HORAS0.01736111 DIAS

m 21369.6

Page 4: TIR Y VAN

VANTIR

A B

MES DIA1 0 -15,000.00 -25,000.00 2 30 -354.00 -412.00 3 60 -354.00 -412.00 4 90 -354.00 -412.00 5 120 -354.00 -412.00 6 150 1,800.00 -354.00 2,300.00 -412.00 7 180 -354.00 -412.00 8 210 -354.00 -412.00 9 240 -354.00 -412.00

10 270 -354.00 -412.00 11 300 -354.00 -412.00 12 330 3,210.00 1,800.00 -354.00 5,647.00 2,300.00 -412.00 13 360 -354.00 -412.00 14 390 -354.00 -412.00 15 420 -354.00 -412.00 16 450 -354.00 -412.00 17 480 -354.00 -412.00 18 510 1,800.00 -354.00 2,300.00 -412.00 19 540 -354.00 -412.00 20 570 -354.00 -412.00 21 600 -354.00 -412.00 22 630 -354.00 -412.00 23 660 -354.00 -412.00 24 690 3,210.00 1,800.00 -354.00 5,647.00 2,300.00 -412.00 25 720 -354.00 -412.00 26 750 -354.00 -412.00 27 780 -354.00 -412.00 28 810 -354.00 -412.00 29 840 -354.00 -412.00 30 870 1,800.00 -354.00 2,300.00 -412.00 31 900 -354.00 -412.00 32 930 -354.00 -412.00 33 960 -354.00 -412.00 34 990 -354.00 -412.00 35 1020 -354.00 -412.00 36 1050 3,210.00 1,800.00 -354.00 5,647.00 2,300.00 -412.00 37 1080 -354.00 -412.00 38 1110 -354.00 -412.00 39 1140 -354.00 -412.00 40 1170 -354.00 -412.00 41 1200 -354.00 -412.00

INGRESOS ANUALES

INGRESOS SEMESTRALES

EGRESOS MENSUALES

INGRESOS ANUALES

INGRESOS SEMESTRALES

EGRESOS MENSUALES

Page 5: TIR Y VAN

42 1230 1,800.00 -354.00 2,300.00 -412.00 43 1260 -354.00 -412.00 44 1290 -354.00 -412.00 45 1320 -354.00 -412.00 46 1350 -354.00 -412.00 47 1380 -354.00 -412.00 48 1410 3,210.00 1,800.00 -354.00 5,647.00 2,300.00 -412.00 49 1440 -354.00 -412.00 50 1470 -354.00 -412.00 51 1500 -354.00 -412.00 52 1530 -354.00 -412.00 53 1560 -354.00 -412.00 54 1590 1,800.00 -354.00 2,300.00 -412.00 55 1620 -354.00 -412.00 56 1650 -354.00 -412.00 57 1680 -354.00 -412.00 58 1710 -354.00 -412.00 59 1740 -354.00 -412.00 60 1770 5,210.00 1,800.00 -354.00 5,647.00 2,300.00 -412.00

Page 6: TIR Y VAN

$ -4,062.26 -4,848.06 0.8119%0.03% 0.203%

A B -15,000.00 -25,000.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 1,446.00 1,888.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 4,656.00 7,535.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 1,446.00 1,888.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 4,656.00 7,535.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 1,446.00 1,888.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 4,656.00 7,535.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00

Page 7: TIR Y VAN

1,446.00 1,888.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 4,656.00 7,535.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 1,446.00 1,888.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 -354.00 -412.00 6,656.00 7,535.00