{"product_id":"9781937842277","title":"Mastering Excel Loan \u0026 Mortgage Formulas (No Fluff Guide)","description":"\u003cp\u003eUpdated for Excel 2016. Calculations with loans, mortgages, leases, credit-card debt, car payments, medical expenses, and retirement funds are the most common financial operations in Excel. Author Tim Hill shows you how to use worksheet functions, data tables, and other Excel features to manage your business and personal finances. If you're using an older version of Excel that doesn't support the latest worksheet functions, you'll find equivalent formulas that work in Excel 2003 or earlier. You can download the sample workbook to follow along with the author's examples.\u003c\/p\u003e\u003cp\u003e\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\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\u003cli\u003eFigure out the payments needed to pay off a loan or to meet an investment target.\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\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\u003ePlenty of tips, tricks, and timesavers.\u003c\/li\u003e\n\u003cli\u003eFully indexed and cross-referenced.\u003c\/li\u003e\n\u003cbr\u003e\n\u003c\/ul\u003e\u003cp\u003eContents\u003c\/p\u003e\u003cp\u003e1. Getting Started with Loans \u0026amp; Mortgages\u003c\/p\u003e\u003cp\u003e2. Present Value (PV)\u003c\/p\u003e\u003cp\u003e3. Future Value (FV)\u003c\/p\u003e\u003cp\u003e4. Payments (PMT)\u003c\/p\u003e\u003cp\u003e5. Interest Rates (RATE)\u003c\/p\u003e\u003cp\u003e6. Periods (NPER)\u003c\/p\u003e\u003cp\u003e7. Interest and Principal Components\u003c\/p\u003e\u003cp\u003e8. Converting Interest Rates\u003c\/p\u003e\u003cp\u003e9. Loan Amortization Schedules\u003c\/p\u003e\u003cp\u003e10. Summarizing Loan Options\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eAbout the Author\u003c\/p\u003e\u003cp\u003eTim Hill is a data scientist living in Boulder, Colorado. He holds degrees in mathematics and statistics from Stanford University and the University of Colorado. When he's not crunching numbers, Tim climbs rocks, hikes canyons, and avoids malls.\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e","brand":"Questing Vole Press","offers":[{"title":"Default Title","offer_id":47044154294512,"sku":"9781937842277","price":9.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781937842277_p0.jpg?v=1763665119","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781937842277","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}