skip to content
Financial analysis with Microsoft Excel Preview this item
ClosePreview this item
Checking...

Financial analysis with Microsoft Excel

Author: Timothy R Mayes; Todd M Shank
Publisher: Boston, MA, USA : Cengage Learning, [2015]
Edition/Format:   Print book : English : Seventh editionView all editions and formats
Database:WorldCat
Summary:

Helps students develop a proficiency in using Excel[registered] 2013 to solve real financial problems without sacrificing any finance background. This book covers all of the topics in corporate  Read more...

Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Document Type: Book
All Authors / Contributors: Timothy R Mayes; Todd M Shank
ISBN: 9781285432274 1285432274
OCLC Number: 877372359
Notes: 6th edition published: Australia ; Mason, OH : South-Western, c2012.
Description: xxiii, 520 pages : illustrations ; 26 cm
Contents: Machine generated contents note: ch. 1 Introduction to Excel 2013 --
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 2013 --
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 --
ch. 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 --
ch. 3 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 --
ch. 4 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 --
ch. 5 Financial 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 --
ch. 6 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 --
ch. 7 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 --
Uneven Cash Flow Streams --
Solving for the Yield in an Uneven Cash Flow Stream --
Nonannual Compounding Periods --
Continuous Compounding --
Summary --
Problems --
ch. 8 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 --
ch. 9 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 --
ch. 10 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 --
ch. 11 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 --
ch. 12 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 --
ch. 13 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 --
ch. 14 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 --
ch. 15 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 --
Using Formulas in Tables --
Using Pivot Tables --
Creating a Pivot Table
Responsibility: Timothy R. Mayes, Metropolitan State College of Denver, Todd M. Shank, University of South Florida - St. Petersburg.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/877372359> # Financial analysis with Microsoft Excel
    a schema:CreativeWork, schema:Book ;
   library:oclcnum "877372359" ;
   library:placeOfPublication <http://id.loc.gov/vocabulary/countries/mau> ;
   schema:about <http://experiment.worldcat.org/entity/work/data/34887629#Topic/entreprises_finances_logiciels> ; # Entreprises--Finances--Logiciels
   schema:about <http://experiment.worldcat.org/entity/work/data/34887629#Topic/business_computer_programs> ; # Business--Computer programs
   schema:about <http://experiment.worldcat.org/entity/work/data/34887629#Topic/tableurs> ; # Tableurs
   schema:about <http://experiment.worldcat.org/entity/work/data/34887629#Topic/electronic_spreadsheets> ; # Electronic spreadsheets
   schema:about <http://dewey.info/class/005.54/e23/> ;
   schema:about <http://experiment.worldcat.org/entity/work/data/34887629#Topic/microsoft_excel_logiciel> ; # Microsoft Excel (logiciel)
   schema:about <http://experiment.worldcat.org/entity/work/data/34887629#Topic/corporations_finance> ; # Corporations--Finance
   schema:about <http://experiment.worldcat.org/entity/work/data/34887629#Topic/corporations_finance_computer_programs> ; # Corporations--Finance--Computer programs
   schema:about <http://experiment.worldcat.org/entity/work/data/34887629#CreativeWork/microsoft_excel_computer_file> ; # Microsoft Excel (Computer file)
   schema:bookEdition "Seventh edition." ;
   schema:bookFormat bgn:PrintBook ;
   schema:contributor <http://experiment.worldcat.org/entity/work/data/34887629#Person/shank_todd_m> ; # Todd M. Shank
   schema:creator <http://experiment.worldcat.org/entity/work/data/34887629#Person/mayes_timothy_r> ; # Timothy R. Mayes
   schema:datePublished "2015" ;
   schema:exampleOfWork <http://worldcat.org/entity/work/id/34887629> ;
   schema:inLanguage "en" ;
   schema:name "Financial analysis with Microsoft Excel"@en ;
   schema:productID "877372359" ;
   schema:workExample <http://worldcat.org/isbn/9781285432274> ;
   wdrs:describedby <http://www.worldcat.org/title/-/oclc/877372359> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/34887629#CreativeWork/microsoft_excel_computer_file> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
   schema:name "Microsoft Excel (Computer file)" ;
    .

<http://experiment.worldcat.org/entity/work/data/34887629#Person/mayes_timothy_r> # Timothy R. Mayes
    a schema:Person ;
   schema:familyName "Mayes" ;
   schema:givenName "Timothy R." ;
   schema:name "Timothy R. Mayes" ;
    .

<http://experiment.worldcat.org/entity/work/data/34887629#Person/shank_todd_m> # Todd M. Shank
    a schema:Person ;
   schema:familyName "Shank" ;
   schema:givenName "Todd M." ;
   schema:name "Todd M. Shank" ;
    .

<http://experiment.worldcat.org/entity/work/data/34887629#Topic/business_computer_programs> # Business--Computer programs
    a schema:Intangible ;
   schema:name "Business--Computer programs"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/34887629#Topic/corporations_finance> # Corporations--Finance
    a schema:Intangible ;
   schema:name "Corporations--Finance"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/34887629#Topic/corporations_finance_computer_programs> # Corporations--Finance--Computer programs
    a schema:Intangible ;
   schema:name "Corporations--Finance--Computer programs"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/34887629#Topic/electronic_spreadsheets> # Electronic spreadsheets
    a schema:Intangible ;
   schema:name "Electronic spreadsheets"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/34887629#Topic/entreprises_finances_logiciels> # Entreprises--Finances--Logiciels
    a schema:Intangible ;
   schema:name "Entreprises--Finances--Logiciels"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/34887629#Topic/microsoft_excel_logiciel> # Microsoft Excel (logiciel)
    a schema:Intangible ;
   schema:name "Microsoft Excel (logiciel)"@en ;
    .

<http://worldcat.org/isbn/9781285432274>
    a schema:ProductModel ;
   schema:isbn "1285432274" ;
   schema:isbn "9781285432274" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.