Pay Off Your Mortgage Early With Excel!Pay Off Your Mortgage Early With Excel! Create an Optimal Payoff Plan for Your Income
by Tim Hill

Download excel_loans.zip (sample workbooks).

Description

The immense power of compound interest is such that adding a small amount of extra principal to each of your mortgage payments will result in thousands (or tens of thousands) in interest savings over the life of your loan. Using only high-school mathematics, Tim Hill provides clear and readable lessons that you can use to understand and pay down your mortgage by using Microsoft Excel (or any spreadsheet software). This entirely practical guide teaches you how to use worksheet functions, array formulas, data tables, and other spreadsheet features to manage your business and personal finances. You’ll also learn the auxiliary skills needed to create and maintain financial spreadsheets: rounding numbers, date and time arithmetic, summing and counting values, and more. Plenty of examples show you how to use these tools for any type of debt or savings: mortgages, student loans, leases, credit-card debt, car payments, medical expenses, annuities, and retirement funds. You can download the sample workbooks to follow along with the author’s examples and calculations.

Contents

Part I—Loans & Mortgages
1. Getting Started with Loans & Mortgages
2. Present Value (PV)
3. Future Value (FV)
4. Payments (PMT)
5. Interest Rates (RATE)
6. Periods (NPER)
7. Interest and Principal Components
8. Converting Interest Rates
9. Loan Amortization Schedules
10. Summarizing Loan Options

Part II—Dates & Times
11. Getting Started with Dates & Times
12. Date & Time Basics
13. Date & Time Functions
14. Date Tricks
15. Time Tricks

Part III—Sums & Counts
16. Getting Started with Sums & Counts
17. Counting Basics
18. Counting Tricks
19. Frequency Distributions
20. Summing Basics
21. Summing Tricks

Excerpt

Amazon preview

Purchase

Paperback
   Amazon paperback (US, CA, UK, AU, DE)

Ebook
   Amazon Kindle (US, CA, UK, AU, DE)
   Apple Books (US, CA, UK, AU, DE)
   Barnes & Noble Nook
   Google Play