Financial Analysis with Microsoft® Excel®, 7th Edition
- Timothy R. Mayes
- ISBN-10: 1285432274
- ISBN-13: 9781285432274
- 544 Pages | Paperback
- Previous Editions: 2012, 2010, 2007
- COPYRIGHT: 2015 Published
Help students master the latest features in Excel® 2013 while establishing a strong foundation in corporate finance. With Mayes's FINANCIAL ANALYSIS WITH MICROSOFT® EXCEL® 2013, 7E, your students develop a proficiency in using Excel® 2013 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® 2013. 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® 2013 with the understanding of corporate finance that they need to succeed with Mayes' FINANCIAL ANALYSIS WITH MICROSOFT® EXCEL® 2013,7E.
1. Introduction to Excel 2013.
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.
All supplements have been updated in coordination with the Main title.
Please see Main title page for new to this edition information.
Instructor's Manual provides additional problem sets and solutions. Instructor Spreadsheets provide active spreadsheets for end of chapter problems as well as solutions. Worksheets are provided for spreadsheet Exhibits in each Chapter.