388x Filetype XLSX File size 0.02 MB Source: cdn.document360.io
PMT is calculated based on monthly interest rate.
Interest type Compound Interest
Compounded frequency Daily
Accrued interest posting frequency Monthly
Disbursement Date 01/04/2021
Loan Amount 1000
IR per year 10.00%
Days in Year 360
No of installments 5.00
Daily Interest Rate 0.0265%
Monthly Interest Rate 0.7974%
PMT 204.81
Transactions
Date Type Amount
1/4/2021Disbursement 1000
Schedule
Installment Number Due Date Principal Expected
1/4/2021
1 1/5/2021 196.84
2 1/6/2021 198.41
3 1/7/2021 199.99
4 1/8/2021 201.58
5 1/9/2021 203.19
Principal Balance Interest Balance
1000 0
Interest Expected Total Expected Principal Paid Interest Paid Principal Balance
1,000.00
7.97 204.81 0.00 0.00 803.16
6.40 204.81 0.00 0.00 604.75
4.82 204.81 0.00 0.00 404.76
3.23 204.81 0.00 0.00 203.18
1.62 204.81 0.00 0.00 -0.01
State No of days in an installment
Pending 30
Pending 30
Pending 30
Pending 30
Pending 30
no reviews yet
Please Login to review.