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

 | Unit |  | K-75-0 |  |  |  |  |  |  |  | K-75-1
 | Total Price |  | 739086
 |  |  | 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 |  | 480406 | 48040.09000000003 | 408345 | 24020.91 |  |  |  |  | 258680 | 25867.81 | 219878 | 12934.19 |  |  |  |  |  |  |  | 0
 | *All Currency in MYR
 | CN for Discount | 0.05 | 24020.75500009471 |  |  | 24020.76 | 48040.09000000003 | -72060.99999999994 | 456385.24 |  | 12934.24499990529 |  |  | 12934.24 | 25867.81 | -38802 | 245745.76 |  |  |  |  |  | #N/A | #N/A | 0 |  | 36955
 | Booking Fee | 0.05 | 6500 | 6500 |  |  | 41540.09000000003 | -48040.24499990523 | 449885.24 |  | 3500 | 3500 |  |  | 22367.81 | -25867.75500009471 | 242245.76 |  |  |  |  |  | #N/A | #N/A | 0 |  | 10000
1 | Down Payment |  | 17519.8449999053 | 17519.8449999053 |  |  | 24020.24500009473 | -41540.24499990523 | 432365.3950000947 |  | 9433.755000094712 | 9433.855000094703 |  | -0.1 | 12934.05499990529 | -22367.75500009471 | 232812.0049999053 |  |  |  |  |  | #N/A | #N/A | 0 |  | 26953.60000000001
2a | Earthworks | 0.1 | 48040.60000000001 | 24020.25 | 24020.2 | 0.15 | -24020.35499990528 | -24020.39999999994 | 384324.7950000947 |  | 25868 | 12933.95 | 12934 | 0.05 | -12933.94500009471 | -12934 | 206944.0049999053 |  |  |  |  |  | #N/A | #N/A | 0 |  | 73908.6
2b | Piling | 0.1 | 48040.60000000001 |  | 48040.6 |  | -72060.95499990528 | 24020.20000000007 | 336284.1950000947 |  | 25868 |  | 25868 |  | -38801.94500009471 | 12934 | 181076.0049999053 |  |  |  |  |  | #N/A | #N/A | 0 |  | 73908.6
2c | Sub Struc | 0.15 | 72060.9 |  | 72060.9 |  | -144121.8549999053 | 72060.80000000008 | 264223.2950000947 |  | 38802 |  | 38802 |  | -77603.94500009471 | 38802 | 142274.0049999053 |  |  |  |  |  | #N/A | #N/A | 0 |  | 110862.9
2d | Concrete | 0.15 | 72060.9 |  |  |  | -216182.7549999053 | 144121.7000000001 | 264223.2950000947 |  | 38802 |  |  |  | -116405.9450000947 | 77604 | 142274.0049999053 |  |  |  |  |  | #N/A | #N/A | 0 |  | 110862.9
2e | Walls | 0.1 | 48040.60000000001 |  |  |  | -264223.3549999053 | 216182.6000000001 | 264223.2950000947 |  | 25868 |  |  |  | -142273.9450000947 | 116406 | 142274.0049999053 |  |  |  |  |  | #N/A | #N/A | 0 |  | 73908.6
2f | Ceiling | 0.05 | 24020.3 |  | 24020.3 |  | -288243.6549999053 | 264223.2000000001 | 240202.9950000947 |  | 12934 |  | 12934 |  | -155207.9450000947 | 142274 | 129340.0049999053 |  |  |  |  |  | #N/A | #N/A | 0 |  | 36954.3
2g | Wiring | 0.05 | 24020.3 |  | 24020.3 |  | -312263.9549999053 | 288243.5000000001 | 216182.6950000947 |  | 12934 |  | 12934 |  | -168141.9450000947 | 155208 | 116406.0049999053 |  |  |  |  |  | #N/A | #N/A | 0 |  | 36954.3
2h | Plaster | 0.05 | 24020.3 |  |  |  | -336284.2549999052 | 312263.8 | 216182.6950000947 |  | 12934 |  |  |  | -181075.9450000947 | 168142 | 116406.0049999053 |  |  |  |  |  | #N/A | #N/A | 0 |  | 36954.3
2i | Roof | 0.05 | 24020.3 |  | 24020.3 |  | -360304.5549999052 | 336284.1 | 192162.3950000947 |  | 12934 |  | 12934 |  | -194009.9450000947 | 181076 | 103472.0049999053 |  |  |  |  |  | #N/A | #N/A | 0 |  | 36954.3
2j | Road | 0.05 | 24020.3 |  |  |  | -384324.8549999052 | 360304.4 | 192162.3950000947 |  | 12934 |  |  |  | -206943.9450000947 | 194010 | 103472.0049999053 |  |  |  |  |  | #N/A | #N/A | 0 |  | 36954.3
3 | CPC | 0.05 | 24020.3 |  |  |  | -408345.1549999052 | 384324.7 | 192162.4 |  | 12934 |  |  |  | -219877.9450000947 | 206944 | 103472 |  |  |  |  |  | #N/A | #N/A | 0 |  | 36954.3
 | Total | 1 | 480405.9999999999 | 48040.0949999053 | 216182.6 | 24020.91 | 24020.24500009473 | 24020.20000000007 | - |  | 258680 | 25867.8050000947 | 116406 | 12934.19 | 12934.05499990529 | 12934 | - |  | 0 | 0 | 0 | 0 | #N/A | #N/A | - |  | 739086.0000000002
 |  | Expected | Actual | % | Outstanding (Act-Exp) |  |  |  |  |  | [NAME]
 | Total Cash Paid | 73907.9 | 73907.9 | 0.1 | 0 |  |  |  |  |  | Total Loan | 628223
 | Total Loan | 628223 | 332588.6 | 0.85 | -295634.4 |  |  |  |  |  | GF | 408345
 | Total CN | 36955.1 | 36955.1 | 0.05 | 0 |  |  |  |  |  | FF | 219878
 | Differential Sum (Cash + CN) | 110863 | 110863 | 0.15 | 0 |  |  |  |  |  | SF | 0
 | Apportionment of Differential Sum
 | Floor | To Bank | Differential Sum | Stage | % | Variance (Act-Exp) |  |  | CN
 | GF | 480406 | 24020.20000000007 | 2a | 0.04999979184273317 | 0
 | FF | 258680 | 12934 | 2a | 0.05 | 0
 | SF |  | 0 |  |  | 0
 | Total | 739086 | 36954.20000000007 |  |  | 0
 | Floor | To Customer | Final Amount (Exp) | Stage | % | Variance (Act-Exp) |  |  | CN
 | GF | 480406 | 24020.24500009473 | 2a | 0.04999988551370035 | 0
 | FF | 258680 | 12934.05499990529 | 2a | 0.05000021261754015 | 0.1
 | SF |  | 0
 | Total | 739086 | 36954.30000000002 |  |  | 0.1