Help students master the latest features in Excel® 2010 while establishing a strong foundation in corporate finance. With Mayes/Shank’s FINANCIAL ANALYSIS WITH MICROSOFT® EXCEL® 2010, 6E, your students develop a proficiency in using Excel® 2010 to solve real financial problems without sacrificing any finance background. This edition covers all of the topics in 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 both an ideal resource for independent learning and a valuable long-term reference tool. Because today's typical students enter college with basic spreadsheet skills, this new edition covers the basics early for those with no background, before moving quickly into many of the more advanced and most powerful features of Excel® 2010. This edition offers new focus on Excel® tables, pivot tables and pivot charts and other areas that have become increasingly important to today’s employers. 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® 2010 with the understanding of corporate finance that they need to succeed with Mayes' FINANCIAL ANALYSIS WITH MICROSOFT® EXCEL® 2010, 6E.
Table of Contents
1. Introduction to EXCEL® 2010.
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. Common Stock Valuation.
9. Bond Valuation.
10. The Cost of Capital.
11. Capital Budgeting.
12. Risk and Capital Budgeting.
13. Portfolio Statistics and Diversification.
14. Writing User-Defined Functions with VBA.
15. Analyzing Datasets with Tables and Pivot Tables.