Spreadsheet: 116442d1311842608-excel-2007-lookup-if-then-multiple-rows-duplicate-data-l-and-d-account-template
Sheet: Liquid&dist (2)

INDEX |  |  |  |  |  |  |  |  |  | Asset converted to cash number them 1 - 2 etc
 | LIQUIDATION AND DISTRIBUTION ACCOUNT 5(1)(c) |  |  |  |  |  |  | Assets/(Liability) | Cumulative
IP | Immovable Property |  |  |  | ASSETS
IP1
IP2 |  |  |  |  |  |  |  |  |  | 1
MP | Moveable Property
MP1 |  |  |  |  |  |  |  |  |  | 2
MP2 |  |  |  |  |  |  |  |  |  | 3
C | Claims in Favour of the Estate
c1
c2
 | Total property
L |  |  |  |  | LIABILITIES
L1
 | TOTAL LIABILITIES
 |  |  |  | CASH RECAPITULATION STATEMENT 5(1)(d) |  |  |  | Liabilities | Assets
 |  |  |  |  |  |  |  |  | 0
 | Liabilities of the estate
 | Cash shortfall in the Estate
 |  |  |  | INCOME AND EXPENDATURE ACCOUNT 5(1)(f)
 | No income was collected
 | All expenses as above in cash recapitulation statement were paid for by [NAME]
 |  |  |  | [NAME] ACCOUNT 5(1)(e)
A1 | Erf 3073 Parow 50% ditributed in terms of clause 2 of the will to Mrs E .M [NAME],spouse (Heir) Major. |  |  |  |  |  |  |  | 370000
A2 | [NAME] - distributed in terms of clause 2 of the will to [NAME], spouse (Heir) Major. |  |  |  |  |  |  |  | 50000
A3 | HOUSEHOLD EFFECTS - distributed in terms of clause 2 of the will to Mrs E .M Finney, Spouse(Heir) Major. |  |  |  |  |  |  |  | 75000
A4 | BROWNING HIGH POWER PISTOL SERIAL# T184268 - distributed in terms of clause 2 of the will to Mrs E .M [NAME], spouse (Heir) Major. |  |  |  |  |  |  |  | 1000
A5 | WINCHESTER SHOTGUN SERIAL# 1956071 - distributed in terms of clause 2 of the will to Mrs E .M [NAME],spouse (Heir) Major. |  |  |  |  |  |  |  | 1000
A6 | COLT 38 SERIAL# 9153300 - distributed in terms of clause 2 of the will to Mrs E .M [NAME],spouse (Heir) Major. |  |  |  |  |  |  |  | 1000
A7 | SMITH & WESSON SERIAL# 6D21389 - distributed in terms of clause 2 of the will to Mrs E .M [NAME],spouse (Heir) Major. |  |  |  |  |  |  |  | 1000
 | The firearms , A4, A5,A6 and A7 are not wanted by the spouse, [NAME] in terms of clause 2 of the will and she has donated
 | the firearms A4, A5,A6 and A7 to her son as stated in the letter from said spouse dated 24 February 2010.
 | The license's for the firearms has been applied for by [NAME] as you are aware the CFR is behind.
 |  |  |  | FIDUCIARY ASSETS 5(1)(g)
 | None
 |  |  |  | ESTATE DUTY ACCOUNT 5(1)(h)
 | Value of assets as per the distribution account
 | No deemed property |  |  |  |  |  |  |  | 0
 | Less Liabilities
 | Value of assets as per the distribution account |  |  |  |  |  | Gross dutiable estate
 | Deductions in terms of section 4 of the act |  |  |  | 4Q
 |  |  |  |  | 4A |  |  |  | 3500000
 |  |  |  |  |  |  | Dutiable Amount
 |  |  |  |  |  |  | Estate duty @ 20% |  | 0
 |  |  |  |  | [NAME] CERTIFICATE
 | Final
 | I, the undersigned,
 | [NAME], [NAME]
 | executor testamentary in the estate of the late [NAME], herby declare that the aforesaid is to the best of my knowledge and
 | ability, a true and proper account of the liquidation and distribution of the estate, and I further declare that to the best of my knowledge
 | and ability, all assets and income which were collected subsequent to the date of death have been disclosed herein.
 | Signed at Cape Town this 25th of July 2011
 | Executors Testamentary