Where you are trying to go — Investment Planning: Investor's CalcStation | How you are going to get there — Portfolio Management: Investor's WorkStation | How well you have done — Modified Dietz Performance Calculator: PerfCalc | What you need to think about, know, do, have, use, forget, and avoid — Investing Principles and Perspectives: In My Opinion | Home | Contact Us | Free 30-Day Software Trials | Prices/Order
mhj3.com Investing Philosophy | mhj3.com Audio Introduction Excerpts

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.
• 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 $1,250 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 period dividends earned has to be adjusted downward by the $1,250 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.

Click on Back to go back to the Investment Detail and Performance tab.

• Click on Import From File icon, select file, click on Import Data.

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.