Loan Calculator Google Sheets Template
These numbers and formulas might not be accurate or appropriate for your situation.
Loan calculator google sheets template. Amort sched with extra payments loan data if you want to plug in your own numbers click file make a copy. Scenario 1 to use for yourself select file make a copy loan amortization schedule scenario 1. At the top right click more. Total loan amount 200 000 feel free to comment on things that you think i should change improve.
Sheet1 student loan interest calculator inputs if you found this helpful and want to support more of these projects you can donate by venmo to jonathanposton payment frequency options student loan amount 80 000 frequency payments yr months annual interest rate 7 00 to share copy and paste. You can use our lease mileage spreadsheet to make certain you don t exceed your allowed lease miles. Loan details additional principal payment year loan obtained 2014 extra amo. What if i pay x amount toward the principal every month or once a year.
On your computer open chrome. This calculator is for educational and informational use only. Learn how to change more cookie settings in chrome. Click more tools clear browsing data.
And our miles per gallon calculator will help you determine the average mpg your vehicle gets. Below are free loan and calculator spreadsheets. To delete everything select all time. You must verify all details calculations and projections with your financial institution before making consult your tax advisor financial advisor and legal counsel before taking any action or making any decisions.
Below are more images from the google sheets mortgage paydown and amortization calculator spreadsheet. Our loan amortization spreadsheet can help you determine your next mortgage payment or car payment. The results are only estimates. Down payment 40 000 original principal 160 000.
How much sooner do i pay it off. Please don t request edit access.