Financial Analysis with Microsoft Excel, 9th Edition

Timothy R. Mayes

Copyright 2021
{{checkPublicationMessage('Published', '2020-01-22T00:00:00+0000')}}

Starting At $77.95 See pricing and ISBN options

Instructor Next Steps

Students: Buy now

Financial Analysis with Microsoft Excel 9th Edition by Timothy R. Mayes

Quick Navigation

Overview
Meet the Author
What's New
Features
Table of Contents
Pricing

Overview

Equip your students with the skills and knowledge to solve real-world financial problems as Mayes' FINANCIAL ANALYSIS WITH MICROSOFT® EXCEL®, 9E combines the power of Excel® with a solid foundation in corporate finance. This edition provides a new focus on time series forecasting and Get & Transform tools (formerly Power Query). Comprehensive coverage addresses the corporate finance topics and tool most important to today's employers, including financial statements, cash budgets, the Security Market Security Line, pro forma financial statements, cost of capital, Visual Basic Applications (VBA) programming and pivot tables. A reader-friendly, self-directed learning approach and numerous study tools make this resource ideal for learners of all levels. This edition begins with the basics before quickly moving into more advanced Excel® features. The easy-to-understand presentation helps students solidify spreadsheet skills while strengthening an understanding of contemporary corporate finance.

Meet the Authors

{{collapseContainerClosed['meet-the-author'] ? 'Show More' : 'Show Less'}}

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.

What's New

{{collapseContainerClosed['whats-new'] ? 'Show More' : 'Show Less'}}

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.

Features

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

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

{{collapseContainerClosed['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.