Financial Analysis with Microsoft Excel, 7th Edition

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.

Table of Contents

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