Request for consultation

Thanks for your request. You’ll soon be chatting with a consultant to get the answers you need.
{{formPostErrorMessage.message}} [{{formPostErrorMessage.code}}]
First Name is required. 'First Name' must contain at least 0 characters 'First Name' cannot exceed 0 characters Please enter a valid First Name
Last Name is required. 'Last Name' must contain at least 0 characters 'Last Name' cannot exceed 0 characters Please enter a valid Last Name
Institution is required.
Discipline is required.
Why are you contacting us today? is required. 'Why are you contacting us today?' must contain at least 0 characters 'Why are you contacting us today?' cannot exceed 0 characters Please enter a valid Why are you contacting us today?

Financial Analysis with Microsoft® Excel® 6th Edition

Timothy R. Mayes, Todd M. Shank

  • Published
  • Previous Editions 2010, 2007, 2004
  • 528 Pages


Help students master the latest features in Excel® 2010 while establishing a strong foundation in corporate finance. With Mayes/Shank’s FINANCIAL ANALYSIS WITH MICROSOFT® EXCEL® 2010, 6E, your students develop a proficiency in using Excel® 2010 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® 2010. 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® 2010 with the understanding of corporate finance that they need to succeed with Mayes' FINANCIAL ANALYSIS WITH MICROSOFT® EXCEL® 2010, 6E.

Timothy R. Mayes, Metropolitan State College of Denver

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. His research interests include portfolio performance analysis and reporting, portfolio theory, derivatives, and, of course, the use of spreadsheets in financial education.

Todd M. Shank, University of Portland

Todd M. Shank is Associate Dean and M.B.A. Director of the Robert B. Pamplin, Jr. School of Business Administration at the University of Portland in Oregon. In the spring of 2003, he served as a Fulbright Lecturer in China, where he taught corporate financial management in the graduate school at Sun Yat-sen University in Guangzhou. Dr. Shank received his Ph.D. from Central Florida. He has worked for the U.S. Treasury Department's Office of Comptroller of the Currency as a banking regulator and has been teaching, consulting, and writing for more than 25 years. During that time, he has served on the faculties of three universities, published two textbooks and academic articles in numerous journals, including American Business Review, Global Business and Finance Review, Journal of Foreign Exchange and International Finance, and the Journal of Financial Education. He has received numerous teaching awards, including the University's Teacher of the Year and the Pamplin School's Best Graduate Professor. He also serves on several national panels that promote technological applications in business education.
  • UPDATES PREPARE STUDENTS TO UTILIZE THE LATEST EXCEL® 2010 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® 2010 new functions and features.
  • NEW FINAL CHAPTER ANALYZES DATA SETS USING EXCEL® TABLES AND PIVOT TABLES. This new chapter (Ch. 15) thoroughly addresses the use of Excel® Tables, Pivot Tables and Pivot Charts – an area that has become an increasingly important requirement in job interviews.
  • NEW COVERAGE OF WEB QUERIES AND PIVOT TABLES HELPS STUDENTS MAXIMIZE POWERFUL EXCEL® TOOLS. Now you can introduce your students to more advanced, powerful Excel® skills, such as using web queries to download and work with Internet data. New coverage also delves into using pivot tables, one of the most powerful Excel® features for extracting, summarizing and presenting data in readable form.
  • EQUIP STUDENTS WITH BOTH BASIC SKILLS AND ADVANCED FINANCIAL TECHNIQUES FOR USING EXCEL® 2010. This proven, reader-friendly text introduces the basics of using spreadsheet as well as maximizing Excel® 2010 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® 2010.
  • 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.
1. Introduction to EXCEL® 2010.
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.

Textbook Only Options

Traditional eBook and Print Options

{{collapseContainerClosed['detail_0'] ? 'Show More' : 'Show Less'}}

  • ISBN-10: 1133778313
  • ISBN-13: 9781133778318
  • STARTING AT $16.49

  • ISBN-10: 1111826242
  • ISBN-13: 9781111826246
  • Bookstore Wholesale Price $104.50
  • RETAIL $138.95

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.



ISBN: 9781305084322
All instructor resources are conveniently located on the password-protected website at Instantly access the Instructor’s Manual with suggestions for using learning features and supplements as well as tips for using ethical dilemmas and references to related real situations. You can also access the Test Bank in Word with numerous conceptual as well as financial calculation questions labeled by level of difficulty. Easily add, edit, delete, or reorganize test items online with the new Cognero testing platform. You can also bring lectures to life with PowerPoint® slides that highlight key chapter features. Excel spreadsheet templates are also posted and contain models for the computer-related end of chapter problems.

Cengage Learning Testing, powered by Cognero Instant Access

ISBN: 9781305085763
Cengage Learning Testing Powered by Cognero is a flexible, online system that allows you to: Author, edit, and manage test bank content from multiple Cengage Learning solutions; create multiple test versions in an instant; deliver tests from your learning management system, your classroom or wherever you want!