Financial analysis with microsoft excel 2016/ (Record no. 23073)

MARC details
000 -LEADER
fixed length control field 04337nam a22001937a 4500
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
ISBN 9789355738073
041 ## - LANGUAGE CODE
Language code of text/sound track or separate title English
082 ## - DEWEY DECIMAL CLASSIFICATION NUMBER
Classification number 658.1502
Item number MAY
100 ## - MAIN ENTRY--AUTHOR NAME
Author name Mayes R, Timothy.
245 ## - TITLE STATEMENT
Title Financial analysis with microsoft excel 2016/
Statement of responsibility, etc Timothy R. Mayes.
250 ## - EDITION STATEMENT
Edition statement 8th ed.
260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)
Place of publication Delhi, India:
Name of publisher Cengage,
Year of publication 2018.
300 ## - PHYSICAL DESCRIPTION
Number of Pages xx, 540 pages;
Other physical details illustrations;
Dimensions 26 cm.
504 ## - BIBLIOGRAPHY, ETC. NOTE
Bibliography, etc Includes bibliographical references and index.
505 ## - FORMATTED CONTENTS NOTE
Formatted contents note Intro<br/>Title page<br/>Copyright page<br/>Contents<br/>Preface<br/>Purpose of the Book<br/>Target Audience<br/>A Note to Students<br/>Organization of the Book<br/>Outstanding Features<br/>Pedagogical Features<br/>Supplements<br/>Typography Conventions<br/>Changes from the 7th Edition<br/>A Note on the Internet<br/>Acknowledgments<br/>Chapter 1: Introduction to Excel 2016<br/>Spreadsheet Uses<br/>Starting Microsoft Excel<br/>Parts of the Excel Screen<br/>The File Tab and Quick Access Toolbar<br/>The Home Tab<br/>The Formula Bar<br/>The Worksheet Area<br/>Sheet Tabs<br/>Status Bar<br/>Navigating the Worksheet Selecting a Range of Cells<br/>Using Defined Names<br/>Entering Text and Numbers<br/>Formatting and Alignment Options<br/>Formatting Numbers<br/>Adding Borders and Shading<br/>Entering Formulas<br/>Copying and Moving Formulas<br/>Mathematical Operators<br/>Parentheses and the Order of Operations<br/>Using Excel's Built-In Functions<br/>Using the Insert Function Dialog Box<br/>"Dot Functions" in Excel 2016<br/>Using User-Defined Functions<br/>Creating Graphics<br/>Creating Charts in a Chart Sheet<br/>Creating Embedded Charts<br/>Formatting Charts<br/>Changing the Chart Type<br/>Creating Sparkline Charts<br/>Printing Using Excel with Other Applications<br/>Quitting Excel<br/>Best Practices for Spreadsheet Models<br/>Summary<br/>Problems<br/>Internet Exercise<br/>Chapter 2: The Basic Financial Statements<br/>The Income Statement<br/>Building an Income Statement in Excel<br/>The Balance Sheet<br/>Building a Balance Sheet in Excel<br/>Improving Readability: Custom Number Formats<br/>Common-Size Financial Statements<br/>Creating Common-Size Income Statements<br/>Creating a Common-Size Balance Sheet<br/>Building a Statement of Cash Flows<br/>Using Excel's Outliner<br/>Common-Size Statement of Cash Flows<br/>Summary<br/>Problems Internet Exercise<br/>Chapter 3: Financial Statement Analysis Tools<br/>Liquidity Ratios<br/>The Current Ratio<br/>The Quick Ratio<br/>Efficiency Ratios<br/>Inventory Turnover Ratio<br/>Accounts Receivable Turnover Ratio<br/>Average Collection Period<br/>Fixed Asset Turnover Ratio<br/>Total Asset Turnover Ratio<br/>Leverage Ratios<br/>The Total Debt Ratio<br/>The Long-Term Debt Ratio<br/>The Long-Term Debt to Total Capitalization Ratio<br/>The Debt to Equity Ratio<br/>The Long-Term Debt to Equity Ratio<br/>Coverage Ratios<br/>The Times Interest Earned Ratio<br/>The Cash Coverage Ratio<br/>Profitability Ratios The Gross Profit Margin<br/>The Operating Profit Margin<br/>The Net Profit Margin<br/>Return on Total Assets<br/>Return on Equity<br/>Return on Common Equity<br/>DuPont Analysis<br/>Analysis of EPI's Profitability Ratios<br/>Financial Distress Prediction<br/>The Original Z-Score Model<br/>The Z-Score Model for Private Firms<br/>Using Financial Ratios<br/>Trend Analysis<br/>Comparing to Industry Averages<br/>Company Goals and Debt Covenants<br/>Automating Ratio Analysis<br/>Economic Profit Measures of Performance<br/>Summary<br/>Problems<br/>Internet Exercise<br/>Chapter 4: The Cash Budget<br/>The Worksheet Area<br/>
520 ## - SUMMARY, ETC.
Summary, etc 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.
650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM
Subject Microsoft Excel (Computer file)
942 ## - ADDED ENTRY ELEMENTS (KOHA)
Source of classification or shelving scheme Dewey Decimal Classification
Koha item type Books
Holdings
Withdrawn status Lost status Source of classification or shelving scheme Damaged status Not for loan Home library Current library Shelving location Date acquired Source of acquisition Cost, normal purchase price Bill Date Full call number Accession Number Price effective from Koha item type
    Dewey Decimal Classification     Institute of Public Enterprise, Library Institute of Public Enterprise, Library S Campus 05/07/2024 Professional Book Services 799.00 29/11/2023 658.1502 MAY 48091 05/07/2024 Books
    Dewey Decimal Classification     Institute of Public Enterprise, Library Institute of Public Enterprise, Library S Campus 05/07/2024 Professional Book Services 799.00 29/11/2023 658.1502 MAY 48092 05/07/2024 Books
    Dewey Decimal Classification     Institute of Public Enterprise, Library Institute of Public Enterprise, Library S Campus 05/07/2024 Professional Book Services 799.00 29/11/2023 658.1502 MAY 48093 05/07/2024 Books
    Dewey Decimal Classification     Institute of Public Enterprise, Library Institute of Public Enterprise, Library S Campus 05/07/2024 Professional Book Services 799.00 29/11/2023 658.1502 MAY 48094 05/07/2024 Books
    Dewey Decimal Classification     Institute of Public Enterprise, Library Institute of Public Enterprise, Library S Campus 05/07/2024 Professional Book Services 799.00 29/11/2023 658.1502 MAY 48095 05/07/2024 Books

Maintained and Designed by
2cqr automation private limited, Chennai. All Rights Reserved.

You are Visitor Number

PHP Hits Count