Islamic Banking Calculation - Excel by tpr19804

VIEWS: 0 PAGES: 5

More Info
									                        THE BANK OF KHYBER
                      ISLAMIC BANKING GROUP
                   E-Mail : ibd@bok.com.pk Web site: www.bok.com.pk
                          DIMINISHING MUSHARIKA
                  Calculation of Rentals & Shares Purchased

Date                                                   12 April 2011
Customer Name                                             Name
Account Number                                                0

Price of the House                                                     2,000,000
 Shares of Customer (Not less than 20%)                       0%             -
Share of BOK                                                100%       2,000,000
Initial Year IRR                                                             14%
Increase in IRR after First Year                                               5%
Period (Years )                                                                 15
No. of Monthly Installments/Payments                                          180
Rentals Payable                                                        2,589,417
Total Payable                                                          4,589,417
Expected Average Monthly Payments                                         25,497
Fist months payment                                                       34,444
Note
Above schedules are Tentative in nature and actual amount will depend upon shares
purchased by the customer.
                      THE BANK OF KHYBER
                    ISLAMIC BANKING GROUP
       Expected / Projected Diminishing Musharaka Schedule

Date                                        12 April 2011
Customer Name                                  Name
Price of House                                                    (2,000,000)

          Total Monthly                             Share      Total Payment
                              Share in Rent     Purchased by
Month         Rent        Client      BOK          Client
   1           23,333            -       23,333      11,111           34,444
   2           23,333            130     23,204      11,111           34,315
   3           23,333            259     23,074      11,111           34,185
   4           23,333            389     22,944      11,111           34,056
   5           23,333            519     22,815      11,111           33,926
   6           23,333            648     22,685      11,111           33,796
   7           23,333            778     22,556      11,111           33,667
   8           23,333            907     22,426      11,111           33,537
   9           23,333          1,037     22,296      11,111           33,407
  10           23,333          1,167     22,167      11,111           33,278
  11           23,333          1,296     22,037      11,111           33,148
  12           23,333          1,426     21,907      11,111           33,019
  13           24,500          1,633     22,867      11,111           33,978
  14           24,500          1,769     22,731      11,111           33,842
  15           24,500          1,906     22,594      11,111           33,706
  16           24,500          2,042     22,458      11,111           33,569
  17           24,500          2,178     22,322      11,111           33,433
  18           24,500          2,314     22,186      11,111           33,297
  19           24,500          2,450     22,050      11,111           33,161
  20           24,500          2,586     21,914      11,111           33,025
  21           24,500          2,722     21,778      11,111           32,889
  22           24,500          2,858     21,642      11,111           32,753
  23           24,500          2,994     21,506      11,111           32,617
  24           24,500          3,131     21,369      11,111           32,481
  25           25,667          3,422     22,244      11,111           33,356
  26           25,667          3,565     22,102      11,111           33,213
  27           25,667          3,707     21,959      11,111           33,070
  28           25,667          3,850     21,817      11,111           32,928
  29           25,667          3,993     21,674      11,111           32,785
  30           25,667          4,135     21,531      11,111           32,643
  31           25,667          4,278     21,389      11,111           32,500
  32           25,667          4,420     21,246      11,111           32,357
  33           25,667          4,563     21,104      11,111           32,215
  34           25,667          4,706     20,961      11,111           32,072
  35           25,667          4,848     20,819      11,111           31,930
  36           25,667          4,991     20,676      11,111           31,787
  37           26,833          5,367     21,467      11,111           32,578
  38           26,833          5,516     21,318      11,111           32,429
  39           26,833          5,665     21,169      11,111           32,280
  40           26,833          5,814     21,019      11,111           32,131
  41           26,833          5,963     20,870      11,111           31,981
42   26,833    6,112   20,721   11,111   31,832
43   26,833    6,261   20,572   11,111   31,683
44   26,833    6,410   20,423   11,111   31,534
45   26,833    6,559   20,274   11,111   31,385
46   26,833    6,708   20,125   11,111   31,236
47   26,833    6,857   19,976   11,111   31,087
48   26,833    7,006   19,827   11,111   30,938
49   28,000    7,467   20,533   11,111   31,644
50   28,000    7,622   20,378   11,111   31,489
51   28,000    7,778   20,222   11,111   31,333
52   28,000    7,933   20,067   11,111   31,178
53   28,000    8,089   19,911   11,111   31,022
54   28,000    8,244   19,756   11,111   30,867
55   28,000    8,400   19,600   11,111   30,711
56   28,000    8,556   19,444   11,111   30,556
57   28,000    8,711   19,289   11,111   30,400
58   28,000    8,867   19,133   11,111   30,244
59   28,000    9,022   18,978   11,111   30,089
60   28,000    9,178   18,822   11,111   29,933
61   29,167    9,722   19,444   11,111   30,556
62   29,167    9,884   19,282   11,111   30,394
63   29,167   10,046   19,120   11,111   30,231
64   29,167   10,208   18,958   11,111   30,069
65   29,167   10,370   18,796   11,111   29,907
66   29,167   10,532   18,634   11,111   29,745
67   29,167   10,694   18,472   11,111   29,583
68   29,167   10,856   18,310   11,111   29,421
69   29,167   11,019   18,148   11,111   29,259
70   29,167   11,181   17,986   11,111   29,097
71   29,167   11,343   17,824   11,111   28,935
72   29,167   11,505   17,662   11,111   28,773
73   30,333   12,133   18,200   11,111   29,311
74   30,333   12,302   18,031   11,111   29,143
75   30,333   12,470   17,863   11,111   28,974
76   30,333   12,639   17,694   11,111   28,806
77   30,333   12,807   17,526   11,111   28,637
78   30,333   12,976   17,357   11,111   28,469
79   30,333   13,144   17,189   11,111   28,300
80   30,333   13,313   17,020   11,111   28,131
81   30,333   13,481   16,852   11,111   27,963
82   30,333   13,650   16,683   11,111   27,794
83   30,333   13,819   16,515   11,111   27,626
84   30,333   13,987   16,346   11,111   27,457
85   31,500   14,700   16,800   11,111   27,911
86   31,500   14,875   16,625   11,111   27,736
87   31,500   15,050   16,450   11,111   27,561
88   31,500   15,225   16,275   11,111   27,386
89   31,500   15,400   16,100   11,111   27,211
90   31,500   15,575   15,925   11,111   27,036
91   31,500   15,750   15,750   11,111   26,861
92   31,500   15,925   15,575   11,111   26,686
93   31,500   16,100   15,400   11,111   26,511
 94   31,500   16,275   15,225   11,111   26,336
 95   31,500   16,450   15,050   11,111   26,161
 96   31,500   16,625   14,875   11,111   25,986
 97   32,667   17,422   15,244   11,111   26,356
 98   32,667   17,604   15,063   11,111   26,174
 99   32,667   17,785   14,881   11,111   25,993
100   32,667   17,967   14,700   11,111   25,811
101   32,667   18,148   14,519   11,111   25,630
102   32,667   18,330   14,337   11,111   25,448
103   32,667   18,511   14,156   11,111   25,267
104   32,667   18,693   13,974   11,111   25,085
105   32,667   18,874   13,793   11,111   24,904
106   32,667   19,056   13,611   11,111   24,722
107   32,667   19,237   13,430   11,111   24,541
108   32,667   19,419   13,248   11,111   24,359
109   33,833   20,300   13,533   11,111   24,644
110   33,833   20,488   13,345   11,111   24,456
111   33,833   20,676   13,157   11,111   24,269
112   33,833   20,864   12,969   11,111   24,081
113   33,833   21,052   12,781   11,111   23,893
114   33,833   21,240   12,594   11,111   23,705
115   33,833   21,428   12,406   11,111   23,517
116   33,833   21,616   12,218   11,111   23,329
117   33,833   21,804   12,030   11,111   23,141
118   33,833   21,992   11,842   11,111   22,953
119   33,833   22,180   11,654   11,111   22,765
120   33,833   22,368   11,466   11,111   22,577
121   35,000   23,333   11,667   11,111   22,778
122   35,000   23,528   11,472   11,111   22,583
123   35,000   23,722   11,278   11,111   22,389
124   35,000   23,917   11,083   11,111   22,194
125   35,000   24,111   10,889   11,111   22,000
126   35,000   24,306   10,694   11,111   21,806
127   35,000   24,500   10,500   11,111   21,611
128   35,000   24,694   10,306   11,111   21,417
129   35,000   24,889   10,111   11,111   21,222
130   35,000   25,083    9,917   11,111   21,028
131   35,000   25,278    9,722   11,111   20,833
132   35,000   25,472    9,528   11,111   20,639
133   36,167   26,522    9,644   11,111   20,756
134   36,167   26,723    9,444   11,111   20,555
135   36,167   26,924    9,243   11,111   20,354
136   36,167   27,125    9,042   11,111   20,153
137   36,167   27,326    8,841   11,111   19,952
138   36,167   27,527    8,640   11,111   19,751
139   36,167   27,728    8,439   11,111   19,550
140   36,167   27,929    8,238   11,111   19,349
141   36,167   28,130    8,037   11,111   19,148
142   36,167   28,331    7,836   11,111   18,947
143   36,167   28,531    7,635   11,111   18,746
144   36,167   28,732    7,434   11,111   18,545
145   37,333   29,867    7,467   11,111   18,578
   146           37,333          30,074           7,259          11,111             18,370
   147           37,333          30,281           7,052          11,111             18,163
   148           37,333          30,489           6,844          11,111             17,956
   149           37,333          30,696           6,637          11,111             17,748
   150           37,333          30,904           6,430          11,111             17,541
   151           37,333          31,111           6,222          11,111             17,333
   152           37,333          31,319           6,015          11,111             17,126
   153           37,333          31,526           5,807          11,111             16,919
   154           37,333          31,733           5,600          11,111             16,711
   155           37,333          31,941           5,393          11,111             16,504
   156           37,333          32,148           5,185          11,111             16,296
   157           38,500          33,367           5,133          11,111             16,244
   158           38,500          33,581           4,919          11,111             16,031
   159           38,500          33,794           4,706          11,111             15,817
   160           38,500          34,008           4,492          11,111             15,603
   161           38,500          34,222           4,278          11,111             15,389
   162           38,500          34,436           4,064          11,111             15,175
   163           38,500          34,650           3,850          11,111             14,961
   164           38,500          34,864           3,636          11,111             14,747
   165           38,500          35,078           3,422          11,111             14,533
   166           38,500          35,292           3,208          11,111             14,319
   167           38,500          35,506           2,994          11,111             14,106
   168           38,500          35,719           2,781          11,111             13,892
   169           39,667          37,022           2,644          11,111             13,756
   170           39,667          37,243           2,424          11,111             13,535
   171           39,667          37,463           2,204          11,111             13,315
   172           39,667          37,683           1,983          11,111             13,094
   173           39,667          37,904           1,763          11,111             12,874
   174           39,667          38,124           1,543          11,111             12,654
   175           39,667          38,344           1,322          11,111             12,433
   176           39,667          38,565           1,102          11,111             12,213
   177           39,667          38,785             881          11,111             11,993
   178           39,667          39,006             661          11,111             11,772
   179           39,667          39,226             441          11,111             11,552
   180           39,667          39,446             220          11,111             11,331
                                                                                 4,589,417

It is tentative schedule for reference purpose only. Actual schedule may vary at the time of
actual transactions.
The customer has to apply for the facility as per laid down procedure.
The facility is extended as per banks policy and SBP Prudential regulations.
The bank reserve the right to refuse any customer to extend the facility without assigning any
reason.
It is a computer generated schedule and does not require signature.

								
To top