Description
Financial Analysis with Microsoft Excel Edition 6 by Timothy R. Mayes EBOOK PDF Instant Download
Table of Contents
Contents
Preface
Ch 1: Introduction to Excel 2010
Starting Microsoft Excel
Parts of the Excel Screen
Navigating the Worksheet
Entering Formulas
Using Excel’s Built-In Functions
Creating Graphics
Printing
Saving and Opening Files
Using Excel with Other Applications
Quitting Excel
Best Practices for Spreadsheet Models
Summary
Problems
Internet Exercise
Ch 2: The Basic Financial Statements
The Income Statement
The Balance Sheet
Improving Readability: Custom Number Formats
Common-Size Financial Statements
Building a Statement of Cash Flows
Using Excel’s Outliner
Summary
Problems
Internet Exercise
Ch 3: The Cash Budget
The Worksheet Area
Collections and Disbursements
Calculating the Ending Cash Balance
Adding Interest and Investment of Excess Cash
Summary
Problems
Ch 4: Financial Statement Analysis Tools
Liquidity Ratios
Efficiency Ratios
Leverage Ratios
Coverage Ratios
Profitability Ratios
Financial Distress Prediction
Using Financial Ratios
Economic Profit Measures of Performance
Summary
Problems
Internet Exercise
Ch 5: Financial Forecasting
The Percent of Sales Method
Using Iteration to Eliminate DFN
Other Forecasting Methods
Summary
Problems
Internet Exercises
Ch 6: Break-Even and Leverage Analysis
Break-Even Points
Using Goal Seek to Calculate Break-Even Points
Leverage Analysis
Summary
Problems
Internet Exercise
Ch 7: The Time Value of Money
Future Value
Present Value
Annuities
Graduated Annuities
Uneven Cash Flow Streams
Nonannual Compounding Periods
Summary
Problems
Ch 8: Common Stock Valuation
What is Value?
Fundamentals of Valuation
Determining the Required Rate of Return
Valuing Common Stocks
Alternative Discounted Cash Flow Models
Relative Value Models
Preferred Stock Valuation
Summary
Problems
Internet Exercise
Ch 9: Bond Valuation
Bond Valuation
Bond Return Measures
The U.S. Treasury Yield Curve
Bond Price Sensitivities
Duration and Convexity
Summary
Problems
Internet Exercise
Ch 10: The Cost of Capital
The Appropriate “Hurdle” Rate
WACC Calculations in Excel
Calculating the Component Costs
Using Excel to Calculate the Component Costs
The Role of Flotation Costs
The Marginal WACC Curve
Summary
Problems
Internet Exercise
Ch 11: Capital Budgeting
Estimating the Cash Flows
Calculating the Relevant Cash Flows
Making the Decision
Sensitivity Analysis
The Optimal Capital Budget
Summary
Problems
Ch 12: Risk and Capital Budgeting
Review of Some Useful Statistical Concepts
Using Excel to Measure Risk
Introducing Uncertainty
Summary
Problems
Ch 13: Portfolio Statistics and Diversification
Portfolio Diversification Effects
Determining Portfolio Risk and Return
Portfolios with More Than Two Securities
The Efficient Frontier
The Capital Market Line
The Capital Asset Pricing Model
Summary
Problems
Internet Exercise
Ch 14: Writing User-Defined Functions with VBA
What is a Macro?
The Visual Basic Editor
The Parts of a Function
Writing Your First User-Defined Function
Writing More Complicated Functions
Debugging VBA Code
Creating Excel Add-Ins
Summary
Problems
Ch 15: Analyzing Datasets with Tables and Pivot Tables
Creating and Using an Excel Table
Using Pivot Tables
Pivot Tables for Financial Statements
Summary
Problems
Internet Exercise
Appendix: Directory of User-Defined Functions in Famefncs.xlam
Index
