[ WebToolTip.com ] Financial Problem Solving with Excel - Modeling and Analysis

File Name

Size

Get Bonus Downloads Here.url

180 B

~Get Your Files Here !/1 - Introduction/1. Introduction.mp4

10 MB

~Get Your Files Here !/2 - Optimizing Balance Sheet and P&L with Goal Seek Function/2. What is the Balance Sheet and P&L Statement.mp4

11 MB

~Get Your Files Here !/2 - Optimizing Balance Sheet and P&L with Goal Seek Function/3. Using Goal Seek to Optimize Profit Level.mp4

16 MB

~Get Your Files Here !/2 - Optimizing Balance Sheet and P&L with Goal Seek Function/4. Using Goal Seek to Maximize Export Sales in P&L Statement.mp4

20 MB

~Get Your Files Here !/2 - Optimizing Balance Sheet and P&L with Goal Seek Function/5. Optimizing EBITDA margin in P&L Statement.mp4

32 MB

~Get Your Files Here !/2 - Optimizing Balance Sheet and P&L with Goal Seek Function/6. Calculating and Optimizing ROE.mp4

37 MB

~Get Your Files Here !/2 - Optimizing Balance Sheet and P&L with Goal Seek Function/7. Calculating and Optimizing ROA.mp4

19 MB

~Get Your Files Here !/3 - From Financial Data to Management Insights with PivotTables/10. Calculating Product Profitability on a Raw Dataset with PivotTables.mp4

63 MB

~Get Your Files Here !/3 - From Financial Data to Management Insights with PivotTables/11. Analyzing Product Profitability by Region with PivotTables.mp4

50 MB

~Get Your Files Here !/3 - From Financial Data to Management Insights with PivotTables/12. Analyzing Product Profitability per Sales Person with PivotTables.mp4

33 MB

~Get Your Files Here !/3 - From Financial Data to Management Insights with PivotTables/13. Calculating Product Profit Margin & Analyzing with PivotTables.mp4

82 MB

~Get Your Files Here !/3 - From Financial Data to Management Insights with PivotTables/8. Financial Data to Decision-Ready Insights with PivotTables.mp4

8.7 MB

~Get Your Files Here !/3 - From Financial Data to Management Insights with PivotTables/9. How to create PivotTables.mp4

92 MB

~Get Your Files Here !/4 - Linear Programming for Financial Optimization with Excel Solver/14. Introduction What is Solver and Why is it Useful.mp4

18 MB

~Get Your Files Here !/4 - Linear Programming for Financial Optimization with Excel Solver/15. Maximizing EBIT with Solver Production Under Constraints - PT I.mp4

41 MB

~Get Your Files Here !/4 - Linear Programming for Financial Optimization with Excel Solver/16. Maximizing EBIT with Solver Production Under Constraints - PT II.mp4

28 MB

~Get Your Files Here !/4 - Linear Programming for Financial Optimization with Excel Solver/17. Optimize Investment Allocation using Solver - PT I.mp4

34 MB

~Get Your Files Here !/4 - Linear Programming for Financial Optimization with Excel Solver/18. Optimize Investment Allocation using Solver - PT II.mp4

57 MB

~Get Your Files Here !/4 - Linear Programming for Financial Optimization with Excel Solver/19. Maximizing Bank Profit with Solver Loan Allocation Under Compliance Constraints.mp4

71 MB

~Get Your Files Here !/4 - Linear Programming for Financial Optimization with Excel Solver/20. Optimizing Capital Allocation with Solver Maximizing GDP Impact.mp4

76 MB

~Get Your Files Here !/4 - Linear Programming for Financial Optimization with Excel Solver/21. Optimizing Workforce Capacity with Solver An Accounting Firm Case - PT I.mp4

32 MB

~Get Your Files Here !/4 - Linear Programming for Financial Optimization with Excel Solver/22. Optimizing Workforce Capacity with Solver An Accounting Firm Case - PT II.mp4

107 MB

~Get Your Files Here !/5 - Loan Modeling & Credit Analytics Cash Flows and Leverage Sensitivity/23. Introduction Loan Interest Rates.mp4

8.6 MB

~Get Your Files Here !/5 - Loan Modeling & Credit Analytics Cash Flows and Leverage Sensitivity/24. Interest Rate Modeling with Excel.mp4

87 MB

~Get Your Files Here !/5 - Loan Modeling & Credit Analytics Cash Flows and Leverage Sensitivity/25. Credit Cash Flow Modeling with Excel.mp4

128 MB

~Get Your Files Here !/5 - Loan Modeling & Credit Analytics Cash Flows and Leverage Sensitivity/26. Net Debt to EBITDA Explained.mp4

16 MB

~Get Your Files Here !/5 - Loan Modeling & Credit Analytics Cash Flows and Leverage Sensitivity/27. Computing Net Debt to EBITDA.mp4

62 MB

~Get Your Files Here !/5 - Loan Modeling & Credit Analytics Cash Flows and Leverage Sensitivity/28. Computing Net Debt to EBITDA - A Different Approach.mp4

52 MB

~Get Your Files Here !/5 - Loan Modeling & Credit Analytics Cash Flows and Leverage Sensitivity/29. Net Debt EBITDA Sensitivity Analysis with Excel Data Tables.mp4

54 MB

~Get Your Files Here !/5 - Loan Modeling & Credit Analytics Cash Flows and Leverage Sensitivity/30. Turning Sensitivity Results into Credit Risk Signals with VLOOKUP.mp4

43 MB

~Get Your Files Here !/6 - Bond Valuation & Analytics Cash Flows, Yields and Interest Rate Risk/31. Introduction to Bonds.mp4

14 MB

~Get Your Files Here !/6 - Bond Valuation & Analytics Cash Flows, Yields and Interest Rate Risk/32. Bond Fundamentals Key Features & Terminology.mp4

14 MB

~Get Your Files Here !/6 - Bond Valuation & Analytics Cash Flows, Yields and Interest Rate Risk/33. How to Evaluate Bonds.mp4

7.1 MB

~Get Your Files Here !/6 - Bond Valuation & Analytics Cash Flows, Yields and Interest Rate Risk/34. Bond Valuation with Present Value Approach.mp4

41 MB

~Get Your Files Here !/6 - Bond Valuation & Analytics Cash Flows, Yields and Interest Rate Risk/35. How I Explained Bond Yields to a Development Bank CEO — A Practical Example.mp4

76 MB

~Get Your Files Here !/6 - Bond Valuation & Analytics Cash Flows, Yields and Interest Rate Risk/36. Understanding Bond Duration (Macaulay Duration, Modified Duration).mp4

77 MB

~Get Your Files Here !/6 - Bond Valuation & Analytics Cash Flows, Yields and Interest Rate Risk/37. Case Study (Part I.) Modeling the Cash Flows & Monthly PV of a Bond.mp4

97 MB

~Get Your Files Here !/6 - Bond Valuation & Analytics Cash Flows, Yields and Interest Rate Risk/38. Case Study (Part II.) Modeling the Cash Flows & Monthly PV of a Bond.mp4

34 MB

~Get Your Files Here !/6 - Bond Valuation & Analytics Cash Flows, Yields and Interest Rate Risk/39. Bonus Lecture How Economic Expectations and Central Bank Decisions Move Yields.mp4

59 MB

~Get Your Files Here !/7 - Complete Corporate Financial Analysis An Industrial Company Case Study/40. Company Analytics, Operations and Industry Risks.mp4

54 MB

~Get Your Files Here !/7 - Complete Corporate Financial Analysis An Industrial Company Case Study/41. Understanding Corporate Profit and Loss Statement.mp4

22 MB

~Get Your Files Here !/7 - Complete Corporate Financial Analysis An Industrial Company Case Study/42. P&L Analysis EBITDA margin, Profit Margin and Many More.mp4

45 MB

~Get Your Files Here !/7 - Complete Corporate Financial Analysis An Industrial Company Case Study/43. Understanding Corporate Balance Sheet.mp4

53 MB

~Get Your Files Here !/7 - Complete Corporate Financial Analysis An Industrial Company Case Study/44. Balance Sheet Analysis (focus on Liquidity and Leverage).mp4

66 MB

~Get Your Files Here !/7 - Complete Corporate Financial Analysis An Industrial Company Case Study/45. Understanding Cash Flow Direct vs. Indirect Method.mp4

48 MB

~Get Your Files Here !/7 - Complete Corporate Financial Analysis An Industrial Company Case Study/46. Calculating Operating Cash Flow Step by Step.mp4

68 MB

~Get Your Files Here !/7 - Complete Corporate Financial Analysis An Industrial Company Case Study/47. Calculating Investment Cash Flow Step by Step.mp4

25 MB

~Get Your Files Here !/7 - Complete Corporate Financial Analysis An Industrial Company Case Study/48. Calculating Financing Cash Flow Step by Step.mp4

55 MB

~Get Your Files Here !/7 - Complete Corporate Financial Analysis An Industrial Company Case Study/49. Analysing Key Cash Flow KPI-s CF Margin and OCF Ratio.mp4

38 MB

~Get Your Files Here !/7 - Complete Corporate Financial Analysis An Industrial Company Case Study/50. Bringing It All Together Complete Financial Analysis.mp4

122 MB

~Get Your Files Here !/8 - Course Wrap-Up and Key Takeaways/51. Key Takeaways from the Course.mp4

1.8 MB

~Get Your Files Here !/Bonus Resources.txt

70 B