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.
Features:
- 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®.
About the Author
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.
