When creating an equity class within a Project, there are Investor Dashboard Preferences that can be set and will be shown on the Investor Dashboard. This document will detail those preferences and the calculations surrounding them. Many preferences can be managed both at the class level and the account level.
|
Raising |
Funded/Invested/Syndicating |
Liquidated |
|
Amount Invested |
Amount Invested |
Amount Invested |
|
(Est.) Closing Date |
Date Invested |
Date Invested |
|
|
Annualized Cash on Cash |
Annualized Cash on Cash |
|
|
Entity Ownership % |
Entity Ownership % |
|
Remaining Investment Term |
Remaining Investment Term |
|
|
|
Distributions to Date |
Distributions to Date |
|
|
Current Quarter Distributions |
|
|
|
Next Distribution Date |
|
|
|
Return of Capital |
|
|
|
YTD Return of Capital |
|
|
|
Unreturned Contributions |
|
|
Preferred Return |
Preferred Return |
Preferred Return |
|
Cash on Cash |
Cash on Cash |
Cash on Cash |
|
Rate of Return |
Internal Rate of Return |
Internal Rate of Return |
|
Inception to Date Rate of Return |
|
|
|
|
Annualized Rate of Return |
|
|
Accrued and Unpaid Preferred Returns Acquisition Price Estimated Disposition Date Fund Details Internal Rate of Return Calculation Reporting for Period Ending ___ |
Return Multiple Accrued and Unpaid Preferred Returns Acquisition Price Estimated Disposition Date Fund Details Internal Rate of Return Calculation Property Value Reporting for Period Ending ___ |
Return Multiple Accrued and Unpaid Preferred Returns Acquisition Price
Fund Details
Property Value Reporting for Period Ending ___ |
Accrued and Unpaid Preferred Returns
All status’ – This is a calculated field based on your selected preferred return waterfall template. *Note the dashboard preference on period for preferred return.
Displays the accrued and unpaid preferred returns based on the specified dashboard preference date.
Acquisition Price
All status’ – This is a numerical field from the asset details page.
Displays the price paid to acquire the asset.
Allocated Net Asset Value
Represents the Fund Net Asset Value or Property Net Asset Value as applicable times an Investor's ownership % in the Fund.
Amount Invested
All status’ – This field will show the Amount Invested by the investment entity.
Annualized Cash on Cash
Funded – This field will show the annualized cash income earned on the cash invested. Investment must have investment amount and at least one distribution with a value for the investment.
Liquidated - This field will show the annualized cash income earned on the cash invested. Investment must have investment amount and at least one distribution with a value for the investment, and an Exit Date for the project.
Users can select the following end date opens:
Distribution Period End Date
Distribution Period Pay Date
Prior Quarter End Date
Prior Month End Date
Prior Business Day (excluding Saturday and Sunday)
Inception to Date
Result = ((a)/(i)) x (365/L) x 100
- A = sum of all distributions within the specified period
- I = Investment Amount
- L = DE-DS (+1)
a. DE = user selected end date
b. DS = Investment date
c. (+1) = system will add 1 day if the DE or DS value falls on the first or last day of the month
EXAMPLE:
DS = 01/25/2017
DE = 03/31/2019
L = 796
A = 87,500
I = 100,000
Result = ((87,500)/(100,000)) x (365/796) x 100 = 40.12%
Year to Date
Result = ((a)/(i)) x (365/L) x 100
- A = sum of all distributions within the specified period
- I = Investment Amount
- L = DE-DS + 1
a. DE = user selected end date
b. DS = based on DE selection, 01/01/yyyy
EXAMPLE:
DS = 01/01/2019
DE = 03/31/2019
L = 90
A = 10,000
I = 100,000
Result = ((10,000)/(100,000)) x (365/90) x 100 = 40.56%
Trailing 3 Months
Result = ((a)/(i)) x (365/L) x 100
- A = sum of all distributions within the specified period
- I = Investment Amount
- L = DE-DS (+1)
a. DE = user selected end date
b. DS = based on DE selection, 3 month look back
c. (+1) = system will add 1 day if the DE or DS value falls on the first or last day of the month
EXAMPLE:
DS = 01/01/2019
DE = 03/31/2019
L = 90
A = 10,000
I = 100,000
Result = ((10,000)/(100,000)) x (365/90) x 100 = 40.56%
Trailing 12 Month
Result = ((a)/(i)) x (365/L) x 100
- A = sum of all distributions within the specified period
- I = Investment Amount
- L = DE-DS
a. DE = user selected end date
b. DS = based on DE selection, 365 day look back
EXAMPLE:
DS = 03/31/2018
DE = 03/31/2019
L = 365
A = 47,500
I = 100,000
Result = ((47,500)/(100,000)) x (365/365) x 100 = 47.5%
Annualized Rate of Return
Funded – This is a calculated field.
Calculation:
ds = Based on today's date, the start date of the period that the last distribution was distributed de = Based on today's date, the end date of the period that the last distribution was distributed a = Sum of all distributions within the specified period
b = Sum of "Return of Capital" distributions within the specified period c = Sum of all "Return of Capital" distributions
i = Investment amount
L = # of days in the specified period L = de – ds + 1
Result = ((a-b)/(i-c))*(365/L)*100
Investment must have invested amount, as well as at least one "Return of Capital" type distribution.
Average Share Price
Displays the calculation of the (Sum of all Invested Capital)/(Sum of all Shares).
Cash on Cash
All status’ – This is either a manual field or calculated based on the Type of Cash on Cash selected on the equity class. If manual, this field will display the Manual Cash on Cash Value entered. Will display with Custom Name for “Cash on Cash Return”, if entered. If calculated, Calculation: Cash on Cash = (Sum of Distributions / (Investment Amount) * 100. “Est.” will show when in Raising stage.
(Est.) Closing Date
Raising –This field will show the estimated closing date of the project.
Current Quarter Distributions
Funded – This field will display the sum of distributions made in the most current distribution period. Investment must have at least one distribution for the investment.
Date Invested
Funded, Liquidated - This field will show the closing date for the project.
Distributions to Date
Funded, Liquidated – Will show a sum of all distributions to date for the investment entity.
Entity Ownership (%)
Funded, Liquidated – This field will show the Entity Ownership %. Investment amount and Project ownership structure definition must be complete for this field to display.
Estimated Disposition Date
Raising, Funded – This is a numerical field from the asset details page.
Displays approximate date the asset is expected to be sold or liquidated.
Fund Details
-Distributions
Shows the cumulative distributions paid to date by the investment.
-Expected Term
Displays the approximate term for the fund.
-Fund Hold Period
Shows the anticipated term for assets within the fund.
-Fund Image
Displays image uploaded to help identify a given fund.
-Net Asset Value
Displays the estimated net asset value of the fund.
-Target Amount
Displays the target amount you wish to raise for a given fund.
All status’ but only shows on fund projects. The inputs are found on the asset details page.
Inception to Date Rate of Return
Funded – This is a calculated field.
Calculation:
ds = Closing date of project de = Date of last distribution
a = Sum of all distributions within the specified period
b = Sum of "Return of Capital" distributions within the specified period c = Sum of all "Return of Capital" distributions
i = Investment amount
L = # of days in the specified period L = de – ds + 1
Result = ((a-b)/(i-c))*(365/L)*100
Investment must have at least one “Return of Capital” type distribution. As well as a project close date defined on the equity class.
Internal Rate of Return
Funded, Liquidated – This field will display the Internal Rate of Return when defined on the equity class.
Internal Rate of Return Calculation
Funded, Liquidated, Syndicating – This is a calculated field based on XIRR.
Displays the calculated internal rate of return for a project.
Next Distribution Date
Funded – This field will show the next distribution date, given that a distribution frequency is defined on the equity class, and at least one distribution with a value is available for the investment.
Preferred Return
Raising, Funded, Liquidated – This field will display the available preferred return if defined on the equity class.
Property Value
All status’ – This displays the property value from the home page.
Displays the fair market value of a given piece of property.
Rate of Return
Funded, Liquidated – While this will eventually be a calculated field, this field currently will display the Internal Rate of Return when defined on the equity class. We have scheduled development for a future date which will incorporate our client feedback, as Rate of Return is calculated differently across industries.
Remaining Investment Term
Raising – This field will show the Project Close Date and Exit Date if defined in the project. Funded - This field will show the Project Exit Date if defined in the project.
Reporting for Period Ending ___
All status’ – This is a calculated field based off logic.
Informs investors that the metrics displayed are for the last period's distribution end date.
Return Multiple
Funded, Liquidated – This is a calculated field.
Calculation:
(Sum of Distributions)/(Investment Amount)
*Investment must have invested amount, as well as at least one distribution.
Return of Capital
Funded – This field displays a sum of all “Return of Capital” type distributions. Investment must have at least one “Return of Capital” type distribution for the investment.
Shares
If issued, display a sum of all shares from all contributions.
Total Return on Investment
Funded, Liquidated– This is a calculated field. Calculation: (Total Distributions – Return of Capital)/ Investment Amount.
Unreturned Contributions
Funded – This is a calculated field. Calculation: (Investment amount – sum of “Return of Capital” type distributions).
YTD Return of Capital
Funded – This field will show the year to date return of capital type distributions. Investment must have at least one Return of Capital type distribution for the investment.
Custom Metrics
For information on custom metrics, please click here.