What is a Lynda Excel for Corporate Finance Professionals for Cheap?
Learn how to use 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 for capital budgeting and corporate investment selection at your firm, determine your firm’s cost of capital, and perform operational budgeting.
Michael explains 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 and downloadable exercise files that can give you a practical understanding of these key topics.
Lynda Excel for Corporate Finance Professionals Index:
📁 1 – Introduction
📄 01. Welcome.en.srt (1.65 KB)
📄 01. Welcome.mp4 (7.86 MB)
📁 2 – 1._Critical_Tasks_in_Corporate_Finance
📄 02. Corporate_finance_and_modern_business.en.srt (6.70 KB)
📄 02. Corporate_finance_and_modern_business.mp4 (5.38 MB)
📄 03. Project_selection_in_finance.en.srt (7.71 KB)
📄 03. Project_selection_in_finance.mp4 (6.75 MB)
📄 04. Weighted_average_cost_of_capital_and_capital_structure.en.srt (10.87 KB)
📄 04. Weighted_average_cost_of_capital_and_capital_structure.mp4 (9.20 MB)
📄 05. Cash_flows_in_budgeting.en.srt (5.66 KB)
📄 05. Cash_flows_in_budgeting.mp4 (5.39 MB)
📁 3 – 2._Project_Selection_in_Excel
📄 06. Capital_budgeting_in_Excel.en.srt (10.84 KB)
📄 06. Capital_budgeting_in_Excel.mp4 (13.36 MB)
📄 07. Capital_budgeting_scenarios.en.srt (12.99 KB)
📄 07. Capital_budgeting_scenarios.mp4 (18.81 MB)
📄 08. NPV_tests_in_Excel.en.srt (9.60 KB)
📄 08. NPV_tests_in_Excel.mp4 (16.80 MB)
📄 09. IRR_tests_in_Excel.en.srt (7.76 KB)
📄 09. IRR_tests_in_Excel.mp4 (12.12 MB)
📄 10. PBP_and_MIRR_tests.en.srt (10.05 KB)
📄 10. PBP_and_MIRR_tests.mp4 (16.11 MB)
📄 11. Unexpected_events_and_capital_budgeting.en.srt (6.76 KB)
📄 11. Unexpected_events_and_capital_budgeting.mp4 (8.87 MB)
📄 12. NPV_and_scenario_analysis.en.srt (11.42 KB)
📄 12. NPV_and_scenario_analysis.mp4 (23.32 MB)
📁 4 – 3._WACC_and_Capital_Structure_in_Excel
📄 13. Capital_structure_in_Excel.en.srt (7.14 KB)
📄 13. Capital_structure_in_Excel.mp4 (8.09 MB)
📄 14. Using_Excel_and_WACC.en.srt (5.63 KB)
📄 14. Using_Excel_and_WACC.mp4 (6.57 MB)
📄 15. Capital_structure_options_in_Excel.en.srt (9.27 KB)
📄 15. Capital_structure_options_in_Excel.mp4 (12.17 MB)
📄 16. Changes_in_capital_structure.en.srt (6.39 KB)
📄 16. Changes_in_capital_structure.mp4 (9.47 MB)
📄 17. Estimating_WACC_in_Excel.en.srt (9.21 KB)
📄 17. Estimating_WACC_in_Excel.mp4 (15.31 MB)
📄 18. Sensitivity_of_WACC_to_capital_structure.en.srt (9.05 KB)
📄 18. Sensitivity_of_WACC_to_capital_structure.mp4 (12.65 MB)
📄 19. Optimal_WACC.en.srt (8.59 KB)
📄 19. Optimal_WACC.mp4 (13.50 MB)
📁 5 – 4._Operational_Budgeting_in_Excel
📄 20. Operational_budgeting_in_Excel.en.srt (12.97 KB)
📄 20. Operational_budgeting_in_Excel.mp4 (11.35 MB)
📄 21. Building_a_budget_in_Excel.en.srt (12.23 KB)
📄 21. Building_a_budget_in_Excel.mp4 (14.71 MB)
📄 22. CAGRs_and_long-term_assumptions.en.srt (8.89 KB)
📄 22. CAGRs_and_long-term_assumptions.mp4 (12.51 MB)
📄 23. Cash_flow_budgeting.en.srt (10.54 KB)
📄 23. Cash_flow_budgeting.mp4 (14.94 MB)
📄 24. The_power_of_price.en.srt (11.64 KB)
📄 24. The_power_of_price.mp4 (11.12 MB)
📄 25. Stress_test_tools_for_budget_in_Excel.en.srt (10.26 KB)
📄 25. Stress_test_tools_for_budget_in_Excel.mp4 (19.42 MB)
📁 6 – Conclusion
📄 26. Next_steps.en.srt (1.58 KB)
📄 26. Next_steps.mp4 (1.40 MB)
📁 Ex_Files_Excel_Corporate_Finance_Professionals
📁 Exercise Files
📄 02_01_Begin.xls (36.00 KB)
📄 02_01_End.xls (37.00 KB)
📄 02_02_Begin.xls (37.00 KB)
📄 02_02_End.xls (39.50 KB)
📄 02_03_Begin.xls (39.50 KB)
📄 02_03_End.xls (40.00 KB)
📄 02_04_Begin.xls (40.50 KB)
📄 02_04_End.xls (40.50 KB)
📄 02_05_Begin.xls (40.50 KB)
📄 02_05_End.xls (41.00 KB)
📄 02_06_Begin.xls (41.50 KB)
📄 02_06_End.xls (42.00 KB)
📄 02_07_Begin.xls (42.00 KB)
📄 02_07_End.xls (42.00 KB)
📄 03_01_Begin.xls (35.00 KB)
📄 03_01_End.xls (35.00 KB)
📄 03_02_Begin.xls (35.00 KB)
📄 03_02_End.xls (35.50 KB)
📄 03_03_Begin.xls (35.00 KB)
📄 03_03_End.xls (35.00 KB)
📄 03_04_Begin.xls (35.50 KB)
📄 03_04_End.xls (37.00 KB)
📄 03_05_Begin.xls (38.00 KB)
📄 03_05_End.xls (39.50 KB)
📄 03_06_Begin.xls (39.50 KB)
📄 03_06_End.xls (40.00 KB)
📄 03_07_Begin.xls (40.50 KB)
📄 03_07_End.xls (40.50 KB)
📄 04_02_Begin.xls (27.00 KB)
📄 04_02_End.xls (27.50 KB)
📄 04_03_Begin.xls (29.50 KB)
📄 04_03_End.xls (30.50 KB)
📄 04_04_Begin.xls (31.00 KB)
📄 04_04_End.xls (31.50 KB)
📄 04_06_Begin.xls (32.00 KB)
📄 04_06_End.xls (25.50 KB)
💬 Feel free to REACH OUT to our CHAT support for personalized assistance and detailed information tailored to your needs. We’re here to help!
Reviews
There are no reviews yet.