If It Is Measured, It Will Get Done
Performance/R/ROI is the definitive measure of one's investment advising and investing performance skills that trumps all other discussions and representations; the single best measure of one's ability to convert rhetoric into results.

When compromise is not a performance calculation option....

PerfCalc: Correct, Complete, Compliant, Transparent
Excel Data Import Options for Individual, Selected, and Global Investment Portfolios

PerfCalc for Dummies

Slideshow | Screenshots | Premise | Returns' Calculation History
Help | Free 10-Day Software Trial | mhj3.com Home
YouTube PerfCalc QuickView, Tutorial in Detail, Tutorials by Subject

Trends Analysis.jpg

'What If' Benchmarks' Calculation Option
(In addition to PerfCalc's default industry standard benchmark calculation methodology — R=(EMV-BMV)/BMV — to compare the performances of different portfolios to a selected 'passive, unmanaged' benchmark; individual or user defined composite)

'Given the same performance calculation analysis range, the same dated cash flows, the same dated Market Value entries, the same adjustments to profit, and the same performance calculation methodology as the linked portfolio, how well would I have done had I invested in my user defined and selected 'What If' benchmark — X alone (a selected index for example) or X, Y, and Z (user defined composite benchmark or user selected and weighted investments) — compared to my current portfolio composed of A, B, and C; actual, precise benchmark performance and variance compared to my current portfolio?'

'I invested in IBM, F, etc. How would the performance of that portfolio compare to my investing in GOOG, NFLX, etc. over the same time period?'

PerfCalc gives the user the option to calculate selected index benchmarks, user defined composite benchmarks, and any number of alternative weighted investments (30% X, 20% Y, and 50% Z rather than current portfolio composed of 25% A, 40% B, 35% C over user defined and selected portfolio performance calculation ranges) as 'managed' 'What If' Benchmarks' Calculation Option as opposed to standard 'unmanaged' benchmarks typically used to compare an 'internal' portfolio's performance to an 'external' portfolio's performance using a common 'unmanaged' benchmark.

• By applying the same dated external cash flows (Investor Contributions/Investor Withdrawals) of a portfolio to a 'What If' benchmark.
• By applying the same user entered, selected, and dated Market Values of a portfolio to a 'What If' benchmark.
• By applying the same performance analysis range to a 'What If' benchmark as applied to the linked portfolio; hidden calculation of dated 'What If' benchmark Market Values mirroring the dates of user entered, selected, and dated Market Values for a linked portfolio.
• By calculating a 'What If' benchmark using the same performance calculation methodology used to calculate a linked portfolio's performance; Modified Dietz, Large Cash Flows Geometric Linking, or Daily Valuation.
• By comparing a portfolio's performance to a user defined and selected 'What If' benchmark @ an individual portfolio performance report 'as if'' the user had invested in the benchmark; the most accurate 'internal' investment portfolio performance verses benchmark performance comparison calculation.

• GIPS compliant.

  QuickView of Four PerfCalc Performance Calculation Options

• Modified Dietz, Modified Dietz Geometric Linking, Large Cash Flows Geometric Linking, and Daily Valuation performance calculation options.
• Easy performance calculations; only Market Values, Investor Contributions, and Investor Withdrawals need be entered; no need to track individual trades, transfers, dividends, interest, income, splits, etc.
• Accruals' Calculation options.
• Gross and net of fees.
• External/Internal Fee Calculation options.
• Portfolio Benchmarking; individual index or user defined composite.
• Benchmark data import; download from Internet to Excel and import to PerfCalc.
• Auto-sync benchmark analysis range dates and calculations with user selected investment portfolio's performance analysis range dates and calculations.
• Performance Calculations for individual, selected, or global investment portfolios.
• Transparent portfolio performance calculations detailing cash flows applied.
• Excel or Windows Notepad .txt data import of individual, selected, or global investment portfolios.
• PerfCalc currency position options and currency symbol, format, and and date sequence options as set @ Windows/Control Panel/Regional and Language Options.
• Create accounts, import data, import or enter benchmark data, define benchmark, set performance calculation analysis range, print individual portfolio performance report or selected or global combined performance report and optional underlying individual portfolio performance reports in an instant.
• Create individual portfolio Trends Analysis by selecting a total analysis range and sub-period analysis ranges; years, months, days in any order and sequence.
• Report footnotes; performance calculation methodology used, individual or composite benchmark, gross or net of fees.
• Windows XP, Vista, 7.

For those of you who are looking for Excel templates and Excel solutions to compliant performance calculations for all performance calculation situations, there are none; don't exist — we searched ourselves and sought the help of Excel experts, without success, before starting on our three year journey to design software that would generate correct and complaint investment portfolio performance calculations for all situations.

As wonderful as Excel is, Excel's XIRR function might calculate the same return as a PerfCalc Modified Dietz Calculation for only the most basic of investment portfolio performance calculation situations; if analysis range inputs are but one starting and one ending market value, if there are no accrual or a certain type of fee issues, if individual dated cash flows are small relative to the total value of the portfolio, and if dated investor contribution and/or dated investor withdrawal cash flows within an analysis range happen to be in a certain order. Beyond these specific and narrow performance calculation situations, Excel performance calculations deteriorate rapidly.

If and when performance calculations need to be 2010 GIPS compliant — Modified Dietz, Modified Dietz Geometric Linking, Large Cash Flows Geometric Linking, or Daily Valuation — portfolio performance calculations, if an when there is/are large cash flow(s), if and when advisor fees are paid through the account or paid directly to an advisor, and/or if and when accrued interest, dividends, income, and/or advisor fees occur during an analysis range, Excel's XIRR function will not calculate correct and compliant returns; not even close.