Corporate Financial Analysis with Microsoft Excel (PROFESSIONAL FINANCE & INVESTM) - Hardcover

Clauss, Francis J.

Hardcover

ISBN 10: 0071628851 ISBN 13: 9780071628853

Publisher: McGraw Hill, 2009

Synopsis

Corporate Financial Analysis with Microsoft®Excel® visualizes spreadsheets as an effectivemanagement tool both for financial analysisand for coordinating its results and actionswith marketing, sales, production and serviceoperations, quality control, and other businessfunctions.

Taking an integrative view that promotesteamwork across corporate functions andresponsibilities, the book contains dozens ofcharts, diagrams, and actual Excel® screenshotsto reinforce the practical applications ofevery topic it covers. The first two sections―Financial Statements and Cash Budgeting―explain how to use spreadsheets for:

• Preparing income statements,balance sheets, and cashflow statements
• Performing vertical andhorizontal analyses offinancial statements
• Determining financial ratiosand analyzing their trendsand significance
• Combining quantitative andjudgmental techniques to improveforecasts of sales revenues andcustomer demands
• Calculating and applying thetime value of money
• Managing inventories,safety stocks, and theallocation of resources

The third and final section―Capital Budgeting―covers capital structure, the cost ofcapital, and leverage; the basics of capitalbudgeting, including taxes and depreciation;applications, such as new facilities, equipmentreplacement, process improvement, leasingversus buying, and nonresidential real estate;and risk analysis of capital budgets and thepotential impacts of unforeseen events.

Corporate Financial Analysis with Microsoft®Excel® takes a broad view of financial functionsand responsibilities in relation to thoseof other functional parts of modern corporations,and it demonstrates how to use spreadsheetsto integrate and coordinate them. Itprovides many insightful examples and casestudies of real corporations, including Wal-Mart, Sun Microsystems, Nike, H. J. Heinz,Dell, Microsoft, Apple Computer, and IBM.

Corporate Financial Analysis with Microsoft®Excel® is the ideal tool for managing yourfirm’s short-term operations and long-termcapital investments.

About this title

From the Back Cover:

Executive guidance for enhancing business management through spreadsheets

Learning from spreadsheet models is cheaper, faster, and less hazardous than learning in the real world. Corporate Financial Analysis with Microsoft(R) Excel(R) contains numerous examples demonstrating how to use spreadsheet models to help you manage more effectively under a wide range of conditions and assumptions. You'll learn how to use Excel's powerful tools to:

• Perform sensitivity analysis and alert managers to the financial impact of unexpected conditions that might occur
• Identify the best strategies to maximize profits, minimize costs, and achieve other goals
• Use Monte Carlo simulation to provide a complete picture of the risks and probabilities of doing business in an uncertain environment

Corporate Financial Analysis with Microsoft(R) Excel(R) provides practical, real-life examples to help you relate to both the quantitative and qualitative sides of business management. In addition to using spreadsheets for analysis, you will learn how to apply them in management presentations that are convincing, and be able to justify your recommendations.

Corporate Financial Analysis with Microsoft(R) Excel(R) helps you become a better manager and decisionmaker-- not just a skilled spreadsheet programmer. In today's evolving markets, it is a must-have toolbox of skills for every manager.

About the Author:

Francis J. Clauss, Ph.D., teaches in the MBA program at Golden Gate University's School of Business. He earned his Ph.D. from the University of Michigan and has both technical and management experience in the steel, chemical, and aerospace industries. He lives in Palo Alto, California.

About this edition

• Publisher: McGraw Hill
• Publication date: 2009
• ISBN 10: 0071628851
• ISBN 13: 9780071628853
• Binding: Hardcover
• Number of pages: 528