Financial analysis with microsoft excel 2016/ (Record no. 23073)
[ view plain ]
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 |
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 |