|
|
|
In stock, usually dispatched within 24 hours
| Rate this book...
Rating: 0.0/5 (0 votes cast)
|
|
|
|
|
Description of Financial Analysis Using Microsoft Excel |
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.
Benefits
- Teaches basics of spreadsheet usage, uses Excel to build basic financial statements, then "springboards" into techniques for performance evaluation, forecasting, valuation, and capital budgeting.
New to this edition
- We show a bit more of Excel''s modeling capabilities, with VBA and other analyses - emphasizing less basic material and moving the book towards a more sophisticated approach.
- Chapter 8 has been separated into two chapters -- one on bonds, which discusses valuation models, convexity, duration, and the term structure of interest rates -- and one on stocks -- which shows portfolio benefits, betas, various ratio analyses, and valuation models.
- We have improved the end-of-chapter materials so that they rely less on templates or "black boxes" and instead emphasize Excel as a tool to truly learn financial concepts.
- Produce short camtasia illustrations to show students how to perform some of the more sophisticated Excel functions.
- This book is not just templates, not just a spreadsheet book. It is a finance textbook that teaches how to solve financial problems using Excel.
- The DuPont system of decomposing the ROE has been added to Chapter 4.
- New coverage of economic value added (EVA).
- Coverage of Microsoft Excel''s new tools for debugging formulas, like formula evaluator, color cell features and watch windows.
- Chapters 2 (The Basic Financial Statements) and 3 (The Cash Budget) have been thoroughly revised to clarify and emphasize key financial tools.
|
Contents of Financial Analysis Using Microsoft Excel |
1: Spreadsheet Basics
2: The Basic Financial Statements
3: The Cash Budget
4: Financial Statement Analysis Tools
5: Financial Forecasting
6: Break-even and Leverage Analysis
7: The Time Value of Money
8: Stock Valuation and Rates of Return
9: Bond Valuation
10: The Cost of Capital
11: Capital Budgeting
12: Risk, Capital Budgeting, and Diversification
13: Using VBA to Create Function Macros
|
About Timothy Mayes and Todd Shank |
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 mayest@mscd.edu.
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.
|
Other books by Timothy Mayes
Other books by Todd Shank
Bulk buying
| If you need bulk copies of Financial Analysis Using Microsoft Excel, or are interested in opening a corporate account, please contact us. |
|
|
Shopping basket