Financial Analysis with Microsoft Excel, 6th Edition

Now readers can master their Excel 2010 skills while establishing a strong understanding of contemporary corporate finance. Mayes/Shank’s Financial Analysis with Microsoft Excel, 6th Edition shows today’s reader how to tap into some of Excel 2010’s most powerful tools to solve real financial problems. The book’s solid content addresses today’s most important corporate finance topics, including financial statements, budgets, the Market Security Line, pro forma statements, cost of capital, equities, and debt. This edition now covers Excel tables, pivot tables and pivot charts and other areas that have become increasingly important to today’s employers. The book’s reader-friendly, self-directed learning approach and numerous study tools help readers build upon basic skills for the Excel 2010 proficiency and the solid finance knowledge business professionals need for success.

Table of Contents

Chapter 1 Introduction to Excel 2010
Chapter 2 The Basic Financial Statements
Chapter 3 The Cash Budget
Chapter 4 Financial Statement Analysis Tools
Chapter 5 Financial Forecasting
Chapter 6 Break-Even and Leverage Analysis
Chapter 7 The Time Value of Money
Chapter 8 Common Stock Valuation
Chapter 9 Bond Valuation
Chapter 10 The Cost of Capital
Chapter 11 Capital Budgeting
Chapter 12 Risk and Capital Budgeting
Chapter 13 Portfolio Statistics and Diversification
Chapter 14 Writing User-Defined Functions with VBA
Chapter 15 Analyzing Datasets with Tables and Pivot Tables
Appendix: Directory of User-defined Functions in Famefncs.xlam