Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 14 views

    Funciones Financieras

    Uploaded by

    Jaehyun Park
    The document discusses the financial functions of a loan. It shows the calculation of total payment as the sum of net payment and interest. It then provides a repayment schedule over 36 periods showing the outstanding balance, interest, fees and total monthly payment as the loan is paid off.

    Copyright:

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

    Funciones Financieras

    Uploaded by

    Jaehyun Park
    14 views4 pages
    The document discusses the financial functions of a loan. It shows the calculation of total payment as the sum of net payment and interest. It then provides a repayment schedule over 36 periods showing the outstanding balance, interest, fees and total monthly payment as the loan is paid off.

    Original Description:

    Original Title

    Funciones financieras

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses the financial functions of a loan. It shows the calculation of total payment as the sum of net payment and interest. It then provides a repayment schedule over 36 periods showing the outstanding balance, interest, fees and total monthly payment as the loan is paid off.

    Copyright:

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

    Funciones Financieras

    Uploaded by

    Jaehyun Park
    The document discusses the financial functions of a loan. It shows the calculation of total payment as the sum of net payment and interest. It then provides a repayment schedule over 36 periods showing the outstanding balance, interest, fees and total monthly payment as the loan is paid off.

    Copyright:

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

    “FUINCIONES FINANCIERA

    PAGO NETO+ INTERES = PAGO TOTAL

    Cronograma de pagos correspondiente


    Monto del préstamo Portes vf
    $4,500 $2.50 0
    Tem(tasa) nper tipo
    1.53% 36 0
    Cuota fija

    Pago= $163.50
    Perido Saldo Interes portes Cuota
    0 $4,500.00
    1 $4,405.35 $68.85 $2.50 $163.50
    2 $4,309.25 $67.40 $2.50 $163.50
    3 $4,211.68 $65.93 $2.50 $163.50
    4 $4,112.62 $64.44 $2.50 $163.50
    5 $4,012.05 $62.92 $2.50 $163.50
    6 $3,909.93 $61.38 $2.50 $163.50
    7 $3,806.25 $59.82 $2.50 $163.50
    8 $3,700.99 $58.24 $2.50 $163.50
    9 $3,594.12 $56.63 $2.50 $163.50
    10 $3,485.61 $54.99 $2.50 $163.50
    11 $3,375.44 $53.33 $2.50 $163.50
    12 $3,263.58 $51.64 $2.50 $163.50
    13 $3,150.01 $49.93 $2.50 $163.50
    14 $3,034.71 $48.20 $2.50 $163.50
    15 $2,917.64 $46.43 $2.50 $163.50
    16 $2,798.78 $44.64 $2.50 $163.50
    17 $2,678.10 $42.82 $2.50 $163.50
    18 $2,555.58 $40.97 $2.50 $163.50
    19 $2,431.18 $39.10 $2.50 $163.50
    20 $2,304.88 $37.20 $2.50 $163.50
    21 $2,176.64 $35.26 $2.50 $163.50
    22 $2,046.45 $33.30 $2.50 $163.50
    23 $1,914.26 $31.31 $2.50 $163.50
    24 $1,780.04 $29.29 $2.50 $163.50
    25 $1,643.78 $27.23 $2.50 $163.50
    26 $1,505.43 $25.15 $2.50 $163.50
    27 $1,364.96 $23.03 $2.50 $163.50
    28 $1,222.35 $20.88 $2.50 $163.50
    29 $1,077.55 $18.70 $2.50 $163.50
    30 $930.54 $16.49 $2.50 $163.50
    31 $781.27 $14.24 $2.50 $163.50
    32 $629.73 $11.95 $2.50 $163.50
    33 $475.86 $9.63 $2.50 $163.50
    34 $319.64 $7.28 $2.50 $163.50
    35 $161.04 $4.89 $2.50 $163.50
    36 -$0.00 $2.46 $2.50 $163.50
    NANCIERAS”

    $b$55;c63$e

    amortizacion

    $94.65
    $96.10
    $97.57
    $99.06
    $100.58
    $102.12
    $103.68
    $105.26
    $106.87
    $108.51
    $110.17
    $111.86
    $113.57
    $115.30
    $117.07
    $118.86
    $120.68
    $122.52
    $124.40
    $126.30
    $128.23
    $130.20
    $132.19
    $134.21
    $136.26
    $138.35
    $140.47
    $142.62
    $144.80
    $147.01
    $149.26
    $151.55
    $153.86
    $156.22
    $158.61
    $161.04

    You might also like