دورة التحليل المالي باستخدام Excel

المصدر: Ryan O'Connell, CFA, FRM

• Stock Annual Return & Standard Deviation in Excel | FREE FILE مقفل 5 د
• How to Estimate the Beta of a Stock in Excel مقفل 2 د
• Investment Performance Evaluation in Excel: Sharpe Ratio, Treynor Ratio & Jensen's Alpha مقفل 8 د
• How to Calculate NPV and IRR in Excel مقفل 4 د
• Calculate Sharpe Ratio In Excel مقفل 4 د
• How to Create a Loan Amortization Table in Excel مقفل 5 د
• Profitability Index Explained in Excel مقفل 3 د
• How to Calculate Payback Period and Discounted Payback Period مقفل 4 د
• Bond Duration in Excel مقفل 2 د
• Bond Duration and Bond Convexity Explained مقفل 9 د
• Calculating Macauley, Modified, and Effective Bond Durations in Excel مقفل 9 د
• Calculate Bond Convexity and Duration in Excel | Interest Rate Risk مقفل 11 د
• Key Rate Duration & Key Rate Shifts Explained مقفل 4 د
• The Spot Curve and Forward Curve Explained In 5 Minutes مقفل 4 د
• Riding the Yield Curve and Rolling Down the Yield Curve Explained مقفل 8 د
• Probability of Default (PD) and Loss Given Default (LGD) Explained مقفل 6 د
• Interest Rate Swaps Explained | Example Calculation مقفل 6 د
• Weighted Average Cost of Capital (WACC) Explained مقفل 3 د
• How to Value a Stock Using the Dividend Discount Model مقفل 4 د
• Dividend Discount Model: A Thorough Introduction مقفل 8 د
• Mastering Multi-Asset Portfolio Analysis: Standard Deviation & Returns in Excel مقفل 14 د
• Calculating the Optimal Portfolio in Excel | Portfolio Optimization مقفل 8 د
• Portfolio Optimization in Excel: Step by Step Tutorial مقفل 15 د
• Graph The Efficient Frontier And Capital Allocation Line In Excel مقفل 8 د
• Efficient Frontier Explained in Excel: Plotting a 3-Security Portfolio مقفل 14 د
• Stock Portfolio Monte Carlo Simulation In Excel مقفل 8 د
• Parametric Method: Value at Risk (VaR) In Excel مقفل 7 د
• Monte Carlo Method: Value at Risk (VaR) In Excel مقفل 10 د
• Historical Method: Value at Risk (VaR) In Excel مقفل 5 د
• Constructing Call and Put Option Payoff Diagrams in Excel مقفل 8 د
• Put-Call Parity in Options Trading Explained Using Excel مقفل 9 د
• Covered Calls Explained | Option Strategy Basics مقفل 7 د
• Protective Puts Explained | Option Strategy Basics مقفل 6 د
• The Greeks Explained: Options Analysis in Excel مقفل 25 د
• Binomial Interest Rate Trees Explained | CFA & FRM مقفل 11 د
• Cross Hedging Explained: Find Optimal # of Futures Contracts مقفل 7 د
• SOFR Futures Explained: 3-Month & 1-Month Pricing in Excel مقفل 10 د
• Futures Pricing and Valuation Simplified مقفل 8 د
• Traditional vs Roth IRA Rollover: Excel Analysis مقفل 1 س 9 د
• Create a Live Stock Portfolio Tracker in Excel | No Microsoft 365 Required مقفل 21 د
• LIVE Stock Portfolio Dashboard in Excel in 30 Minutes! مقفل 29 د
• Create a Correlation Matrix in Excel In 4 Minutes! مقفل 4 د
• How to Create a Covariance Matrix In Excel مقفل 3 د
• Maximum Drawdown Calculation Explained in Excel | Portfolio Risk Analysis مقفل 5 د
• Beginner Excel for Finance & Accounting Course – Full Free Training مقفل 1 س 21 د
• Get Free Historical Stock Prices from Yahoo Finance to Excel: Bypass Paywall مقفل 3 د
• How Long Will Your Retirement Savings Last? (Excel Simulation) مقفل 13 د
• How to Annualize Monthly Returns in Excel (Simple vs Log + Standard Deviation) مقفل 5 د
• What Is the Probability of a Recession? Calculate It in Excel for Free مقفل 7 د