Scribd
Upload
145 views99 pages

Loan Amortization Schedule

The document outlines a loan amortization schedule for a $800,000 loan over 2 years at an interest rate of 12% per annum. The borrower will make 24 monthly installment payments of $37,659 each. By the end of the loan period, the borrower will have paid a total of $103,811 in interest charges.

Uploaded by

Ali Gokhan Kocan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
145 views99 pages

Loan Amortization Schedule

The document outlines a loan amortization schedule for a $800,000 loan over 2 years at an interest rate of 12% per annum. The borrower will make 24 monthly installment payments of $37,659 each. By the end of the loan period, the borrower will have paid a total of $103,811 in interest charges.

Uploaded by

Ali Gokhan Kocan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 99

Loan Amortization Schedule

Zair Haider
Loan Amount 800,000 Business C
Down Payment - What is the
Loan Amount after Downpayment (Present Value) 800,000 your LOAN?

Interest Rate Per Annum (Rate) 12%


Zair Haider
Number of Years to pay back 2 Business C
Number of Installments in a year 12 How many y
Total Number of Installments 24 Loan for?

Final Payment at the End (Future Value) -


If Installment is paid at start of period type "0" or end of period type "1" -
Monthly Installment (PMT) $37,659

Total Interest Paid by Consumer 103,811


Per Annum Charges 6.49%
Schedule of Payments
PMT. No. Principal Interest Charges Total Installment
0 800,000 -
Zair Haider - Oak Zair Haider - Oak
Business 1 Consultant:
800,000 12%
Business Consultant: 8,000.00 808,000 37,659
What is the of How many installments
2 amount 770,341 12%will 7,703.41 778,045 37,659
your LOAN? be paid each year?
3 740,386 12% 7,403.86 747,790 37,659
4 710,131 12% 7,101.31 717,232 37,659
Zair Haider - Oak
Business 5 Consultant:
679,573 12% 6,795.73 686,369 37,659
How many 6 years is this
648,710 12% 6,487.10 655,198 37,659
Loan for?7 617,539 12% 6,175.39 623,714 37,659
8 586,055 12% 5,860.55 591,916 37,659
9 554,257 12% 5,542.57 559,800 37,659
10 522,141 12% 5,221.41 527,362 37,659
11 489,704 12% 4,897.04 494,601 37,659
12 456,942 12% 4,569.42 461,511 37,659
13 423,852 12% 4,238.52 428,091 37,659
14 390,432 12% 3,904.32 394,337 37,659
15 356,678 12% 3,566.78 360,245 37,659
16 322,586 12% 3,225.86 325,812 37,659
17 288,153 12% 2,881.53 291,034 37,659
18 253,376 12% 2,533.76 255,909 37,659
19 218,251 12% 2,182.51 220,433 37,659
20 182,774 12% 1,827.74 184,602 37,659
21 146,943 12% 1,469.43 148,413 37,659
22 110,754 12% 1,107.54 111,861 37,659
23 74,203 12% 742.03 74,945 37,659
24 37,286 12% 372.86 37,659 37,659
Balance
800,000
770,341
740,386
710,131
679,573
648,710
617,539
586,055
554,257
522,141
489,704
456,942
423,852
390,432
356,678
322,586
288,153
253,376
218,251
182,774
146,943
110,754
74,203
37,286
0

You might also like