Website: http://investexcel.net

Rank: 441 / 1400

3 selected articles

Calculate Auto Loan Payments in Excel

Want to know how much that new car will cost? Just crack open Excel and load this spreadsheet.

It calculates your car loan payments and generates a payment schedule. You can also investigate how changing your loan conditions (such as the payment frequency or the term) affects the payment.

The spreadsheet is easy to use and navigate; required parameters are highlighted, and drop-down menus let you change the payment frequency and compounding period.

Just enter the loan amount, interest rate, loan term, first payment date, payment frequency and...

Date: 2017-02-28 09:13:38

How to Calculate Accelerated Mortgage Payments in Excel

Accelerated mortgage payments can save you thousands of dollars in interest. They're rapidly becoming the tool of choice for frugal homeowners.

By increasing the total amount you pay over a year, you pay less interest across the life of the mortgage.

Banks commonly offer two accelerated schemes.

Accelerated weekly - this divides your monthly payment into four. Because there are more than four weeks in a month, you effectively make two extra payment every year.

Accelerated bi-weekly - this divides your monthly payment into two equal parts. And because there are more than four weeks in a month, you effectively make an...

Date: 2017-02-28 14:51:50

Mortgage Payment Calculator - Invest Excel

term,

first payment date,

payment frequency (you can pick from annual, semi-annual, quarterly, bi-monthly, monthly, semi-monthly, bi-weekly, weekly, accelerated bi-weekly and accelerated weekly payments),

and the compounding period (you can pick from semi-annual, monthly, quarterly and annual).

After you click the "Calculate Mortgage" button, Excel gives you your payment, the total interest and outstanding...

3 Resources