Accounting question
in [General]
|
From: Russell Dawson on 12 May 2010 13:34 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.
From: Russell Dawson on 12 May 2010 15:40 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.
From: Gord Dibben on 12 May 2010 15:54 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 <russell.dawson(a)discussions.microsoft.com> 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.
From: Russell Dawson on 13 May 2010 13:08 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 > <russell.dawson(a)discussions.microsoft.com> 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. > > . >
|
Pages: 1 Prev: Auto Page Numbering Question Next: Macro-total a column with different row sizes |