Access over 20 million homework & study documents

Loan Amortization Schedule1

Content type
User Generated
Subject
Accounting
Type
Homework
Rating
Showing Page:
1/10

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/10

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/10

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 10 pages?
Access Now
Unformatted Attachment Preview
LOAN AMORTIZATION SCHEDULE ENTER VALUES Loan amount Annual interest rate Loan period in years Number of payments per year Start date of loan LOAN SUMMARY Scheduled payment Scheduled number of payments Actual number of payments Total early payments Total interest $200,000.00 4.00% 1 12 1/26/2020 Optional extra payments PMT NO 1 2 3 4 5 6 7 8 9 10 11 12 PAYMENT DATE 1/26/2020 2/26/2020 3/26/2020 4/26/2020 5/26/2020 6/26/2020 7/26/2020 8/26/2020 9/26/2020 10/26/2020 11/26/2020 12/26/2020 BEGINNING BALANCE $200,000.00 $183,636.69 $167,218.83 $150,746.24 $134,218.75 $117,636.16 $100,998.30 $84,304.98 $67,556.02 $50,751.23 $33,890.42 $16,973.40 LENDER NAME SCHEDULE D PAYMENT $17,029.98 $17,029.98 $17,029.98 $17,029.98 $17,029.98 $17,029.98 $17,029.98 $17,029.98 $17,029.98 $17,029.98 $17,029.98 $17,029.98 EXTRA PAYMENT $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 TOTAL PAYMENT $17,029.98 $17,029.98 $17,029.98 $17,029.98 $17,029.98 $17,029.98 $17,029.98 $17,029.98 $17,029.98 $17,029.98 $17,029.98 $16,973.40 $17,029.98 12 12 $0.00 $4,359.77 Woodgrove Bank PRINCIPAL INTEREST $16,363.31 $16,417.86 $16,472.58 $16,527.49 $16,582.59 $16,637.86 $16,693.32 $16,748.96 $16,804.79 $16,860.81 $16,917.01 $16,916.82 $666.67 $612.12 $557.40 $502.49 $447.40 $392.12 $336.66 $281.02 $225.19 $169.17 $112.97 $56.58 ENDING BALANCE $183,636.69 $167,218.83 $150,746.24 $134,218.75 $117,636.16 $100,998.30 $84,304.98 $67,556.02 $50,751.23 $33,890.42 $16,973.40 $0.00 C ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Just what I needed…Fantastic!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4