Sheet1
    Loan Amortization
    Loan amount    $2,000,000
    Term in years    5
    Annual coupon rate    15.00%
    Calculation of loan payment        Formula
    Loan payment =    $596,631.10    =PMT(B5,B4,-B3,0,0)
    Loan Amortization Schedule
    Year    Beginning Balance    Payment    Interest    Principal    Ending...