Financial Analysis with Microsoft® Excel® 2016, 8E,
8th Edition

Timothy R. Mayes, Todd M. Shank

ISBN-13: 9781337298049 | ISBN-10: 1337298042

Copyright 2018

| Published 2017

| 544 pages

List Price USD $99.95


Take your spreadsheet skills to a new level of proficiency! Giving you hands-on experience solving real financial problems, Mayes/Shank's FINANCIAL ANALYSIS WITH MICROSOFT® EXCEL® 2016, 8E, equips you with a solid foundation in corporate finance while helping you maximize the tools professionals use every day. Packed with examples, the text covers today's most important corporate finance topics, including financial statements, budgets, the Security Market Security Line, pro forma financial statements, cost of capital, VBA programming, and Pivot Tables. It also offers the latest on time series forecasting and the new Get & Transform feature (formerly known as Power Query), which helps you process large data files. A reader-friendly, self-directed learning approach and numerous study tools enable you to quickly build upon or transfer skills from other spreadsheet programs -- empowering you with the expertise today's employers want.

Read More

Meet the Authors

Show More Show Less

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.

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.

  • The chapter on cash budgeting now comes after the chapter on financial ratios so that coverage of financial ratios immediately follows financial statements. This new chapter order provides a logical progression of concepts for students.
  • Preparing your students for immediate finance and spreadsheet success, FINANCIAL ANALYSIS WITH MICROSOFT® EXCEL® 2016, 8E, delivers thorough coverage of introductory and advanced spreadsheet skills as it helps learners maximize EXCEL® 2016's new functions and features.
  • Every chapter includes all-new screen captures that showcase the features in Excel® 2016 as well as provide students with an example of what they will see when they use the program themselves.
  • Chapter 10, Bond Valuation, includes an excellent approximation for convexity as well as a user-defined function for calculating exact convexity on any date. The chapter also uses the new Get & Transform feature (formerly known as the Power Query add-in) to get yield curve data. Get & Transform is used extensively in Chapter 16, Analyzing Datasets with Tables and Pivot Tables, which details its powerful tools for processing data files.
  • Chapter 13, Risk in Capital Budgeting, includes coverage of the new Histogram chart added to Excel® 2016.
  • Chapter 12, Capital Budgeting, now explains how to use an IF statement for calculating the payback period.
  • An all-new chapter focuses on using time series techniques for forecasting quarterly revenues.
  • 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 it an ideal resource for independent learning as well as a valuable reference tool.
  • COMBINE COMPREHENSIVE FINANCE COVERAGE WITH ESSENTIAL SPREADSHEET SKILLS. Providing much more than a mere spreadsheet book 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® 2016.
  • INTRODUCTORY LEVEL IS IDEAL FOR STUDENTS UNFAMILIAR WITH EXCEL®. The eighth edition's reader-friendly approach begins at a basic introductory level that's perfect for learners who are not very familiar with Excel® and then quickly advances to topics that will also challenge those entering the course with a basic understanding of spreadsheets.
  • COVERAGE OF THE SOLVER, THE FORECAST SHEET, GET & TRANSFORM, AND PIVOT TABLES HELPS STUDENTS MAXIMIZE POWERFUL EXCEL® TOOLS. Give your students a thorough introduction to more advanced 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.
  • EQUIP STUDENTS WITH BOTH BASIC SKILLS AND ADVANCED FINANCIAL TECHNIQUES FOR USING EXCEL® 2016. This proven, reader-friendly text introduces the fundamentals of using spreadsheets as well as more complex skills for using Excel® 2016 to build financial statements. After establishing a solid foundation, the book launches into more sophisticated techniques for performance evaluation, forecasting, valuation, and capital budgeting.

Table of Contents

Show More Show Less
1. Introduction to Excel® 2016.
2. The Basic Financial Statements.
3. Financial Statement Analysis Tools.
4. The Cash Budget.
5. Financial 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.

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 Website for Mayes/Shank's Financial Analysis with Microsoft® Excel, 8th

Instructor's Website



Compare Buying Options

Show More Show Less

Pricing Options

Financial Analysis with Microsoft® Excel® 2016, 8E

  • ISBN-10: 1337298042
  • ISBN-13: 9781337298049

Price USD$ 99.95

eBook: Financial Analysis with Microsoft® Excel® 2016, 8E 12Months

  • ISBN-10: 8000010674
  • ISBN-13: 9788000010670

Price USD$ 58.49


*Purchase not available for this country