Spreadsheet: 354064d1414133758-seek-for-suggestions-on-how-to-display-the-data-for-easy-reference-customer-database-excel-forum
Sheet: I64

 | Unit |  | I-64-0 |  |  |  |  |  |  |  | I-64-1
 | Total Price |  | 762700
 |  |  | Ground Floor | Cash | Loan | CN/DN | [NAME] | [NAME] | Balance |  | Ground Floor | Cash | Loan | CN/DN | [NAME] | [NAME] | Balance |  | Ground Floor | Cash | Loan | CN/DN | [NAME] | [NAME] | Balance |  | Total
 | Original Price / Loan Amount |  | 495755 | 0 | 421200 | 74555.00000000001 |  |  |  |  | 266945 | 0 | 226800 | 40145 |  |  |  |  |  |  | 0 | 0
 | *All Currency in MYR
 | CN for Discount | 0 | 76269.99999999999 |  |  |  | 0 | -150825 | 495755 |  | 41068.46153846152 |  |  |  | 0 | -81213.46153846153 | 266945 |  |  |  |  |  | #N/A | #N/A | 0 |  | 117338.4615384615
 | Booking Fee | 0.1 | 6500 |  |  | 6500 | -6500 | -74555 | 489255 |  | 3500 |  |  | 3500 | -3500 | -40145 | 263445 |  |  |  |  |  | #N/A | #N/A | #N/A |  | 10000
1 | Down Payment |  | 43075.5 |  |  | 43075.5 | -49575.5 | -68055 | 446179.5 |  | 23194.5 |  |  | 23194.5 | -26694.5 | -36645 | 240250.5 |  |  |  |  |  | #N/A | #N/A | #N/A |  | 66270
2a | Earthworks | 0.1 | 49575.5 |  | 24596 | 24979.50000000001 | -99151 | -24979.5 | 396604 |  | 26694.5 |  | 13244 | 13450.5 | -53389 | -13450.5 | 213556 |  |  |  | 0 | 0 | #N/A | #N/A | #N/A |  | 76270
2b | Piling | 0.1 | 49575.5 |  | 49575.5 |  | -148726.5 | 24596 | 347028.5 |  | 26694.5 |  | 26694.5 |  | -80083.5 | 13244 | 186861.5 |  |  |  |  |  | #N/A | #N/A | #N/A |  | 76270
2c | Sub Struc | 0.15 | 74363.25 |  | 74363.25 |  | -223089.75 | 74171.5 | 272665.25 |  | 40041.75 |  | 40041.75 |  | -120125.25 | 39938.5 | 146819.75 |  |  |  |  |  | #N/A | #N/A | #N/A |  | 114405
2d | Concrete | 0.15 | 74363.25 |  | 74363.25 |  | -297453 | 148534.75 | 198302 |  | 40041.75 |  | 40041.75 |  | -160167 | 79980.25 | 106778 |  |  |  |  |  | #N/A | #N/A | #N/A |  | 114405
2e | Walls | 0.1 | 49575.5 |  | 49575.5 |  | -347028.5 | 222898 | 148726.5 |  | 26694.5 |  | 26694.5 |  | -186861.5 | 120022 | 80083.5 |  |  |  |  |  | #N/A | #N/A | #N/A |  | 76270
2f | Ceiling | 0.05 | 24787.75 |  | 24787.75 |  | -371816.25 | 272473.5 | 123938.75 |  | 13347.25 |  | 13347.25 |  | -200208.75 | 146716.5 | 66736.25 |  |  |  |  |  | #N/A | #N/A | #N/A |  | 38135
2g | Wiring | 0.05 | 24787.75 |  | 24787.75 |  | -396604 | 297261.25 | 99151 |  | 13347.25 |  | 13347.25 |  | -213556 | 160063.75 | 53389 |  |  |  |  |  | #N/A | #N/A | #N/A |  | 38135
2h | Plaster | 0.05 | 24787.75 |  | 24787.75 |  | -421391.75 | 322049 | 74363.25 |  | 13347.25 |  | 13347.25 |  | -226903.25 | 173411 | 40041.75 |  |  |  |  |  | #N/A | #N/A | #N/A |  | 38135
2i | Roof | 0.05 | 24787.75 |  | 24787.75 |  | -446179.5 | 346836.75 | 49575.5 |  | 13347.25 |  | 13347.25 |  | -240250.5 | 186758.25 | 26694.5 |  |  |  |  |  | #N/A | #N/A | #N/A |  | 38135
2j | Road | 0.05 | 24787.75 |  | 24787.75 |  | -470967.25 | 371624.5 | 24787.75 |  | 13347.25 |  | 13347.25 |  | -253597.75 | 200105.5 | 13347.25 |  |  |  |  |  | #N/A | #N/A | #N/A |  | 38135
3 | CPC | 0.05 | 24787.75 |  | 24787.75 |  | -495755 | 396412.25 | 0 |  | 13347.25 |  | 13347.25 |  | -266945 | 213452.75 | 0 |  |  |  |  |  | #N/A | #N/A | #N/A |  | 38135
 | Total | 1 | 572025 | 0 | 421200 | 74555.00000000001 | #N/A | 24596 | - |  | 308013.4615384615 | 0 | 226800 | 40145 | #N/A | 13244 | - |  | 0 | 0 | 0 | 0 | #N/A | #N/A | - |  | 880038.4615384615
 |  | Expected | Actual | % | Outstanding (Act-Exp) |  |  |  |  |  | [NAME]
 | Total Cash Paid | 0 | 0 | 0 | 0 |  |  |  |  |  | Total Loan | 648000
 | Total Loan | 648000 | 648000 | 0.85 | 0 |  |  |  |  |  | GF | 421200
 | Total CN | 114700 | 114700 | 0.15 | 0 |  |  |  |  |  | FF | 226800
 | Differential Sum (Cash + CN) | 114700 | 114700 | 0.15 | 0 |  |  |  |  |  | SF | 0
 | Apportionment of Differential Sum |  |  |  |  |  |  |  |  |  |  | Total CN + Cash | Deduct Return
 | Floor | To Bank | Differential Sum | Stage | % | Variance (Act-Exp) |  |  |  |  | 648000
 | GF | 495755 | 24596 | 2a | 0.04961321620558542 | 0 |  |  |  |  | 117338.4615384615 | 127338.4615384615 | 114700
 | FF | 266945 | 13244 | 2a | 0.04961321620558542 | 0 |  |  |  |  | 10000
 | SF |  | 0 |  |  | 0 |  |  |  |  | 775338.4615384615
 | Total | 762700 | 37840 |  |  | 0 |  |  |  |  | 12638.4615384615
 |  |  |  |  |  |  |  |  |  |  |  | 82769.99999999999 | 8214.999999999976 | 74555.00000000001
 |  |  |  |  |  |  |  |  |  |  |  | 44568.46153846152 | 4423.461538461525 | 40145
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Refund