Hi, i want to calc. the quarterly profit payout for investors, but my spreadsheet knowledge is not deep enough to accomplish this task. I don't have Excel on this laptop, i've linked a Google sheet for it with online access, it basically does the same. Would be great if someone knows how this go
* Before payout, the profit is shared between the company and the investors, where the investors receive 30%
* Payouts are in relation to the investment amount (smaller investments receive respectively smaller part of profit ...)
* Also the investment entry day is considered accordingly (the investor receives only the portion for the days of the quarter where the investor already had invested)
* Investors that have not yet reached 200% payout of their investment, receive 3 times as much as the ones that have exceeded 200%
* The payout is limited to 1100% (so after that the respective investor is paid up)
Image_2016_01_23__05_33_36__1453523617.jpg
Link to Sheet
Regards,
Frank
Bookmarks