Financial Analysis with Microsoft Excel

✍ Scribed by Timothy R. Mayes

• Publisher: Cengage
• Year: 2017
• Tongue: English
• Leaves: 561
• Edition: 8
• Category: Library

✦ Synopsis

Take your spreadsheet skills to a new level of proficiency! Giving you hands-on experience solving real financial problems, Mayes/Shank's FINANCIAL ANALYSIS WITH MICROSOFT® EXCEL® 2016, 8E, equips you with a solid foundation in corporate finance while helping you maximize the tools professionals use every day. Packed with examples, the text covers today's most important corporate finance topics, including financial statements, budgets, the Security Market Security Line, pro forma financial statements, cost of capital, VBA programming, and Pivot Tables. It also offers the latest on time series forecasting and the new Get & Transform feature (formerly known as Power Query), which helps you process large data files. A reader-friendly, self-directed learning approach and numerous study tools enable you to quickly build upon or transfer skills from other spreadsheet programs -- empowering you with the expertise today's employers want.

✦ Table of Contents

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