jagomart
digital resources
picture1_Compound Interest Excel Template 46110 | Compound Interest


 210x       Filetype XLSX       File size 0.02 MB       Source: cdn.document360.io


File: Compound Interest Excel Template 46110 | Compound Interest
pmt is calculated based on monthly interest rate interest type compound interest compounded frequency daily accrued interest posting frequency monthly disbursement date 01042021 loan amount 1000 ir per year 1000 ...

icon picture XLSX Filetype Excel XLSX | Posted on 17 Aug 2022 | 3 years ago
Partial file snippet.
         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
The words contained in this file might help you see if this file matches what you are looking for:

...Pmt is calculated based on monthly interest rate type compound compounded frequency daily accrued posting disbursement date loan amount ir per year days in no of installments transactions schedule installment number due principal expected balance total paid state an pending...

no reviews yet
Please Login to review.