Docstoc

Simple Loan Calculator - Excel - Excel

Document Sample
Simple Loan Calculator - Excel - Excel Powered By Docstoc
					Loan Calculator with Extra Payments
Enter values Loan amount Annual interest rate Loan period in years Start date of loan Optional extra payments Instructions Must be between 1 and 30 years. If your extra payments vary, enter them in the table below.

Scheduled monthly payment Scheduled number of payments Actual number of payments Total of early payments Total interest

No.

Payment Date

Beginning Balance

Scheduled Payment

Extra Payment

Total Payment

Principal

Interest

Ending Balance

$

250.00

No.

Payment Date

Beginning Balance

Scheduled Payment

Extra Payment

Total Payment

Principal

Interest

Ending Balance

No.

Payment Date

Beginning Balance

Scheduled Payment

Extra Payment

Total Payment

Principal

Interest

Ending Balance

No.

Payment Date

Beginning Balance

Scheduled Payment

Extra Payment

Total Payment

Principal

Interest

Ending Balance

No.

Payment Date

Beginning Balance

Scheduled Payment

Extra Payment

Total Payment

Principal

Interest

Ending Balance

No.

Payment Date

Beginning Balance

Scheduled Payment

Extra Payment

Total Payment

Principal

Interest

Ending Balance