Financial Analysis with Microsoft Excel 2007

Excel has become the tool of choice in finance education and in practice. This book is designed for a wide variety of students and practitioners of finance. This text is a strong choice for undergraduate business courses, either as an ancillary text in conjunction with a Corporate Finance text or as part of a business technology course that covers Excel, WORD, PPT, and other commonly used business programs. The topics covered generally follow those in an introductory financial management course for undergraduates or first-year MBA students. Because of the emphasis on spreadsheet building skills, the book is also appropriate as a reference for case-oriented courses in which the spreadsheet is used extensively. Students typically enter the class prepared to use Microsoft Office programs. As a result, this edition raises the level of learning and focuses less on basics and more on the financial analysis aspects. Instructors will find that their students can use this book on their own time, minimizing the amount of class time required for teaching the rudiments of spreadsheets. Practitioners will find that the book will help them transfer skills from other spreadsheets to Excel, and at the same time, update their knowledge of corporate finance.

Master the tool that finance professionals depend upon every day as you perfect your skills in Excel 2007 while establishing a strong understanding of contemporary corporate finance. Mayes/Shank's FINANCIAL ANALYSIS WITH MICROSOFT EXCEL 2007, 5th Edition shows today's reader how to tap into some of Excel 2007's most powerful tools to solve real financial problems. The book's solid content covers all of the topics from today's corporate finance course, including financial statements, budgets, the Market Security Line, pro forma statements, cost of capital, equities, and debt. A reader-friendly, self-directed learning approach and numerous study tools help you build upon basic skills or transfer skills from other spreadsheet programs for the Excel skills and solid finance knowledge today's developing business professionals need for success.

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