Refinance Scenario Builder
Prepared by Bill Lewis, NMLS #233784
Refinance Scenario Builder
Notes
Enter a description of the Scenarios you are building. Fill in values for all data input fields below
Property Details
Annual Income
Monthly Expenses After Refi
Scenario #1
Conv 30 yr fixed
Loan Details
Payoffs
Subtotal Payoffs$265,500.00
Loan Fees
Subtotal Fees$3,460.00
Results
New Loan Amount$268,960.00
Loan to Value44.83%
Base Payment$1,700.01
Monthly MI$0.00
Monthly Taxes$541.67
Monthly Insurance$200.00
Monthly HOA$0.00
Total Monthly Cost$2,441.68
Difference—
Debt-to-Income Ratios
Monthly Income$10,000.00
Housing DTI24.42%
Combined DTI40.42%
Scenario #2
Conv 30 yr fixed
Loan Details
Payoffs
Subtotal Payoffs$265,500.00
Loan Fees
Subtotal Fees$3,460.00
Results
New Loan Amount$268,960.00
Loan to Value44.83%
Base Payment$1,677.96
Monthly MI$0.00
Monthly Taxes$541.67
Monthly Insurance$200.00
Monthly HOA$0.00
Total Monthly Cost$2,419.63
Difference$0.00
Debt-to-Income Ratios
Monthly Income$10,000.00
Housing DTI24.20%
Combined DTI40.20%
Scenario #3
Conv 30 yr fixed
Loan Details
Payoffs
Subtotal Payoffs$265,500.00
Loan Fees
Subtotal Fees$3,460.00
Results
New Loan Amount$268,960.00
Loan to Value44.83%
Base Payment$1,656.03
Monthly MI$0.00
Monthly Taxes$541.67
Monthly Insurance$200.00
Monthly HOA$0.00
Total Monthly Cost$2,397.70
Difference$0.00
Debt-to-Income Ratios
Monthly Income$10,000.00
Housing DTI23.98%
Combined DTI39.98%
Debt Ratio should be within Guidelines
Debt Ratio is approaching maximum
May Exceed Debt Ratio Limits