Cash-out refinance net cash and borrowing cost · Calculation guide

Estimate cash received at closing and interest over the new loan’s term.

Calculation guide

End-of-month payments and a fixed nominal annual rate divided by twelve. No fees or early settlement charges.

Net cash = new loan amount − old payoff − closing fees; interest = PMT(new loan,rate,term) × months − new loan.

Inputs

New loan principal

Example entry 250000 (in the selected currency). Minimum 0.01.

Old loan payoff quote

Example entry 180000 (in the selected currency).

Fees

Example entry 5000 (in the selected currency).

Nominal annual interest rate

Example entry 6 %. Allowed range 0 to 100.

Months remaining

Example entry 240. Allowed range 1 to 600. Use whole numbers.

Worked example

InputValue
New loan principal250,000
Old loan payoff quote180,000
Fees5,000
Nominal annual interest rate6%
Months remaining240
ResultValue
Net cash received at closing65,000
New monthly payment1,791.077646
New lifetime interest cost179,858.635087
New interest plus closing fees184,858.635087

Calculation steps

Net cash received at closing = ((New loan principal − Old loan payoff quote) − Fees)

((250,000 − 180,000) − 5,000) = 65,000

New monthly payment = payment(New loan principal, Nominal annual interest rate, Months remaining)

payment(250,000, 6, 240) = 1,791.077646

New lifetime interest cost = ((New monthly payment × Months remaining) − New loan principal)

((1,791.077646 × 240) − 250,000) = 179,858.635087

New interest plus closing fees = (New lifetime interest cost + Fees)

(179,858.635087 + 5,000) = 184,858.635087

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
New loan principal250,000275,000Net cash received at closing65,00090,000
Old loan payoff quote180,000198,000Net cash received at closing65,00047,000
Fees5,0005,500Net cash received at closing65,00064,500
Nominal annual interest rate6%7%New monthly payment1,791.0776461,938.247339
Months remaining240264New monthly payment1,791.0776461,707.686124
Cash-out refinance net cash and borrowing cost →

Sources