Corporate Financial Analysis with Microsoft Excel

Corporate Financial Analysis with Microsoft Excel

4.11 - 1251 ratings - Source

Corporate Financial Analysis with MicrosoftAr ExcelAr 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 ExcelAr screenshots to reinforce the practical applications of every topic it covers. The first two sectionsa€” Financial Statements and Cash Budgetinga€” explain how to use spreadsheets for: Preparing income statements, balance sheets, and cash flow statements Performing vertical and horizontal analyses of financial statements Determining financial ratios and analyzing their trends and significance Combining quantitative and judgmental techniques to improve forecasts of sales revenues and customer demands Calculating and applying the time value of money Managing inventories, safety stocks, and the allocation of resources The third and final sectiona€”Capital Budgetinga€” 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 MicrosoftAr ExcelAr 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 case studies of real corporations, including Wal- Mart, Sun Microsystems, Nike, H. J. Heinz, Dell, Microsoft, Apple Computer, and IBM. Corporate Financial Analysis with MicrosoftAr ExcelAr is the ideal tool for managing your firma€™s short-term operations and long-term capital investments.... 37 Cash and Equivalents 1, 565.0 990.0 Accounts Receivable 565.0 605.0 Inventories 895.0 1, 215.0 Other 215.0 180.0 3, 240.0 2, 990.0 Total Current Assets Fixed ... B37: =B21=B36, copy to C37 This uses Excela#39;s logic test to verify balance.

Title:Corporate Financial Analysis with Microsoft Excel
Author: Francis Clauss
Publisher:McGraw Hill Professional - 2009-08-23

You must register with us as either a Registered User before you can Download this Book. You'll be greeted by a simple sign-up page.

Once you have finished the sign-up process, you will be redirected to your download Book page.

How it works:
  • 1. Register a free 1 month Trial Account.
  • 2. Download as many books as you like (Personal use)
  • 3. Cancel the membership at any time if not satisfied.

Click button below to register and download Ebook
Privacy Policy | Contact | DMCA