CNET Editors' review
Loan Amortization Schedule for Excel is, no surprise, an XLS file that has loan amortization formulas embedded in it. Distributed as a ZIP file with the XLS sheet and a couple of text files (release notes and license agreement), there's no installation process to follow. Just open the XLS file with Excel (or compatible program) and you're good to go.
The layout of the first sheet is simple: space at the top for loan mount, interest rate, term, and a few other details like payment frequency and compounding period. You just enter your information to see the monthly payment along with an amortization schedule. There's no ability to load two or more sets of data on the one sheet allowing for comparisons, but it does have the flexibility to perform any type of loan amortization and payment we can think of. A second sheet on the XLS file is used for storing actual payments made, so you can see progress against the amortization schedule. We doubt most people will actually use the second sheet, once the payments are set up, but it's a nice touch if you can prepay or are late paying and want to see the resulting numbers.
There are a lot of Web sites that provide similar calculators, but the ability to play "what-if" in the comfort of your own home with an Excel spreadsheet is a nice option. Loan Amortization Schedule for Excel is free and is sure to be of use for those who are crunching the numbers for loan options. It's nicely done, simple to use, and easy to understand.
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.
More Products to Consider
- Create amortization tables for a loan.Download
Installed
Smart Install - Eliminate your credit card debt and consumer loans using popula...Download
Installed
Smart Install - Manage any mobile phone from the PC via Wi-Fi, Bluetooth, or ca...Download
Installed
Smart Install - Figure out your monthly loan payments.Download
Installed
Smart Install - Create printable calendars with saved activities in MS Word and...Download
Installed
Smart Install - Take notes and stick them to your desktop.Download
Installed
Smart Install - Manage your email, time and calendar.Visit Site
This download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
- Calculate loan details & create a printable amortization schedu...Download
Installed
Smart Install - Create Post-it notes, bookmark websites, send/receive notes, se...Download
Installed
Smart Install - Split and merge PDF documents.Download
Installed
Smart Install - Calculate loans and debt with financial calculators with an amo...Download
Installed
Smart Install - Build, save, share, and print arbitrary mind maps.Download
Installed
Smart Install - Calculate monthly loan payments and payment schedules.Download
Installed
Smart Install - Calculate a fixed-rate loan amortization schedule.Download
Installed
Smart Install - Track and manage mortgage payments and loans.Download
Installed
Smart Install - Get a collection of 33 flexible financial calculators.Download
Installed
Smart Install - Schedule, plan, and remind yourself of important events.Download
Installed
Smart Install - Calculate your monthly mortgage payments.Download
Installed
Smart Install - Create and manage various events and to-do list on your desktop...Download
Installed
Smart Install - Transfer Phone Contacts, SMS, Photos, Call Log between Android,...Download
Installed
Smart Install - Display different scenarios of any loan, up to a 30-year term.Download
Installed
Smart Install - Organize your schedule and provide reminders of upcoming events...Download
Installed
Smart Install - Perform various financial calculations.Download
Installed
Smart Install - Perform various financial calculations.Download
Installed
Smart Install
-
All versions:
4.0 starsout of 24 votes
-
Current version:
3.3 starsout of 3 votes
-
My rating:
Write review
Results 1-3 of 3
-
"Just what I was looking for!"
Version: Amortization Schedule for Excel 1.6.3
Pros
Easy to use.
Cons
None so far.
-
"Nothing special about this"
Version: Amortization Schedule for Excel 1.6.3
Pros
Basic program that I suppose could be of value to some people.
Cons
All of these free excel programs in my opinion are over rated as is this one. What especially didn't like is when you download this they cleverly have a default that you will also be adding a tool bar to your computer. Easy to miss it until it is too late. Then the developer gets paid every time someone inadvertently downloads this program. Deceptive marketing to say the least.
-
"Nice little program"
Version: Amortization Schedule for Excel 1.6.3
Pros
Provides loan information with a minimum of input. Simple to use; I don't see a 'learning curve' issue. You can be inputting data in minutes.
Cons
For what it's designed to do -- none.
Summary
While the functionality of the program is good, it does have limitations. It saves the user the trouble of creating a spreadsheet to accomplish the same task. However, if one has experience in creating spreadsheets, they can easily create one that will give the same results with a great deal more flexibility. I'd class this program as great for someone that doesn't understand spreadsheets, doesn't know algebra (for formulas) or simply has a limited use for loan details/data.
Results 1-3 of 3
Add Your Review
Submit your reply
E-mail this review
Report offensive content
See more CNET content tagged:
Previous Versions:







