How to perform Amortization calculation using DataSnipper

Learn how to use DataSnipper to perform form Amortization calculation using Snips.

Video Tutorial

Example

Here you can download the workbook shown in the video including all of the sample data and documents.

Amortization Calculation - example

Template

Here you can download a blank version of the workbook shown in the video to use or customise for your own procedures. 

Amortization Calculation - template

Prerequisites

• Loan agreement and addendum
• Repayment schedule
• Bank Statements

Start Procedure

1. Start by opening your Excel workbook and ensuring that the data essential for the testing procedure is documented.
2. Import your relevant documents, i.e., Loan agreement and addendum, Bank Statements.
3. Next, in the viewer select the Loan agreement and extract the relevant data from the Loan Agreement into the “Agreement Summary” sheet.
   
4. Now, select the addendum and extract the repayment terms.
   
5. Use the Validation or Exception Snip to verify signatures in both agreements.
   
6. Select the 'Bank Statement' in the Document Viewer.
7. In the “Amortization Table” sheet, use text snip to extract the repayments from the bank statements into the relevant cells.