{"product_id":"pay-off-your-mortgage-early-tim-hill-9781671697249","title":"Pay Off Your Mortgage Early With Excel! Create an Optimal Payoff Plan for Your Income","description":"\u003cp\u003eThe 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.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eCovers all versions of Excel.\u003c\/li\u003e\n\u003cli\u003eLearn about basic financial concepts, including cash flows, timing issues, and the time value of money.\u003c\/li\u003e\n\u003cli\u003eCompute the payments needed to pay off a loan or to meet an investment target.\u003c\/li\u003e\n\u003cli\u003eSeparate the interest and principal portions of your mortgage or loan payments for tax purposes.\u003c\/li\u003e\n\u003cli\u003eConvert between the commonly used methods of quoting interest rates.\u003c\/li\u003e\n\u003cli\u003eCreate amortization schedules to see how your debts change over time.\u003c\/li\u003e\n\u003cli\u003eBuild summary tables to compare loans that have different interest rates, loan amounts, or payment terms.\u003c\/li\u003e\n\u003cli\u003eDerive the true interest rate of your investments or loans, including \"interest-free\" loans.\u003c\/li\u003e\n\u003cli\u003eSee how much time it will take to pay off a loan, meet an investment target, or retire.\u003c\/li\u003e\n\u003cli\u003eDetermine how much to invest now to meet a future goal.\u003c\/li\u003e\n\u003cli\u003eCalculate how money will accumulate in your retirement or savings accounts.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eContents\u003c\/strong\u003e\u003cbr\u003ePart I - Loans \u0026amp; Mortgages\u003cbr\u003e1. Getting Started with Loans \u0026amp; Mortgages\u003cbr\u003e2. Present Value (PV)\u003cbr\u003e3. Future Value (FV)\u003cbr\u003e4. Payments (PMT)\u003cbr\u003e5. Interest Rates (RATE)\u003cbr\u003e6. Periods (NPER)\u003cbr\u003e7. Interest and Principal Components\u003cbr\u003e8. Converting Interest Rates\u003cbr\u003e9. Loan Amortization Schedules\u003cbr\u003e10. Summarizing Loan Options\u003cbr\u003e\u003cbr\u003ePart II - Dates \u0026amp; Times\u003cbr\u003e11. Getting Started with Dates \u0026amp; Times\u003cbr\u003e12. Date \u0026amp; Time Basics\u003cbr\u003e13. Date \u0026amp; Time Functions\u003cbr\u003e14. Date Tricks\u003cbr\u003e15. Time Tricks\u003cbr\u003e\u003cbr\u003ePart III - Sums \u0026amp; Counts\u003cbr\u003e16. Getting Started with Sums \u0026amp; Counts\u003cbr\u003e17. Counting Basics\u003cbr\u003e18. Counting Tricks\u003cbr\u003e19. Frequency Distributions\u003cbr\u003e20. Summing Basics\u003cbr\u003e21. Summing Tricks\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eAbout the Author\u003c\/strong\u003e\u003cbr\u003eTim Hill is a statistician living in Boulder, Colorado. He holds degrees in mathematics and statistics from Stanford University and the University of Colorado. Tim has written guides for Algebra, Trigonometry, Geometry, Precalculus, Calculus, Permutations \u0026amp; Combinations, Debt, and Excel Pivot Tables. When he's not crunching numbers, Tim climbs rocks, hikes canyons, and avoids malls.\u003c\/p\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Tim Hill\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 1671697243\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9781671697249\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Independently Published\u003cbr\u003e\u003cb\u003eLanguage:\u003c\/b\u003e English\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 12\/04\/2019\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 162\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 0.43lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 8.50h x 5.50w x 0.35d","brand":"Tim Hill","offers":[{"title":"Paperback","offer_id":43941661376767,"sku":"9781671697249","price":10.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/products\/img_2a8cd85b-c53d-459c-8ef0-9e273aefcd0f.jpg?v=1681454229","url":"https:\/\/www.whiterainbookhouse.com\/products\/pay-off-your-mortgage-early-tim-hill-9781671697249","provider":"WR Book House","version":"1.0","type":"link"}