Scribd Logo
Upload

Welcome to Scribd!

  • 29 views

    Loan Amortization Schedule: Enter Values Loan Summary

    Uploaded by

    Shreenivas Thakur
    This document contains an amortization schedule for a $1.5 million loan with a 6.95% annual interest rate over 15 years. It shows the scheduled monthly payments, interest, principal and ending balance over time, as well as totals for interest paid and payments made over the life of the loan.

    Copyright:

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

    Loan Amortization Schedule: Enter Values Loan Summary

    Uploaded by

    Shreenivas Thakur
    29 views1 page
    This document contains an amortization schedule for a $1.5 million loan with a 6.95% annual interest rate over 15 years. It shows the scheduled monthly payments, interest, principal and ending balance over time, as well as totals for interest paid and payments made over the life of the loan.

    Original Description:

    Loan Calulator

    Original Title

    Loan Calulator

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains an amortization schedule for a $1.5 million loan with a 6.95% annual interest rate over 15 years. It shows the scheduled monthly payments, interest, principal and ending balance over time, as well as totals for interest paid and payments made over the life of the loan.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    29 views1 page

    Loan Amortization Schedule: Enter Values Loan Summary

    Uploaded by

    Shreenivas Thakur
    This document contains an amortization schedule for a $1.5 million loan with a 6.95% annual interest rate over 15 years. It shows the scheduled monthly payments, interest, principal and ending balance over time, as well as totals for interest paid and payments made over the life of the loan.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 1

    Loan Amortization Schedule

    Enter Values Loan Summary


    Loan amount $1,500,000.00 Scheduled payment $13,440.53
    Annual interest rate 6.95% Scheduled number of payments 180
    Loan period in years 15 Actual number of payments Err:508

    Number of payments per year 12 Total early payments $1,000.00


    Start date of loan 6/7/2022 Total interest $85,590.45

    Optional extra payments $100.00 Lender name Woodgrove Bank

    Payment Payment Beginning Scheduled Extra Total Principal Interest Ending Cumulative
    Number Date Balance Payment Payment Payment Balance Interest

    1 6/7/2022 ### $13,440.53 $100.00 $13,540.53 $4,853.03 $8,687.50 $1,495,146.97 $8,687.50


    2 7/7/2022 ### $13,440.53 $100.00 $13,540.53 $4,881.14 $8,659.39 $1,490,265.84 $17,346.89
    3 8/7/2022 ### $13,440.53 $100.00 $13,540.53 $4,909.41 $8,631.12 $1,485,356.43 $25,978.02

    4 9/7/2022 ### $13,440.53 $100.00 $13,540.53 $4,937.84 $8,602.69 $1,480,418.59 $34,580.71


    5 10/7/2022 ### $13,440.53 $100.00 $13,540.53 $4,966.44 $8,574.09 $1,475,452.16 $43,154.80

    6 11/7/2022 ### $13,440.53 $100.00 $13,540.53 $4,995.20 $8,545.33 $1,470,456.95 $51,700.12


    7 12/7/2022 ### $13,440.53 $100.00 $13,540.53 $5,024.13 $8,516.40 $1,465,432.82 $60,216.52
    8 1/7/2023 ### $13,440.53 $100.00 $13,540.53 $5,053.23 $8,487.30 $1,460,379.59 $68,703.82
    9 2/7/2023 ### $13,440.53 $100.00 $13,540.53 $5,082.50 $8,458.03 $1,455,297.10 $77,161.85
    10 3/7/2023 ### $13,440.53 $100.00 $13,540.53 $5,111.93 $8,428.60 $1,450,185.16 $85,590.45

    Page 1 of 1

    You might also like