The Power of Gold- The History of an Obsession

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. Combining the best of Excel 2016 with a solid foundation in corporate finance, Mayes/Shank's FINANCIAL ANALYSIS WITH MICROSOFT EXCEL 2016, 8E, equips students with the skills to solve real-world financial problems. With a new focus on time series forecasting and Get & Transform tools (formerly known as Power Query), the text delivers comprehensive coverage of the corporate finance topics most important to employers, including financial statements, cash budgets, the Security Market Security Line, pro forma financial statements, cost of capital, VBA programming, and Pivot Tables. A reader-friendly, self-directed learning approach and numerous study tools make the book an ideal resource for learners of all levels. It begins with the basics before moving quickly into the more advanced features of Excel 2016. In addition, its easy-to-understand presentation helps students build upon their spreadsheet skills while strengthening their understanding of contemporary corporate finance.-- Provided by Publisher Contents 4 Preface 14 1 Introduction to Excel 2016 22 2 The Basic Financial Statements 62 3 Financial Statement Analysis Tools 90 4 The Cash Budget 124 5 Financial Statement Forecasting 160 6 Forecasting Sales with Time Series Methods 188 7 Break-Even and Leverage Analysis 216 8 The Time Value of Money 236 9 Common Stock Valuation 268 10 Bond Valuation 304 11 The Cost of Capital 342 12 Capital Budgeting 368 13 Risk and Capital Budgeting 410 14 Portfolio Statistics and Diversification 446 15 Writing User-Defined Functions with VBA 484 16 Analyzing Datasets with Tables and Pivot Tables 514 Appendix: Directory of User-Defined Functions in FameFncs.xlam 550 Index 554