|
mhj3.com
Home | PerfCalc Home
|
Next
Setup Go
to Report Settings (bottom right @ Account Detail tab) to enter report header
options and to select a currency symbol position; leading or trailing currency
numbers. 
Start 
Investment
Portfolio Performance Calculator
Analysis
Range The
first user entered dated Market Value is calculated as the SMV and the second
user entered dated Market Value is calculated as the EMV. In
the case of a new account, the first entry can be entered as an Investor Contribution
type and will be treated as the SMV if selected as part of an analysis range. Whatever
user entered MV is selected as the starting SMV, PerfCalc takes that user entered
end of day Market Value and uses it as the starting analysis range value for the
first day of the analysis which is the next day. - SMV
date day will not be part of the calculation.
For
example, for a July analysis range, MV1 would be entered on 6/30; the end of day
closing market value. MV2 would be entered on 7/31; the end of day closing market
value on the last day of the month of July; the end of the analysis range. If,
for some reason, you wanted to include 6/30 in the analysis range, you would start
by entering a MV for 6/29.
If
you get a June bank statement dated 6/30 and a July bank statement dated 7/31,
how many days does the 2nd bank statement cover? It
covers every day in July or 31 days; from the 6/30 statement end of business day
balance to the 7/31 statement end of business day balance; all
activity from the beginning of 7/1 up to the end of day business, July 31st. The
change in your balance between the 6/30 statement end of business day balance
and the 7/31 statement end of business day balance happened over 31 days. The
withdrawals and deposits made during the day on 6/30 are reflected in the end
of business day balance in the June 30 statement, not in the July statement. The
withdrawals and deposits made during the day on 7/31 are reflected in the end
of business day balance in the July 31 statement, not in the August statement. The
end of business day balance in the July 31 statement is the SMV for the month
of August.
Cash
Flow Types Contribution,
Withdrawal, and Advisor Fees Taken types are assumed to occur at end of day and
if a market Value is entered on that date, they are included in that days' Market
Value. . Modified
Dietz Any
two user selected MVs may be used to define a performance calculation range to
calculate Modified Dietz.
User entered cash flows within the analysis range will be considered in
the performance calculation. Geometric
Linking Any
two user selected MVs may be used to define a performance calculation range to
calculate Large Cash Flows Geometric Linking. Market
Values entered on the date before Large Cash Flows (Contributions/Withdrawals),
define geometric linking subperiods. 
Geometric
Linking vs. Daily Valuation The
difference between Geometric Linking and Daily Valuation methodologies is
simply one of degrees; Geometric Linking, enter a Market Value @ large
cash flows only, and Daily Valuation, enter a Market Value @ all cash flows.
In
most cases, entering a Market Value on the dates prior for all cash flows is not
worth the effort when comparing the results to a Geometric Linking calculation. Think
of each methodology from Modified Dietz, to Geometric Linking, to Daily Valuation
as zooming in from one Modified Dietz calculation for an analysis range, to a
few Modified Dietz Large Cash Flow Calculations within the same analysis range
geometrically linked, to many Modified Dietz calculations for all cash flows within
the same analysis range geometrically linked; the more the Modified Dietz calculations
within an analysis range, the better, the more precise the answer.
After
deciding which calculation is to be used, click on that tab and then Save. Icons Impt.:
Excel Import. Clr.:
Clear all data. Sort:
Data does not need to be entered chronologically. However, report will be printed
as viewed. - Click
on Sort icon to arrange entries by date so they appear in order by date on report.
+:
Add data entry. _:
Remove highlighted entry. |
