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.