Nelson Higher Education

Higher Education

Financial Analysis with Microsoft® Excel®, 7th Edition

  • Timothy R. Mayes
  • ISBN-10: 1285432274
  • ISBN-13: 9781285432274
  • 544 Pages | Paperback
  • Previous Editions: 2012, 2010, 2007
  • COPYRIGHT: 2015 Published
Request a Copy for Review


About the Product

Help students master the latest features in Excel® 2013 while establishing a strong foundation in corporate finance. With Mayes's FINANCIAL ANALYSIS WITH MICROSOFT® EXCEL® 2013, 7E, your students develop a proficiency in using Excel® 2013 to solve real financial problems without sacrificing any finance background. This edition covers all of the topics in today's corporate finance course, including financial statements, budgets, the Market Security Line, pro forma statements, cost of capital, equities, and debt. A reader-friendly, self-directed learning approach and numerous study tools make this book both an ideal resource for independent learning and a valuable long-term reference tool. Because today's typical students enter college with basic spreadsheet skills, this new edition covers the basics early for those with no background, before moving quickly into many of the more advanced and most powerful features of Excel® 2013. This edition offers new focus on Excel® tables, pivot tables and pivot charts and other areas that have become increasingly important to today's employers. The book's easy-to-understand presentation helps students build upon or transfer skills from other spreadsheet programs as they establish a strong understand of contemporary corporate finance. Give your students the valuable, highly marketable skills in Excel® 2013 with the understanding of corporate finance that they need to succeed with Mayes' FINANCIAL ANALYSIS WITH MICROSOFT® EXCEL® 2013,7E.


  • EQUIP STUDENTS WITH BOTH BASIC SKILLS AND ADVANCED FINANCIAL TECHNIQUES FOR USING EXCEL® 2013. This proven, reader-friendly text introduces the basics of using spreadsheet as well as maximizing Excel® 2013 to build basic financial statements. After establishing a solid foundation, the book launches into more advanced techniques for performance evaluation, forecasting, valuation, and capital budgeting.

  • COMBINE SOLID FINANCE COVERAGE WITH ESSENTIAL SPREADSHEET SKILLS. This edition offers more than a mere spreadsheet book or a text filled with spreadsheet templates. This trusted financial resource offers all of the advantages of a solid, thorough finance text while equipping your students to effectively solve financial problems using Excel® 2013.

  • COVERAGE OF WEB QUERIES AND PIVOT TABLES HELPS STUDENTS MAXIMIZE POWERFUL EXCEL® TOOLS. You can introduce your students to more advanced, powerful Excel® skills, such as using web queries to download and work with Internet data. Coverage also delves into using pivot tables, one of the most powerful Excel® features for extracting, summarizing and presenting data in readable form.

  • INTRODUCTORY LEVEL IS IDEAL FOR READERS UNFAMILIAR WITH EXCEL®. This edition's reader-friendly approach begins at a basic introductory level that's ideal for students who are not very familiar with Excel®. Topics quickly advance to challenge those entering the course with a basic understanding of spreadsheets.

About the Author

Timothy R. Mayes

Timothy R. Mayes serves as finance professor at Metropolitan State College of Denver. He holds a B.S. and B.A. in Finance and a Ph.D. in Finance from the University of Central Florida. Dr. Mayes' research interests include portfolio performance analysis and reporting, portfolio theory, derivatives and, of course, the use of spreadsheets in financial education.

Table of Contents

1. Introduction to Excel 2013.
2. The Basic Financial Statements.
3. The Cash Budget.
4. Financial Statement Analysis Tools.
5. Financial Forecasting.
6. Break-Even and Leverage Analysis.
7. The Time Value of Money.
8. Common Stock Valuation.
9. Bond Valuation.
10. The Cost of Capital.
11. Capital Budgeting.
12. Risk and Capital Budgeting.
13. Portfolio Statistics and Diversification.
14. Writing User-Defined Functions with VBA.
15. Analyzing Datasets with Tables and Pivot Tables.

New to this edition

  • UPDATES PREPARE STUDENTS TO UTILIZE THE LATEST EXCEL® 2013 ADVANTAGES. Prepare your students for immediate finance and spreadsheet success in a financial context as this edition highlights introductory and advanced spreadsheet skills using EXCEL® 2013 new functions and features.
  • ADDITIONAL COVERAGE OF BASIC FINANCIAL STATEMENTS. Chapter 2 now includes coverage of Contribution Analysis to the common-size income statement and an expanded section on Common-Size Statement of Cash Flows.
  • EXPANDED CHAPTER ON PORTFOLIO STATISTICS AND DIVERSIFICATION. Chapter 13 adds a kind of simulation technique to demonstrate the feasible set of portfolios by generating 5000 random portfolios.
  • EXPANDED CHAPTER WRITING USER-DEFINED FUNCTIONS WITH VBA. This expanded chapter (Ch. 14) provides additional sections on Optional Arguments, ParamArray for Unlimited Arguments as well as a section on "Best Practices for VBA."


All supplements have been updated in coordination with the Main title.
Please see Main title page for new to this edition information.

Instructor Supplements

Website  (ISBN-10: 1305086155 | ISBN-13: 9781305086159)

Instructor's Manual provides additional problem sets and solutions. Instructor Spreadsheets provide active spreadsheets for end of chapter problems as well as solutions. Worksheets are provided for spreadsheet Exhibits in each Chapter.