Portfolio Theory

profilepateldixit0000
CopyofSamplePortfolioTheoryProject.xlsx

Sheet1

Growth Invested Amounts Year 1 New Allocations Trades Proceeds Tax
Equity 90% 900,000 1025400 91.20% -0.2
Large Cap Value 22 220,000 242000 21.52% 0.48
Pepsi
JNJ
Blackrock Large Cap Value
IWD
Large Cap Growth 22 220,000 242000 21.52% 0.48
AAPL
MSFT
T Rowe Price Large Cap Growth
IWF
Small Cap Growth 13 130,000 143000 12.72% 0.28
CDXS
Vanguard Small cap Growth Fund
IWO
International 25 250,000 300000 26.68% -1.68 18889.92 15111.936
Nestle ***
EFG
EFV
Emerging Markets 8 80,000 98400 8.75% -0.75 120.895488
VWO ***
Parametrics Emerging Markets
Fixed Income 2% 20,000 19000 1.69% 0.31
Tax-free Bonds
State of DEL GO 2% due 4-30/2020
Wilmington Tax Free Fund
Real Assets 2% 20,000 20000 1.78% 0.22
Inflation Protected Securities
TIPS
Franklin Commodity Fund
Hedge Funds 5% 50,000 50000 4.45% 0.55
Blackrock Long/Short Fund
Cash 1% 10,000 10000 0.89% 0.11
Vanguard Money Market Fund
Total 100% 1,000,000 1124400 100.00% 100.00%

Sheet2

Sheet3