PH Stock Preference & Allocation (Excel) Budget-Fit Finder for PSE Investors

Every beginner hits the same wall: "I have money ready. I just don't know what to buy."

Guru pages will happily tell you what to buy. This template does something better: it shows you what actually fits your budget real PSE board lots and all then lets YOUR rules pick the shortlist. A screener, not a guru.

✅ Enter your budget. See every stock that fits. Type ₱10,000 (or any amount) and how many stocks you want to hold. Instantly see which of the 50 built-in PSE dividend payers fit your per-slot budget, ranked from the cheapest board-lot entry up. With ₱10,000 across 3 slots, 32 of 50 fit cheapest doors open from around ₱560.

✅ Board lots — the thing most beginners don't even know exists. The PSE sells shares in minimum bundles. A "cheap" ₱7 stock can cost ₱700 to enter; a ₱913 stock might need ₱9,130. This template auto-detects every board lot from the official PSE table, so every suggested buy is actually executable at your broker.

✅ Screen with YOUR rules including a built-in yield-trap filter. Set minimum yield, maximum yield, and max entry cost. The shortlist rebuilds itself instantly. The max-yield rule quietly filters out "yield traps" stocks whose sky-high yields come from crashing prices and the sheet explains why. The tool teaches while it filters.

✅ Build a diversified basket in minutes. Pick up to 10 stocks from dropdowns. Lots, shares, cost, leftover cash, and estimated annual dividends auto-calculate. Set sector targets (say, 30% REITs) and watch your basket compared against them live with an automatic warning if two picks share a sector.

✅ 50 PSE dividend payers built in. Every stock in the reference is a large-cap PSE company with an active dividend program screened for income relevance, grouped by sector, with editable prices and yields. Appearing on the list is factual data, never a recommendation.

✅ Fully editable, no macros, no subscriptions. Pure Excel formulas you can inspect. Works in Excel and imports to Google Sheets. Buy once it's yours forever, downloadable anytime from your library.

What's inside (4 sheets):

• Cover & step-by-step Guide
• Stock Preference — 50 PSE dividend payers grouped by sector, with auto board lots
• Allocation — budget inputs, "cheapest doors" ranked list, sector allocation targets, 10-slot basket builder with sector-diversity check, and the criteria screener shortlist

Who this is for: Anyone with a starting amount and decision paralysis from your first ₱1,000 to a ₱100,000 build-out. Perfect before your first buy, and pairs with the PH Dividend Portfolio Tracker for after.

Instant digital download. Excel (.xlsx), no macros, Google Sheets compatible.

OJPH Templates | For personal use. Educational tool not financial advice. The stock list is factual market data; passing the screen means matching your criteria, not a buy signal. Prices are dated samples always update and confirm with your broker. Dividends are never guaranteed.