Book Categories

Description of Fin Analysis W/Micrsft Excel

Start mastering the tool that finance professionals depend upon every day. FINANCIAL ANALYSIS WITH MICROSOFT A(R) EXCEL covers all the topics you'll see in a corporate finance course: financial statements, budgets, the Market Security Line, pro forma statements, cost of capital, equities, and debt. Plus, it's easy-to-read and full of study tools that will help you succeed in class.

Title Information

ISBN:

9780324407501

Pages:

476 pages

Format:

Paperback

Product Code:

27050

Publisher:

Cengage Learning EMEA

Published:

14/09/2006

Edition:

3rd Revised edition

Write a review of this book

Customer Reviews from Amazon

About SHANK and MAYES

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.

Contents of Fin Analysis W/Micrsft 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