Complete AI Training
Sign inGet my AI kit

Your job's AI kit

Get your AI kit

Tell us who you are and what you do. We show you your kit right away and email you the link: skills, prompts, AI agents, MCP servers and courses for your job.

500+ jobs ready, and we make a kit for any other job. No payment needed to look.

Share

AI agent for loan officers

Income and Debt-to-Income Calculation Agent

Accurate qualifying income and debt-to-income ratio per program rules

Income and Debt-to-Income Calculation Agent: what goes in, what the agent does and what you get

What it does

Qualifying income and debt-to-income ratio decide what a borrower can be offered, and errors lead to bad quotes or denied loans later. This agent reads pay stubs, W-2s, tax returns and the credit report. It applies program rules: averaging overtime and bonus over two years, using business income from returns for self-employed borrowers, and counting debts from the credit report, including the rule for debts with under 10 payments left. It checks that year-to-date figures support the income used. If income is declining or figures conflict, it uses the lower supported figure, notes the reason and asks for a written explanation. It flags any ratio above the program maximum. The loan officer reviews the full calculation before quoting terms. Edge case: overtime fell 30 percent this year, so the agent uses the lower current figure rather than the two-year average.

How it works

Follow the arrows from top to bottom. The orange dashed arrow is the loop: when a check fails, the agent goes back and tries again.

Start and resultWhat it doesA check on its own workWaits for your OKGoes back and retries
Yes, continueApprovedNo 1 STARTS WHEN Income documents received 2 USES A TOOL Read income documents and credit report 3 DOES Calculate qualifying income by type 4 DOES Total monthly debts 5 CHECKS THE RESULT Do year-to-date figures support the income used? If not: use the lower supported figure and note thereason. Back to step 3. 6 DOES Calculate debt-to-income ratio 7 YOU APPROVE Loan officer reviews 8 RESULT Income worksheet saved
Read the steps as a list
  1. Income documents received
  2. Read income documents and credit report
  3. Calculate qualifying income by type
  4. Total monthly debts
  5. Do year-to-date figures support the income used?If not: use the lower supported figure and note the reason. Back to step 3.
  6. Calculate debt-to-income ratio
  7. Loan officer reviewsThe agent waits here for your OK.
  8. Income worksheet saved

How it decides

It applies the program's income rules and uses the lower figure when income is declining.

  • Variable income declining: use current lower amount
  • Debt with under 10 payments left: follow program rule
  • DTI over program max: flag

Make it yours

Every agent is a starting point. You choose these settings for your own situation.

  • Programs and rules
  • Income types
  • DTI limits
  • Worksheet format

What keeps you in control

It always asks you first

  • Using the figures to quote terms

Hard limits

  • Never makes credit decisions
  • Never shares figures with the borrower without approval

It stops when

  • Done: worksheet saved
  • Stop: missing tax returns for self-employed borrower

Set it up

We guide you through the set-up, step by step

Members get the full set-up guide for this agent. No technical skills needed: you copy, paste and upload.

10 minto set it up in your AI
5 AIsChatGPT, Claude, Copilot, Gemini, Grok
  • One set of instructions to paste into your AI, with the clicks for ChatGPT, Claude, Microsoft 365 Copilot, Gemini and Grok
  • The agent then walks you through connecting your own data, one source at a time
  • A downloadable copy with the flow chart, the rules and the full guide
Get access to this agent

An example run

What happensFor a borrower's file on August 4, overtime was $14,000 last year but only $9,800 annualized this year. The year-to-date check failed because income was declining, so the agent went back and used the lower $9,800 instead of the two-year average. That moved debt-to-income from 41% to 43%, still under the 45% limit. The loan officer reviewed the worksheet and accepted the figure.

More agents for loan officers