Corporate Financial Analysis with Microsoft Excel

INSTANT DOWNLOAD!

Price: $5.00

eBook: Francis J Clauss – Corporate Financial Analysis with Microsoft Excel.pdf – (528pgs).

Corporate Financial Analysis with Microsoft® Excel®
This book provides a comprehensive approach to using Excel® as an effective management tool for financial analysis and for coordinating actions across various business functions such as marketing, sales, production, service operations, quality control, and more.

Key Topics Covered:

• Financial Statements & Cash Budgeting:

  • Income Statements, Balance Sheets, & Cash Flow Statements: Learn how to prepare these critical financial statements using Excel®.

  • Vertical and Horizontal Analysis: Techniques to analyze financial statements and spot trends over time.

  • Financial Ratios: Calculation and analysis of financial ratios to assess company health.

  • Sales & Customer Demand Forecasting: Combine quantitative and judgmental techniques to improve forecasting accuracy.

  • Time Value of Money: Understand how to calculate and apply the time value of money in decision-making.

  • Inventory & Resource Management: Manage inventories, safety stocks, and resource allocation effectively.

• Capital Budgeting:

  • Capital Structure & Cost of Capital: Understand the financial structure and cost implications of capital.

  • Leverage: Analyze how leveraging affects financial performance.

  • Capital Budgeting Techniques: Basics of budgeting for new facilities, equipment replacement, process improvement, and leasing vs. buying decisions.

  • Risk Analysis: Learn to analyze potential risks in capital budgets, accounting for unforeseen events.

Real-World Applications:

The book provides insightful examples and case studies from well-known companies like Wal-Mart, Sun Microsystems, Nike, H. J. Heinz, Dell, Microsoft, Apple Computer, and IBM, showcasing how these companies manage their financial functions and decision-making processes.

Why This Book is Valuable:

• Integrative Approach: Promotes collaboration across corporate functions and uses Excel® to integrate and align financial analysis with other business operations.

• Practical Tools: Dozens of charts, diagrams, and Excel® screenshots enhance the understanding and application of the topics.

• Real-World Case Studies: Learn from the practices of global corporations.

Corporate Financial Analysis with Microsoft® Excel® is an essential resource for anyone looking to manage both short-term operations and long-term capital investments within their organization.