mhj3.com Home | PerfCalc Home | PerfCalc Screenshots Start | Back | Next

QuickView

PerfCalc Story in an Instant.jpg: Individual Portfolio Performance Report

Click on "+" to enter new Data Entry Window below:

Types

Types may be broken down into two categories; entries that affect the calculation of Modified Dietz TWRR average Investment and the entries that calculate Modified Dietz profit.

TWRR

• Investor Contribution
  • Client initiated addition of capital or securities to the account.
  • When an account is new, Investor Contribution may be used instead of Market Value as the first entry only to indicate the account is new and this Investor Contribution, and only this Investor Contribution, may be used to start an analysis range; Investor Contribution to selected Market Value rather than the standard convention of Market Value to Market Value.
• Investor Withdrawal
  • Client initiated subtraction of capital or securities from the account.

Profit

• Advisor Fees Taken
  • Advisor fees that were paid from the account.
  • Rrequired only if a Gross of Fees/No Fees report is needed.
• Advisor Fees Paid
  • Advisor fees that were paid directly from the client to the advisor.
  • If client deposits a check for fees into the account use 'Type' 'Investor Contribution' when deposited and use 'Type' 'Advisor Fees Paid' when paid.
• Market Value
  • The value of the portfolio on a user selected date.
• Accrued Dividends
  • The value of dividends that have been earned, but not yet paid.
• Accrued Interest
  • The value of interest that has been earned, but not yet paid.
• Accrued Income
  • The value of income that has been earned, but not yet paid.
• Accrued Fees
  • The value of fees that have been earned, but not yet paid.
• Accrued Dividends Paid
  • The value of accrued dividends that have been taken to date and that need to be reconciled in the period paid.
    • For example, you have taken $4,000 in accrued dividends to date.
    • In a subsequent period, the accrued dividends taken (and the accrued dividends earned in the subsequent period) have been paid; for example $6,000.
    • The subsequent period dividends earned has to be adjusted downward by the $4,000 Accrued Dividends taken so as not to overstate dividends earned in the paid period.
• Accrued Interest Paid
  • The value of accrued interest that has been taken to date and that needs to be reconciled in the period paid.
• Accrued Income Paid
  • The value of accrued income that has been taken to date and that needs to be reconciled in the period paid.
• Accrued Fees Taken
  • The value of fees that have been taken to date and that need to be reconciled in the period paid.

The general assumption is that all user entered dated Market Value entries include the market value of investments, net of cash flow contributions and withdrawals if still in cash, dividends, interest, income, money market, and fees.

The need to enter accruals in PerfCalc occurs when you want to shift a portion of/all of dividends, interest, and income (which increase period profit) and/or fees (which reduce period profit) earned, but unpaid into a user defined portfolio analysis range (any two user entered dated Market Values) which is prior to, that does not include the date(s) when the accruals are actually to be paid.

Other than this situation, there is no need to enter accruals as dividends, interest, income and fees will be included in Market Values entered after their payment.

Assume periods A-B and B-C; with Market Value entries @ A, B, and C:

Should you decide to do a performance calculation for the period A-C, and you have applied Accruals in period A-B with balances appearing in PerfCalc @ Accruals Outstanding until paid) and Accruals Paid (to the extent paid will reduce Accruals Outstanding) in B-C, PerfCalc will calculate the analysis range profit and performance correctly; the same as if you had not made any accrual type entries at all.

Use left/right Scroll Arrows to Month and Year and then click on the day.

Date may also be entered manually in the Date field.

Enter Amount for the different types of cash flow entries.

Select the entry Type.

The initial entry may be 'Typed' either as an 'Investor Contribution' or as 'Market Value;' depends only on what you prefer.

From that point on use the appropriate 'Type' for cash flow entries.

Dates will fill in @ Valuation Period as you make entries.

The order of the entries is not important.

After you have made all of your entries, should you suddenly decide that you want to do a portfolio performance valuation for new dates within the entries already made, simply add Market Value entries (which will appear as the last entries) and go to Valuation Period and select the range.

If you forget to make a cash flow entry simply add it.

• Even though it will appear at the bottom of the entry window, it will be used in the calculation if within the analysis range.
• This capability is intended to give the user the opportunity to show quarterly and annual performances; select a range (quarter or any time period) and print the report. Repeat until all quarters or time periods are done and then print a final total/annual report using, for example, the first entry (Investor Contribution or Market Value) and the last Market Value entry.
• Years of data can be saved and selected performance ranges can be printed.

A starting Market Value and an ending Market Value are the minimum required entries.

Highlight an entry in the Investment Detail and click on the Minus (-) icon to delete.

Click on Clear to delete all entries.

Use Sort option to sort by entries by date.

To calculate performance net of fees, enter Advisor Fees Taken.

Apply Accrued options to apply accruals earned but not yet paid.

Hint: To save time when making corrections to entries already added to the Investment detail, highlight it, the data will appear in the Entry Window, make changes in the Entry Window, click the Plus (+) icon and the modified entry will be added. Then highlight the original entry that has since been modified and click on the Minus (-) icon to delete it.