Many renovations are paid for with a loan, and the true cost is more than the project price. This home improvement loan calculator takes the project cost, the interest rate, the term, the origination fee and the resale value added to give the loan amount, the monthly payment, the cost of financing, the total repaid and the cost not recovered when you sell.
How the calculation works
- Loan amount = cash needed ÷ (1 − origination fee). The fee is taken from the loan, so you borrow a little more than the project costs.
- Monthly payment = loan × r ÷ (1 − (1 + r)^−n), with r the monthly rate and n the number of months.
- Cost of financing = total repaid − cash received. It is the interest plus the fee.
- Cost not recovered = project cost + cost of financing − resale value added, which shows how much the project costs you beyond what you may get back when you sell.
Example
You need $30,000 for a project and borrow it at 8% over 7 years with a 2% origination fee. The loan is 30,000 ÷ 0.98 = $30,612, the monthly payment is $477.1, and you repay $40,079 in total. The cost of financing is $10,079. If the project adds 70% of its cost to the resale value, or $21,000, about $19,079 of the total outlay is not recovered.
Why it matters
Homeowners use the numbers to decide between a loan and savings, to compare lenders and to set a budget that includes financing. Seeing the cost not recovered at resale helps to weigh a project that is for comfort rather than for value.
Good to know
The calculator assumes a fixed rate, equal monthly payments and a fee that is taken from the loan. Real offers may include other fees, variable rates, or tax deductions on some home equity loans that change the result. The resale value added is a guess, and actual values depend on the market. This is for planning only and is not financial advice.
Related tools
The personal loan calculator works out the payment for any loan, the kitchen remodel calculator estimates the cost of a kitchen and the bathroom remodel calculator does the same for a bathroom.