Type (Used/New/Refinance) (U/N/R)
N
Note: Cells Shaded to IRR Calculation be keyed in
Cost
(Rs.)
375,439
Loan Amt
(Rs.)
275,000 Margin money to
EMI Tenor
(Rs.)
34780
Dealer
100,439 Business IRR
11.82%
73.25% Customer IRR
11.57%
6,000 Gross LTV
(months)
60
(Nos.)
1
Adv EMIs
Sheet for Auto Loans
Net LTV
71.65% PDC Start Date
Subvention - Dealer
(Rs.)
1,500 Branch
Subvention - DMA
(Rs.)
File No
-
Subvention - MFR - Gross 1 (Rs.)
-
Mfr subv included in IRR
- Customer Name
KHANJAN
Mfr Subv passed to dealer 3 (Rs.)
- Dealer name
SHREE RAM AUTO WORLD
Unutilised Mfr Subv
4 (Rs.)
- DMA Name
SHREE RAM AUTO WORLD
Margin money to
(D/I/B)
Adv EMI to
2 (Rs.)
(D/I)
Mfr Subv to be ded from Disb (Y/N)
267,500
- Disb Amt
SENTRO GLS
Asset(Mfr / Veh / Mod)
VORA
D Remarks : D Rate approved by
Repymnt Mode
2.00% Rate Deviation(%)
Mode of Pmt
5,380
Bank A/c No
N Approved Valuer Sales Exec Name
IRR FOR ICICI
Product
Structure
Other Deductions
passed on to the dealer. Unutilised mfr subv is the amount which Business proposes to pass on to the DMA at the end of the month
#N/A
Scheme code
Amount to DMA (Per Lac)
### This is the total subv on the model as informed by Sales at the beginning of the month ### This is the amount used for computation of IRR NOT passed on the Dealer or DMA ### This is the amount added to the disbursement ### This is the Gross Manufacturer Subv. Less the amount utilised for IRR and amount
ECS
11.82%
Sheet7
Page 1
Sheet7
5555.56
Page 2
Sheet8
IRR Calculation Sheet for Auto Loans Type (Used/New/Refinance) (U/N/R) Cost (Rs.) Loan Amt (Rs.) EMI (Rs.) Tenor (months) Adv EMIs (Nos.) Subvention - Dealer (Rs.) Subvention - DMA (Rs.) Subvention - MFR - Gross 1 (Rs.) Mfr subv included in IRR 2 (Rs.) Mfr Subv passed to dealer 3 (Rs.) Unutilised Mfr Subv 4 (Rs.) Margin money to (D/I/B) Adv EMI to (D/I)
N 375439 275000 5000 60 1 1500 0 0 0 0 0 D D 2.00% 5380
Mfr Subv to be ded from Disb (Y/N) Amount to DMA (Per Lac) Product
N 0 0
Page 1
Note: Cells Shaded IRR Calculation to be keyedSheet in for Auto Loa 0 0 Margin money Dealer to Gross LTV 0 Net LTV 0 0 Branch 0 File No 0 Asset(Mfr / Veh / Mod) 0 Customer Name KHANJAN Dealer name SHREE RAM AUTO WORLD DMA Name SHREE RAM AUTO WORLD Remarks : 0.00% Rate approved by 0 Rate Deviation(%) 0.00% 0 Approved Valuer 0.00% Sales Exec Name 0 Structure 0
Sheet8
0 0 100439 73.25% 71.65% 0 0 0 SENTRO GLS 0 0 0 0 0 0.00% 0 0.00% 0 0
0 0 0 0 0 34780 0 Business IRR 11.82% 0.00% Customer IRR 11.57% 0.00% PDC Start Date 12/30/99 0 Disb Amt 267500 0 0 0 0 0 0 0 0 0 VORA 0 0 0 0 0 0 0 0.00% 0 0 0 Repymnt ModeECS 0 Mode of Pmt 0 0 Bank A/c No #N/A 0 Scheme code 0.00% 0 IRR FOR ICICI 11.82% 12/30/99 Other Deductions 0
Page 2
Auto Database Sr No. 20055 20059 20060 20066 20067 20069 20076 20077 20078 20082 20086 20088 20090 20104 20105 20106 20107 20108 20110 20111 20113 20121 20130 20138 20197 20202 20203 20210 20072 20092 20212 20054 20056 20061 20068 20075 20120 20136 20206 20051 20062 20063 20065 20071 20087 20143
PDC Control No.
File No
DM No
NAGAU000299 BARAU000285 UDRAU000099 UDRAU000098 UDRAU000105 INDAU000103 MEEAU000066 MEEAU000059 MEEAU000069 JODAU000087 PATAU000042 INDAU000066 COIAU000114 ASRAU000100 ASRAU000093 ASRAU000098 ASRAU070099 ASRAU0700092 JODAU000073 COIAU000073 JAIAU001340 INDAU000097 HYDAU001013 SURAU000205 DELAU005523 DELAU005726 DELAU005898 JALAU000236 MEEAU000064 MUMAU001480 CHAAU000823 NAGAU000294 INDAU000096 UDRAU000107 UDRAU000106 MEEAU000070 MUMAU001499 SURAU000199 DELAU005834 NASAU000185 UDRAU000104 UDRAU000063 RAJAU000054 MEEAU000063 INDAU000089 COIAU000129
6 10 11 17 18 20 27 28 29 33 37 39 41 55 56 57 58 59 61 62 64 72 81 89 148 153 154 161 23 43 163 5 7 12 19 26 71 87 157 2 13 14 16 22 38 94
DM File Received Received (Date) (Date) Aug 2, 00 Aug 2, 00 Aug 2, 00 Aug 2, 00 Aug 2, 00 Aug 2, 00 Aug 2, 00 Aug 2, 00 Aug 2, 00 Aug 2, 00 Aug 2, 00 Aug 2, 00 Aug 2, 00 Aug 3, 00 Aug 3, 00 Aug 3, 00 Aug 3, 00 Aug 3, 00 Aug 3, 00 Aug 3, 00 Aug 3, 00 Aug 3, 00 Aug 3, 00 Aug 3, 00 Aug 2, 00 Aug 3, 00 Aug 3, 00 Aug 3, 00 Aug 2, 00 Aug 2, 00 Aug 3, 00 Aug 2, 00 Aug 2, 00 Aug 2, 00 Aug 2, 00 Aug 2, 00 Aug 3, 00 Aug 3, 00 Aug 3, 00 Aug 2, 00 Aug 2, 00 Aug 2, 00 Aug 2, 00 Aug 2, 00 Aug 2, 00 Aug 4, 00
Branch
Name of Manufact the urer Customer
NAGPUR RAVINDRAMARUTI V JOG BARODA KUMUDCHANDRA MARUTI THAKKAR UDAIPUR SUSHILA DEVI MARUTI UDAIPUR PARMANAND MARUTI CHOTRANI UDAIPUR DILIP BHADADA MARUTI INDORE SURESH GHODKE MARUTI MEERUT P C SRIVASTAVA MARUTI MEERUT PREM SAGAR MARUTI MAHAJAN MEERUT NAVEEN KUMAR MARUTI JAIN JODHPUR OM SINGHMARUTI SISHODIA PATIALA MRS. PUSHPA MARUTI SINGLA INDORE JAGDISH CMARUTI VERMA COIMBATORE S RAVIKANTH MARUTI AMRITSARRAJINDERMARUTI SINGH AMRITSARSATPAL ARORA MARUTI AMRITSARS GURCHARAN MARUTI SINGH AMRITSARGUNEET GARMENTS MARUTI AMRITSARADITYA KUMAR MARUTI NATH JODHPUR SMT.SEEMA MARUTI MEHTA COIMBATORE USHA KUMARI MARUTI JAIPUR PANKAJ AHUJA MARUTI INDORE BHAURAOMARUTI BHUJADE HYDERABAD KARVY CONSULTANTS MARUTI LTD SURAT SUBHABRATA MARUTI CHATTERJEE DELHI MANG MINTHAG MARUTI TANGPURA DELHI MADHAVI CHILUKURI MARUTI DELHI DEEPA PANDY MARUTI JALANDHAR JITENDER MARUTI SINGH MEERUT MEENAKSHI MARUTI MITHAL MUMBAI STFA PILING MARUTI (I) LTD CHANDIGARH DELHI STEEL MARUTI INDUSTIRES NAGPUR SUBRATA MARUTI N ROY INDORE RAMESH KOTIA MARUTI UDAIPUR SHAJAUDDIN MARUTI KHILONAWALA UDAIPUR JINENDRAMARUTI MEHTA MEERUT SADHNA PRAKASHAN MARUTI MUMBAI SIRAJ KHUNJ MARUTI SURAT MADHAVBHAI MARUTI C PATEL DELHI RAKESH PANDEY MARUTI NASIK ARVIND TRIMBAK MARUTIMORE UDAIPUR PREETI HANDA MARUTI UDAIPUR RAMESH CHANDRA MARUTI PATEL RAJKOT SUKUMARAN MARUTI D NAIR MEERUT PRADEEP MARUTI PARUTHI INDORE GUL CHANDWANI MARUTI COIMBATORE C HARIKRISHNAN MARUTI
20162 20189
COIAU000109 113 Aug 4, 00 ASRAU000051/1 140 Aug 4, 00
COIMBATORE S BALAKRISHANAN MARUTI AMRITSARR K PRINTMARUTI HOUSE
Subvention
Vehicle M-800 M-800 M-800 M-800 M-800 M-800 M-800 M-800 M-800 M-800 M-800 M-800 M-800 M-800 M-800 M-800 M-800 M-800 M-800 M-800 M-800 M-800 M-800 M-800 M-800 M-800 M-800 M-800 ESTEEM ESTEEM ESTEEM OMNI OMNI OMNI OMNI OMNI OMNI OMNI OMNI ZEN ZEN ZEN ZEN ZEN ZEN ZEN
Not required
DMA
Dealer
3,033 1,060 500 915 4,008 570 1,300 1,720.00 1,400.00 5,109 6,760.00 4,967 320 500 2,500 6,630
2,500 4,000 1,825 540 380 1,000 4,136 1,640 6,741 4,345 1,300 1,744 3,600 2,000 2,700 1,080 1,000 9,950 4,000 3,600.00 4,500.00 2,850.00 7,000 2,500 1,000 1,300 900.00 2,000 3,250 3,550 6,000 1,000 -
Manufact Dealer urer Receipt 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 7,200 7,200 7,200 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400 3,600 3,600 3,600 3,600 3,600 3,600 3,600
ZEN ZEN
4,640 -
-
3,600 3,600