Microsoft Excel - Visual Basic for Applications Consultant PROFESSIONAL SOFTWARE DEVELOPMENT Reliable Excel VBA Solutions !

excel solutions letter     dropdown list in cell     mult-criteria text lookup     spreadsheet bloat     more ...     if...then[...else]     what are variables ?     dynamic arrays     more ...     dynamic named ranges     finding real last cell     charting dynamic data     more ...     amortization guide     breakeven analysis     combinatorics     standard deviation     weighted average     excel vba customization     professional experience     project request form     engineering analysis     financial reporting     sales forecasting     automated billing     engineering design     clients - past & present     gratuitous kudos         e-mail contact 20831 Rosehill Church Rd Tomball, Texas 77377 Amortization with Excel Spreadsheets Rodney POWELL Microsoft MVP - Excel Amortization calculators are essential business tools. In addition to home loans and other real estate mortgages, they are employed many ways. Common applications for amortization calculators are for: car loans or other auto loans business loans and other commercial loans personal loans or student loans Many people use amortization schedules. FREE online calculators are available to calculate loan payments for you. But, wouldn't you like to actually know how they work and/or learn how to create your own? Within 15 minutes of reading my user-friendly guide to Amortization with Excel Spreadsheets, you will understand amortization and how to use it ! It is written with you in mind   -   to benefit ordinary people who work with Excel at their jobs or school. You can instantly download it for about the price of a pizza ! Learn how to show the breakdown of interest and principal over the life of a loan See what it would take to pay off a loan years earlier than scheduled Learn how to save thousands of dollars in interest off a home mortgage, auto, or other loan See how much even slight changes in the interest rate affect the payments on a loan And, learn easy-to-apply tips to make your work with Excel more efficient and productive ! The guide explains how to create and use amortization schedules in Excel to help you make better financial decisions and save time and money !   Besides developing Excel custom applications, I have also been one of the most productive individual real estate brokers in Texas   -   so, I know the personal and business value of this calculator for you ! This will provide you an excellent explanation of amortization schedules that includes illustrations and formulas. The guide is 15 pages, with lots of pictures. It is so easy-to-understand; I'd say, if you can follow a recipe, you will grasp what I will teach you here. And, if you don't want to build your own amortization schedule, you can just use the fully functional example spreadsheet provided for you. If you can open a file in Excel, you can use this amortization model like an expert. In fact, you can use it over and over again. Simply save your amortization schedule as another Excel workbook   -   it will always be there when you need it ! What the Amortization Guide covers ... Illustrating the Concept of Compound Interest Understanding the differences between SIMPLE interest and COMPOUND interest » see an easy-to-follow compound interest formula calculation Effects of varying frequency of your compounding interval LOAN VARIABLES : Four Easy Inputs Loan Amount Annual Interest Rate Amortization Period » how this is distinct from Loan Term (and Balloon Payments) First Payment Date LOAN SUMMARY INFORMATION : Four Easy Calculations Debt Service Payment » how to calculate your loan payment [Excel's PMT function] Total Interest » calculating HOW MUCH interest is paid over the life of a loan Number of Payments » projecting your loan payoff Last Payment Date » help with using Excel's VLOOKUP function AMORTIZATION SCHEDULE : How to Build the Table Payment Number » applying Excel ABSOLUTE cell references in your formulas Period » working with Excel DATE functions Interest Calculation » how to calculate your interest payments Principal Calculation » how to calculate the principal contribution in your payments Additional Principal Payment » see the effects of extra small payments on : interest savings over the life of the loan eliminating the loan balance how much sooner the loan will payoff Calculating Principal Balance » calculating reduction of the debt Cumulative Interest » creating a formula that stretches with your data Cumulative Principal » watch equity accelerate and replace debt with each payment AMORTIZATION TABLES : Getting the Size Right Increasing or decreasing the number of periods that print in your amortization schedule DIFFERENCES : Accounting for Variations Why your spreadsheets can differ from an amortization schedule provided by a lender Effects of rounding » applying Excel's ROUND function for nearest dollar and cents Amortization with Excel Spreadsheets   $ 15.00 USD Click this link to download a copy licensed for personal use ... Amortization with Excel Spreadsheets 2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for goods and services provided by Beyond Technology. Follow the links provided on this page to download in minutes a ZIP file containing the Amortization with Excel Spreadsheets guide [PDF]. It's EASY ! Your download will also have an Excel workbook with ALL the formulas and the actual spreadsheet used in the examples. This XLS file is compatible with Excel 97-2003 and Excel 2007. The worksheets are completely unprotected so you can adapt my examples for your own purposes. Easy to Use !! The Amortization with Excel Spreadsheets guide demystifies amortization and lays out a simple framework for building amortization schedules. Then, step-by-step, we will look at useful Excel formulas in an accessible, jargon-free way. It's not rocket science. You will probably be amazed at how straightforward my approach is. After learning the information in this guide, you'll know more about amortization than ever before ! This Amortization with Excel Spreadsheets guide not only takes you through Excel formula building, it also tells you why these functions are useful to you. You will gain a valuable understanding of amortization and be impressed with how you are able to apply amortization for your own projects ! And, because this amortization model is for Microsoft Excel, there are no new programs to learn. If you are already familiar with Excel, you can build an amortization schedule minutes after downloading the guide ! Amortization with Excel Spreadsheets   $ 15.00 USD Click this link to download a copy licensed for personal use ... Amortization with Excel Spreadsheets 2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for goods and services provided by Beyond Technology. A few ADDED BENEFITS of this amortization model for you are : Flexibility with Extra Principal Payments You are able to display the dramatic interest savings and faster payoff gained from any additional principal payments -- ANY amounts, at ANY time, and ANY frequency ! "Open Code" to Customize You will be able to simply "bolt on" my amortization worksheet to YOUR Excel projects   -   the cells are unprotected and the example amortization table is available to customize for your own project Here's what people are saying ...   Rodney - Thanks for the Amortization spreadsheet. It works perfect and saves me a lot of time and gives me a record of payment schedules. - Dean CHITTENDEN [AcuBids.com] Dallas, TX   Rodney: Your amortization schedule is fabulous. Doing mortgage schedules for 15 years and this is the easiest tool I have ever seen. ... Thank you for making a troublesome area so easily clarified. And these schedules are available to everyone, not just the professional mortgage person. - Cathy TANNER Mortgage Broker [MBI Mortgage]   I personally already used it to calculate how much interest I would save if I paid $100 more a month or $200 more a month on my house payment :-). You're right - it IS motivating! - Terri S. Folsom, CA   Hi Rodney: It works well, simple and easy unlike some of the online programs with our MLS system. ... I will say I was quite impressed with the tutorial and the explanation of interest with examples. I think this would be very useful if it could be taught in real estate licensing classes or any kind of finance class. ... Most of the lenders I work with in this area have quite sophisticated programs for this and do the overkill explanation to buyers. This program is great because of it's simplicity and clarity. ... Thanks, - Judy Pool HOMAN [KW Realty] Dallas/Ft Worth, TX Amortization with Excel Spreadsheets   $ 15.00 USD Click this link to download a copy licensed for personal use ... Amortization with Excel Spreadsheets 2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for goods and services provided by Beyond Technology.

home   professional consulting   developer tips   visitor kudos   e-mail   Your suggestions and comments are greatly appreciated. Please keep them coming. Mail to:   rodney@beyondtechnology.com All terms, product designs, and company names used in this site may be trademarks or registered trademarks of their respective owners, and are hereby acknowledged. © 1996 - 2008 Beyond Technology. All rights reserved.