Semana_6_Finanzas (1).xlsx

download Semana_6_Finanzas (1).xlsx

of 29

Transcript of Semana_6_Finanzas (1).xlsx

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    1/29

    prestamo TEAPERIODO(AÑOS)

    1.CUOTA MENSUAL2.número per o!os mens"a#es$. nteres 2 pr meros a%os

    amort &a' n 2 pr meros a%osINTERES AÑOS

    *. tasa mens"a#

    .per o!o

    12$*

    +,-

    1/11

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    2/29

    121$1*1

    1+1,1-12/21222$2*22+2,2-2$/$1$2$$$*$$+$,

    $-$*/*1*2*$

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    3/29

    ****+*,

    *-*/12$*

    +,-

    +/

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    4/29

    pa0onperpa0o. nt.entrepa0o.pr n'.entre

    tasa

    (1) (2) ($)pagoint pagoprin

    sa#!o n ' a# nteres amort &a' on

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    5/29

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    6/29

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    7/29

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    8/29

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    9/29

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    10/29

    Pago Interes Amortiz. aldo Final

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    11/29

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    12/29

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    13/29

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    14/29

    Pre' o Dpto.INICIAL

    PRESTAMO TEA

    AÑOS

    (1)per o!o sa#!o n ' a#

    12$*

    +,-

    1/

    11121$1*11+

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    15/29

    1,1-12/

    21222$2*22+2,2-2$/$1$2$$$*$$+$,$-$*/*1*2

    *$****+*,*-

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    16/29

    */12

    $*

    +,-

    +/+1+2+$+*++++,+-+,/,1,2,$,*

    ,,+,,,-,-/

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    17/29

    -1-2-$-*

    --+-,---

    /12$*

    +,-

    1//1/11/21/$1/*1/1/+

    1/,1/-1/11/111112

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    18/29

    11$11*1111+

    11,11-1112/12112212$12*1212+12,12-121$/1$11$21$$1$*1$1$+1$,1$-

    1$1*/1*11*21*$1**

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    19/29

    (2) ($)pa0o nt pa0opr n (1)5($)

    nteres amort &a' on sa#!o 6na#

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    20/29

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    21/29

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    22/29

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    23/29

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    24/29

    '"ota

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    25/29

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    26/29

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    27/29

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    28/29

  • 8/16/2019 Semana_6_Finanzas (1).xlsx

    29/29

    CREDITOPA7O

    TASA MENSUAL