Financial Analysis with Microsoft Excel 2007

Front Cover
Cengage Learning, Mar 26, 2009 - Business & Economics - 480 pages
Help your students master THE calculating tool of choice for today’s financial professionals -- Excel -- while gaining a strong foundation in corporate finance. With Mayes/Shank’s FINANCIAL ANALYSIS WITH MICROSOFT EXCEL 2007, 5th Edition, you can take your students to a new level of proficiency in using Excel 2007 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 make this book an ideal resource for independent learning as well as a valuable long-term reference tool. Because today’s typical students enter college with basic spreadsheet skills, this new edition takes learning to a new level -- covering the basics early and moving quickly into many of the more advanced and most powerful features of Excel. The book’s easy-to-understand presentation helps students build upon or transfer skills from other spreadsheet programs as they establish a strong understand of contemporary corporate finance. Give your students the valuable, highly marketable skills in Excel and corporate finance that they need to succeed now and throughout their careers with the latest in Mayes/Shank’s FINANCIAL ANALYSIS WITH MICROSOFT EXCEL 2007, 5th Edition.
Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
 

What people are saying - Write a review

User Review - Flag as inappropriate

Invaluable step by step instruction on how to use excel for finance.

Contents

Introduction to Excel 2007
1
The Basic Financial Statements
41
The Cash Budget
67
Financial Statement Analysis Tools
99
Financial Forecasting
135
BreakEven and Leverage Analysis
163
The Time Value of Money
183
Common Stock Valuation
215
The Cost of Capital
285
Capital Budgeting
311
Risk and Capital Budgeting
355
Portfolio Statistics and Diversification
391
Writing UserDefined Functions with VBA
425
Directory of UserDefined Functions in Famefncsxlam
451
Index
455
Copyright

Bond Valuation
247

Other editions - View all

Common terms and phrases

About the author (2009)

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.

Bibliographic information