How to use this tool
Check the units, enter your values, and run the tool. Results follow the assumptions and method below.
Calculation method
(price-down)*(exempt == 1 ? 0 : (down/price >= 0.1 ? 0.0125 : (down/price >= 0.05 ? 0.015 : (subsequent == 1 ? 0.033 : 0.0215))))((price-down)*(1+financed*(exempt == 1 ? 0 : (down/price >= 0.1 ? 0.0125 : (down/price >= 0.05 ? 0.015 : (subsequent == 1 ? 0.033 : 0.0215))))))(apr == 0 ? ((price-down)*(1+financed*(exempt == 1 ? 0 : (down/price >= 0.1 ? 0.0125 : (down/price >= 0.05 ? 0.015 : (subsequent == 1 ? 0.033 : 0.0215))))))/(years*12) : ((price-down)*(1+financed*(exempt == 1 ? 0 : (down/price >= 0.1 ? 0.0125 : (down/price >= 0.05 ? 0.015 : (subsequent == 1 ? 0.033 : 0.0215))))))*(apr/1200)/(1-(1+apr/1200)^(-years*12)))(apr == 0 ? ((price-down)*(1+financed*(exempt == 1 ? 0 : (down/price >= 0.1 ? 0.0125 : (down/price >= 0.05 ? 0.015 : (subsequent == 1 ? 0.033 : 0.0215))))))/(years*12) : ((price-down)*(1+financed*(exempt == 1 ? 0 : (down/price >= 0.1 ? 0.0125 : (down/price >= 0.05 ? 0.015 : (subsequent == 1 ? 0.033 : 0.0215))))))*(apr/1200)/(1-(1+apr/1200)^(-years*12)))+escrow(apr == 0 ? ((price-down)*(1+financed*(exempt == 1 ? 0 : (down/price >= 0.1 ? 0.0125 : (down/price >= 0.05 ? 0.015 : (subsequent == 1 ? 0.033 : 0.0215))))))/(years*12) : ((price-down)*(1+financed*(exempt == 1 ? 0 : (down/price >= 0.1 ? 0.0125 : (down/price >= 0.05 ? 0.015 : (subsequent == 1 ? 0.033 : 0.0215))))))*(apr/1200)/(1-(1+apr/1200)^(-years*12)))*years*12-((price-down)*(1+financed*(exempt == 1 ? 0 : (down/price >= 0.1 ? 0.0125 : (down/price >= 0.05 ? 0.015 : (subsequent == 1 ? 0.033 : 0.0215))))))