List of Loan Excel E-book

Download Business & Economics, Mathematics, Computers ebook, Questing Vole Press, Tim Hill.

Essential Excel Loan & Mortgage Formulas
by Tim Hill

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.

– Covers all versions of Excel.

– Learn about basic financial concepts, including cash flows, timing issues, and the time value of money.

– Determine how much to invest now to meet a future goal.

– Calculate how money will accumulate in your retirement or savings accounts.

– Figure out the payments needed to pay off a loan or to meet an investment target.

– Derive the true interest rate of your investments or loans, including "interest-free" loans.

– See how much time it will take to pay off a loan, meet an investment target, or retire.

– Separate the interest and principal portions of your mortgage or loan payments for tax purposes.

– Convert between the commonly used methods of quoting interest rates.

– Create amortization schedules to see how your debts change over time.

– Build summary tables to compare loans that have different interest rates, loan amounts, or payment terms.

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


Microsoft Office Excel 2007 – Illustrated Complete
by Elizabeth Eisner Reding, Lynn Wermers

Part of the Illustrated Series, this practical, easy to navigate book provides the essential knowledge of how to use Microsoft Excel 2007 that students need to succeed in both the classroom and beyond.
Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Excel 2010 Power Programming with VBA
by John Walkenbach

All the methods and tools you need to successfully program with Excel

John Walkenbach’s name is synonymous with excellence in computer books that decipher complex technical topics. With this comprehensive guide, “Mr. Spreadsheet” shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.

Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2010, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel’s capabilities with VBA.

  • Offers an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA)
  • Features invaluable advice from “Mr. Spreadsheet” himself (bestselling author John Walkenbach), who demonstrates all the techniques you need to create large and small Excel applications
  • Provides tips, tricks, and techniques for expanding Excel’s capabilities with VBA that you won’t find anywhere else

This power-user’s guide is packed with procedures, tips, and ideas for expanding Excel’s capabilities with VBA.


New Perspectives on Microsoft Excel 2010, Introductory
by June Jamrich Parsons, Dan Oja, Roy Ageloff, Patrick Carey

With the New Perspectives’ critical-thinking, problem-solving approach, students will gain a comprehensive understanding of MICROSOFT OFFICE EXCEL 2010 and will learn how to take advantage of the flexibility it offers. Case-based tutorials challenge students to apply what they are learning to real-life tasks, preparing them to easily transfer skills to new situations. With New Perspectives, students understand why they’re learning what they’re learning and are better situated to retain skills beyond the classroom.
Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

New Perspectives on Microsoft Excel 2010: Comprehensive
by June Jamrich Parsons, Dan Oja, Roy Ageloff, Patrick Carey

With the New Perspectives’ critical-thinking, problem-solving approach, students will gain a comprehensive understanding of MICROSOFT OFFICE EXCEL 2010 and will learn how to take advantage of the flexibility it offers. Case-based tutorials challenge students to apply what they are learning to real-life tasks, preparing them to easily transfer skills to new situations. With New Perspectives, students understand why they’re learning what they’re learning and are better situated to retain skills beyond the classroom.
Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Excel 2013 In Depth
by Bill Jelen

Get more out of Microsoft Excel® 2013: more productivity and better answers for greater success! Drawing on his unsurpassed Excel experience, Bill Jelen (“Mr Excel”) brings together all the intensely useful knowledge you need: insights, techniques, tips, and shortcuts you just won’t find anywhere else. Excel 2013 In Depth is the fastest, best way to master Excel 2013’s full power; get comfortable with its updated interface; and leverage its new tools for everything from formulas, charts, and functions to dashboards, data visualization, and social media integration. Start by taking a quick “tour” of Excel 2013’s most valuable new features. Then, learn how to

  • Build more trustworthy, error-resistant, flexible, extensible, intelligent, and understandable spreadsheets
  • Get more productive with Excel 2013’s new Start Screen and Timelines
  • Create formulas, charts, subtotals, and pivot tables faster with new Flash Fill and Analysis Lens
  • Quickly apply attractive, consistent formats
  • Master every function you’ll ever need,- including powerful new web services functions
  • Solve real-world business intelligence analysis problems
  • Create amazing PowerPivot data mashups that integrate information from anywhere
  • Use Power View to generate stunningly intuitive maps, dashboards, and data visualizations
  • Share workbooks on the Web and social networks
  • Leverage the improved Excel Web App to create highly interactive web pages and online surveys
  • Automate repetitive functions using Excel macros
  • Supercharge your workbooks with new apps from the Excel App Store

Like all In Depth books, Excel 2013 In Depth delivers complete coverage with detailed solutions, and troubleshooting help for tough problems you can’t fix on your own. Whatever you intend to do with Excel 2013, this is the only book you’ll need!


Teach Yourself VISUALLY Complete Excel
by Paul McFedries

Get the basics of Excel and then go beyond with this new instructional visual guide

While many users need Excel just to create simple worksheets, many businesses and professionals rely on the advanced features of Excel to handle things like database creation and data analysis. Whatever project you have in mind, this visual guide takes you step by step through what each step should look like. Veteran author Paul McFedries first presents the basics and then gradually takes it further with his coverage of designing worksheets, collaborating between worksheets, working with visual data, database management and analysis, VBA, and more.

  • Offers step-by-step instructions on a variety of tasks, some everyday and some more unique
  • Shows you how to create basic spreadsheets, insert functions and formulas, work with pivot tables, and more
  • Features a two-color interior features numerous screen shots to enhance your learning process for tasks such as creating and managing macros, generating and working with analytics, and using the advanced tools

Offering you a deep dive into Microsoft Excel, this book is the complete package for learning Excel with step-by-step, clear visual instructions.


Problem Solving Cases In Microsoft Access and Excel
by Ellen Monk, Joseph Brady, Gerard S. Cook, Emillio Mendelsohn

PROBLEM-SOLVING CASES IN MICROSOFT ACCESS AND EXCEL, 13th Annual Edition, helps you effectively apply the Access database management system and Excel spreadsheet to analyze and solve real-world business problems. Six user-friendly tutorials build your practical knowledge as they walk you step-by-step through each software application’s capabilities, while 12 all-new case studies present scenarios and problems common in today’s business practice. In addition, a skill-building integration feature enables you to use Access and Excel together on cases, making this the most up-to-date, practical guide for these widely used software programs.
Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Problem-Solving Cases in Microsoft AccessTM and Excel
by Ellen Monk, Joseph Brady, Gerard S. Cook

PROBLEM-SOLVING CASES IN MICROSOFT ACCESS AND EXCEL, Twelfth Annual Edition, helps you apply the Access database management system and Excel spreadsheet to effectively analyze and solve real-world business problems. Six individual tutorials build a practical knowledge of each software application’s capabilities, while 12 all-new case studies present scenarios and problems common in business. Further, a skill-building integration feature requires readers to use Access and Excel together on cases, making this the most up-to-date, practical guide for these widely used software programs.
Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Financial Modeling with Crystal Ball and Excel, + Website
by John Charnes

Updated look at financial modeling and Monte Carlo simulation with software by Oracle Crystal Ball

This revised and updated edition of the bestselling book on financial modeling provides the tools and techniques needed to perform spreadsheet simulation. It answers the essential question of why risk analysis is vital to the decision-making process, for any problem posed in finance and investment. This reliable resource reviews the basics and covers how to define and refine probability distributions in financial modeling, and explores the concepts driving the simulation modeling process. It also discusses simulation controls and analysis of simulation results.

The second edition of Financial Modeling with Crystal Ball and Excel contains instructions, theory, and practical example models to help apply risk analysis to such areas as derivative pricing, cost estimation, portfolio allocation and optimization, credit risk, and cash flow analysis. It includes the resources needed to develop essential skills in the areas of valuation, pricing, hedging, trading, risk management, project evaluation, credit risk, and portfolio management.

  • Offers an updated edition of the bestselling book covering the newest version of Oracle Crystal Ball
  • Contains valuable insights on Monte Carlo simulation—an essential skill applied by many corporate finance and investment professionals
  • Written by John Charnes, the former finance department chair at the University of Kansas and senior vice president of global portfolio strategies at Bank of America, who is currently President and Chief Data Scientist at Syntelli Solutions, Inc. Risk Analytics and Predictive Intelligence Division (Syntelli RAPID)

Engaging and informative, this book is a vital resource designed to help you become more adept at financial modeling and simulation.