Financial Analysis with Microsoft

Financial Analysis with Microsoft? Excel?

SIXTH EDITION

Timothy R. Mayes

Metropolitan State College of Denver

Todd M. Shank

University of South Florida ? St. Petersburg

Australia ? Brazil ? Japan ? Korea ? Mexico ? Singapore ? Spain ? United Kingdom ? United States

This is an electronic version of the print textbook. Due to electronic rights restrictions, some third party content may be suppressed. Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. The publisher reserves the right to remove content from this title at any time if subsequent rights restrictions require it. For valuable information on pricing, previous editions, changes to current editions, and alternate formats, please visit highered to search by ISBN#, author, title, or keyword for materials in your areas of interest.

Financial Analysis with Microsoft? Excel? Sixth Edition Timothy R. Mayes

VP/Editorial Director: Jack W. Calhoun Editor-in-Chief: Joe Sabatino Executive Editor: Mike Reynolds Developmental Editor: Adele Scholtz Marketing Manager: Nathan Anderson Marketing Coordinator: Suellen Ruttkay Senior Marketing Communication Manager: Jim Overly Content Project Management: PreMediaGlobal Supervising Media Editor: Scott Fidler Manufacturing Planner: Kevin Kluck Production Service: PreMediaGlobal Senior Art Director: Michelle Kunkler Cover Designer: Stratton Design Cover Image: ? RonTech2000 Rights Acquisition Director: Audrey Pettengill Rights Acquisition Specialist, Text and Image: Sam Marshall

? 2012, 2010 South-Western, Cengage Learning

ALL RIGHTS RESERVED. No part of this work covered by the copyright herein may be reproduced, transmitted, stored, or used in any form or by any means graphic, electronic, or mechanical, including but not limited to photocopying, recording, scanning, digitizing, taping, web distribution, information networks, or information storage and retrieval systems, except as permitted under Section 107 or 108 of the 1976 United States Copyright Act, without the prior written permission of the publisher.

For product information and technology assistance, contact us at Cengage Learning Customer & Sales Support, 1-800-354-9706

For permission to use material from this text or product, submit all requests online at permissions

Further permissions questions can be emailed to permissionrequest@

All figures, tables, and exhibits are author created and Cengage owned unless otherwise noted.

Screenshots are ? 2011 Microsoft Corporation. Microsoft? Office Excel? icon is ? 2011 Microsoft Corporation. Microsoft? Office Excel? is a registered trademark of the Microsoft Corporation in the United States and/or other countries.

Library of Congress Control Number: 2011938350

ISBN-13: 978-1-111-82624-6 ISBN-10: 1-111-82624-2

South-Western 5191 Natorp Boulevard Mason, OH 45040 USA

Cengage Learning products are represented in Canada by Nelson Education, Ltd.

For your course and learning solutions, visit

Purchase any of our products at your local college store or at our preferred online store

Printed in the United States of America 1 2 3 4 5 6 7 15 14 13 12 11

For my mother, Patricia Evans

iii

This page intentionally left blank

Contents

CHAPTER 1

Introduction to Excel 2010 1

Spreadsheet Uses 2 Starting Microsoft Excel 2 Parts of the Excel Screen 3

The File Tab and Quick Access Toolbar 3 The Home Tab 4 The Formula Bar 6 The Worksheet Area 6 Sheet Tabs 7 Status Bar 7 Navigating the Worksheet 8 Selecting a Range of Cells 9 Using Defined Names 10 Entering Text and Numbers 11 Formatting and Alignment Options 11 Formatting Numbers 13 Adding Borders and Shading 14 Entering Formulas 15 Copying and Moving Formulas 17 Mathematical Operators 19 Parentheses and the Order of Operations 19

v

Contents

Using Excel's Built-In Functions 21 Using the Insert Function Dialog Box 22 New "Dot Functions" in Excel 2010 24 Using User-defined Functions 25

Creating Graphics 27 Creating Charts in a Chart Sheet 27 Creating Embedded Charts 28 Formatting Charts 29 Changing the Chart Type 31 Creating Sparkline Charts 33

Printing 34 Saving and Opening Files 35

Saving Worksheets for the Internet 35 Using Excel with Other Applications 36 Quitting Excel 36 Best Practices for Spreadsheet Models 37 Summary 38 Problems 39 Internet Exercise 42

CHAPTER 2

The Basic Financial Statements 43

The Income Statement 44 Building an Income Statement in Excel 44

The Balance Sheet 49 Building a Balance Sheet in Excel 49

Improving Readability: Custom Number Formats 51 Common-Size Financial Statements 54

Creating Common-Size Income Statements 54 Creating a Common-Size Balance Sheet 56 Building a Statement of Cash Flows 57 Using Excel's Outliner 62 Summary 64 Problems 65 Internet Exercise 67

vi

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download