Financial Analysis with Microsoft Excel,
9th Edition

Timothy R. Mayes

ISBN-13: 9780357442050
Copyright 2021 | Published
560 pages | List Price: USD $124.95

Gain the hands-on experience and knowledge to solve real financial problems while taking your Excel® spreadsheet skills to a new level with Mayes' FINANCIAL ANALYSIS WITH MICROSOFT® EXCEL®, 9E. This edition provides a reader-friendly solid foundation in corporate finance while teaching you to maximize the spreadsheet tools that professionals use every day. Packed with interesting examples, this edition covers today's most important corporate finance topics and tools, including financial statements, budgets, the Security Market Security Line, pro forma financial statements, cost of capital, Visual Basic Applications (VBA) programming and Excel® pivot tables. You study the latest information on time series forecasting and work with Excel®'s Get & Transform feature to process large data files. This edition's self-directed learning approach and numerous self-study tools let you strengthen spreadsheet skills while equipping you with the expertise today's employers want in corporate finance.


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

  • 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.

  • UPDATES THROUGHOUT EVERY CHAPTER ENSURE ACCURACY, CURRENCY AND IMPROVED STUDENT UNDERSTANDING. Every chapter within this edition includes numerous updates to clarify and offer accurate and timely instruction, while the overall proven organization of the book remains the same.

  • THE LATEST EXCEL® UPDATES INCLUDE A NEW SECTION ON ARRAY FORMULAS. Chapter 1 reflects the latest updates to Excel®, as of late 2019, with an entire new section devoted for the first time specifically to array formulas. This dedicated coverage ensures array formulas are properly introduced.

  • UPDATED CHAPTERS REFLECT RECENT DATA AND NEW OFFICE 365 FUNCTIONS. Actual data throughout this edition is revised to include current data, as recent as mid-2019. Several cases address new dynamic array functions and other new functions released by Office 365 in late 2019.

  • NEW TAX RATE USED THROUGHOUT THIS EDITION CORRESPONDS MORE CLOSELY WITH TODAY'S LOWER CORPORATE TAX RATES. In order to reflect the lower corporate tax rates due to the Tax Cuts and Jobs Act of 2017, examples through this edition now use a tax rate of 25%. This includes a 21% federal flat tax rate and 4% state tax rate, which is based on state tax rate averages.

  • MS EXCEL® IS INTEGRATED THROUGHOUT THIS EDITION AS A LEARNING TOOL. This edition presents Excel® as a learning tool, rather than a "fancy calculator." Students learn how and why accounting principles function the way they do. Readers not only learn to create a worksheet, but they also understand how it works as well as the assumptions behind the calculations. Students gain a deeper understanding than the traditional "template" approach offers. In addition, this edition facilitates your use of spreadsheets in your course.

  • UNIQUE SELF-TEACHING APPROACH ENABLES IN-DEPTH EXPERIMENTATION THAT OTHERS DO NOT OFFER. This edition's presentation extends well beyond other "how-to" spreadsheet texts. For example, the often-recommended scenario analysis is demonstrated in-depth. This book uses tools built into Excel® to simplify computation-intensive techniques, eliminating tedious calculations. Regression analysis, linear and nonlinear programming and the Monte Carlo simulation are explored as this edition encourages students to use tools mastered in previous statistics and management science classes.

  • COVERAGE OF THE SOLVER, THE FORECAST SHEET, GET & TRANSFORM AND PIVOT TABLES HELPS STUDENTS MAXIMIZE POWERFUL EXCEL® TOOLS. This edition provides a thorough introduction to more advanced MS Excel® skills, such as using web queries to download and work with Internet data or using pivot tables for extracting, summarizing and presenting data in readable form.

  • INTRODUCTORY LEVEL IS IDEAL FOR STUDENTS UNFAMILIAR WITH EXCEL®. This edition's reader-friendly approach begins at a basic introductory level that's perfect for learners who are not very familiar with Excel®. The book then quickly advances to topics that will challenge those who are entering your course already equipped with a basic understanding of spreadsheets.

  • AN EASY-TO-UNDERSTAND PRESENTATION HELPS STUDENTS BUILD UPON SKILLS FROM OTHER SPREADSHEET PROGRAMS. The book's self-directed learning approach and numerous study tools make this edition an ideal resource for independent learning as well as a valuable reference tool. Students can easily build upon the experience they already have in working with spreadsheets.

  • STUDENTS MASTER BOTH BASIC SKILLS AND ADVANCED FINANCIAL TECHNIQUES FOR USING EXCEL®. This proven, reader-friendly text introduces the fundamentals of using spreadsheets as well as more complex skills for using Excel® to build financial statements. After establishing a solid foundation, the author launches into more sophisticated techniques for performance evaluation, forecasting, valuation and capital budgeting.

  • PROVEN APPROACH COMBINES COMPREHENSIVE FINANCE COVERAGE WITH ESSENTIAL SPREADSHEET SKILLS. This edition offers much more than a mere spreadsheet reference tool or a text filled with spreadsheet templates. This trusted resource delivers all the advantages of a thorough finance text while empowering your students to effectively solve financial problems using Excel®.

Cengage provides a range of supplements that are updated in coordination with the main title selection. For more information about these supplements, contact your Learning Consultant.

Instructor's Companion Website for Mayes' Financial Analysis with Microsoft Excel

Cengage eBook: Financial Analysis with Microsoft Excel 12 Months