




















Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
investing investing investing investing investing investing wqertyetyuui
Typology: Essays (university)
1 / 28
This page cannot be seen from the preview
Don't miss anything!
Directions (See the Read Me sheet for more details) Rebalancing Parameters Enter desired change in portfolio value Trigger Factor: 10.0% Portfolio Value Change (optional) $ Adjustment Factor: 0.0% Asian Stocks 9.00% ### Foreign Equities $9,000 $10,780 10.78% 31.0% +1.78% Remove $1,933 $8,848 8.85% 29.0% European Stocks 12.00% Foreign Equities $12,000 $12,382 12.38% +0.38% $12,382 12.38% Emerging Mkts 8.00% Foreign Equities $8,000 $7,812 7.81% -0.19% $7,812 7.81% Lg Cap Growth 12.00% ### US Equities $12,000 $12,341 12.34% 26.7% +0.34% $12,341 12.34% 26.7% Lg Cap Value 4.00% US Equities $4,000 $4,088 4.09% +0.09% $4,088 4.09% Lg Cap Blend 0.00% US Equities $0 $0 0.00% +0.00% $0 0.00% Mid Cap Growth 0.00% US Equities $0 $0 0.00% +0.00% $0 0.00% Mid Cap Value 0.00% US Equities $0 $0 0.00% +0.00% $0 0.00% Mid Cap Blend 5.00% US Equities $5,000 $5,026 5.03% +0.03% $5,026 5.03% Sm Cap Growth 0.00% US Equities $0 $0 0.00% +0.00% $0 0.00% Sm Cap Value 5.00% US Equities $5,000 $5,233 5.23% +0.23% $5,233 5.23% Sm Cap Blend 0.00% US Equities $0 $0 0.00% +0.00% $0 0.00% Micro Cap 0.00% US Equities $0 $0 0.00% +0.00% $0 0.00% Gold 4.00% ### Hard Assets $4,000 $8,172 8.17% 13.7% +4.17% Remove $4,529 $3,643 3.64% 12.7% Commodities 5.00% Hard Assets $5,000 $5,340 5.34% +0.34% $5,340 5.34% REITs 4.00% Hard Assets $4,000 $207 0.21% -3.79% Add $3,468 $3,675 3.68% Domestic Bonds 1.00% ### US Bonds $1,000 $3,846 3.85% 19.2% +2.85% Remove $3,090 $756 0.76% 19.7% Municipal Bonds 11.00% US Bonds $11,000 $11,276 11.28% +0.28% $11,276 11.28% Real Ret. Bonds 8.00% US Bonds $8,000 $4,097 4.10% -3.90% Add $3,569 $7,666 7.67% Foreign Bonds 6.00% 6.0% Foreign Bonds $6,000 $6,244 6.24% 6.2% +0.24% $6,244 6.24% 6.2% Cash 1.00% 6.0% Cash $1,000 $905 0.90% 3.2% -0.10% $905 0.90% 5.7% Short Term CDs 5.00% Cash $5,000 $2,250 2.25% -2.75% Add $2,515 $4,765 4.76% Total 100.00% 100,000 100,000 $100,000 100.00% Portfolio breakdown based on reaction to macroeconomic factors Inflation Breakdown Dollar Breakdown World GDP Breakdown Inflation Neutral 57.7% Dollar Neutral 22.4% GDP Neutral 8.2% Favors Inflation 17.8% Favors Strength 26.7% Favors Growth 63.2% Favors Deflation 24.5% Favors Weakness 50.9% Favors Slowdown 28.6% 100% 100% 100% Edit cells that are shaded in yellow or striped yellow to see resulting "Rebalancing Action." Values for the "Current Allocation" column come from Imported Data worksheet. (Note: The Detailed Asset Class names must match the names used in the Asset Class Info worksheet. Also, you can mouse over cells with red comment indicators to read comments. Detailed Asset Class Target Percent Overall Percent Major Asset Class Target Amount Current Allocation Current Percent Current Overall Percent Difference Rebalancing Action Adjusted Allocation Adjusted Percent Adjusted Overall Foreign Equities US Equities Hard Assets US Bonds Foreign Bonds Cash 0% 5% 10% 15% 20% 25% 30% 35% (^) Overall Asset Allocation Target Current Adjusted Overall Allocation Foreign Equities US Equities Hard Assets US Bonds Foreign Bonds Cash
Economic Scenario M
Detailed Asset Class Table
Asian Stocks Foreign Equities $10,780 10.8% Inflation Neutral Favors Weakness Favors Growth European Stocks Foreign Equities $12,382 12.4% Inflation Neutral Favors Weakness Favors Growth Emerging Mkts Foreign Equities $7,812 7.8% Inflation Neutral Favors Weakness Favors Growth Lg Cap Growth US Equities $12,341 12.3% Inflation Neutral Favors Strength Favors Growth Lg Cap Value US Equities $4,088 4.1% Inflation Neutral Favors Strength Favors Growth Lg Cap Blend US Equities $0 0.0% Inflation Neutral Favors Strength Favors Growth Mid Cap Growth US Equities $0 0.0% Inflation Neutral Favors Strength Favors Growth Mid Cap Value US Equities $0 0.0% Inflation Neutral Favors Strength Favors Growth Mid Cap Blend US Equities $5,026 5.0% Inflation Neutral Favors Strength Favors Growth Sm Cap Growth US Equities $0 0.0% Inflation Neutral Favors Strength Favors Growth Sm Cap Value US Equities $5,233 5.2% Inflation Neutral Favors Strength Favors Growth Sm Cap Blend US Equities $0 0.0% Inflation Neutral Favors Strength Favors Growth Micro Cap US Equities $0 0.0% Inflation Neutral Favors Strength Favors Growth Gold Hard Assets $8,172 8.2% Favors Inflation Favors Weakness GDP Neutral Commodities Hard Assets $5,340 5.3% Favors Inflation Favors Weakness Favors Growth Energy Hard Assets $0 0.0% Favors Inflation Favors Weakness Favors Growth Timber Hard Assets $0 0.0% Favors Inflation Favors Weakness Favors Growth REITs Hard Assets $207 0.2% Favors Inflation Favors Weakness Favors Growth Domestic Bonds US Bonds $3,846 3.8% Favors Deflation Dollar Neutral Favors Slowdown Municipal Bonds US Bonds $11,276 11.3% Favors Deflation Dollar Neutral Favors Slowdown Real Ret. Bonds US Bonds $4,097 4.1% Favors Inflation Dollar Neutral Favors Slowdown Foreign Bonds Foreign Bonds $6,244 6.2% Favors Deflation Favors Weakness Favors Slowdown Cash Cash $905 0.9% Favors Deflation Dollar Neutral Favors Slowdown Short Term CDs Cash $2,250 2.3% Favors Deflation Dollar Neutral Favors Slowdown $100,000 100.0% Major Asset Class Table Allocation^ Percent^ Target^ Portfolio breakdown based on reaction to macroeconomic factors Foreign Equities $30,975 31.0% 29.0% Inflation Breakdown Dollar Breakdown World GDP Breakdown US Equities $26,689 26.7% 26.0% Inflation Neutral 57.7% Dollar Neutral 22.4% GDP Neutral 8.2% Hard Assets $13,719 13.7% 13.0% Favors Inflation 17.8% Favors Strength 26.7% Favors Growth 63.2% US Bonds $19,220 19.2% 20.0% Favors Deflation 24.5% Favors Weakness 50.9% Favors Slowdown 28.6% Foreign Bonds $6,244 6.2% 6.0% 100% 100% 100% Cash $3,155 3.2% 6.0% $100,000 100.0% 100.0% Security Table Portfolio Total: $100,000 Imported Portfolio Total: $100, Number of Securities: 18 Imported Security Count: 18
American Century Intl Bond $6,244 Foreign Bonds 100% 0% 0% 0% 100% CD (6 month) $2,250 Short Term CDs 100% 0% 0% 0% 100% Precious Metals Fund $2,817 Gold 100% 0% 0% 0% 100% Municipal Bond Fund $11,276 Municipal Bonds 100% 0% 0% 0% 100% Oakmark Fund $3,636 Lg Cap Value 100% 0% 0% 0% 100% PIMCO Commodity Real Return $5,340 Commodities 100% 0% 0% 0% 100% StreetTracks Gold $5,355 Gold 100% 0% 0% 0% 100% Van Growth Index $12,341 Lg Cap Growth 100% 0% 0% 0% 100% Van Intntl Index - Emerg. Mkt $7,812 Emerging Mkts 100% 0% 0% 0% 100% Van Intntl Index - European $12,382 European Stocks 100% 0% 0% 0% 100% Major Asset Class Total Allocation (from Import) Current Value (from Import) Total Percent
A4 below and paste the data from the Quicken report into this sheet. Do not insert or remove rows from this sheet or the na
THE DATA ON THIS SHEET IS AUTO-GENERATED FROM THE IMPORTED DATA S