Corporate Financial Analysis with Microsoft Excel

by Clauss, Francis

• ISBN13: 9780071628853
• ISBN10: 0071628851
• Edition: 1st
• Format: Hardcover
• Copyright: 2009-09-09
• Publisher: McGraw-Hill Education

Summary

Corporate Financial Analysis with Microsoft Excel visualizes spreadsheets as an effective management tool both for financial analysis and for coordinating its results and actions with marketing, sales, production and service operations, quality control, and other business functions.Taking an integrative view that promotes teamwork across corporate functions and responsibilities, the book contains dozens of charts, diagrams, and actual Excel screen shots to 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 and horizontal analyses offinancial statements Determining financial ratios and analyzing their trendsand significance Combining quantitative and judgmental techniques to improve forecasts of sales revenues andcustomer demands Calculating and applying thetime value of money Managing inventories, safety stocks, and the allocation of resources. The third and final section Capital Budgeting covers capital structure, the cost of capital, and leverage; the basics of capital budgeting, including taxes and depreciation applications, such as new facilities, equipment replacement, process improvement, leasing versus buying, and nonresidential real estate and risk analysis of capital budgets and the potential impacts of unforeseen events. Corporate Financial Analysis with Microsoft Excel takes a broad view of financial functions and responsibilities in relation to those of other functional parts of modern corporations,and it demonstrates how to use spreadsheets to integrate and coordinate them. It provides 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 your firm's short-term operations and long-termcapital investments.

Author Biography

Francis J. Clauss teaches in the MBA program at.Golden Gate Universityn++s School of Business and School of Industry and Technology.

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