Scribd Logo
Upload

Welcome to Scribd!

  • 47 views

    Scatter Plot: 10000 F (X) 7.6826983136x 2 - 10550.0630855715x + 10546.0342910681 R 0.9999999728

    Uploaded by

    Daniel John Cañares Legaspi
    This document contains a scatter plot and trend line of monthly amortization amounts for a $500,000 auto loan with varying downpayment percentages and a term of 60 months. It also includes the polynomial trend formula and calculates the monthly payment for a 0.7 downpayment.

    Copyright:

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

    Scatter Plot: 10000 F (X) 7.6826983136x 2 - 10550.0630855715x + 10546.0342910681 R 0.9999999728

    Uploaded by

    Daniel John Cañares Legaspi
    47 views6 pages
    This document contains a scatter plot and trend line of monthly amortization amounts for a $500,000 auto loan with varying downpayment percentages and a term of 60 months. It also includes the polynomial trend formula and calculates the monthly payment for a 0.7 downpayment.

    Original Description:

    1

    Original Title

    QUAMET

    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 contains a scatter plot and trend line of monthly amortization amounts for a $500,000 auto loan with varying downpayment percentages and a term of 60 months. It also includes the polynomial trend formula and calculates the monthly payment for a 0.7 downpayment.

    Copyright:

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

    Scatter Plot: 10000 F (X) 7.6826983136x 2 - 10550.0630855715x + 10546.0342910681 R 0.9999999728

    Uploaded by

    Daniel John Cañares Legaspi
    This document contains a scatter plot and trend line of monthly amortization amounts for a $500,000 auto loan with varying downpayment percentages and a term of 60 months. It also includes the polynomial trend formula and calculates the monthly payment for a 0.7 downpayment.

    Copyright:

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

    Scatter Plot

    10000

    9000

    f(x) = 7.6826983136x^2 - 10550.0630855715x + 10546.0342910681


    R = 0.9999999728

    8000

    7000

    6000

    5000

    4000

    3000

    2000

    1000

    0
    0.05

    0.1

    0.15

    0.2

    0.25

    0.3
    X

    0.35

    0.4

    0.45

    0.5

    0.55

    Variable Variable
    0.1
    9491
    0.15
    8964
    0.2
    8436
    0.3
    7382
    0.4
    6327
    0.5
    5273

    BPI Auto Loan Calculator (Monthly Amortization)


    Amount Downpayment Payment Terms Monthly Amortization
    500000
    0.1
    60 months
    9491
    500000
    0.15
    60 months
    8964
    500000
    0.2
    60 months
    8436
    500000
    0.3
    60 months
    7382
    500000
    0.4
    60 months
    6327
    500000
    0.5
    60 months
    5273
    0.7

    Trend Formula: y = 7.6827x^2 - 10550x + 10546


    y = 7.6827(.7)^2 - 10550(.7) + 10546
    y = 3164.764523
    or
    y = 3164.765

    BPI Auto Loan Calculator (Monthly Amortization)


    10000
    9000
    8000

    1; 9491
    2;7.6826983136x^2
    8964
    f(x) =
    - 10550.0630855715x + 10546.0342910681
    3; 8436
    R = 0.9999999728
    4; 7382

    7000

    5; 6327

    6000

    Monthly Amortization
    Polynomial (Monthly
    Amortization)

    6; 5273

    5000
    4000
    3000
    2000
    1000
    0
    0.1
    1.11022302462516E-016

    0.3
    0.2

    0.5
    0.4

    0.7
    0.6

    Legaspi, Daniel John C

    AC121

    ion)

    ortization)

    42910681

    Monthly Amortization
    Polynomial (Monthly
    Amortization)

    Daniel John C

    AC121

    You might also like