The Car Calculator
$9.99
This Google Sheet Does The Following:
PAYMENT CALCULATOR
Fully customize your monthly payment with 7 line items that can be changed. Each line item can be toggled between what you are financing vs. what you plan to pay cash for. Taxes, total loan amount, total cash and total out the door price auto-calculated.
MOBILE CALCULATOR TAB
Easily use the payment calculator on a mobile device via the Google Sheets app.
AUTO LOAN EARLY PAYOFF + AMORTIZATION SCHEDULE
Want to pay off your car loan early? NO PROBLEM! Manually enter in extra principal payments into the amortization schedule. The amount of money you save in interest and the amount of months reduced by making extra payments will auto-calculate.
AFFORDABILITY CALCULATOR
Have a target monthly payment in mind? Enter your desired payment and interest rate and the price of the car you can afford will auto-calculate.
SENSITIVITY TABLES
PAYMENT: View how your monthly payment changes based on different loan terms and interest rates.
FREQUENCY: View how much your monthly payment / total interest paid over life of the changes based on payment frequency
DOWN PAYMENT: View different loan amount and payments based on the percentage down payment you put on the car
DIFFERENT PAYMENT FREQUENCIES
Toggle between 7 different payment frequencies (monthly, bi-weekly, semi-monthly etc.) to see how it impacts your payment and total interest paid over the life of the loan.
CAR COMPARISON
Compare monthly payments for up to 4 cars.
Note: You will receive this as a PDF file that contains the link to download the Google Sheet.
For those of you who are not a fan of pink, there is a neutral *aka boring* version which will also come with your purchase.
Legal: For personal use only. No redistribution, reselling, or modification. All content copyrighted. No refunds. Information provided "as is" without warranty. Creator not liable for any losses or calculation errors. You assume full responsibility for usage.