Questing Vole Press
Essential Excel Loan and Mortgage Formulas

Essential Excel Loan & Mortgage Formulas: A Self-Teaching Guide
by Tim Hill

Download (sample workbooks).


The most common financial operations in Microsoft Excel are calculations for mortgages, student loans, leases, credit-card debt, car payments, medical expenses, annuities, and retirement funds. This no-nonsense guide shows you how to use worksheet functions, array formulas, data tables, and other Excel features to manage your business and personal finances. You’ll also learn the auxiliary skills needed to create and maintain financial workbooks: rounding numbers, data and time arithmetic, summing and counting values, and more. You can download the sample workbooks to follow along with the author’s examples.


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


Amazon preview.

Prices and formats

   Amazon paperback (US, UK, FR, DE, ES, IT)

   Amazon Kindle (US, CA, UK, AU, FR, DE, NL, ES, IT, JP, BR, IN, MX)
   Apple iBooks (US, CA, MX, AU, NZ, UK, IE, DE, IT, SE, NL, DK, JP)
   Barnes & Noble Nook
   Google Play