## 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