If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Accounting question
This is not an Excel question but I know there are experts here who I know
will provide an answer. There is an estate of a deceased person to distribute. Net value is £112k which includes the value of a car (£2500) Two persons are the beneficiaries. Person A - has sold the car for £2500 and has had £3000 as an interim payment There is £106500 in the bank to distribute. How much does A and B get in cash so that each has had an equal share of the total estate? It should be simple but whatever I do it just doesn't match the figures I've been given. I'm sure that the adjustment for the car is the problem but the longer I look at it now the more confused I'm getting. -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. |
#2
|
|||
|
|||
Accounting question
Done it.
The solicitor was deducting the value of the car and then adding in half it's value before apportionment rather than apportionment after adding the car value. -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Russell Dawson" wrote: This is not an Excel question but I know there are experts here who I know will provide an answer. There is an estate of a deceased person to distribute. Net value is £112k which includes the value of a car (£2500) Two persons are the beneficiaries. Person A - has sold the car for £2500 and has had £3000 as an interim payment There is £106500 in the bank to distribute. How much does A and B get in cash so that each has had an equal share of the total estate? It should be simple but whatever I do it just doesn't match the figures I've been given. I'm sure that the adjustment for the car is the problem but the longer I look at it now the more confused I'm getting. -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. |
#3
|
|||
|
|||
Accounting question
Divide 112000 by two.
Person B gets half or 56000 Person A gets 56k less the 5500 or 50500 56000 + 50500 = 106500 Gord Dibben MS Excel MVP On Wed, 12 May 2010 10:34:01 -0700, Russell Dawson wrote: This is not an Excel question but I know there are experts here who I know will provide an answer. There is an estate of a deceased person to distribute. Net value is £112k which includes the value of a car (£2500) Two persons are the beneficiaries. Person A - has sold the car for £2500 and has had £3000 as an interim payment There is £106500 in the bank to distribute. How much does A and B get in cash so that each has had an equal share of the total estate? It should be simple but whatever I do it just doesn't match the figures I've been given. I'm sure that the adjustment for the car is the problem but the longer I look at it now the more confused I'm getting. |
#4
|
|||
|
|||
Accounting question
Thanks Gord,
As you have seen I did get it eventually. It good to have the figures confirmed though. Regards -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Gord Dibben" wrote: Divide 112000 by two. Person B gets half or 56000 Person A gets 56k less the 5500 or 50500 56000 + 50500 = 106500 Gord Dibben MS Excel MVP On Wed, 12 May 2010 10:34:01 -0700, Russell Dawson wrote: This is not an Excel question but I know there are experts here who I know will provide an answer. There is an estate of a deceased person to distribute. Net value is £112k which includes the value of a car (£2500) Two persons are the beneficiaries. Person A - has sold the car for £2500 and has had £3000 as an interim payment There is £106500 in the bank to distribute. How much does A and B get in cash so that each has had an equal share of the total estate? It should be simple but whatever I do it just doesn't match the figures I've been given. I'm sure that the adjustment for the car is the problem but the longer I look at it now the more confused I'm getting. . |
Thread Tools | |
Display Modes | |
|
|