Extra Quality Tip: Instead of using the browser’s print-to-PDF option, always look for a native “Download PDF” button. This preserves the original vector quality and embedded data tags.
When moving your Kotak personal loan to another bank, the new lender will ask for a 12-month repayment history. Blurry or incomplete downloads can delay approval.
If Kotak’s official download lacks detail, build your own using loan parameters: Extra Quality Tip: Instead of using the browser’s
Formula for monthly breakdown:
Interest for month = Outstanding Principal × (Annual Rate / 12)
Principal repaid = EMI – Interest
Outstanding principal = Previous outstanding – Principal repaid
Tools:
The phrase “extra quality” in the context of a loan repayment schedule refers to:
A standard downloaded schedule might suffice for casual viewing, but for auditors, CA filings, or prepayment planning, you need extra quality—error-free, clear, and comprehensive. Tools: The phrase “extra quality” in the context
A high-quality schedule will include:
Pick any month. Calculate:
Interest = Opening Balance × (Annual Interest Rate / 12)
If the difference is more than ₹1, the schedule has a quality defect. A standard downloaded schedule might suffice for casual
| Feature | Standard Schedule | Extra Quality Method | |--------|------------------|----------------------| | Print resolution | 96 DPI (screen) | 300 DPI via PDF printer (CutePDF, Adobe Acrobat) | | Data format | Read-only PDF | Excel/CSV via manual export or third-party template | | Prepayment impact | Not shown | Use Kotak’s Part-prepayment calculator to generate revised schedule | | Colour coding | None | DIY in Excel (conditional formatting for interest vs principal) | | Multi-currency / notes | No | Add custom columns (e.g., tax, insurance) via spreadsheet |