Includes bibliographical references and index.

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.--