Financial analysis with microsoft excel 2016/
Mayes R, Timothy.
Financial analysis with microsoft excel 2016/ Timothy R. Mayes. - 8th ed. - Delhi, India: Cengage, 2018. - xx, 540 pages; illustrations; 26 cm.
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.
9789355738073
Microsoft Excel (Computer file)
658.1502 / MAY
Financial analysis with microsoft excel 2016/ Timothy R. Mayes. - 8th ed. - Delhi, India: Cengage, 2018. - xx, 540 pages; illustrations; 26 cm.
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.
9789355738073
Microsoft Excel (Computer file)
658.1502 / MAY
2cqr automation private limited, Chennai. All Rights Reserved.