Corporate Financial Analysis with Microsoft Excel

Hardcover | September 9, 2009

byFrancis Clauss

not yet rated|write a review

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.

Pricing and Purchase Info

$77.87
$89.95 list price save 13%
In stock online
Ships free on orders over $25

From the Publisher

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 co...

From the Jacket

Executive guidance forenhancing business managementthrough spreadsheetsLearning from spreadsheet models is cheaper, faster, and less hazardous than learning in the realworld. Corporate Financial Analysis with Microsoft® Excel® contains numerous examples demonstratinghow to use spreadsheet models to help you manage more effectively unde...

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.

other books by Francis Clauss

Corporate Financial Analysis with Microsoft Excel
Corporate Financial Analysis with Microsoft Excel

Kobo ebook|Aug 19 2009

$84.19$105.25list pricesave 20%
Format:HardcoverDimensions:512 pages, 10.3 × 8.5 × 1 inPublished:September 9, 2009Publisher:McGraw-Hill EducationLanguage:English

The following ISBNs are associated with this title:

ISBN - 10:0071628851

ISBN - 13:9780071628853

Customer Reviews of Corporate Financial Analysis with Microsoft Excel

Reviews

Extra Content

Table of Contents

1: Corporate Financial Statements
2: Analysis of Financial Statements
3: Forecasting Annual Revenues
4: Forecasting Financial Statements
5: Forecasting Seasonal Revenues
6: Time Value of Money
7: Cash Budgeting
8: Cost of Capital
9: Profits, Leverage
10: Depreciation, Taxes
11: Capital Budgeting
12: Applications of Capital Budgeting
13: Capital Budgeting: Risk Analysis
14: Capital Budgeting: Monte Carlo