I'm working on a file that tracks 5 different investment accounts for a college foundation. However, here's the kicker, each investment account has several scholarship funds in the account.
What's the simplest way to figure out how each scholarship fund has done over the year. So I will need it to proportionally spread the gains and losses of the investment account to each of the scholarship funds each month but also be able to figure in deposits and withdrawals to and from that scholarship fund throughout the year as well. And then be able to figure out the cost of the scholarship fund throughout the year.
And then of course, I would like to graph it eventually.
Thanks.
What's the simplest way to figure out how each scholarship fund has done over the year. So I will need it to proportionally spread the gains and losses of the investment account to each of the scholarship funds each month but also be able to figure in deposits and withdrawals to and from that scholarship fund throughout the year as well. And then be able to figure out the cost of the scholarship fund throughout the year.
And then of course, I would like to graph it eventually.
Thanks.