Free Template
Investment Portfolio Template
Master portfolio tracker with asset allocation, sector diversification, and rebalancing alerts.
Template Content
Portfolio Master Tracker ======================= 1. Asset Allocation Table -------------------------- Asset Class | Target % | Current Value | Current % | Variance | Action Australian Equities | 40% | [Value] | =C5/Total | =D5-B5 | [Formula] International Equities | 30% | [Value] | =C6/Total | =D6-B6 | [Formula] Fixed Interest | 20% | [Value] | =C7/Total | =D7-B7 | [Formula] Cash | 10% | [Value] | =C8/Total | =D8-B8 | [Formula] Total | 100% | =SUM(C5:C8) | 100% | - | - 2. Performance Monitoring ------------------------- - Portfolio Opening Balance: [Value] - Net Contributions: [Value] - Portfolio Closing Balance: [Value] - Total Return ($): =Closing - (Opening + Contributions) - Simple Return (%): =Total Return / (Opening + Contributions) 3. Rebalancing Logic (Formula for 'Action' column): ------------------------------------------------- =IF(ABS(Variance)>0.05, "REBALANCE", "OK") (Flags assets that have drifted more than 5% from their target allocation.)
How to Use This Template
- 1
Define your 'Target Allocation' based on your risk tolerance.
- 2
Input the current market value of all your holdings grouped by asset class.
- 3
Calculate the 'Current %' for each class relative to the total portfolio value.
- 4
Use the 'Action' column formula to identify where you need to rebalance.
- 5
Update your 'Closing Balance' monthly to calculate your portfolio's growth.
Pro Tips
Use Excel's 'STOCKHISTORY' or 'Stocks' data type to pull real-time prices for your tickers.
Don't rebalance too often: Aim for quarterly or bi-annual adjustments to minimize brokerage fees.
Include your Superannuation balance for a true 'Whole of Wealth' view.
Ivy Sinclair-Wren
Financial Chaos Analyst
Ivy Sinclair-Wren is a Financial Chaos Analyst covering investing, AI, wealth psychology, and the emotional consequences of opening finance apps during market crashes. Based in Melbourne, she specializes in demystifying the Australian tax code and helping users navigate the intersection of spreadsheet logic and human irrationality.