Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,081
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can a service account be embedded in Workbook so that by default the macros are run with service account credentials and not the user credentials??? Divya Sanam Excel Discussion (Misc queries) 0 July 20th 06 05:15 PM
Sorting a Worksheet using Capital letters This Guy Excel Worksheet Functions 0 April 25th 06 04:56 AM
Merging data looking up (Account) numbers in a coloumn gandhi318 Excel Worksheet Functions 0 December 29th 05 03:58 PM
Help with function to sum values in a worksheet depending on account number Dab Excel Worksheet Functions 4 June 7th 05 10:08 PM
Chart Account# and $ value from MANY into Line Chart P. G. Charts and Charting in Excel 4 February 3rd 05 08:25 PM


All times are GMT +1. The time now is 09:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"