Corporate Financial Analysis with Microsoft Excel

Corporate Financial Analysis with MicrosoftExcel 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 sectionsFinancial Statements and Cash Budgetingexplain 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 sectionCapital Budgetingcovers 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 MicrosoftExcel 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 MicrosoftExcel is the ideal tool for managing yourfirms short-term operations and long-termcapital investments.