<u>Asset Allocation Optimizer</u>
Tab 1: START HERE — Learn the purpose of asset allocation, follow the workbook's setup instructions, and understand the role of risk profiles and portfolio planning before entering personal data.
Tab 2: RISK & GOALS QUIZ — Record your investment timeline, risk tolerance, objectives, liquidity needs, and comfort with volatility to create a structured investor profile.
Tab 3: MODEL PORTFOLIO ENGINE — Explore risk-profile information and model target weights for asset classes including U.S. stocks, international stocks, bonds, real estate, cash, and alternatives.
Tab 4: CURRENT ALLOCATION INPUT — Enter your present portfolio allocation by asset class and check that the percentages add up before comparing them with targets.
Tab 5: RESULTS DASHBOARD — See your profile summary, current-versus-target allocation comparison, and portfolio drift and rebalancing indicators in a consolidated planning view.
<u>Investment Due Diligence Checklist</u>
Tab 1: START_HERE — Follow the workbook's recommended due diligence sequence, from initial screening through opportunity-specific assessment and a final decision record.
Tab 2: QUICK_START — Perform a short initial screening with basic opportunity information and red-flag questions before investing time in deeper research.
Tab 3: STOCKS_DD — Examine an individual stock using structured criteria for business-model clarity, financial performance, management, valuation, and other investment considerations.
Tab 4: ETFS_DD — Examine an ETF or fund using prompts for objectives, portfolio concentration, expenses, tracking, liquidity, and investment fit.
Tab 5: REAL_ESTATE_DD — Organize the core assumptions for a property opportunity, including location, rents, vacancy, operating expenses, returns, and property condition.
Tab 6: BUSINESS_DD — Assess a business investment or acquisition across financial statements, customer concentration, operations, legal considerations, and growth risks.
Tab 7: SCORING_RUBRIC — Apply a consistent 1–5 evaluation scale and category weights so research observations can be summarized systematically.
Tab 8: FINAL_DECISION — Document the investment's key figures, decision status, principal risks, conditions, and next steps after completing your assessment.
Tab 9: ONE_PAGE_SUMMARY — Capture the opportunity, principal metrics, strengths, concerns, and recommendation in a concise, print-oriented record.
<u>Investment Portfolio Tracker</u>
Tab 1: START_HERE — Follow quick-start instructions and read the workbook's educational-use guidance before working with portfolio data.
Tab 2: SETTINGS — Choose a base currency and enter target asset allocation percentages across investment categories for subsequent comparisons.
Tab 3: ACCOUNTS — Organize brokerage, retirement, and other investment accounts with account type, institution, and tax-advantaged status fields.
Tab 4: HOLDINGS — List investments by ticker, asset, class, account, position size, cost basis, and manually entered current prices to organize position-level information.
Tab 5: TRANSACTIONS — Record transaction dates, accounts, instruments, buy/sell or other transaction types, quantities, prices, and related fees.
Tab 6: DASHBOARD — Examine consolidated portfolio figures, allocation-versus-target views, and sections for leading winning and losing holdings.
Tab 7: REBALANCING — Compare asset class weightings against targets, examine drift and suggested actions, and consult guidance for planning future contributions.
<u>Retirement Planning Calculator</u>
Tab 1: START_HERE — Read the setup guide, the calculator's scope, and its educational-purpose disclaimer before working with retirement assumptions.
Tab 2: INPUTS — Enter age, intended retirement age, life expectancy, savings, monthly contributions, investment-return assumptions, and retirement spending information.
Tab 3: PROJECTIONS — Examine the workbook's year-by-year accumulation and retirement-phase model together with projected nest-egg and spending-gap metrics.
Tab 4: RESULTS — View the retirement-readiness dashboard, including the workbook's intended comparison between projected savings, estimated needs, and monthly savings requirements.
Tab 5: SCENARIOS — Compare conservative, moderate, and aggressive return assumptions and their possible effect on retirement projections and estimated savings requirements.
<u>Tax-Loss Harvesting Spreadsheet</u>
Tab 1: Start Here — Learn the educational purpose of tax-loss harvesting, how the tracker is organized, and why wash-sale rules and professional tax guidance matter.
Tab 2: Settings — Enter the tax year, assumed tax rates, wash-sale window, and notes about potential replacement securities used in your planning workflow.
Tab 3: Lots_Holdings — Record securities by purchase lot, share quantities, cost basis, current prices, and unrealized gain or loss information.
Tab 4: Trade_Log — Maintain a dated record of buys and sells, security identifiers, transaction amounts, and accounts to support checking relevant trade activity.
Tab 5: Harvest_Candidates — Examine the workbook's intended loss-candidate view, term classifications, estimated tax impact, wash-sale risk flags, and follow-up notes.
Tab 6: Summary_Dashboard — Consult the summary of unrealized losses, estimated tax benefits, candidate counts, wash-sale warnings, and the tax-impact breakdown.
