refi-analysis

name: refi-analysis description: > Builds a branded multi-page refinance analysis PDF for a borrower and drafts the accompanying email to send with it. Use this skill whenever Adam uploads an Initial Fees Worksheet (IFW) PDF from Arive and wants to present refinance options to a borrower. Also trigger on phrases like "build a refi analysis", "create a refi presentation", "refinance PDF for [name]", "put together options for [name]", "send [name] their refi options", or any time Adam is comparing two or more refinance scenarios for a client. Always use when both a Mortgage Coach screenshot and an IFW are provided together. The skill produces a polished PDF and a ready-to-send Outlook email draft. metadata: version: "1.0" author: "Adam Styer"

Produces a branded, multi-page refinance analysis PDF (Adam Styer | Mortgage Solutions LP) and a matching borrower email. Built from IFW PDFs exported from Arive.

Inputs Required

Before building, collect:

1. Borrower name — full name for the cover
2. IFW PDF(s) — one per option (extract all fee fields)
3. Current loan details — rate, balance, payment (from Mortgage Coach screenshot or borrower-provided)
4. Property value
5. Escrow reimbursement amount — if borrower has confirmed their current escrow balance, use exact figure; otherwise use estimated range ($3,000–$5,000)
6. Property Inspection Waiver? — yes/no (saves $800–$900, call it out if yes)
7. Number of options — typically 2; can be 1 or 3

If any field is missing, ask before building.

Extraction from IFW PDF

For each IFW, extract:

PDF Structure

Build with reportlab (pip install reportlab --break-system-packages).

Brand Colors

NAVY     = "#0A1628"
GOLD     = "#C9A84C"
GOLD_LT  = "#F0D98A"
LIGHT_BG = "#F2F0EB"
HIGHLIGHT= "#FFF3CD"
MID_GRAY = "#8A8A8A"
GREEN    = "#2A7A4B"

Header / Footer (every page)

• Top bar: NAVY background, "Adam Styer | Mortgage Solutions LP" in white
• Gold accent line below header
• Sub-line: "NMLS #513013 · (512) 956-6010 · styermortgage.com" in GOLD_LT
• Date top right in GOLD_LT
• Footer: NAVY bar, disclaimer text in MID_GRAY centered

Page 1 — Intro + Snapshot + Option Cards

• Borrower name + "Refinance Analysis" as H1
• Prepared by line in MID_GRAY
• Gold HR divider
• 2–3 sentence intro (acknowledge what they've done, frame the analysis)
• Current Loan at a Glance: 4-column table (Property Value, Loan Balance, Current Rate, Current Payment)
• Option cards side by side (one per IFW):
  • Non-recommended card: dark charcoal header, LIGHT_BG body, gray border
  • Recommended card: NAVY header, dark navy body (#0D1F3C), GOLD border, all text WHITE or GOLD
  • Each card shows: rate (large), APR, P&I/mo, total payment w/ escrow, cash to close
  • Tag recommended card with "★ RECOMMENDED"
• Footnote: clarify P&I only, escrow adds ~$X/mo

Page 2 — Adam's Take + Breakeven

• "Adam's Take" section header
• NAVY header bar: "Here's how I'd think about it:"
• 3–4 bullet rows: when to choose each option, why either is a win, PIW callout
• Breakeven comparison table: cash to close, monthly P&I, monthly savings, breakeven months

Page 3 — Full Cost Breakdown + Escrow Callout + Monthly Payment + Next Steps

• Full fee table with both options as columns (highlight waived fees in GREEN)
• Section headers for: Lender Fees, Third Party Fees, Title & Settlement, Government Fees, Prepaids & Escrow
• TOTAL CASH TO CLOSE row in NAVY
• Escrow callout box (HIGHLIGHT background, GOLD border):
  • Explain escrow funding portion of cash to close
  • State exact reimbursement check amount if known
  • Show "True Out-of-Pocket" table: headline cash to close − reimbursement = net cost
• Monthly payment breakdown table (both options as columns)
• Next Steps (3 items): choose option, lock rate, no appraisal (if PIW)
• CTA footer bar: NAVY background, GOLD border, contact info

Layout Rules

• Use KeepTogether on any section header + its table to prevent orphaned headers
• Use PageBreak() before Page 2 and Page 3
• Left/right margins: 0.4"
• Top margin: 0.85" (clears header bar)
• Bottom margin: 0.65" (clears footer bar)

Output File

Save to: /mnt/user-data/outputs/[LastName]_Refinance_Presentation.pdf

Call present_files after building.

Email Draft

After the PDF, draft a borrower email:

Subject: Updated Refinance Analysis — [First Name]

Body structure:

1. One line: what's attached and what it reflects (updated balance, two options, etc.)
2. Bullet each option: rate, cash to close, true out-of-pocket after escrow reimbursement
3. Monthly payment difference + breakeven framing (X months)
4. Escrow reimbursement explanation (1–2 sentences, exact amount if known)
5. PIW callout if applicable (no appraisal, saves $800–$900)
6. One closing question: which direction are you leaning?
7. Signature: Adam Styer / Mortgage Solutions LP / NMLS #513013 / (512) 956-6010 / styermortgage.com

Use message_compose_v1 tool with kind="email".

Iteration Notes (update as you improve this skill)

• v1.0 (2026-03-10): Initial build from Dhaval Poladia refi session. Two-option layout. Lessons learned:
  • Green-on-green cards are unreadable — recommended card must be NAVY bg with WHITE/GOLD text
  • Use KeepTogether on monthly payment header + table to prevent orphan headers
  • Always confirm loan balance with borrower before building — IFW may lag a payment
  • Use exact escrow reimbursement amount when borrower provides it; don't use estimated range
  • IFW files from Arive are sometimes HTML-formatted .xls — parse with pandas.read_html if needed
  • Date in header should match IFW preparation date, not session date

Common Variations