Website: https://www.vertex42.com
Rank: 94 / 1400
8 selected articles
Loan Amortization Schedule and Calculator - vertex42.com
Screenshot
Bonus #1: Home Mortgage Calculator (Commercial Version)
This is a commercial use license of our Home Mortgage Calculator spreadsheet. It allows you to run an analysis on either a fixed rate or variable rate mortgage.
Screenshots: Simple Interest Amortization & Payment Schedule
Bonus #2: Simple Interest Loan Amortization & Payment Schedule (Commercial Version)
This is a commercial...
Date: 2017-02-16 18:11:01
Related topics : amortization loan calculator weekly payments / loan calculator payment schedule / amortization loan calculator extra payment / commercial loan mortgage payment calculator / loan calculator payment every 2 weeks
Home Equity Calculator - Free Home Equity Loan Calculator ...
(not for distribution or resale)
Support
"No installation, no macros - just a simple spreadsheet" - by Jon Wittwer
Advertisement
Description
This Excel workbook is a feature-packed spreadsheet that lets you calculate your monthly payment on a fixed-rate home equity loan. It creates an amortization schedule and allows you to either set up periodic extra payments, or manually enter prepayments in...
Date: 2016-11-21 02:24:33
Related topics : home equity interest only payment calculator / home equity loan payment calculator / interest only home equity loan calculator / interest rate home equity loan / loan calculator home equity line of credit
Loan Calculator - Free Simple Loan Calculator for Excel
(not for distribution or resale)
Support
"No installation, no macros - just a simple spreadsheet" - by Jon Wittwer
Advertisement
Description
This loan calculator uses the PMT, PV, RATE, and NPER formulas to calculate the Payment, Loan Amount, Annual Interest, or Term Length for a fixed-rate loan. Useful for both auto and mortgage loans. See below for more information.
How to Use the Loan...
Date: 2016-11-21 02:24:43
Related topics : loan calculator auto extra payment / used car loan interest rate / amortization loan calculator extra payment / loan calculator auto interest paid / monthly payment auto loan calculator
Auto Loan Calculator for Excel - vertex42.com
Screenshot
1. Use the Auto Loan Calculator worksheet to calculate the amount you will need to finance, based on the sales price of the car, destination charge, fees, sales tax, down payment, cash rebate, and trade-in value of an older auto.
2. Use the Payment Calculator worksheet (the featured image above) to create an amortization table based on the auto loan amount, annual interest rate, term...
Date: 2016-11-21 02:24:25
Related topics : loan calculator auto extra payment / monthly payment auto loan calculator / loan calculator auto excel spreadsheet / loan calculator auto interest paid / calculator auto loan interest
Free Balloon Loan Calculator for Excel | Balloon Mortgage ...
(not for distribution or resale)
"No installation, no macros - just a simple spreadsheet" - by Jon Wittwer
Advertisement
Description
Calculate the monthly payments, total interest, and the amount of the balloon payment for a simple loan using this Excel spreadsheet template.
The spreadsheet includes an amortization and payment schedule suitable for car loans, business loans, and mortgage...
Date: 2016-11-21 02:57:24
Related topics : balloon payment auto loan calculator / monthly payment auto loan calculator / loan payment calculator mortgage / balloon payment auto loan / loan calculator payment schedule
Free Credit Card Payoff Calculator for Excel - vertex42.com
Credit Card Payoff Calculator
The spreadsheet contains a worksheet with instructions and definitions for some of the terms used in the calculator. For more general information about how to pay off your credit card, see the steps below.
If you have any questions about how to use the spreadsheet, please contact us .
Steps to Pay off Your Credit Card Debt
Are you trying to escape from the oppression...
Date: 2016-11-21 02:24:28
Related topics : loan credit card payoff calculator / loan credit card calculator / loan pay credit card debt / loan credit card pay off / loan consolidation credit card debt
Amortization Calculation Formula and Payment Calculator
Advertisement
Calculating the Monthly Payment in Excel
Microsoft Excel has a number of built-in functions for amortization formulas . The function corresponding to the formula above is the PMT function. In Excel, you could calculate the monthly payment using the following formula:
=PMT(r,n,P) or =PMT(0.075/12,5*12,20000)
Calculating the Rate Per Period
When the number of compounding periods...
Date: 2016-11-21 02:19:12
Related topics : calculating loan payments formula / loan calculator payment amount / calculating loan payments in excel / loan payment calculator excel / loan calculator payment schedule
Free Home Equity Line of Credit Calculator for Excel
(not for distribution or resale)
Support
"No installation, no macros - just a simple spreadsheet" - by Jon Wittwer
Advertisement
Description
This spreadsheet creates an estimated payment schedule for a revolving line of credit with a variable or fixed interest rate, daily interest accrual, and a fixed draw period.
Features:
Additional Payments: You can enter additional payments and indicate...
Date: 2016-11-21 02:24:36
Related topics : line of credit home equity calculator / line of credit home equity rates / line of credit home equity / home equity interest only payment calculator / home equity credit
8 Resources