Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago
Authentication
digital resources
332x Filetype XLSX File size 0.13 MB Source: www.samba.com.pk
Sheet 1: Loan Calculator
| 18-Aug-22 | 18-Aug-22 | |||||||||||||
| ROSHAN APNI CAR LOAN CALCULATION SHEET | 18-Aug-22 | 18-Aug-22 | ||||||||||||
| MAKE : | REGAL AUTOMOBILES INDUSTRIES | |||||||||||||
| MODEL : | PRINCE - PEARL | |||||||||||||
| CAR TYPE: | New | |||||||||||||
| CAR PRICE NEW (PKR): | 1,149,000 | |||||||||||||
| CAR PRICE USED (PKR): | 2,000,000 | |||||||||||||
| FIRST YEAR INSURANCE (PKR): | 17,235 | |||||||||||||
| INSURED AMOUNT (PKR): | 1,149,000 | |||||||||||||
| EQUITY ( % ): | 15% | FINANCING %: | 85% | |||||||||||
| TENURE (in Years): | 6 | |||||||||||||
| INSURANCE OPTIONS |
INSURANCE COMPANY | EFU W/o Tracker With Addon (VAS*) | ||||||||||||
| WITH TRACKER | No | |||||||||||||
| WITH VALUE ADDED SERVICE(S) - ADD-Ons | Yes | |||||||||||||
| INSURANCE RATE | 1.50% | |||||||||||||
| EQUITY : | 172,350 | |||||||||||||
| FINANCING : | 976,650 | |||||||||||||
| 1st YEAR INSURANCE : | 17,235 | |||||||||||||
| PROCESSING FEES : | 7,500 | |||||||||||||
| FEDRAL EXISE DUTY : | 1,125 | |||||||||||||
| ----> | 0.15% | |||||||||||||
| DOWN PAYMENT (Amount in PKR) | 198,210 | |||||||||||||
| TENTATIVE MONTHLY PAYMENT SCHEDULE | ||||||||||||||
| Year | EQUAL MONTHLY INSTALLMENT | INSURANCE INSTALLMENT | TOTAL MONTHLY PAYMENT | DEPRECIATION | ||||||||||
| 1 | 17,726 | 1,293 | = | 19,019 | @ | 90% | ||||||||
| 2 | 17,726 | 1,221 | = | 18,947 | @ | 85% | ||||||||
| 3 | 17,726 | 1,149 | = | 18,875 | @ | 80% | ||||||||
| 4 | 17,726 | 1,077 | = | 18,803 | @ | 75% | ||||||||
| 5 | 17,726 | 1,005 | = | 18,731 | @ | 70% | ||||||||
| 6 | 17,726 | 0 | = | 17,726 | @ | 65% | ||||||||
| CUSTOMER SIGNATURE:______________________________________________ | Select Interest Rate | 5year-Lien Product | ||||||||||||
| Interest Rate | 9.2500% | |||||||||||||
no reviews yet
Please Login to review.
