Scribd Logo
Upload

Welcome to Scribd!

  • 27 views

    Aplicacion de Formulas para Prestamos

    Uploaded by

    MONTSERRAT GARCIA RODRIGUEZ
    This document summarizes the details of a $40,000 loan with an 18% interest rate taken over 32 periods. It shows the payment amount each period of $1,559.69, with portions going towards interest, principal payment, and the remaining balance. By period 19, the remaining balance is $19,563.77 and it continues making payments until the final period of 32 where the remaining balance is paid off completely.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Aplicacion de Formulas para Prestamos

    Uploaded by

    MONTSERRAT GARCIA RODRIGUEZ
    27 views4 pages
    This document summarizes the details of a $40,000 loan with an 18% interest rate taken over 32 periods. It shows the payment amount each period of $1,559.69, with portions going towards interest, principal payment, and the remaining balance. By period 19, the remaining balance is $19,563.77 and it continues making payments until the final period of 32 where the remaining balance is paid off completely.

    Original Title

    APLICACION DE FORMULAS PARA PRESTAMOS

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document summarizes the details of a $40,000 loan with an 18% interest rate taken over 32 periods. It shows the payment amount each period of $1,559.69, with portions going towards interest, principal payment, and the remaining balance. By period 19, the remaining balance is $19,563.77 and it continues making payments until the final period of 32 where the remaining balance is paid off completely.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    27 views4 pages

    Aplicacion de Formulas para Prestamos

    Uploaded by

    MONTSERRAT GARCIA RODRIGUEZ
    This document summarizes the details of a $40,000 loan with an 18% interest rate taken over 32 periods. It shows the payment amount each period of $1,559.69, with portions going towards interest, principal payment, and the remaining balance. By period 19, the remaining balance is $19,563.77 and it continues making payments until the final period of 32 where the remaining balance is paid off completely.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 4

    12 Ingreso mensual $12,000.

    00
    Tasa 18% Porcentaje p. pag. 20%
    Plazo 32 Pago p. préstamo $2,400.00
    Préstamo $40,000.00
    Saldo $0.00 Periodos 19
    Tipo 1 $40,000.00

    PAGO $1,559.69

    Factible para crédito

    MES IMPORTE PAG. CAP.


    1 $40,000.00 $1,559.69
    2 $38,440.31 $983.08
    3 $37,457.23 $997.83
    4 $36,459.40 $1,012.80
    5 $35,446.60 $1,027.99
    6 $34,418.61 $1,043.41
    7 $33,375.20 $1,059.06
    8 $32,316.14 $1,074.95
    9 $31,241.19 $1,091.07
    10 $30,150.12 $1,107.44
    11 $29,042.69 $1,124.05
    12 $27,918.64 $1,140.91
    13 $26,777.73 $1,158.02
    14 $25,619.71 $1,175.39
    15 $24,444.31 $1,193.02
    16 $23,251.29 $1,210.92
    17 $22,040.37 $1,229.08
    18 $20,811.29 $1,247.52
    19 $19,563.77 $1,266.23
    20 $18,297.54 $1,285.23
    21 $17,012.31 $1,304.50
    22 $15,707.81 $1,324.07
    23 $14,383.74 $1,343.93
    24 $13,039.80 $1,364.09
    25 $11,675.71 $1,384.55
    26 $10,291.16 $1,405.32
    27 $8,885.84 $1,426.40
    28 $7,459.44 $1,447.80
    29 $6,011.64 $1,469.51
    30 $4,542.13 $1,491.56
    31 $3,050.57 $1,513.93
    32 $1,536.64 $1,536.64
    33 $0.00
    No factible para crédito
    Factible para crédito

    PAG. INTERES PAGO M. SALDO


    $0.00 $1,559.69 $38,440.31
    $576.60 $1,559.69 $37,457.23
    $561.86 $1,559.69 $36,459.40
    $546.89 $1,559.69 $35,446.60
    $531.70 $1,559.69 $34,418.61
    $516.28 $1,559.69 $33,375.20
    $500.63 $1,559.69 $32,316.14
    $484.74 $1,559.69 $31,241.19
    $468.62 $1,559.69 $30,150.12
    $452.25 $1,559.69 $29,042.69
    $435.64 $1,559.69 $27,918.64
    $418.78 $1,559.69 $26,777.73
    $401.67 $1,559.69 $25,619.71
    $384.30 $1,559.69 $24,444.31
    $366.66 $1,559.69 $23,251.29
    $348.77 $1,559.69 $22,040.37
    $330.61 $1,559.69 $20,811.29
    $312.17 $1,559.69 $19,563.77
    $293.46 $1,559.69 $18,297.54
    $274.46 $1,559.69 $17,012.31
    $255.18 $1,559.69 $15,707.81
    $235.62 $1,559.69 $14,383.74
    $215.76 $1,559.69 $13,039.80
    $195.60 $1,559.69 $11,675.71
    $175.14 $1,559.69 $10,291.16
    $154.37 $1,559.69 $8,885.84
    $133.29 $1,559.69 $7,459.44
    $111.89 $1,559.69 $6,011.64
    $90.17 $1,559.69 $4,542.13
    $68.13 $1,559.69 $3,050.57
    $45.76 $1,559.69 $1,536.64
    $23.05 $1,559.69 $0.00

    You might also like