Loading...

Financial Analysis with Microsoft Excel,
9th Edition

Timothy R. Mayes, Todd M. Shank

ISBN-13: 9780357442050 | ISBN-10: 0357442059

Copyright 2021

| Published 2020

| 560 pages

List Price USD $99.95

Overview

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.

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

Table of Contents

Show More Show Less
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.

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 Manual (Internal Only) for Mayes' Financial Analysis with Microsoft Excel

ISBN13:9780357131176
ISBN10:0357131177

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

ISBN13:9780357131169
ISBN10:0357131169
Everything you need for your course in one place! This collection of product-specific lecture and class tools is available online via the instructor resource center at www.cengage.com/login. You'll be able to access and download materials such as PowerPoint® presentations, images, instructor’s manual, videos, and more.

Compare Buying Options

Show More Show Less

Pricing Options

Financial Analysis with Microsoft Excel

  • ISBN-10: 0357442059
  • ISBN-13: 9780357442050

Price USD$ 99.95

eBook: Financial Analysis with Microsoft Excel 12Months

  • ISBN-10: 8000029324
  • ISBN-13: 9788000029320

Price USD$ 46.49

Buy

*Purchase not available for this country