Multi-Asset Portfolio Allocator

What's New in v2.0 — Complete Overhaul

The original portfolio allocator has been completely rebuilt from the ground up. 12 integrated sheets, 50+ automated calculations, and professional-grade risk analysis — all in one workbook.

What's Inside (12 Sheets)

📊 Dashboard

• Total portfolio value, holding count, and best/worst performers at a glance
• Asset allocation summary with target vs. actual weights and drift alerts
• Rebalancing summary (count and value of buys/sells needed)
• Portfolio risk metrics: beta, volatility, weighted return, Sharpe ratio
• Quick navigation panel to all sheets

📖 How to Use

• Step-by-step walkthrough for every feature
• Best practices for rebalancing frequency and threshold setting
• Tips on using correlation, risk analysis, and scenario modeling

💼 Asset Entry

• 50 position slots with auto-calculating market value, cost basis, and returns
• Data validation dropdowns for asset class and position status
• Auto-calculated return percentage, target weight, and drift status for each holding
• Total row with portfolio-level return

🎯 Target Allocation

• 8 asset class target weights with adjustable inputs
• Auto-calculated current weights from your holdings
• Drift tracking with dollar and percentage differences
• BUY / SELL / HOLD signals with color-coded status indicators
• Configurable rebalancing threshold and risk-free rate

⚖️ Rebalancing Calculator

• Exact dollar amounts to buy or sell for each position
• Share count calculations based on current prices
• Priority ranking (High/Medium/Low) based on drift magnitude
• Conditional formatting: green for buys, red for sells

📈 Performance Attribution

• Returns by position with contribution to total portfolio return
• Ranking system showing best and worst performers
• P&L in dollars for each position
• Win rate analysis (winning vs. losing positions count)
• Portfolio-level performance summary

🔗 Correlation Matrix

• 8×8 correlation matrix across all asset classes
• Color-coded cells: green for negative correlation (good diversification), red for high positive
• Diversification score calculation
• Historical average returns, volatility, Sharpe ratios, and max drawdowns for reference

⚠️ Risk Analysis

• Portfolio-level beta, volatility, and weighted average return
• Sharpe ratio estimation
• Value at Risk (VaR) at 95% and 99% confidence levels
• Concentration risk indicator
• Per-position risk analysis with beta contribution and risk scoring

🎭 Scenario Modeling

• Best-case, base-case, and worst-case annual return assumptions per asset class
• Portfolio value projections at 1, 3, 5, and 10 years for each scenario
• Monthly contribution impact calculator (with FV formula)
• Adjustable assumptions to model different market environments

📅 Historical Returns

• 24-month tracking sheet for portfolio values over time
• Auto-calculated monthly change ($ and %), YTD return, and annualized return
• Contribution and withdrawal tracking with net flow analysis
• Time-weighted return calculations

👁️ Watchlist

• Track up to 20 potential investments
• Data validation for risk level, conviction score, and action status
• Priority score formula combining expected return, risk, and conviction

📝 Changelog

• Complete version history with detailed changelog entries

Who It's For

Individual investors managing a multi-asset portfolio who want professional-grade analysis without paying for expensive software. Whether you're running a simple 3-fund portfolio or a complex allocation across stocks, bonds, real estate, commodities, and crypto — this workbook gives you institutional-level insight.

Technical Details

• Compatible with Excel, Google Sheets, LibreOffice Calc
• XLSX format — no macros, no add-ins required
• 12 integrated sheets with cross-sheet formulas
• All formulas use IFERROR wrappers for clean error handling
• Data validation dropdowns prevent input errors
• Conditional formatting for instant visual status checks
• Works offline — no internet connection needed

Recent Updates

• v2.0 (Apr 2026): Complete overhaul — expanded from 5 features to 12 integrated sheets with 50+ automated calculations. Added Dashboard, How to Use, Asset Entry (50 positions), Target Allocation, Rebalancing Calculator, Performance Attribution, Correlation Matrix with diversification scoring, Risk Analysis (beta, VaR, Sharpe), Scenario Modeling (Best/Base/West projections), Historical Returns tracker, Watchlist, and Changelog. Added data validation dropdowns, conditional formatting, cross-sheet integration, and professional styling throughout.