Lequisha NuestroBusiness and Data Analyst

Business and Data Analyst

Lequisha Nuestro

SchoolBS Computer Engineering, Mapúa University GraduatingApril 2028 Based inParañaque City, Philippines SpeaksEnglish and Filipino, native

I want to build my career in financial services. I have already audited 5,000+ legal and insurance documents for accuracy. On my own, I screened five Philippine banks, valued each with two methods, and wrote a full equity note on China Bank.

Proof in numbers

Pick a group, then press any card to see where its number comes from.

Finance project

Philippine Bank Valuation Tracker

Built withExcel, VBA, PowerPoint Pieces4 Ranked firstChina Bank Prices as ofNov 12, 2026 close

These are student projects for learning. They are not investment advice.

The Excel workbooks will be downloadable here.

I screened five listed Philippine banks in an Excel and VBA workbook, valued each one with a justified P/B method and a dividend model, and wrote a one-page equity note on China Bank, which ranked first.

China Bank earns the highest return on equity of the five at 15.6%, yet trades at only 0.70x book value and 4.8x earnings.

China Bank fair value range. The two methods disagree, so I read them as a range and not as a price target.

Five banks, with FY2025 results
Bank, by my rankingPrice, PHPP/EP/BROEYield
1China Bank50.004.8x0.70x15.6%5.6%
2Metrobank60.955.5x0.65x12.3%8.2%
3Security Bank62.104.0x0.30x7.9%4.8%
4BPI98.907.8x1.10x14.5%5.2%
5BDO Unibank120.807.4x1.01x14.4%3.6%

The ranking averages four factors: P/E, P/B, ROE, and dividend yield. Metrobank's yield includes a PHP 2.00 special dividend. Sources: company FY2025 results, PSE Edge, and stockanalysis.com.

Sector deck

Slide 1 of 6
Slide 1 of 6. Title slide: Philippine Banking Sector Snapshot

One-page equity note, Nov 13, 2026

China Bank ranks first of the five Philippine banks I screened. It earns the highest return on equity at 15.6%, yet trades at only 0.70x book value and 4.8x earnings, and it pays a 5.6% dividend yield. Nine-month 2026 profit grew 12%, so the cheap price is not coming from weak results.

Latest results, nine months of 2026: net income PHP 22.6 billion, net interest margin 4.73%, NPL ratio 1.5%, and CET1 ratio 14.65%.

Two methods, two answers
MethodFair value, PHPAgainst PHP 50.00
Justified P/B90.4+81%
Dividend model35.3-29%

Risks I flagged. NPL coverage dropped from 123% to 102%. Net loans grew 19% against 9% for deposits. Only 26.9% of earnings is paid out. The stock fell 6.0% over 50 trading days.

Valuation note, Nov 13, 2026

On my assumptions, neither stock looks cheap at the Nov 12, 2026 close. The main reason is the Philippine 10-year government bond yield, which reached 8.33% in early November 2026. A higher risk-free rate pushes every fair value down.

SM Prime only matches its price if the discount rate falls to about 8.9%. My rate is 9.9%.

Price against my fair value
CompanyPrice, PHPFair valueGap
SM Prime17.4610.71-39%
Synergy Grid21.2517.35-18%

SM Prime uses a discounted cash flow. Synergy Grid uses a dividend discount model.

Yield sensitivity workbook

This workbook asks one question: how far can the 10-year yield move before a bank's fair value falls below its share price. A VBA macro takes any yield I type in and builds a scenario sheet with fair values and upside for each bank.

The base case uses the 8.33% yield from Nov 4, 2026, a 5% equity risk premium, and 5% long-term growth. The premium and growth rate are my assumptions.

Break-even 10-year yield, where fair value equals price
BankP/B methodDividend model
China Bank15.1%5.9%
Metrobank11.3%8.6%
Security Bank9.5%5.1%
BDO Unibank9.3%3.8%
BPI8.7%5.5%

A bank has room under a method while the actual yield stays below its break-even figure.

Experience

Where I have worked

2025 to present

Narrative Group

Research and Data Operations Specialist / Project Manager

  • Built Talent Publisher, a Chrome extension and Python tool that grew live talent profiles from 313 to about 2,792 in 9 days, beating the 1,500 target.
  • Built a sponsor lead pipeline of 122 sponsor brands across 356 CRM entries, screening out brands with no social presence, and found 16 companies missing from earlier batches.
  • Wrote a 28-page strategy proposal for a global native ad platform on Reddit sentiment and competitor activity, and the client signed the campaign.
  • Analyzed market and competitor data on hundreds of U.S. apparel brands for a client, covering revenue indicators, social following, affiliate programs, pricing, and ad activity.
  • Qualified B2B decision-makers for fintech and insurance clients, and turned CEO meeting recordings into strategy reports.
  • Reached 1,000+ influencers in outreach, and pitched podcast host-read sponsorships that drew 15+ replies.
  • Supported the CEO on 28 projects, with all 143 of my tasks tracked in one logbook.
2025 to 2026

Beagle

Portfolio Analyst / Audit Contractor

  • Audited 5,000+ legal and insurance documents for accuracy and source verification.
  • Verified key data points in complex contracts to keep the compliance database accurate.
  • Spotted recurring inconsistencies and turned them into a review checklist that made audits more consistent.
  • Ranked in the top 5 of 250+ international contractors for speed and precision.
2024

Bro Media

Digital Performance Analyst

  • Tracked daily CPC and spend on native ad platforms and recommended budget changes based on content performance.
  • Localized and verified high-volume campaign data across 15+ languages.
2020 to present

Freelance

Market and Competitor Research Consultant

  • Research products and competitors for international clients across industries.
  • Keep research databases organized and do detailed data entry and cleanup work for clients.

Education

Mapúa University

BS Computer Engineering, specializing in Artificial Intelligence

Graduating April 2028

Relevant coursework

  • Data Structures and Algorithms
  • Engineering Data Analysis

Led the AI4A Hackathon team project and school group coding projects, including the Flower Image Classifier.

Pasay City Science High School

Senior High School, with honors

2022 to 2024

Skills and tools

Finance and analysis

  • Excel with VBA
  • PowerPoint
  • DCF valuation
  • Justified P/B
  • Dividend models
  • Document auditing
  • Source verification
  • Data validation
  • KPI tracking
  • Market and competitor analysis
  • Report writing

Tools

  • SQL
  • Python
  • Power BI
  • Tableau
  • Google Sheets
  • Airtable
  • monday.com CRM
  • Lusha
  • Taboola
  • WordPress
  • ChatGPT

Languages

  • English, native
  • Filipino, native

Certificates

Courses I completed

Completed3 coursesFromHuawei ICT Academy and GoogleYear2026

Press View certificate to see each one right here and check it yourself.

July 7, 2026

Information Representation and Data Organization

Huawei ICT Academy

Completed course
Oct. 12, 2026

Operating System Basics and Practice with openEuler

Huawei ICT Academy

Completed course
Huawei ICT Academy, Python Programming Basics, March 2026. Needs the certificate file.
Meta on Coursera, Programming in Python, March 2026. Needs the certificate file.
University of Virginia on Coursera, Design Thinking for Innovation, February 2025. Needs the certificate file.
DeepLearning.AI on Coursera, AI For Everyone, September 2024. Needs the certificate file.
Mapúa University on Coursera, Introduction to Generative AI and Prompt Engineering, September 2024. Needs the certificate file.

Case studies

Systems I built at work

WhereNarrative GroupSince2025Client namesleft out on purposeStudies4
Data operations

Talent Publisher

Designed, built, and ran the tool

Live talent profiles on the company site grew from 313 to about 2,792 in 9 days, beating the 1,500 target.

Open the full report
Research and CRM

Lead generation engine

Researched and built every lead list

Built a sponsor lead pipeline of 122 sponsor brands across 356 CRM entries, and a university list of 616 contacts across 574 institutions. Podcast sponsorship outreach drew 15+ replies.

Open the full report
Vetting and data checks

Creator sourcing at scale

Sourced, vetted, and shortlisted creators

One repeatable method with my own checking tool behind it. One client approved 29 of 31 creators I presented, and another has 12 creators booked or live.

Open the full report
Tracking and reporting

Executive support and operations

Support for the CEO, and my own tracking systems

Delivered 28 projects across meetings, events, and travel, with all 143 of my tasks tracked in one logbook.

Open the full report
Testimonials go here.

More projects

Other things I built

Python, scikit-learn

Heart Disease Prediction Model

Cleaned and audited a 303-patient clinical dataset, then tuned a logistic regression model that caught 96.4% of heart disease cases with 86.9% accuracy against a 54.1% baseline.

Open the full report
AI4A Hackathon

Project ALON

Participant, team lead

An AI wearable that turns industrial sound into touch. ALON is Filipino for "wave". I led the team and contributed across every part of the build.

PyTorch, Google Colab

Flower Image Classifier

Fine-tuned and compared ResNet50 and MobileNetV3 on 2,744 flower images in 5 classes, and recommended MobileNetV3 at 92.72% test accuracy on a Colab T4 GPU because it is 5.5x smaller.

Open the full report
Python, pytest, UML

ChallengeHub Activity Tracker

Designed and built the activity logging feature of a wellness challenge app with the Strategy pattern, input checks, and atomic saves, and fixed a save-order bug. All 18 tests pass.

Open the full report
FastAPI, ChromaDB, Ollama

Course Compass

Documentation and diagrams

A college course advisor that searches CHED and DepEd documents with a local language model. I wrote documentation sections 4, 6, and 8, fixed parts of the other sections, and made the diagrams.

Open the full report
Python, PySide6, Playwright

IGTTYT Tool

Built at work

A desktop tool that checks creator profiles on Instagram, TikTok, and YouTube from one pasted list and returns a single results table.

About me

Player card

I like building things that make repetitive work easier, and I take apart and rebuild plenty of other things too.

I am a native English and Filipino speaker.

My hobbies

  • Gundam and plamo kits
  • LEGO
  • Jigsaw puzzles
  • Cooking
  • Travel
A professional photo goes here.

Contact

Message me

The quickest ways to reach me are email and WhatsApp.

Done reading? Give me a nudge, so I know my site reached you.

Achievements

Break room

A panda looking straight at the camera

File

Download