1、Staff Allocation # of total staff6,664 # of retail staff1,481 % of total%22% Yr1999 Cost Analysis Total SG&ARMB1,542,916,547 Operating expenseRMB1,060,101,949 Personnel expenseRMB482,814,598 - Bad Debt LossRMB308,583,309 SubtotalRMB1,234,333,238 Retail SG&ARMB274,316,855 Per retail staffRMB185,224 C
2、ost Forecast Retail Servicing Cost Per productRMB193 # of products per customer1.2 # of servicing customers per staff*800 Annual servicing time per customerPerson day0.3 * Benchmark: Korean bank 850, HK bank 655, Consumer Loan Origination Cost # of consumer loan orgination per people109 Total # of p
3、eople involved - BJ branch5.5 Total # of consumer loan originations - BJ branch600 Origination cost per loanRMB1,698 Auto loan origination cost per loanRMB1,698 As % of Auto Loan Balance%2.0% Average auto loan balanceRMB86,000 Mortgage Origination Cost # of mortgage orgination per people64 Total # o
4、f people involved - BJ branch7.5 Total # of consumer loan originations - BJ branch480 Origination cost per loanRMB2,8941.70 Mortgage origination cost per loanRMB2,894.13 As % of Mortgage Balance%0.4% Average mortgage balanceRMB460,000 Year12345678910 Discount Rate%12% 1.00.880.770.680.600.530.460.41
5、0.360.32 Mortgage Gross Margin%2.30%2.30%2.30%2.30%2.30%2.30%2.30%2.30%2.30%2.30% Net Loss Rate%0.80%0.80%0.80%0.80%0.80%0.80%0.80%0.80%0.80%0.80% Net Margin%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50% Average Mortgage BalanceRMB95,00076,00057,00038,00019,000 Revenue MarginRMB1,4251,140855570
6、285 Operating ExpenseRMB2,894193193193193 % of balance%3.05%0.25%0.34%0.51%1.02% Net ProfitRMB-1,46994766237792 Discounted net profitRMB-1,46983351325755 NPVRMB189 % of balance%0.2% Auto Loan Gross Margin%2.70%2.70%2.70% Net Loss Rate%1.00%1.00%1.00% Net Margin%1.70%1.70%1.70% Average Auto Loan Bala
7、nceRMB65,00043,33321,667 Revenue MarginRMB1,105737368 Operating ExpenseRMB1,698193193 % of balance%2.61%0.45%0.89% Net ProfitRMB-593544175 Discounted net profitRMB-593478136 NPVRMB21 % of balance%0.0% Deposit Gross Margin*%1.40%1.40%1.40%1.40%1.40% Net Loss Rate%0.00%0.00%0.00%0.00%0.00% Net Margin%
8、1.40%1.40%1.40%1.40%1.40% * Weighted average margin of RMB and F/X Package 1 customers Average Deposit BalanceRMB5,0005,0005,0005,0005,000 Revenue MarginRMB7070707070 Operating ExpenseRMB193193193193193 % of balance%3.86%3.86%3.86%3.86%3.86% Net ProfitRMB-123-123-123-123-123 Discounted net profitRMB
9、-123-108-95-84-74 NPVRMB-484 % of balance%-9.7% Package 2 customers Average Deposit BalanceRMB30,00030,00030,00030,00030,000 Revenue MarginRMB420420420420420 Operating ExpenseRMB193193193193193 % of balance%0.64%0.64%0.64%0.64%0.64% Net ProfitRMB227227227227227 Discounted net profitRMB22720017615513
10、6 NPVRMB894 % of balance%3.0% Package 3 customers Average Deposit BalanceRMB140,000140,000140,000140,000140,000 Revenue MarginRMB1,9601,9601,9601,9601,960 Operating ExpenseRMB193193193193193 % of balance%0.14%0.14%0.14%0.14%0.14% Net ProfitRMB1,7671,7671,7671,7671,767 Discounted net profitRMB1,7671,5551,3681,2041,060 NPVRMB6,954 % of balance%5.0%
