
- English
- PDF
- Available on iOS & Android
Financial Analysis with Microsoft Excel
About this book
Gain the hands-on experience and knowledge to solve real financial problems while taking your Excel® spreadsheet skills to a new level with Mayes' FINANCIAL ANALYSIS WITH MICROSOFT® EXCEL®, 9E. This edition provides a reader-friendly solid foundation in corporate finance while teaching you to maximize the spreadsheet tools that professionals use every day. Packed with interesting examples, this edition covers today's most important corporate finance topics and tools, including financial statements, budgets, the Security Market Security Line, pro forma financial statements, cost of capital, Visual Basic Applications (VBA) programming and Excel® pivot tables. You study the latest information on time series forecasting and work with Excel®'s Get & Transform feature to process large data files. This edition's self-directed learning approach and numerous self-study tools let you strengthen spreadsheet skills while equipping you with the expertise today's employers want in corporate finance.
Frequently asked questions
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Information
Table of contents
- Cover
- Contents
- Preface
- Chapter 1: Introduction to Excel
- Chapter 2: The Basic Financial Statements
- Chapter 3: Financial Statement Analysis Tools
- Chapter 4: The Cash Budget
- Chapter 5: Financial Statement Forecasting
- Chapter 6: Forecasting Sales with Time Series Methods
- Chapter 7: Break-Even and Leverage Analysis
- Chapter 8: The Time Value of Money
- Chapter 9: Common Stock Valuation
- Chapter 10: Bond Valuation
- Chapter 11: The Cost of Capital
- Chapter 12: Capital Budgeting
- Chapter 13: Risk and Capital Budgeting
- Chapter 14: Portfolio Statistics and Diversification
- Chapter 15: Writing User-Defined Functions with VBA
- Chapter 16: Analyzing Datasets with Tables and Pivot Tables
- Appendix: Directory of User-Defined Functions in FameFncs.xlam
- Index