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® 2016 8th Edition

Timothy R. Mayes | Todd M. Shank

Textbook Only Options

Traditional eBook and Print Options

{{collapseContainerClosed['9781337298049_txtbook_0'] ? 'Show More' : 'Show Less'}}
z

  • ISBN-10: 1337670006
  • ISBN-13: 9781337670005
  • STARTING AT $45.49

  • STARTING AT $55.49

  • ISBN-10: 1337298042
  • ISBN-13: 9781337298049
  • Bookstore Wholesale Price $104.50
  • RETAIL $138.95

Overview

Combining the best of Excel® 2016 with a solid foundation in corporate finance, Mayes/Shank's FINANCIAL ANALYSIS WITH MICROSOFT® EXCEL® 2016, 8E, equips students with the skills to solve real-world financial problems. With a new focus on time series forec

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.
  • 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 Int
  • 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
  • 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 too
  • 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 sta
  • 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 empo

Financial Analysis with Microsoft® Excel® 2016

TABLE OF CONTENTS

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.