Financial Analysis with Microsoft Excel - 4th edition

  • ISBN: 0324407505
  • Author: Timothy R. Mayes Todd M. Shank
  • Publisher: South-Western College Pub
  • Publication Date: 2006-08-15

FAME explores the use of Excel as THE calculating tool for finance professionals. As students enter College with basic skills for using Excel and other software packages they need for their business courses, the materials they read must be ramped up. The book as it stands covers the main topics that students would see in a typical corporate finance course: financial statements, budgets, TVM, capital budgeting, the Market Security Line, some options materials, pro forma statements, cost of capital, equities, and debt. In the final chapter of this revision, we include a section on how students can build their own models (or macros) to perform everyday financial analyses.

About the Author
Timothy R. Mayes is a finance professor at Metropolitan State College of Denver. He holds a BS/BA 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. Dr. Mayes may be contacted by e-mail at Todd M. Shank, Ph.D. is Associate Dean and MBA Director, Robert B. Pamplin, Jr. School of Business Administration at the University of Portland in Portland, Oregon. He was recently chosen to serve as a Fulbright Lecturer in China (during the Spring, 2003 semester), where he will teach corporate financial management in the graduate school at Sun Yat-sen University in Guangzhou. Shank formerly 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 over 20 years. During that time, he has served on the faculties of three universities, published two textbooks and academic articles in journals including American Business Review, Global Business and Finance Review, Journal of Foreign Exchange and International Finance, and the Journal of Financial Education, among others. 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.