Excel for Corporate Finance Professionals | Michael McDonald | LYNDA

Excel for Corporate Finance Professionals | Michael McDonald | LYNDA
English | Size: 308.70 MB
Category: Tutorial

Discover how to use Microsoft Excel for the bread-and-butter tasks required by corporate finance and financial planning and analysis (FP&A) professionals. In this hands-on course, professor Michael McDonald steps through how to leverage this powerful tool to pick corporate investments, determine your firm’s cost of capital, and perform operational budgeting. Michael steps through how to estimate weighted average cost of capital (WACC), build a budget, perform stress testing and scenario analysis, and more. Throughout the course, Michael includes exercises-together with downloadable exercise files-that can provide you with a practical understanding of these key topics.

Topics include:
• Capital budgeting in Excel
• Using Excel in project selection
• Analyzing capital structure using Excel
• Estimating weighted average cost of capital (WACC)
• Applying Excel to operational budgeting
• Cash flow budgeting
• Stress test tools for budgets

Table of Contents:

1. Critical Tasks in Corporate Finance
2. Project Selection in Excel
3. WACC and Capital Structure in Excel
4. Operational Budgeting in Excel

Buy Long-term Premium Accounts To Support Me & Max Speed


If any links die or problem unrar, send request to http://goo.gl/aUHSZc

About WoW Team

I'm WoW Team , I love to share all the video tutorials. If you have a video tutorial, please send me, I'll post on my website. Because knowledge is not limited to, irrespective of qualifications, people join hands to help me.