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.