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.
New to this edition
Preparing your students for immediate finance and spreadsheet success, FINANCIAL ANALYSIS WITH MICROSOFT® EXCEL® 2016, 8E, delivers thorough coverage of introductory and advanced spreadsheet skills as it helps learners maximize EXCEL® 2016's new functions and features.
An all-new chapter focuses on using time series techniques for forecasting quarterly revenues.
Chapter 10, Bond Valuation, includes an excellent approximation for convexity as well as a user-defined function for calculating exact convexity on any date. The chapter also uses the new Get & Transform feature (formerly known as the Power Query add-in) to get yield curve data. Get & Transform is used extensively in Chapter 16, Analyzing Datasets with Tables and Pivot Tables, which details its powerful tools for processing data files.
Chapter 12, Capital Budgeting, now explains how to use an IF statement for calculating the payback period.
Chapter 13, Risk in Capital Budgeting, includes coverage of the new Histogram chart added to Excel® 2016.
The chapter on cash budgeting now comes after the chapter on financial ratios so that coverage of financial ratios immediately follows financial statements. This new chapter order provides a logical progression of concepts for students.
Every chapter includes all-new screen captures that showcase the features in Excel® 2016 as well as provide students with an example of what they will see when they use the program themselves.
1. Introduction to Excel® 2016.
2. The Basic Financial Statements.
3. Financial Statement Analysis Tools.
4. The Cash Budget.
5. Financial 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.