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

 | Unit |  | D-25-0 |  |  |  |  |  |  |  | D-25-1
 | Total Price |  | 717839
 |  |  | 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 |  | 466595 | 126597.15 | 326000 | 13997.85 |  |  |  |  | 251244 | 67706.68 | 176000 | 7537.320000000001 |  |  |  |  |  |  |  | 0
 | *All Currency in MYR
 | CN for Discount | 0.03 | 13997.85 |  |  | 13997.85 | 126597.15 | -140595 | 452597.15 |  | 7537.32 |  |  | 7537.35 | 67706.68 | -75244.00000000003 | 243706.65 |  |  |  |  |  | #N/A | #N/A | 0 |  | 21535.17
 | Booking Fee | 0.07 | 9713 | 19500 |  |  | 116884.15 | -126597.15 | 433097.15 |  | 9713 | 10500 |  |  | 57993.67999999999 | -67706.68000000004 | 233206.65 |  |  |  |  |  | #N/A | #N/A | 0 |  | 19426
1 | Down Payment |  | 22948.65 | 13161.65 |  |  | 93935.50000000003 | -116884.15 | 419935.5 |  | 7874.080000000002 | 7087.08 |  | -0.03 | 50119.59999999999 | -57993.68000000004 | 226119.6 |  |  |  |  |  | #N/A | #N/A | 0 |  | 30822.73
2a | Earthworks | 0.1 | 46659.5 | 46659.5 |  |  | 47276.00000000003 | -93935.5 | 373276 |  | 25124.4 | 25124.4 |  |  | 24995.19999999999 | -50119.60000000003 | 200995.2 |  |  |  |  |  | #N/A | #N/A | 0 |  | 71783.9
2b | Piling | 0.1 | 46659.5 | 46659.5 |  |  | 616.5000000000291 | -47276 | 326616.5 |  | 25124.4 | 24995.19999999999 | 129.199999999968 |  | -129.2000000000116 | -24995.20000000003 | 175870.8 |  |  |  |  |  | #N/A | #N/A | 0 |  | 71783.9
2c | Sub Struc | 0.15 | 69989.25 | 616.5000000000291 | 69372.75 |  | -69372.74999999997 | -616.5 | 256627.25 |  | 37686.6 |  | 37686.6 |  | -37815.80000000001 | 129.199999999968 | 138184.2 |  |  |  |  |  | #N/A | #N/A | 0 |  | 107675.85
2d | Concrete | 0.15 | 69989.25 |  | 69989.25 |  | -139362 | 69372.75 | 186638 |  | 37686.6 |  | 37686.6 |  | -75502.40000000001 | 37815.79999999997 | 100497.6 |  |  |  |  |  | #N/A | #N/A | 0 |  | 107675.85
2e | Walls | 0.1 | 46659.5 |  | 46659.5 |  | -186021.5 | 139362 | 139978.5 |  | 25124.4 |  | 25124.4 |  | -100626.8 | 75502.39999999997 | 75373.20000000004 |  |  |  |  |  | #N/A | #N/A | 0 |  | 71783.9
2f | Ceiling | 0.05 | 23329.75 |  | 23329.75 |  | -209351.25 | 186021.5 | 116648.75 |  | 12562.2 |  | 12562.2 |  | -113189 | 100626.8 | 62811.00000000004 |  |  |  |  |  | #N/A | #N/A | 0 |  | 35891.95
2g | Wiring | 0.05 | 23329.75 |  | 23329.75 |  | -232681 | 209351.25 | 93318.99999999997 |  | 12562.2 |  | 12562.2 |  | -125751.2 | 113189 | 50248.80000000005 |  |  |  |  |  | #N/A | #N/A | 0 |  | 35891.95
2h | Plaster | 0.05 | 23329.75 |  | 23329.75 |  | -256010.75 | 232681 | 69989.24999999997 |  | 12562.2 |  | 12562.2 |  | -138313.4 | 125751.2 | 37686.60000000005 |  |  |  |  |  | #N/A | #N/A | 0 |  | 35891.95
2i | Roof | 0.05 | 23329.75 |  | 23329.75 |  | -279340.5 | 256010.75 | 46659.49999999997 |  | 12562.2 |  | 12562.2 |  | -150875.6 | 138313.4 | 25124.40000000005 |  |  |  |  |  | #N/A | #N/A | 0 |  | 35891.95
2j | Road | 0.05 | 23329.75 |  |  |  | -302670.25 | 279340.5 | 46659.49999999997 |  | 12562.2 |  |  |  | -163437.8 | 150875.6 | 25124.40000000005 |  |  |  |  |  | #N/A | #N/A | 0 |  | 35891.95
3 | CPC | 0.05 | 23329.75 |  |  |  | -326000 | 302670.25 | 46659.5 |  | 12562.2 |  |  |  | -176000.0000000001 | 163437.8 | 25124.4 |  |  |  |  |  | #N/A | #N/A | 0 |  | 35891.95
 | Total | 1 | 466595 | 126597.15 | 279340.5 | 13997.85 | 616.5000000000291 | 69372.75 | - |  | 251244.0000000001 | 67706.68 | 150875.6 | 7537.320000000001 | 24995.19999999999 | 129.199999999968 | - |  | 0 | 0 | 0 | 0 | #N/A | #N/A | - |  | 717838.9999999998
 |  | Expected | Actual | % | Outstanding (Act-Exp) |  |  |  |  |  | [NAME]
 | Total Cash Paid | 194303.83 | 194303.83 | 0.27 | 0 |  |  |  |  |  | Total Loan | 502000
 | Total Loan | 502000 | 430216.1 | 0.7 | -71783.90000000002 |  |  |  |  |  | GF | 326000
 | Total CN | 21535.17 | 21535.17 | 0.03 | 0 |  |  |  |  |  | FF | 176000
 | Differential Sum (Cash + CN) | 215839 | 215839 | 0.3 | 0 |  |  |  |  |  | SF | 0
 | Apportionment of Differential Sum
 | Floor | To Bank | Differential Sum | Stage | % | Variance (Act-Exp)
 | GF | 466595 | 69372.75 | 2c | 0.1486787256614409 | 0
 | FF | 251244 | 129.199999999968 | 2b | 0.0005142411361066055 | 0
 | SF |  | 0 |  |  | 0
 | Total | 717839 | 69501.94999999997 |  |  | 0
 | Floor | To Customer | Final Amount (Exp) | Stage | % | Variance (Act-Exp)
 | GF | 466595 | 616.5000000000291 | 2c | 0.001321274338559198 | 0
 | FF | 251244 | 24995.19999999999 | 2b | 0.09948575886389323 | 0
 | SF |  | 0
 | Total | 717839 | 25611.70000000002 |  |  | 0