Amazon cover image
Image from Amazon.com

Financial analysis with microsoft excel 2016/ Timothy R. Mayes.

By: Material type: TextTextLanguage: English Publication details: Delhi, India: Cengage, 2018.Edition: 8th edDescription: xx, 540 pages; illustrations; 26 cmISBN:
  • 9789355738073
Subject(s): DDC classification:
  • 658.1502 MAY
Contents:
Intro Title page Copyright page Contents Preface Purpose of the Book Target Audience A Note to Students Organization of the Book Outstanding Features Pedagogical Features Supplements Typography Conventions Changes from the 7th Edition A Note on the Internet Acknowledgments Chapter 1: Introduction to Excel 2016 Spreadsheet Uses Starting Microsoft Excel Parts of the Excel Screen The File Tab and Quick Access Toolbar The Home Tab The Formula Bar The Worksheet Area Sheet Tabs Status Bar Navigating the Worksheet Selecting a Range of Cells Using Defined Names Entering Text and Numbers Formatting and Alignment Options Formatting Numbers Adding Borders and Shading Entering Formulas Copying and Moving Formulas Mathematical Operators Parentheses and the Order of Operations Using Excel's Built-In Functions Using the Insert Function Dialog Box "Dot Functions" in Excel 2016 Using User-Defined Functions Creating Graphics Creating Charts in a Chart Sheet Creating Embedded Charts Formatting Charts Changing the Chart Type Creating Sparkline Charts Printing Using Excel with Other Applications Quitting Excel Best Practices for Spreadsheet Models Summary Problems Internet Exercise Chapter 2: The Basic Financial Statements The Income Statement Building an Income Statement in Excel The Balance Sheet Building a Balance Sheet in Excel Improving Readability: Custom Number Formats Common-Size Financial Statements Creating Common-Size Income Statements Creating a Common-Size Balance Sheet Building a Statement of Cash Flows Using Excel's Outliner Common-Size Statement of Cash Flows Summary Problems Internet Exercise Chapter 3: Financial Statement Analysis Tools Liquidity Ratios The Current Ratio The Quick Ratio Efficiency Ratios Inventory Turnover Ratio Accounts Receivable Turnover Ratio Average Collection Period Fixed Asset Turnover Ratio Total Asset Turnover Ratio Leverage Ratios The Total Debt Ratio The Long-Term Debt Ratio The Long-Term Debt to Total Capitalization Ratio The Debt to Equity Ratio The Long-Term Debt to Equity Ratio Coverage Ratios The Times Interest Earned Ratio The Cash Coverage Ratio Profitability Ratios The Gross Profit Margin The Operating Profit Margin The Net Profit Margin Return on Total Assets Return on Equity Return on Common Equity DuPont Analysis Analysis of EPI's Profitability Ratios Financial Distress Prediction The Original Z-Score Model The Z-Score Model for Private Firms Using Financial Ratios Trend Analysis Comparing to Industry Averages Company Goals and Debt Covenants Automating Ratio Analysis Economic Profit Measures of Performance Summary Problems Internet Exercise Chapter 4: The Cash Budget The Worksheet Area
Summary: 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.
List(s) this item appears in: New Arrivals - May 1st to 31st 2024
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Call number Status Date due Barcode
Books Institute of Public Enterprise, Library S Campus 658.1502 MAY (Browse shelf(Opens below)) Available 48091
Books Institute of Public Enterprise, Library S Campus 658.1502 MAY (Browse shelf(Opens below)) Available 48092
Books Institute of Public Enterprise, Library S Campus 658.1502 MAY (Browse shelf(Opens below)) Available 48093
Books Institute of Public Enterprise, Library S Campus 658.1502 MAY (Browse shelf(Opens below)) Available 48094
Books Institute of Public Enterprise, Library S Campus 658.1502 MAY (Browse shelf(Opens below)) Available 48095

Includes bibliographical references and index.

Intro
Title page
Copyright page
Contents
Preface
Purpose of the Book
Target Audience
A Note to Students
Organization of the Book
Outstanding Features
Pedagogical Features
Supplements
Typography Conventions
Changes from the 7th Edition
A Note on the Internet
Acknowledgments
Chapter 1: Introduction to Excel 2016
Spreadsheet Uses
Starting Microsoft Excel
Parts of the Excel Screen
The File Tab and Quick Access Toolbar
The Home Tab
The Formula Bar
The Worksheet Area
Sheet Tabs
Status Bar
Navigating the Worksheet Selecting a Range of Cells
Using Defined Names
Entering Text and Numbers
Formatting and Alignment Options
Formatting Numbers
Adding Borders and Shading
Entering Formulas
Copying and Moving Formulas
Mathematical Operators
Parentheses and the Order of Operations
Using Excel's Built-In Functions
Using the Insert Function Dialog Box
"Dot Functions" in Excel 2016
Using User-Defined Functions
Creating Graphics
Creating Charts in a Chart Sheet
Creating Embedded Charts
Formatting Charts
Changing the Chart Type
Creating Sparkline Charts
Printing Using Excel with Other Applications
Quitting Excel
Best Practices for Spreadsheet Models
Summary
Problems
Internet Exercise
Chapter 2: The Basic Financial Statements
The Income Statement
Building an Income Statement in Excel
The Balance Sheet
Building a Balance Sheet in Excel
Improving Readability: Custom Number Formats
Common-Size Financial Statements
Creating Common-Size Income Statements
Creating a Common-Size Balance Sheet
Building a Statement of Cash Flows
Using Excel's Outliner
Common-Size Statement of Cash Flows
Summary
Problems Internet Exercise
Chapter 3: Financial Statement Analysis Tools
Liquidity Ratios
The Current Ratio
The Quick Ratio
Efficiency Ratios
Inventory Turnover Ratio
Accounts Receivable Turnover Ratio
Average Collection Period
Fixed Asset Turnover Ratio
Total Asset Turnover Ratio
Leverage Ratios
The Total Debt Ratio
The Long-Term Debt Ratio
The Long-Term Debt to Total Capitalization Ratio
The Debt to Equity Ratio
The Long-Term Debt to Equity Ratio
Coverage Ratios
The Times Interest Earned Ratio
The Cash Coverage Ratio
Profitability Ratios The Gross Profit Margin
The Operating Profit Margin
The Net Profit Margin
Return on Total Assets
Return on Equity
Return on Common Equity
DuPont Analysis
Analysis of EPI's Profitability Ratios
Financial Distress Prediction
The Original Z-Score Model
The Z-Score Model for Private Firms
Using Financial Ratios
Trend Analysis
Comparing to Industry Averages
Company Goals and Debt Covenants
Automating Ratio Analysis
Economic Profit Measures of Performance
Summary
Problems
Internet Exercise
Chapter 4: The Cash Budget
The Worksheet Area

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.

There are no comments on this title.

to post a comment.

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

You are Visitor Number

PHP Hits Count