catalog
Home
>

Higher Education

shoe image

Financial Analysis with Microsoft® Excel® 2016

Author(s): Timothy R. Mayes | Todd M. Shank

ISBN: 9789355738073

8th Edition

Copyright: 2018

India Release: 2023

₹910

Binding: Paperback

Pages: 560

Trim Size: 254 x 203 mm

Refer Book

Order Inspection Copy

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.

  • The book uses an easy-to-understand presentation and self-directed learning approach, making it ideal for independent study and reference.
  • It combines comprehensive finance coverage with essential spreadsheet skills, going beyond templates to teach real problem-solving with Excel® 2016.
  • The introductory level is perfect for students unfamiliar with Excel®, while also offering challenges for those with basic knowledge.
  • Coverage includes advanced Excel® tools like Solver, Forecast Sheet, Get & Transform, and Pivot Tables to enhance data analysis skills.
  • Students learn both basic spreadsheet functions and advanced financial techniques such as forecasting, valuation, and capital budgeting.
  • The book prepares students for success by thoroughly covering both introductory and advanced Excel® 2016 features.
  • Each chapter includes updated screen captures that reflect the Excel® 2016 interface, helping students visualize and follow along easily.

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

Timothy R. Mayes

Timothy R. Mayes serves as finance professor at Metropolitan State College of Denver.

 

Todd M. Shank

Todd M. Shank is Associate Dean and M.B.A. Director of the Robert B. Pamplin, Jr. School of Business Administration at the University of Portland in Oregon.

Related Books