Financial Analysis with Microsoft Excel 2916 8th edition by Timothy Mayes, Todd Shank – Ebook PDF Instant Download/Delivery: 1337298042, 978-1337298049
Full download Financial Analysis with Microsoft Excel 2916 8th edition after payment
Product details:
ISBN 10: 1337298042
ISBN 13: 978-1337298049
Author: Timothy Mayes, Todd Shank
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.
Financial Analysis with Microsoft Excel 2916 8th Table of contents:
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
Using Date Functions
Calculating Text Strings
Sales and Collections
Purchases and Payments
Collections and Disbursements
Calculating the Ending Cash Balance
Repaying Short-Term Borrowing
Using the Cash Budget for What-If Analysis
The Scenario Manager
Adding Interest and Investment of Excess Cash
Calculating Current Borrowing
Using the Formula Auditing Tools to Avoid Errors
Calculating Current Investing
Working Through the Example
Summary
Problems
Chapter 5: Financial Statement Forecasting
The Percent of Sales Method
Forecasting the Income Statement
Forecasting Assets on the Balance Sheet
Forecasting Liabilities on the Balance Sheet
Discretionary Financing Needed
Using Iteration to Eliminate DFN
Other Forecasting Methods
Linear Trend Extrapolation
Regression Analysis
Statistical Significance
Summary
Problems
Internet Exercises
Chapter 6: Forecasting Sales with Time Series Methods
Time Series Decomposition
Smoothing a Time Series with Moving Averages
Isolating the Seasonality of a Time Series
Extracting the Irregular Component
Time Series Forecasting Techniques
Measuring Forecast Errors
Exponential Smoothing Methods
Simple Exponential Smoothing
Holt’s Linear Trend Exponential Smoothing Model
Forecasting Time Series with Both Trend and Seasonality
Holt-Winters Additive Seasonal Model
Using the Built-in ETS Model
Holt-Winters Multiplicative Seasonal Model
Time Series Forecasting Using Regression Analysis
Forecasting the Trend Using Regression
Using Seasonal Dummy Variables to Account for Seasonality
Summary
Problems
Internet Exercise
Chapter 7: Break-Even and Leverage Analysis
Break-Even Points
Calculating Break-Even Points in Excel
Other Break-Even Points
Using Goal Seek to Calculate Break-Even Points
Leverage Analysis
The Degree of Operating Leverage
The Degree of Financial Leverage
The Degree of Combined Leverage
Extending the Example
Linking Break-Even Points and Leverage Measures
Summary
Problems
Internet Exercise
Chapter 8: The Time Value of Money
Future Value
Using Excel to Find Future Values
Present Value
Annuities
Present Value of an Annuity
Future Value of an Annuity
Solving for the Annuity Payment
Solving for the Number of Periods in an Annuity
Solving for the Interest Rate in an Annuity
Deferred Annuities
Graduated Annuities
Present Value of a Graduated Annuity
Future Value of a Graduated Annuity
Solving for the Graduated Annuity Payment
Uneven Cash Flow Streams
Solving for the Yield in an Uneven Cash Flow Stream
Nonannual Compounding Periods
Continuous Compounding
Summary
Problems
Chapter 9: Common Stock Valuation
What Is Value?
Fundamentals of Valuation
Determining the Required Rate of Return
A Simple Risk Premium Model
CAPM: A More Scientific Model
Valuing Common Stocks
The Constant-Growth Dividend Discount Model
The Two-Stage Growth Model
Three-Stage Growth Models
Alternative Discounted Cash Flow Models
The Earnings Model
The Free Cash Flow Model
Relative Value Models
Preferred Stock Valuation
Summary
Problems
Internet Exercise
Chapter 10: Bond Valuation
Bond Valuation
Valuing Bonds between Coupon Dates
Using Excel’s Advanced Bond Functions
Bond Return Measures
Current Yield
Yield to Maturity
Yield to Call
Returns on Discounted Debt Securities
The U.S. Treasury Yield Curve
Bond Price Sensitivities
Changes in the Required Return
Changes in Term to Maturity
Comparing Two Bonds with Different Maturities
Comparing Two Bonds with Different Coupon Rates
Duration and Convexity
Duration
Modified Duration
Visualizing the Predicted Price Change
Convexity
Summary
Problems
Internet Exercise
Chapter 11: The Cost of Capital
The Appropriate Hurdle Rate
The Weighted Average Cost of Capital
Determining the Weights
WACC Calculations in Excel
Calculating the Component Costs
The Cost of Common Equity
The Cost of Preferred Equity
The Cost of Debt
Using Excel to Calculate the Component Costs
The After-Tax Cost of Debt
The Cost of Preferred Stock
The Cost of Common Stock
The Role of Flotation Costs
Adding Flotation Costs to Our Worksheet
The Cost of Retained Earnings
The Marginal WACC Curve
Finding the Break-Points
Creating the Marginal WACC Chart
Summary
Problems
Internet Exercise
Chapter 12: Capital Budgeting
Estimating the Cash Flows
The Initial Outlay
The Annual After-Tax Operating Cash Flows
The Terminal Cash Flow
Estimating the Cash Flows: An Example
Calculating the Relevant Cash Flows
Making the Decision
The Payback Method
The Discounted Payback Period
Net Present Value
The Profitability Index
The Internal Rate of Return
Problems with the IRR
The Modified Internal Rate of Return
Sensitivity and Scenario Analysis
NPV Profile Charts
Scenario Analysis
The Optimal Capital Budget
Optimal Capital Budget without Capital Rationing
Optimal Capital Budget under Capital Rationing
Other Techniques
Summary
Problems
Chapter 13: Risk and Capital Budgeting
Review of Some Useful Statistical Concepts
The Expected Value
Measures of Dispersion
Using Excel to Measure Risk
The Freshly Frozen Fish Company Example
Introducing Uncertainty
Sensitivity Analysis
Scenario Analysis
Calculating the Expected NPV from the Scenarios
Calculating the Variance and Standard Deviation
Calculating the Probability of a Negative NPV
Monte Carlo Simulation
The Risk-Adjusted Discount Rate Method
The Certainty-Equivalent Approach
Summary
Problems
Chapter 14: Portfolio Statistics and Diversification
Portfolio Diversification Effects
Determining Portfolio Risk and Return
Portfolio Standard Deviation
Changing the Weights
Portfolios with More than Two Securities
Creating a Variance/Covariance Matrix
Calculating the Portfolio Standard Deviation
The Efficient Frontier
Locating Portfolios on the Efficient Frontier in Excel
Charting the Efficient Frontier
The Capital Market Line
Charting the Capital Market Line
Identifying the Market Portfolio
Utility Functions and the Optimal Portfolio
Charting Indifference Curves
The Capital Asset Pricing Model
The Security Market Line
Summary
Problems
Internet Exercise
Chapter 15: Writing User-Defined Functions with VBA
What Is a Macro?
Two Types of Macros
The Visual Basic Editor
The Project Explorer
The Code Window
The Parts of a Function
Writing Your First User-Defined Function
Writing More Complicated Functions
Variables and Data Types
The If-Then-Else Statement
Looping Statements
Using Worksheet Functions in VBA
Using Optional Arguments
Using ParamArray for Unlimited Arguments
Debugging VBA Code
Breakpoints and Code Stepping
The Watch Window
The Immediate Window
Creating Excel Add-Ins
Best Practices for VBA
Summary
Problems
Chapter 16: Analyzing Datasets with Tables and Pivot Tables
Creating and Using an Excel Table
Removing Duplicate Records from the Table
Filtering the Table
Sorting and Filtering Numeric Fields
Structured Referencing for Formulas in Tables
Using Get & Transform
Cleaning the Dataset
An Example Data Query
Using Pivot Tables
Creating a Pivot Table
Formatting the Pivot Table
Rearranging the Pivot Table and Adding Fields
Transforming the Data Field Presentation
Calculations in Pivot Tables
Pivot Tables for Financial Statements
Grouping Data by Date
Using Pivot Charts to Show Trends Over Time
Displaying Multiple Subtotals
Using Calculated Fields for Financial Ratios
Filtering Data with Slicers and Timelines
Extracting Data from a Pivot Table
Summary
Problems
Internet Exercise
Appendix Directory of User-Defined Functions in FameFncs.xlam
Index
People also search for Financial Analysis with Microsoft Excel 2916 8th:
free download financial analysis with microsoft excel
etextbook financial analysis with microsoft excel
financial analysis with microsoft excel 9th edition
financial analysis with microsoft excel 9th edition free download
financial analysis with microsoft excel answers
Tags: Timothy Mayes, Todd Shank, Financial Analysis, Microsoft Excel