Stock Distribution Setup

Modified on Wed, 15 Dec 2021 at 01:21 PM

When a requestor reaches out inquiring about setting up Stock Distributions or asking for Stock Distributions, there can be some initial confusion around how the feature works and what the input process will be for stock & share related information. To set expectations and explain how our current implementation of this feature works, the below canned response can be sent to the client before proceeding with implementing Stock Distributions: 


https://fundpanel.freshdesk.com/a/admin/canned_responses/folders/35000130923/responses/35000121282/edit


1. Create a new field on the Distribution Parent object: 


Name: Share Price 

Type: Currency (16,2 format for the decimal places)


Be sure to include the field on all available layouts. 



2. Create a formula field on the Distribution child object:


Name: Shares Distributed 

Type: Number (Zero decimal places)


Copy and paste the formula below within the formula editor for this field: 


ROUND( aduro__Distribution_Amount__c /aduro__Distribution_Parent__r.Share_Price__c ,0)


Be sure to add this field to all available layouts.


3. Next, create a Stock Distribution email template with the email template information pictured below: 



The body & code to use for the template can be found at the bottom of this article. Please note that the template code may need to be updated to include the client's logo as well as and custom formatting or branding they may have. It is recommended to review the clients other fund communications to determine what branding needs to be replicated on this template.


4. Navigate to Custom Settings, and click "Manage" next to Fund Communication Templates. Add the Stock Distribution email template API name to the "Cash Distribution" custom setting. 





Template Code & Body Text 


The general Stock Distribution template HTML will look something like this, the client can request to make adjustments as needed (note that the client's logo URL will need to be inserted within the "" where it says img src=""): 


Template Name: 


{!aduro__Fund__c.Name} – Stock Distribution


Template Code

<html>
<head>
</head>
<body style="font-family: 'Dosis', 'Calibri', sans-serif; font-size: 12pt; line-height: 1.5em;">
<table style="border-spacing: 0; border-colålapse: collapse; font-size: 11pt; width: 100%; text-align: center;">
<colgroup> <col width="200px" /> <col width="200px" /> <col width="200px" /> </colgroup>
<tbody>
<tbody>
<tr>
<td colspan="3">&nbsp;</td>
</tr>
<!-- Begin horizontal rule -->
<tr>
<td colspan="3"><img src="" alt="" width="200" /></td>
</tr> <!-- end horizontal rule -->
<tr>
<td colspan="3">&nbsp;</td>
</tr>
<tr>
<td colspan="3" style="font-weight: bold; font-size: 18pt;">{!aduro__Fund__c.Name}</td>
</tr>
<tr>
<td colspan="3" style="font-weight: bold;">Stock Distribution Notice</td>
</tr>
<tr>
<td colspan="3" style="font-weight: bold;">{!aduro__Distribution__c.aduro__Distribution_Date__c}</td>
</tr>
<tr>
<td colspan="3">&nbsp;</td>
</tr>
<!-- Begin horizontal rule -->
<tr>
<td colspan="3" style="font-size: 1px; line-height: 1em; background-color: #000">&nbsp;</td>
</tr>
<!-- end horizontal rule -->

<tr>
<td colspan="3">&nbsp;</td>
</tr>
<tr>
<td style="font-weight: bold;" colspan="3">{!Account.Name}</td>
</tr>
<tr>
<td colspan="3">&nbsp;</td>
</tr>
<tr style="font-weight: bold;">
<td>Total Capital Commitment</td>
<td>100.00%</td>
<td>{!aduro__Distribution__c.aduro__Capital_Commitment_Amount__c}</td>
</tr>
<tr>
<td>Capital Contributions to Date</td>
<td>100.00%</td>
<td>{!aduro__Distribution__c.aduro__Capital_Commitment_Total_Called_Paid__c}</td>
</tr>
<tr style="font-weight: bold;">
<td>Remaining Commitment</td>
<td>0.00%</td>
<td>{!aduro__Distribution__c.aduro__Capital_Commitment_Remaining_Value__c}</td>
</tr>
<tr>
<td colspan="3">&nbsp;</td>
</tr>
<tr>
<td>Distributions to Date <span style="font-weight: bold;">(prior to the Current Distribution)</span></td>
<td></td>
<td>{!aduro__Distribution__c.aduro__Total_Distributions_To_Date__c}</td>
</tr>
<tr>
<td colspan="3">&nbsp;</td>
</tr>
<!-- Begin horizontal rule -->
<tr>
<td colspan="3" style="font-size: 1px; line-height: 1em; background-color: #000">&nbsp;</td>
</tr>
<!-- end horizontal rule -->

<tr style="font-weight: bold;">
<td>Current Stock Distribution:</td>
</tr>
<tr>
<td>Number of Shares</td>
<td></td>
<td>{!aduro__Distribution__c.Shares_distributed__c}</td>
</tr>
<tr>
<td>Value of Shares as of January 6, 2021</td>
<td></td>
<td>{!aduro__Distribution__c.aduro__Distribution_Amount__c}</td>
</tr>
<tr style="font-weight: bold;">
<td>Total Distributions</td>
<td></td>
<td>{!aduro__Distribution__c.aduro__Total_Distributions__c}</td>
</tr>
<!-- Begin horizontal rule -->
<tr>
<td colspan="3" style="font-size: 1px; line-height: 1em; background-color: #000">&nbsp;</td>
</tr>
<!-- end horizontal rule -->

<tr>
<td colspan="3">&nbsp;</td>
</tr>

<tr style="font-weight: bold;">
<td>Distribution Scheduled for {!aduro__Distribution__c.aduro__Distribution_Date__c}</td>
<td></td>
<td>{!aduro__Distribution__c.aduro__Distribution_Amount__c}</td>
</tr>
<tr>
<td colspan="3">&nbsp;</td>
</tr>
<tr>
<td style="text-align: left;" colspan="3">
<div align="center">
<div align="center">&nbsp;</div>
</div>
</td>
</tr>
</table>
</body>
</tr>

</html>

Plain Text Preview


Dear {!Account.Name},

Please find attached a distribution notice relating to your investment in {!aduro__Fund__c.Name}.

The distribution is set to occur on {!aduro__Distribution__c.aduro__Distribution_Date__c} and will be sent to the instructions we have on file.

Do not hesitate to contact us if you have any questions or concerns on the attached.

Best regards,

Aduro Advisors
on behalf of {!aduro__Fund__c.Name}