Overview


Sheet 1: Input

KEY ASSUMPTIONS










Interest Rate Assumptions




Particulars|Year Year 1 Year 2 Year 3 Year 4 Year 5
Mortgages 11.5% 11.5% 11.5% 11.5% 11.5%
LAP 12.8% 12.8% 12.8% 12.8% 12.8%
Construction Finance 13.5% 13.5% 13.5% 13.5% 13.5%
Developer Funding 20.0% 20.0% 20.0% 20.0% 20.0%
Interest Income (on FDs) 8.5% 8.5% 8.5% 8.5% 8.5%
Interest Expenses (on borrowing) 10.0% 10.0% 10.0% 10.0% 10.0%






Commission / Incentive Assumptions for sales




Particulars|Year Year 1 Year 2 Year 3 Year 4 Year 5
Mortgages 0.75% 0.75% 0.75% 0.75% 0.75%
Commision payment period(months) 18



Particulars LAP Mortgage


Insurance Commission : 0.94% 1.06%


% of Book size 75% 85%


Innsurance cost as a % of property value 2.50% 2.50%


% of pass back 50% 50%














Key other assumptions




Particulars LAP Construction Finance Developer Finance Mortgage
Repayment period (months) 48 Months 60 Months 30 Months 72 Months
Upfront Fee 1% 3% 2% ₹ 0.01 Million
Disbursal time period


15 Months
Disbursement (% of LAP + Mortgages)
10.0% 7.5%

Avg Ticket Size / Customer 7.50 Million

2.00 Million
Business Generated per Branch


₹ 650 Million
LTV 65%

75%






DEBT-EQUITY RATIO:




Total Loan Assets Maximum Debt / Equity



40,000 5.00



30,000 4.25



20,000 3.65



15,000 3.05



10,000 2.45



7,500 1.85



2,500 1.25









LAP Disbursement assumptions:




Period Incremental amount Disbursement amount


1 - 6 - -


7 - 12 250 250


13 - 18 25 275


19 - 24 25 300


25 - 30 50 350


31 - 36 50 400


37 - 42 50 450


43 - 48 50 500


49 - 54 50 550


55 - 60 - 550








Branch build up




Period Opening Addition Closing

1 - 6 - - -

7 - 11 - 4 4

12 - 15 4 3 7

16 - 19 7 3 10

20 - 23 10 3 13

24 - 27 13 2 15

28 - 31 15 1 16

32 - 35 16 1 17

36 - 39 17 1 18

40 - 43 18 3 21

44 - 47 21 3 24

48 - 51 24 3 27

52 - 55 27 3 30

56 - 59 30 3 33

60 33 3 36







NPA Provisioning as per NHB norms




Particulars %



On Mortgages 0.40%



On LAP, CF , DF 1.00%









NPA Write off % 0.50%









OPERATING EXPENSES ASSUMPTIONS:




Salary costs at Branches and Hubs




Designation Number of People Base Salary % Monthly Increment

1 Branch Manager 1 ₹ 1.50 Million 1%

1 Recovery / Follow up 1 ₹ 0.75 Million 1%

1 Sr Sales Originator 1 ₹ 1.50 Million 1%

2 Jr Sales Originator 2 ₹ 1.50 Million 1%

1 Operation staff 1 ₹ 0.75 Million 1%

2 Other off roll people 2 ₹ 0.50 Million 1%







Bonus as a % of annual income 25%









OTHER EXPENSE ASSUMPTIONS




Particulars Amount per annum % Monthly Increment


Other Branch Expenses ₹ 0.50 Million 1%


Rental : ₹ 0.42 Million 1%


- Size (Sq.ft) 700



- Rate / Sq. ft 50



Rent Depost 3 Months









Head Office




Designation Number of People Base Salary % Annual Increment

CEO 1 ₹ 17.50 Million 0%

CFO ( Liab + Accs ) 1 ₹ 17.50 Million 0%

COO ( Asset + Recovery) 1 ₹ 17.50 Million 0%

Head of Legal / Compliance (2 s) 2 ₹ 5.00 Million 10%

Head of Products and Policies (2 s) 2 ₹ 7.00 Million 10%

Head of Sales / Relationship with DSAs (2 s) 2 ₹ 2.50 Million 10%

Head of Branches (2 suport) 2 ₹ 3.50 Million 10%

Head of IT ( support) 1 ₹ 2.40 Million 10%







SUPPORT STAFF COST ASSUMPTIONS:




Particulars|Year Year 1 Year 2 Year 3 Year 4 Year 5
No.Of Support Staff 7 12 18 25 30
Cost of Support Staff / person ₹ 0.75 Million ₹ 0.83 Million ₹ 0.91 Million ₹ 1.00 Million ₹ 1.10 Million
% Annual Increment 0% 10% 10% 10% 10%






Bonus for Staff 25%



Bonus for Management ( limited to INR50mm) 5%









HO RENTAL EXPENSE ASSUMPTIONS




Particulars|Year Year 1 Year 2 Year 3 Year 4 Year 5
HO Rental : ₹ 2.40 Million ₹ 2.64 Million ₹ 5.81 Million ₹ 6.39 Million ₹ 7.03 Million
- Size (Sq.ft) 2,000 2,000 4,000 4,000 4,000
- Rate / Sq. ft 100 110 121 133 146
Increase in Rate
10% 10% 10% 10%
Rent Deposit ₹ 0.60 Million - ₹ 0.73 Million - -






Other Indirect Cost Assumptions




Inflation % 10%









Particulars Base Yearly cost



Marketing & PR costs ₹ 10.00 Million



Legal Expenses ₹ 1,000.00 per file



Technical Cost ₹ 500.00 per file



Travelling Cost ₹ 10.00 Million



Storage ₹ 2.50 Million



Directors Sitting Fees ₹ 2.40 Million



Insurance Expenses ₹ 2.40 Million



Auditors Fees ₹ 3.00 Million



Other Expenses (Printing & Stationery, Telephone, office Expenses, electricity, repairs & maint, staff welfare) ₹ 2.50 Million



IT Expenses / AMC ₹ 0.15 Mill / branch p.a.









Recruitment Cost equivalent to 1 month's Salary









INITIAL CAPITAL EXPENDITURE ASSUMPTIONS




Particulars Per Branch Expense Particulars Per Branch Expense

Furniture & Fixtures
IT Assets


Air conditioners 120,000 Laptop / Printer / Scanner per head 50,000

One Sofa Set 40,000 No of peple / branch 6

Chair Sets 100,000



Center Tables 30,000 Total IT Assets 300,000

Micro wave / Aqua guard 10,000



Office Printer / Photocopy machine / Scanner 40,000 HO


High table 12,000 Laptop / Printer / Scanner per head 100,000

Pantry Table 10,000 No of peple / branch 19

Total F&F 362,000









HO CAPEX Assumption




Particulars|Year Year 1 Year 2 Year 3 Year 4 Year 5
- Size (Sq.ft) 2,000 2,000 4,000 4,000 4,000
- Fit out Rate / Sq. ft 2,000 - 2,000 - -
Total ₹ 4.00 Million ₹ 0.00 Million ₹ 4.00 Million ₹ 0.00 Million ₹ 0.00 Million






IT CAPITAL EXPENDITURE




Particulars Month 1 Month 30


IT Capex - MM 30 30


Cash outflow in 6 Months 6 Months








DEPRECIATION RULES




Depreciation as per Companies Act




IT Assets 36 Months



Furniture & Fixtures 120 Months









TAX RATES




Particulars Details



Transfer to Reserves 12.50%



Tax Rate - Income Tax 33.99%



Tax Rate - MAT 19.06%









OTHER FINANCIAL ASSUMPTIONS:










Minimum Cash as a % of assets 5%









Capital Adequacy Assumptions




Capital Adequacy Split %


Mortgages




< 30 L 50% 50%


30 - 75 L 50% 75%








Other Assets 0% 100%








Target Capital Adequacy Ratio % 18%




Sheet 2: Workings

Amounts in INR Million unless mentioned otherwise
M 1 M 2 M 3 M 4 M 5 M 6 M 7 M 8 M 9 M 10 M 11 M 12 M 13 M 14 M 15 M 16 M 17 M 18 M 19 M 20 M 21 M 22 M 23 M 24 M 25 M 26 M 27 M 28 M 29 M 30 M 31 M 32 M 33 M 34 M 35 M 36 M 37 M 38 M 39 M 40 M 41 M 42 M 43 M 44 M 45 M 46 M 47 M 48 M 49 M 50 M 51 M 52 M 53 M 54 M 55 M 56 M 57 M 58 M 59 M 60
Interest Rate Assumptions




























































Mortgages
11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5% 11.5%
LAP
12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8% 12.8%
Construction Finance
13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5% 13.5%
Developer Funding
20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0%






























































Summary of total Closing Book Size




























































Mortgages
- - - - - - 14 42 84 140 210 303 421 561 726 924 1,155 1,419 1,716 2,055 2,437 2,847 3,284 3,755 4,259 4,797 5,357 5,942 6,552 7,186 7,834 8,499 9,181 9,878 10,581 11,292 12,012 12,739 13,467 14,206 14,956 15,716 16,483 17,267 18,067 18,884 19,712 20,563 21,437 22,331 23,243 24,183 25,150 26,143 27,151 28,186 29,244 30,328 31,424 32,544
LAP
- - - - - - 250 495 734 969 1,199 1,424 1,669 1,910 2,145 2,375 2,601 2,821 3,063 3,299 3,530 3,757 3,978 4,195 4,458 4,715 4,967 5,213 5,455 5,691 5,973 6,248 6,518 6,782 7,041 7,294 7,592 7,884 8,170 8,450 8,724 8,992 9,305 9,611 9,910 10,204 10,491 10,773 11,098 11,417 11,729 12,035 12,334 12,627 12,914 13,195 13,470 13,740 14,003 14,262
Construction Finance
- - - - - - - - - - - - 209 244 283 325 370 418 471 528 588 651 715 783 859 937 1,017 1,099 1,182 1,268 1,360 1,452 1,546 1,640 1,735 1,830 1,930 2,030 2,130 2,230 2,331 2,432 2,538 2,645 2,754 2,863 2,973 3,084 3,202 3,321 3,442 3,564 3,689 3,816 3,943 4,072 4,204 4,337 4,470 4,606
Developer Funding
- - - - - - - - - - - - 157 180 209 240 274 309 348 390 435 481 529 579 634 692 751 812 873 937 1,004 1,073 1,142 1,211 1,281 1,351 1,425 1,499 1,573 1,647 1,721 1,796 1,874 1,953 2,033 2,114 2,195 2,277 2,364 2,452 2,541 2,632 2,724 2,817 2,911 3,007 3,103 3,202 3,300 3,400
Total Book Size
- - - - - - 264 537 819 1,109 1,409 1,727 2,456 2,895 3,363 3,864 4,399 4,967 5,597 6,272 6,990 7,735 8,506 9,312 10,210 11,141 12,091 13,065 14,062 15,082 16,171 17,272 18,386 19,512 20,638 21,767 22,959 24,153 25,340 26,533 27,732 28,936 30,200 31,477 32,765 34,064 35,371 36,697 38,101 39,522 40,956 42,414 43,896 45,403 46,920 48,460 50,022 51,606 53,198 54,812






























































Total Book Size (%)




























































Mortgages
0% 0% 0% 0% 0% 0% 5% 8% 10% 13% 15% 18% 17% 19% 22% 24% 26% 29% 31% 33% 35% 37% 39% 40% 42% 43% 44% 45% 47% 48% 48% 49% 50% 51% 51% 52% 52% 53% 53% 54% 54% 54% 55% 55% 55% 55% 56% 56% 56% 57% 57% 57% 57% 58% 58% 58% 58% 59% 59% 59%
LAP
0% 0% 0% 0% 0% 0% 95% 92% 90% 87% 85% 82% 68% 66% 64% 61% 59% 57% 55% 53% 51% 49% 47% 45% 44% 42% 41% 40% 39% 38% 37% 36% 35% 35% 34% 34% 33% 33% 32% 32% 31% 31% 31% 31% 30% 30% 30% 29% 29% 29% 29% 28% 28% 28% 28% 27% 27% 27% 26% 26%
Construction Finance
0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 9% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8%
Developer Funding
0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6%
Total Book Size
0% 0% 0% 0% 0% 0% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100%






























































Commission / Incentive Assumptions for sales




























































Mortgages
0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75% 0.75%
Commission Payment schedule 18 Months - - - - - - 0.11 0.23 0.35 0.48 0.61 0.76 1.07 1.28 1.50 1.73 1.99 2.26 2.57 2.89 3.24 3.61 3.99 4.39 4.73 5.08 5.43 5.80 6.18 6.56 6.81 7.18 7.56 7.92 8.28 8.62 8.98 9.31 9.63 9.95 10.26 10.56 10.85 11.13 11.42 11.70 11.98 12.27 12.55 12.85 13.15 13.45 13.77 14.11 14.42 14.75 15.09 15.45 15.81 16.17






























































LAP Book Schedule 65%



























































Opening
- - - - - - - 250 495 734 969 1,199 1,424 1,669 1,910 2,145 2,375 2,601 2,821 3,063 3,299 3,530 3,757 3,978 4,195 4,458 4,715 4,967 5,213 5,455 5,691 5,973 6,248 6,518 6,782 7,041 7,294 7,592 7,884 8,170 8,450 8,724 8,992 9,305 9,611 9,910 10,204 10,491 10,773 11,098 11,417 11,729 12,035 12,334 12,627 12,914 13,195 13,470 13,740 14,003
Additions
- - - - - - 250 250 250 250 250 250 275 275 275 275 275 275 300 300 300 300 300 300 350 350 350 350 350 350 400 400 400 400 400 400 450 450 450 450 450 450 500 500 500 500 500 500 550 550 550 550 550 550 550 550 550 550 550 550
Interest on above
- - - - - - - 3 5 8 10 13 15 18 20 23 25 28 30 33 35 38 40 42 45 47 50 53 55 58 60 63 66 69 72 75 78 81 84 87 90 93 96 99 102 105 108 111 114 118 121 125 128 131 134 137 140 143 146 149
Interest Paid
- - - - - - - 3 5 8 10 13 15 18 20 23 25 28 30 33 35 38 40 42 45 47 50 53 55 58 60 63 66 69 72 75 78 81 84 87 90 93 96 99 102 105 108 111 114 118 121 125 128 131 134 137 140 143 146 149
Principal Paid 48 Months - - - - - - - 5 10 15 20 25 30 35 40 45 49 54 59 64 69 74 78 83 87 93 98 103 109 114 119 124 130 136 141 147 152 158 164 170 176 182 187 194 200 206 213 219 224 231 238 244 251 257 263 269 275 281 286 292
Closing
- - - - - - 250 495 734 969 1,199 1,424 1,669 1,910 2,145 2,375 2,601 2,821 3,063 3,299 3,530 3,757 3,978 4,195 4,458 4,715 4,967 5,213 5,455 5,691 5,973 6,248 6,518 6,782 7,041 7,294 7,592 7,884 8,170 8,450 8,724 8,992 9,305 9,611 9,910 10,204 10,491 10,773 11,098 11,417 11,729 12,035 12,334 12,627 12,914 13,195 13,470 13,740 14,003 14,262
No of Customers 8 mm Avg tkt size - - - - - - 33 66 98 129 160 190 223 255 286 317 347 376 408 440 471 501 530 559 594 629 662 695 727 759 796 833 869 904 939 973 1,012 1,051 1,089 1,127 1,163 1,199 1,241 1,281 1,321 1,361 1,399 1,436 1,480 1,522 1,564 1,605 1,645 1,684 1,722 1,759 1,796 1,832 1,867 1,902
Target LAP per Branch






63 63 63 63 63 36 39 39 39 28 28 28 30 23 23 23 23 20 23 23 23 22 22 22 25 24 24 24 24 22 25 25 25 21 21 21 24 21 21 21 21 19 20 20 20 18 18 18 18 17 17 17 17 15
LAP Upfront Fee 1.00% - - - - - - 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 5 5 5 5 6 6 6 6 6 6 6 6 6 6 6 6
LAP Insurance Commission - 75% of Book, 2.5% of Property Value and 50% pass back 0.94% - - - - - - 3.6 3.6 3.6 3.6 3.6 3.6 4.0 4.0 4.0 4.0 4.0 4.0 4.3 4.3 4.3 4.3 4.3 4.3 5.0 5.0 5.0 5.0 5.0 5.0 5.8 5.8 5.8 5.8 5.8 5.8 6.5 6.5 6.5 6.5 6.5 6.5 7.2 7.2 7.2 7.2 7.2 7.2 7.9 7.9 7.9 7.9 7.9 7.9 7.9 7.9 7.9 7.9 7.9 7.9






























































Mortgage Book Build-up Schedule 75% LTV at inception



























































No of Branches
- - - - - - 4 4 4 4 4 7 7 7 7 10 10 10 10 13 13 13 13 15 15 15 15 16 16 16 16 17 17 17 17 18 18 18 18 21 21 21 21 24 24 24 24 27 27 27 27 30 30 30 30 33 33 33 33 36
Businesss Generated per Branch Mortgages ₹ 650 Million 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2 54.2
Total Assets Generated
- - - - - - 217 217 217 217 217 379 379 379 379 542 542 542 542 704 704 704 704 813 813 813 813 867 867 867 867 921 921 921 921 975 975 975 975 1,138 1,138 1,138 1,138 1,300 1,300 1,300 1,300 1,463 1,463 1,463 1,463 1,625 1,625 1,625 1,625 1,788 1,788 1,788 1,788 1,950
Cumulativ Assest
- - - - - - 217 433 650 867 1,083 1,463 1,842 2,221 2,600 3,142 3,683 4,225 4,767 5,471 6,175 6,879 7,583 8,396 9,208 10,021 10,833 11,700 12,567 13,433 14,300 15,221 16,142 17,063 17,983 18,958 19,933 20,908 21,883 23,021 24,158 25,296 26,433 27,733 29,033 30,333 31,633 33,096 34,558 36,021 37,483 39,108 40,733 42,358 43,983 45,771 47,558 49,346 51,133 53,083
Disbusals 15 Months


- - - 14 29 43 58 72 98 123 148 173 209 246 282 318 365 412 444 477 516 556 596 625 657 690 722 744 769 794 820 834 852 870 888 899 921 943 964 982 1,011 1,040 1,069 1,094 1,130 1,166 1,203 1,235 1,278 1,322 1,365 1,398 1,441 1,484 1,528 1,560 1,603
Cumulative Interest Earning Asset
- - - - - - 14 43 87 144 217 314 437 585 758 968 1,213 1,495 1,813 2,178 2,589 3,033 3,510 4,026 4,583 5,178 5,803 6,460 7,150 7,872 8,616 9,385 10,180 10,999 11,834 12,686 13,556 14,444 15,344 16,264 17,207 18,171 19,153 20,164 21,204 22,273 23,368 24,498 25,664 26,867 28,102 29,380 30,702 32,067 33,464 34,905 36,389 37,917 39,477 41,080
No of customers ₹ 2.00 Million


- - - 108 217 325 433 542 731 921 1,110 1,300 1,571 1,842 2,113 2,383 2,735 3,088 3,440 3,792 4,198 4,604 5,010 5,417 5,850 6,283 6,717 7,150 7,610 8,071 8,531 8,992 9,479 9,967 10,454 10,942 11,510 12,079 12,648 13,217 13,867 14,517 15,167 15,817 16,548 17,279 18,010 18,742 19,554 20,367 21,179 21,992 22,885 23,779 24,673 25,567 26,542
Insurance Commission - 75% of loan book at 2.5% of premia and 50% pass back 1.06% - - - - - - 3 3 3 3 3 5 5 5 5 8 8 8 8 10 10 10 10 12 12 12 12 12 12 12 12 13 13 13 13 14 14 14 14 16 16 16 16 18 18 18 18 21 21 21 21 23 23 23 23 25 25 25 25 28
Processing Fee Upfront - 5k per file ₹ 0.01 Million - - - - - - 1 1 1 1 1 1 1 1 1 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 6 6 6 6 7 7 7 7 7






























































Mortgage Schedule




























































Opening
- - - - - - - 14 42 84 140 210 303 421 561 726 924 1,155 1,419 1,716 2,055 2,437 2,847 3,284 3,755 4,259 4,797 5,357 5,942 6,552 7,186 7,834 8,499 9,181 9,878 10,581 11,292 12,012 12,739 13,467 14,206 14,956 15,716 16,483 17,267 18,067 18,884 19,712 20,563 21,437 22,331 23,243 24,183 25,150 26,143 27,151 28,186 29,244 30,328 31,424
Additions
- - - - - - 14 29 43 58 72 98 123 148 173 209 246 282 318 365 412 444 477 516 556 596 625 657 690 722 744 769 794 820 834 852 870 888 899 921 943 964 982 1,011 1,040 1,069 1,094 1,130 1,166 1,203 1,235 1,278 1,322 1,365 1,398 1,441 1,484 1,528 1,560 1,603
Interest on above
- - - - - - - 0 0 1 1 2 3 4 5 7 9 11 14 16 20 23 27 31 36 41 46 51 57 63 69 75 81 88 95 101 108 115 122 129 136 143 151 158 165 173 181 189 197 205 214 223 232 241 251 260 270 280 291 301
Interest Paid
- - - - - - - 0 0 1 1 2 3 4 5 7 9 11 14 16 20 23 27 31 36 41 46 51 57 63 69 75 81 88 95 101 108 115 122 129 136 143 151 158 165 173 181 189 197 205 214 223 232 241 251 260 270 280 291 301
Principal Paid
- - - - - - 0 1 1 2 3 4 5 7 9 12 14 17 21 25 30 35 40 45 52 58 65 72 80 88 96 104 113 122 131 141 151 161 171 182 193 204 215 227 240 252 266 279 293 308 323 339 355 372 389 407 425 444 464 484
Closing
- - - - - - 14 42 84 140 210 303 421 561 726 924 1,155 1,419 1,716 2,055 2,437 2,847 3,284 3,755 4,259 4,797 5,357 5,942 6,552 7,186 7,834 8,499 9,181 9,878 10,581 11,292 12,012 12,739 13,467 14,206 14,956 15,716 16,483 17,267 18,067 18,884 19,712 20,563 21,437 22,331 23,243 24,183 25,150 26,143 27,151 28,186 29,244 30,328 31,424 32,544
EMI Paid 72 Months - - - - - - 0 1 2 3 4 6 8 11 14 18 23 29 35 42 49 58 67 77 88 99 111 123 137 150 165 179 195 210 226 242 259 276 293 311 329 347 366 385 405 426 447 468 490 513 537 561 587 613 639 667 695 725 754 785






























































Construction Finance Schedule




























































Opening
- - - - - - - - - - - - - 209 244 283 325 370 418 471 528 588 651 715 783 859 937 1,017 1,099 1,182 1,268 1,360 1,452 1,546 1,640 1,735 1,830 1,930 2,030 2,130 2,230 2,331 2,432 2,538 2,645 2,754 2,863 2,973 3,084 3,202 3,321 3,442 3,564 3,689 3,816 3,943 4,072 4,204 4,337 4,470
Additions
- - - - - - - - - - - - 208.99 38.11 43.43 46.88 50.39 53.92 59.96 64.54 69.16 72.39 75.66 79.65 88.63 92.53 95.47 98.78 102.09 105.40 112.66 115.18 117.78 120.37 121.90 123.79 130.66 132.42 133.55 135.73 137.88 140.02 146.80 149.53 152.31 155.09 157.50 160.97 169.41 172.74 175.79 179.89 183.97 188.04 191.04 195.09 199.12 203.13 206.07 210.06
Interest on above
- - - - - - - - - - - - - 2 3 3 4 4 5 5 6 7 7 8 9 10 11 11 12 13 14 15 16 17 18 20 21 22 23 24 25 26 27 29 30 31 32 33 35 36 37 39 40 42 43 44 46 47 49 50
Interest Paid
- - - - - - - - - - - - - 2 3 3 4 4 5 5 6 7 7 8 9 10 11 11 12 13 14 15 16 17 18 20 21 22 23 24 25 26 27 29 30 31 32 33 35 36 37 39 40 42 43 44 46 47 49 50
Principal Paid 60 Months - - - - - - - - - - - - - 3 4 5 5 6 7 8 9 10 11 12 13 14 16 17 18 20 21 23 24 26 27 29 30 32 34 35 37 39 41 42 44 46 48 50 51 53 55 57 59 61 64 66 68 70 72 75
Closing
- - - - - - - - - - - - 209 244 283 325 370 418 471 528 588 651 715 783 859 937 1,017 1,099 1,182 1,268 1,360 1,452 1,546 1,640 1,735 1,830 1,930 2,030 2,130 2,230 2,331 2,432 2,538 2,645 2,754 2,863 2,973 3,084 3,202 3,321 3,442 3,564 3,689 3,816 3,943 4,072 4,204 4,337 4,470 4,606
Construction Finance Upfront Fee 3.0% - - - - - - - - - - - - 6 1 1 1 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 6 6 6 6 6 6 6 6






























































Developer Finance Schedule




























































Opening
- - - - - - - - - - - - - 157 180 209 240 274 309 348 390 435 481 529 579 634 692 751 812 873 937 1,004 1,073 1,142 1,211 1,281 1,351 1,425 1,499 1,573 1,647 1,721 1,796 1,874 1,953 2,033 2,114 2,195 2,277 2,364 2,452 2,541 2,632 2,724 2,817 2,911 3,007 3,103 3,202 3,300
Additions
- - - - - - - - - - - - 156.74 28.58 35.18 38.12 41.23 44.39 49.47 53.48 57.59 60.70 63.88 67.63 75.15 78.90 82.02 85.45 88.90 92.37 98.83 101.76 104.82 107.88 110.16 112.72 119.02 121.49 123.54 126.39 129.21 132.03 138.33 141.60 144.98 148.36 151.48 155.40 163.06 166.90 170.62 175.14 179.66 184.20 187.95 192.53 197.09 201.66 205.45 210.05
Interest on above
- - - - - - - - - - - - - 3 3 3 4 5 5 6 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 23 24 25 26 27 29 30 31 33 34 35 37 38 39 41 42 44 45 47 49 50 52 53 55
Interest Paid
- - - - - - - - - - - - - 3 3 3 4 5 5 6 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 23 24 25 26 27 29 30 31 33 34 35 37 38 39 41 42 44 45 47 49 50 52 53 55
Principal Paid 30 Months - - - - - - - - - - - - - 5.22 6 7 8 9 10 12 13 14 16 18 19 21 23 25 27 29 31 33 36 38 40 43 45 48 50 52 55 57 60 62 65 68 70 73 76 79 82 85 88 91 94 97 100 103 107 110
Closing
- - - - - - - - - - - - 157 180 209 240 274 309 348 390 435 481 529 579 634 692 751 812 873 937 1,004 1,073 1,142 1,211 1,281 1,351 1,425 1,499 1,573 1,647 1,721 1,796 1,874 1,953 2,033 2,114 2,195 2,277 2,364 2,452 2,541 2,632 2,724 2,817 2,911 3,007 3,103 3,202 3,300 3,400
Developer Funding Upfront Fee 2% - - - - - - - - - - - - 3 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4






























































Total Assets net off repayments
- - - - - - 264 537 819 1,109 1,409 1,727 2,456 2,895 3,363 3,864 4,399 4,967 5,597 6,272 6,990 7,735 8,506 9,312 10,210 11,141 12,091 13,065 14,062 15,082 16,171 17,272 18,386 19,512 20,638 21,767 22,959 24,153 25,340 26,533 27,732 28,936 30,200 31,477 32,765 34,064 35,371 36,697 38,101 39,522 40,956 42,414 43,896 45,403 46,920 48,460 50,022 51,606 53,198 54,812
Total Disbursals
- - - - - - 264 279 293 308 322 348 764 490 527 569 612 655 727 783 838 877 916 964 1,070 1,117 1,152 1,191 1,231 1,270 1,355 1,386 1,417 1,448 1,466 1,489 1,570 1,592 1,606 1,633 1,660 1,686 1,767 1,802 1,837 1,872 1,903 1,947 2,049 2,092 2,131 2,183 2,235 2,287 2,326 2,378 2,430 2,482 2,522 2,573
Total Repayments
- - - - - - 0 6 12 17 23 29 35 51 59 68 77 87 97 108 120 132 145 158 171 186 202 218 234 250 267 285 303 322 340 359 378 399 419 440 461 482 503 526 549 573 596 620 645 671 698 725 753 781 809 839 868 898 929 960






























































Interest Income




























































Mortgages
- - - - - - - 0 0 1 1 2 3 4 5 7 9 11 14 16 20 23 27 31 36 41 46 51 57 63 69 75 81 88 95 101 108 115 122 129 136 143 151 158 165 173 181 189 197 205 214 223 232 241 251 260 270 280 291 301
LAP
- - - - - - - 3 5 8 10 13 15 18 20 23 25 28 30 33 35 38 40 42 45 47 50 53 55 58 60 63 66 69 72 75 78 81 84 87 90 93 96 99 102 105 108 111 114 118 121 125 128 131 134 137 140 143 146 149
Construction Finance
- - - - - - - - - - - - - 2 3 3 4 4 5 5 6 7 7 8 9 10 11 11 12 13 14 15 16 17 18 20 21 22 23 24 25 26 27 29 30 31 32 33 35 36 37 39 40 42 43 44 46 47 49 50
Developer Funding
- - - - - - - - - - - - - 3 3 3 4 5 5 6 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 23 24 25 26 27 29 30 31 33 34 35 37 38 39 41 42 44 45 47 49 50 52 53 55
Total Interest Income
- - - - - - - 3 6 9 12 15 18 27 31 36 42 47 53 60 67 75 83 91 99 108 118 128 138 149 159 171 182 194 205 217 229 241 254 266 278 291 303 317 330 343 357 370 384 399 414 428 444 459 475 490 506 522 539 555






























































NPA Summary




























































NPA provisioning of total book - Cumulative 1% on all assets
except mortgage at 0.4%
- - - - - - 2.56 5.12 7.68 10.25 12.83 15.45 22.03 25.58 29.27 33.10 37.06 41.16 45.68 50.38 55.27 60.27 65.36 70.59 76.55 82.63 88.77 95.00 101.31 107.70 114.70 121.73 128.78 135.85 142.89 149.92 157.52 165.09 172.59 180.09 187.58 195.06 203.10 211.16 219.24 227.34 235.44 243.59 252.39 261.23 270.10 279.04 288.07 297.17 306.29 315.48 324.75 334.09 343.44 352.85
NPA provisioning for the month
- - - - - - 2.56 2.56 2.57 2.57 2.58 2.62 6.58 3.55 3.69 3.83 3.96 4.10 4.52 4.71 4.89 4.99 5.09 5.23 5.96 6.08 6.14 6.23 6.31 6.39 7.00 7.02 7.05 7.08 7.04 7.03 7.60 7.57 7.50 7.50 7.49 7.48 8.04 8.06 8.08 8.10 8.10 8.16 8.80 8.84 8.86 8.94 9.02 9.10 9.12 9.19 9.27 9.34 9.35 9.42
NPA w/off of Repayment - for the month 0.50% - - - - - - 0.00 0.03 0.06 0.09 0.11 0.14 0.18 0.25 0.29 0.34 0.39 0.43 0.49 0.54 0.60 0.66 0.72 0.79 0.86 0.93 1.01 1.09 1.17 1.25 1.33 1.42 1.52 1.61 1.70 1.80 1.89 1.99 2.10 2.20 2.30 2.41 2.52 2.63 2.75 2.86 2.98 3.10 3.23 3.36 3.49 3.63 3.76 3.90 4.05 4.19 4.34 4.49 4.64 4.80
NPA w/off of Repayment - Cumulative
- - - - - - 0.00 0.03 0.09 0.17 0.29 0.43 0.61 0.86 1.16 1.50 1.88 2.32 2.80 3.35 3.95 4.61 5.33 6.12 6.98 7.91 8.92 10.01 11.18 12.43 13.76 15.19 16.70 18.31 20.01 21.81 23.70 25.70 27.79 29.99 32.29 34.70 37.22 39.85 42.59 45.46 48.44 51.54 54.77 58.12 61.61 65.24 69.00 72.91 76.95 81.15 85.49 89.98 94.62 99.42


- - - - - - 2.56 5.09 7.59 10.08 12.54 15.02 21.42 24.72 28.11 31.60 35.18 38.84 42.87 47.04 51.33 55.66 60.02 64.47 69.57 74.72 79.85 84.99 90.13 95.28 100.94 106.54 112.07 117.54 122.88 128.11 133.82 139.40 144.80 150.10 155.29 160.36 165.88 171.31 176.65 181.88 187.00 192.05 197.63 203.11 208.48 213.80 219.06 224.26 229.33 234.34 239.26 244.11 248.81 253.43






























































Operating Expenses




























































Branches and Hubs




























































1 Branch Manager ₹ 1.50 Million 0.13 0.13 0.13 0.13 0.13 0.13 0.13 0.13 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.16 0.16 0.16 0.16 0.16 0.16 0.17 0.17 0.17 0.17 0.17 0.17 0.18 0.18 0.18 0.18 0.18 0.18 0.19 0.19 0.19 0.19 0.19 0.20 0.20 0.20 0.20 0.20 0.21 0.21 0.21 0.21 0.21 0.22 0.22 0.22 0.22 0.22
1 Recovery / Follow up ₹ 0.75 Million 0.06 0.06 0.06 0.06 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.08 0.08 0.08 0.08 0.08 0.08 0.08 0.08 0.08 0.08 0.08 0.08 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.11 0.11 0.11 0.11 0.11 0.11 0.11
1 Sr Sales Originator ₹ 1.50 Million 0.13 0.13 0.13 0.13 0.13 0.13 0.13 0.13 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.16 0.16 0.16 0.16 0.16 0.16 0.17 0.17 0.17 0.17 0.17 0.17 0.18 0.18 0.18 0.18 0.18 0.18 0.19 0.19 0.19 0.19 0.19 0.20 0.20 0.20 0.20 0.20 0.21 0.21 0.21 0.21 0.21 0.22 0.22 0.22 0.22 0.22
2 Jr Sales Originator ₹ 1.50 Million 0.13 0.13 0.13 0.13 0.13 0.13 0.13 0.13 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.15 0.15