ie8 fix

Amortization Schedule for Excel

CNET Editors' review

by: CNET staff on May 08, 2009

Choosing your major financial purchase can be dreamy (stucco or stone? sun roof or tinted windows?) but the dream can quickly morph into a nightmare when trying to determine just how much money your loan will actually cost over time. The Amortization Schedule for Excel gives you the basic information you need so you can see just how much your dream will actually cost over time.

This freeware tool is very easy to use. Just plug in your numbers (loan amount, loan term, and interest rate) and voila, an amortization schedule quickly appears. You can easily change the variables, too. Just enter information into any box and the schedule will automatically reset to your new terms. This flexibility is especially useful if you choose to apply extra payments toward your principal at any point during your loan. (And, yes, this also works if you neglect to make that payment.) Check the rounding box and the schedule will round to the nearest cent, which lets you compare your results with many other amortization schedule programs.

The Amortization Schedule for Excel is very matter-of-fact, which is probably what you want in such a sobering enterprise as the spending of your hard-earned money. This schedule is for fixed rate loans only, and accommodates up to 780 payments, generous enough for most loans, weekly and otherwise. This is truly an amortization schedule; look elsewhere if you want a calculator that includes other expenses such as anticipated taxes and insurance.

No need to install the Amortization Schedule for Excel as it is already accessible after extraction. And what it lacks in pizzazz, this simple utility makes up for with solid data and ease of use.

 
Share your screen instantly, for free.

Publisher's Description

From Vertex42:

The Amortization Schedule for Excel spreadsheet creates an amortization schedule or payment schedule for a fixed-rate loan, with optional extra payments. The payment frequency can be annual, semi-annual, quarterly, bi-monthly, monthly, semi-monthly, bi-weekly, or weekly. Values are rounded to the nearest cent, or the rounding can be turned off. The last payment is adjusted to bring the balance to zero. The compound period can be set based on US or Canadian mortgages. You can select whether payments are due at the end or beginning of the payment period.

What's new in this version: Version 1.6 can make multiple copies of the loan schedule within the same workbook allowing you to compare different loans.

More Popular Personal Finance Software downloads

 
Share your screen instantly, for free.
All User Reviews
  • All versions:

    4.1 stars

    out of 21 votes

    • 5 star: 8
    • 4 star: 8
    • 3 star: 5
    • 2 star: 0
    • 1 star: 0
  • Current version:

    4.1 stars

    out of 21 votes

    • 5 star: 8
    • 4 star: 8
    • 3 star: 5
    • 2 star: 0
    • 1 star: 0
  • My rating:

    0 stars

    Write review

Results 1-10 of 21

Results 1-10 of 21

Add Your Review

or Log in or create an account to post a review.
You are logged in as . Please submit your review for Amortization Schedule for Excel 1.6
Add Your Review

The posting of advertisements, profanity, or personal attacks is prohibited.
Click here to review our site terms of use.

Submit your reply

Submit

The posting of advertisements, profanity, or personal attacks is prohibited.
Click here to review our site terms of use.

cancel

E-mail this review

Submit cancel

Report offensive content

If you believe this comment is offensive or violates the CNET's Site Terms of Use, you can report it below (this will not automatically remove the comment). Once reported, our staff will be notified and the comment will be reviewed.

Select type of offense:

Offensive: Sexually explicit or offensive language
Spam: Advertisements or commercial links
Disruptive posting: Flaming or offending other users
Illegal activities: Promote cracked software, or other illegal content
Submit cancel

See more CNET content tagged:

Previous Versions:

Error

close

ERROR MESSAGE

If you think this is an error, please contact CNET TechTracker Support for further assistance.

Ok

Running Request

close

loading

Smart Install Software

close

CNET TechTracker will now automatically install software without requiring further action by you. (Note: This feature automatically accepts associated EULAs and third party applications on your behalf.)

You have selected the following software to Smart Install:

CNET TechTracker will attempt to install this software without interrupting you again. If an application requires manual installation, CNET TechTracker will download the installer and prompt you to take further action.

Proceed with Smart Install?

Confirm Standard Install Cancel

Submit a problem report for Amortization Schedule for Excel

close

Please describe the problem you have with this software. This information will be sent to our editors for review.

Problem:

The CNET Installer isn't working as expected

The download link does not work

The software has a newer version

The software contains malware

Other

Description:

Please select a feedback type.

Please enter a description.

Submit Problem Report

Problem Report submitted

close

Thank you for submitting a problem report! The Download team is committed to providing you with accurate software information.

OK