Excel for Corporate Finance Professionals
5.0 /5- Offered byLinkedin Learning
Excel for Corporate Finance Professionals at Linkedin Learning Overview
Duration | 3 hours |
Total fee | ₹1,400 |
Mode of learning | Online |
Difficulty level | Intermediate |
Credential | Certificate |
Excel for Corporate Finance Professionals at Linkedin Learning Highlights
- Earn a sharable certificate
Excel for Corporate Finance Professionals at Linkedin Learning Course details
- 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
- Throughout the course, Michael includes exercises?together with downloadable exercise files?that can provide learner with a practical understanding of these key topics
Excel for Corporate Finance Professionals at Linkedin Learning Curriculum
Introduction
Welcome
Critical Tasks in Corporate Finance
Corporate finance and modern business
Project selection in finance
Weighted average cost of capital and capital structure
Cash flows in budgeting
Project Selection in Excel
Capital budgeting in Excel
Capital budgeting scenarios
NPV tests in Excel
IRR tests in Excel
PBP and MIRR tests
Unexpected events and capital budgeting
NPV and scenario analysis
WACC and Capital Structure in Excel
Capital structure in Excel
Using Excel and WACC
Capital structure options in Excel
Changes in capital structure
Estimating WACC in Excel
Sensitivity of WACC to capital structure
Optimal WACC
Operational Budgeting in Excel
Operational budgeting in Excel
Building a budget in Excel
CAGRs and long-term assumptions
Cash flow budgeting
The power of price
Stress test tools for budget in Excel
Conclusion
Next steps
Other courses offered by Linkedin Learning
Excel for Corporate Finance Professionals at Linkedin Learning Students Ratings & Reviews
2 Ratings- 4-52
Student Forum
Anything you would want to ask experts?