I would like some help to create a spreadsheet that would calculate an equal share of the inheritance our two children will eventually inherit.
We have two children 'A' & 'B'
We helped 'B' to buy her property which took '£x' amount out of our investment portfolio
At that time we had a total of £y in our investments
We were then left with '£y-x' in our investments.
It is very likely that before our two children inherit that we will help financially one or both of them again.
I want to create a spreadsheet that will calculate the equal share (percentage or amounts once data is entered) that our two children will eventually inherit taking into account the following data:-
Value of our portfolio before and after any transfers.
Dates and amounts of any transfers to either of our two children.
The growth of our remaining investments between withdrawals so we can calculate the % growth of our investments would have achieved without any withdrawals.
Any amounts that we draw for ourselves.
I would need the spreadsheet to take into account that the fact that we will likely withdraw unequal amounts to give to one or both of our two children on varying dates, and also take withdrawals for ourselves. With the value of our investments fluctuating (hopefully upwards) over the forthcoming years, I feel that it makes it difficult to ensure that each of our two children eventually receive an equal share of their inheritance.
Any help with creating such a spread-sheet would be much appreciated.
We have two children 'A' & 'B'
We helped 'B' to buy her property which took '£x' amount out of our investment portfolio
At that time we had a total of £y in our investments
We were then left with '£y-x' in our investments.
It is very likely that before our two children inherit that we will help financially one or both of them again.
I want to create a spreadsheet that will calculate the equal share (percentage or amounts once data is entered) that our two children will eventually inherit taking into account the following data:-
Value of our portfolio before and after any transfers.
Dates and amounts of any transfers to either of our two children.
The growth of our remaining investments between withdrawals so we can calculate the % growth of our investments would have achieved without any withdrawals.
Any amounts that we draw for ourselves.
I would need the spreadsheet to take into account that the fact that we will likely withdraw unequal amounts to give to one or both of our two children on varying dates, and also take withdrawals for ourselves. With the value of our investments fluctuating (hopefully upwards) over the forthcoming years, I feel that it makes it difficult to ensure that each of our two children eventually receive an equal share of their inheritance.
Any help with creating such a spread-sheet would be much appreciated.