Docstoc

Framework

Document Sample
Framework Powered By Docstoc
					                                                                                                                                                          Wenzel
                                                                                                                                                          Analytics
                                                                                                                                                          Inc



Table 1.

Total Net Worth and Asset Allocation

                       Personal
Get Returns?                                                                                      Investments
                       Property

Asset Allocation                       Cash     Fixed Income Passive Equities                           Active Equities                      Tangible           Debt

   Percentage?


                       Vehicles,     Currency,                  Index Funds,    Self-              Professionally                         Real Estate,      Credit cards,
                                               Bonds, CDs,                                                        Mutual
Within each asset      Furniture,    Checking,                  Exchange Traded managed            managed                    Real Estate Commodities,      Mortgage,
                                               Private Loans                                                      Funds
                       Personal      Money-Mkt                  Funds           Stocks             Stocks                                 Collectables      Margin



                                                                Geographic,         Greenblatt,    Zweig,                                Homestead,
                                                Bonds,
                       Live                                     Sectors,            Mairs,         Piotroski RS,   Small-cap REITs,      Apt Bldg,
Strategy                                        Derivatives
                       comfortably                              Value/Growth,       Resource       Resilient,      Value     Partnership Musical instr,
                                                (Funds)
                                                                Capitalization      Scarcity       Income, etc.                          Coins, etc.


Individual Positions




                                                                                                          Lee Wenzel
                                                                                                          Wenzel Analytics, Inc.         Registered Investment Adviser
                                                                                                          (952) 944-2699                 8666 Westwind Circle
                                                                                                          Lee@WenzelAnalytics.com        Eden Prairie, MN 55344
                                                                                                          www.wenzelanalytics.com       “An alternative to mutual funds.”
C:\Docstoc\Working\pdf\c79b5e54-97e7-4cc4-af87-bddcf64d05b0.xls, Framework, 4/28/2010
                                                                                                                                                                                                                                                                                                     Wenzel
                                                                                                                                                                                                                                                                                                     Analytics
                                                                                                                                                                                                                                                                                                      Inc
Table 2.

Total Net Worth and Asset Allocation
                       An Example (Not to Exact Scale)

                       Personal
Get Returns?                                                                                                                                                 Investments
                       Property

                                                                   Fixed
Asset Allocation                                 Cash                                                   Passive Equities                                                       Actively Managed Equities                                                                                                                Tangible          Debt
                                                                  Income

                                                                  Bonds,
                        Vehicles,              Currency,                                 Index fund in
                                                                   CDs,                                  Exchange Traded                                                                                                                                                          Mutual
Within each asset       Furniture,             Checking,                                Qualified 403(b)                                                                                     Stocks                                                                                                                      Home           Mortgage
                                                                  Private                                     Funds                                                                                                                                                               Funds
                        Personal               Money-Mkt                                      Plan
                                                                  Loans

Management                                                                                                                                                    Managed by Wenzel Analytics
Dollars                 $   40,000              10,000            20,000                   170,000                  155,000                                                               207,000                                                                                76,000                                 250,000         (60,000)
Percentage              Excluded                  1%                 2%                                       39%                                                                                   25%                                                                                 9%                                30%             -7%

                        Excluded                  1%                 2%                      21%                        19%              2.8                  2.4     3.0         4.6                3.5                   1.1 1.9                  3.6      2.1               6%                    3%                   30%             -7%




                                                                                                                                                                                                      Prudent Speculator
                                                                   Bonds, Derivatives




                                                                                                                                                                                                                                                                               Resilient to market
                                                                                                                                         Resource Scarcity
                                                                                                                     cap and emerging
                                                                                                                     Match small, mid-




                                                                                                                                                                               Piotroski Relative




                                                                                                                                                                                                                                                                                                     Small cap growth
                            Live comfortably




                                                                                              Match S&P 500
                                                  Meet Expenses




                                                                    (Mutual Funds)




                                                                                                                                                                                                                                                                                                                           Appreciate
                                                                                                                                                                                                                                                                                  downturns
                                                                                                                                                                                                                           Indiv Pick




                                                                                                                                                                                                                                                                                                                                           Leverage
                                                                                                                                                                                                                                                             Cyclicals
                                                                                                                                                                                                                                        Resilient
                                                                                                                                                                                    Strength




                                                                                                                                                                                                                                                    Shadow
                                                                                                                          markets




                                                                                                                                                                      Income
                                                                                                                                                               Gems
Strategy




                                                                                                                                                                                                                                                                         RSNRX
                                                                                                                                                                                                                                                                         HSGFX
                                                                                              VFINX




                                                                                                                                                                                                                                                                         AVALX



                                                                                                                                                                                                                                                                                                     BRSIX
                                                                                                                                                                                                                            MDRX
                                                                                                                     MDY
                                                                                                                     EEM
                                                                                                                     IJR




Individual Positions




                                                                                                                                                                      Lee Wenzel
                                                                                                                                                                      Wenzel Analytics, Inc.                                                             Registered Investment Adviser
                                                                                                                                                                      (952) 944-2699                                                                     8666 Westwind Circle
                                                                                                                                                                      Lee@WenzelAnalytics.com                                                            Eden Prairie, MN 55344
                                                                                                                                                                      www.wenzelanalytics.com                                                           “An alternative to mutual funds.”
    C:\Docstoc\Working\pdf\c79b5e54-97e7-4cc4-af87-bddcf64d05b0.xls, Example, 4/28/2010
                                                                                                                        Wenzel
                                                                                                                        Analytics
                                                                                                                        Inc


Column Heading            Use Description
Investment                    Separate investment assets giving a return from assets used in lifestyle.
                              Active investments are individually selected by someone, while passive investments have an
Active/Passive
                              automated selection process such as index funds or exchange traded funds.
                              A money manager manages the selection of stocks within a mutual fund. Wenzel Analytics
Managed By                    may serve as a manager. Different family members may have responsibility to manage
                              different assets.
                              Primary asset allocation categories such as cash, fixed income, equities, tangible things
Asset Class                x
                              (commodities and collectibles), debt
                              The breakdown of each asset type, i.e. equity might be divided into stocks, real estate,
Asset Sub-type             x
                              mutual funds, and index or exchange traded funds.
                              Under stocks this might be domestic vs ADR, under bonds it might be municipals, US
Issuer/Geography
                              Treasuries and corporate.
Strategy                   x Under stocks this would be the screen or criteria which characterized the stock selection.
                              Traditionally mutual funds are categories into styles by value/growth and market cap. I find
Style
                              strategy to be more relevant for diversification.
                              What is the time-frame for this investment? Is there a penalty or legal constraint for an
Liquidity
                              earlier liquidation?
                              Do you have a date to end the holding period? If it is a credit card loan at 0% interest being
Target Date
                              used to buy stocks, when does the 0% rate end?
Tax Status                 x After-tax, qualified (IRA, SEP or 401k), Roth IRA, trust
Owner                      x Husband, wife, joint, child, trust, etc.
Held At                    x Bank, brokerage or physical location of assets.
Account #                  x Account number.
Managed By                    Who is looking after these assets and making buy/sell decisions?
                              Is there a designated purpose for this asset, such as college, retirement, long-term care,
Designated Purpose
                              heirs, charity?
Symbol                     x What is the stock symbol or other abbreviation?
Item Name                  x Name of the asset, such as the name of the stock or mutual fund.
Units                      x How many units of shares are owned?
                              For stocks and funds, this field usually contains a lookup function that automatically brings in
Price                      x
                              daily prices.
Value                      x Price multiplied by units, or manually entered periodically such as for a homestead.
                              What led to your buying this asset? Does this source have a good track record or a poor
Source
                              track record?
Action                     x This is a field for noting required action, such as watch, sell or a stop.
Target Price                   Do you have a target price for this asset that you are waiting for or would prompt a sale?
Date Acquired              x   The date acquired is needed for investments that need to be reported on Schedule D.
Date Sold                  x   The date sold is needed for investments that need to be reported on Schedule D.
                               This field can say Own or Sold automatically as a function of Date Sold. It is useful in
Owned/Sold                 x
                               separating current positions from a record of historical holdings.
Purchase Price             x   Price paid per unit.
Basis                      x   What was paid for this asset?
Sale Price                 x   Price received upon sale for each unit.
Sale Value                 x   What was it sold for (if sold)?
Gain/Loss                  x   What is the current gain or loss on this asset?
Annual Return Last Yr          What was the annual return rate last year?
Annual Return Projected        What rate of return are you expecting from this asset? (optional, of course)
Volatility                     How do you rate the volatility or risk level for this asset?
Beta                           Statistical measure of volatility relative to the market.
                               This column is useful if you use the data sheet as a trading worksheet. If you are going to
Trial Shares               x   invest $30,000 in ten stocks, how many shares of each would you buy to spread the dollars
                               evenly?
Trial Cost                 x    In the case of purchasing stocks, trial shares multiplied by price plus commissions.



                                                                  Lee Wenzel
                                                              Wenzel Analytics, Inc.                  Registered Investment Adviser
                                                              (952) 944-2699                          8666 Westwind Circle
                                                              Lee@WenzelAnalytics.com                 Eden Prairie, MN 55344
                                                              www.wenzelanalytics.com                “An alternative to mutual funds.”
    C:\Docstoc\Working\pdf\c79b5e54-97e7-4cc4-af87-bddcf64d05b0.xls, Glossary, 4/28/2010
Investment       Active/Passive Managed By     Asset Class         Asset Sub-type   Issuer/GeographyStrategy
Non-Investment                  Family         Personal Property   Vehicle
Non-Investment                  Family         Personal Property   Vehicle
Non-Investment                  Family         Personal Property   Furniture
Non-Investment                  Family         Personal Property   Personal Items
Non-Investment                  Family         Debt                Vehicle
Non-Investment                  Family         Debt                Credit Card
Investment                      Family         Cash                Currency
Investment                      Family         Cash                Checking/Brokerage
Investment                      Wife           Cash                Money-Market
Investment                      Husband        Cash                Insurance        Cash Value
Investment       Passive        Annuity        Cash                Insurance        Annuity
Investment       Active         Husband        Fixed Income        Bond             US Treasury     TIPS
Investment       Active         Husband        Fixed Income        Bond             Municipals      Tax-sheltered income
Investment       Active         Husband        Fixed Income        Bond             Corporate
Investment       Active         Husband        Fixed Income        Bond             International
Investment       Active         Wife           Fixed Income        CD               Bank
Investment       Active         Husband        Fixed Income        Private Loan     School
Investment       Active         Husband        Fixed Income        Private Loan     Car
Investment       Active         Husband        Equity              Real Estate      Homestead       Homestead
Investment       Active         Husband        Equity              Real Estate      Time Share      Condo
Investment       Passive        Partnership    Equity              Real Estate      Partnership     Apartment Bldg
Investment       Active                        Equity
                                Wenzel Analytics                   Stock            ADR             Tips
Investment       Active                        Equity
                                Wenzel Analytics                   Stock            Domestic        Greenblatt
Investment       Active                        Equity
                                Wenzel Analytics                   Stock            Domestic        Mair
Investment       Active                        Equity
                                Wenzel Analytics                   Stock            Domestic        Resilient
Investment       Active                        Equity
                                Wenzel Analytics                   Stock            Domestic        Shadow
Investment       Active                        Equity
                                Wenzel Analytics                   Stock            Domestic        Piotroski Relative Strength
Investment       Active                        Equity
                                Wenzel Analytics                   Stock            Domestic        REIT
Investment       Passive        Fund           Equity              Mutual Fund
Investment       Passive        Fund           Mixed Derivatives   Balanced Fund
Investment       Passive        Fund           Fixed Income        Bond Fund
Investment       Passive        Fund           Equity                               Chile
                                                                   Exchange Traded Fund
Investment       Passive        Fund           Equity                               Emerging Mkts
                                                                   Exchange Traded Fund
Investment       Passive        Fund           Equity                               Energy
                                                                   Exchange Traded Fund
Investment       Passive        Fund           Equity                               Mid-cap
                                                                   Exchange Traded Fund
Investment       Passive        Fund           Equity              Index Fund
Investment       Passive        Fund           Mixed Derivatives   Hedge Fund
Investment       Active         Husband        Tangible Things     Commodities      Sugar
Investment       Active         Husband        Tangible Things     Commodities      Currencies
Investment       Active         Wife           Tangible Things     Collectibles     Art
Investment       Active         Husband        Tangible Things     Collectibles     Antique Auto
Investment       Active         Husband        Tangible Things     Collectibles     Coins
Investment       Active         Husband        Debt                Real Estate      Homestead       Homestead
Investment       Active         Husband        Debt                Real Estate      Time Share      Condo
Investment       Passive        Partnership    Debt                Real Estate      Partnership     Apartment Bldg
Investment       Active                        Debt
                                Wenzel Analytics                   Stock            Margin
                Style          Liquidity     Target Date   Tax Status   Owner   Held At   Account #   Managed By
                               Medium-term
                               Medium-term
                               Long-term
                               Mixed


                               Short-term
                               Short-term
                               Short-term




 ax-sheltered income




                  Small-cap Growth
                  Large-cap Value
                  Large-cap Growth
                  Small-cap Value
Piotroski Relative Strength




                Mid-cap
                Symbol
Designated Purpose       Item Name   Units   Price   Value   Source   Action   Target Price
                         Honda
                         Camry
Date Acquired   Date Sold   Owned/Sold   Purchase Price Basis   Sale Price Sale Value   Gain/Loss Annual Return Last Yr
          Volatility Beta
Annual Return Projected     Trial SharesTrial Cost

				
DOCUMENT INFO