ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Capital account management (https://www.excelbanter.com/excel-worksheet-functions/119647-capital-account-management.html)

BLIPSKYCPA

Capital account management
 
I need to manage a capital account for investors -
The acct will have contributions from investors and will pay out a dividend
based on ownership % - I will need a program that will calculate the %
ownership of each partner, and change that ownership % as new partners come
in or out. Each partner will be paid out their percentage of net income on a
quarterly basis -
Any ideas how to manage such a capital account?

Duke Carey

Capital account management
 
Depends on a number of factors, not the least of which is the
frequency/number of transactions through which ownership changes. If those
events are rare, then handling it all within a simple spreadsheet is likely
to be feasible.

It gets more complicated when you have more and more investors moving in &
out within a quarter, for you then have to determine ownership percentages
for any number of partial periods and try to allocate income for each of
those partial periods.

In the either case you will need to track the dates on which ownership
changes occur and calculate day-weighted ownership percentages for each
quarter.



"BLIPSKYCPA" wrote:

I need to manage a capital account for investors -
The acct will have contributions from investors and will pay out a dividend
based on ownership % - I will need a program that will calculate the %
ownership of each partner, and change that ownership % as new partners come
in or out. Each partner will be paid out their percentage of net income on a
quarterly basis -
Any ideas how to manage such a capital account?



All times are GMT +1. The time now is 10:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com