DEV Community

Brandon Sooknanan for StatementReady

Posted on Originally published at statementready.net

LTV, CLTV and HCLTV on a Mortgage Loan File (Free Calculator)

By Brandon Sooknanan, Founder of StatementReady

A loan file has an income side and a property side. LTV is the property side: the loan against the value. Lender definitions of value and of which liens count can vary; cite only sources named on the tool page and confirm with the lender for the specific loan.

Formulas

From the LTV and CLTV calculator:

  • LTV = first mortgage loan amount ÷ property value
  • CLTV = (first loan + closed-end second lien balances + HELOC drawn balance) ÷ property value
  • HCLTV uses the full HELOC line in place of the drawn balance

Percents to two decimals, rounded half-up. The calculator sets no limit.

What value is used

Purchase: lower of sales price and appraised value. Refinance: appraised value. The page notes this follows one published convention; check the value the lender uses for the specific loan.

Worked example (page numbers only)

  • Purchase: sales price $400,000, appraised value $410,000 → value used $400,000
  • First mortgage $360,000 → LTV 90.00%
  • HELOC $20,000 drawn → CLTV 95.00%
  • HELOC full line $40,000 → HCLTV 100.00%
  • Equity $20,000

Round numbers for illustration only, not a limit.

Rounding note

The calculator shows two decimals, half-up. Fannie Mae Selling Guide B2-1.2-01 says results must be truncated to two decimals, then rounded up to the nearest whole percent. State both; lenders may round differently.

Sourced quotes (Fannie Mae Selling Guide)

B2-1.2-01 (06/01/2022): "Divide the original loan amount by the property value. (The property value is the lower of the sales price or the current appraised value.)"

B2-1.2-02 (12/04/2018): "The CLTV ratio is determined by dividing the sum of the items listed below by the lesser of the sales price or the appraised value of the property."

B2-1.2-03 (02/23/2016): includes "the full amount of any HELOCs (whether or not funds have been drawn)."

Same B2-1.2-01 rounding line: "The result of these calculations must be truncated (shortened) to two decimal places, then rounded up to the nearest whole percent."

What it doesn't do

  • No lending decision and no LTV/CLTV/HCLTV limit
  • Does not add financed mortgage insurance or fees to the loan amount (enter the loan amount the lender uses)
  • Does not look up property values
  • Runs in the browser; what you type isn't sent or stored

Related free tools: mortgage DTI calculator, DSCR calculator, bank statement income calculator, all free tools.

When you're ready to work from the real statements, StatementReady checks whether each statement's transactions add up to its printed balances. It assists review of loan files; the lender makes all underwriting decisions.

Not legal or tax advice. StatementReady isn't affiliated with or endorsed by Fannie Mae or any lender named here.

Top comments (0)