- Quick specs
- Price: Free
- Operating system: Windows Vista, Windows XP
- Date added: May 26, 2009
- Total Downloads: 107,714
- Downloads last week: 3,787
- See full specifications
- CNET editors' rating: stars
- Average user rating: stars out of 3 votes
See all user reviews
CNET editors' review
Reviewed 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.
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
- 3,787 downloads 1. Amortization Schedule for Excel
- 2,582 downloads 2. Debt Reduction Calculator for Excel
- 1,015 downloads 3. Moffsoft FreeCalc
- 844 downloads 4. AceMoney Lite
- 741 downloads 5. Auto Loan Calculator
- See all Personal Finance Software downloads
User reviews
- Average user rating: 0 stars Not yet available
- My rating: 0 stars Write review
-
Showing 3 of 3 user reviewsSee all 3 user reviews
This software version | All versions -
Version: Amortization Schedule for Excel 1.6
"good amortization schedule for simple terms."
Pros: good basic amortization schedule.
Cons: not many options as to terms of payments.
-
Version: Amortization Schedule for Excel 1.6
"Great Little Program - Very easy to use"
Pros: It does what it is supposed to do and is very easy to use and the price is right
Cons: None worth mentioning
Summary: No reason not to use this program
-
Version: Amortization Schedule for Excel 1.6
"Everything you need and a bit more"
Pros: Easy to use
clear graphsCons: None for this item
- See all 3 user reviews Write review
Submit your review
- See more CNET content tagged:
- amortization,
- payment
Previous Versions:
