• Lesson.No : 43
  • 00:04:22

  • Estimating VaR Using The Historical Simulation Method - Value At Risk In Excel

  • Play

Course Lessons

  1. 1- Create A Monthly Amortisation Table - Mortgage Repayment Calculator In Excel (Part 1 of 3)
  2. 2- Make Amortisation Table Dynamic With VBA - Mortgage Repayment Calculator In Excel (Part 2 of 3)
  3. 3- Insert Charts And Compare Mortgage Options - Mortgage Repayment Calculator In Excel (Part 3 of 3)
  4. 4- Create A Personal Budget In Excel In Under 10 Minutes - Using RANDBETWEEN, SUM And COMBO Charts
  5. 5- Calculate UK National Insurance Using VLOOKUP In Excel – Progressive System
  6. 6- Calculate UK Income Tax Using VLOOKUP In Excel - Progressive Tax Rate
  7. 7- Create A Live Currency Converter In Excel - Extract Currency Data Online
  8. 8- Variable Rate Mortgage Repayment Calculator - Build An Amortisation Table In Excel
  9. 9- Calculate UK Self-Employed National Insurance Contributions Using VLOOKUP In Excel (2020/21)
  10. 10- Compound Interest Calculator In Excel - Calculate Savings Using FV Function
  11. 11- How To Calculate CAGR In Excel (Compound Annual Growth Rate)
  12. 12- Calculate Risk And Return Of A Two-Asset Portfolio In Excel (Expected Return And Standard Deviation)
  13. 13- How To Graph The Efficient Frontier For A Two-Stock Portfolio In Excel
  14. 14- Calculate The Minimum Risk Two Stock Portfolio Using SOLVER In Excel
  15. 15- Calculate The Future Value Of An Investment With Variable Returns In Excel Using FVSCHEDULE
  16. 16- Calculate Net Present Value To Decide Between Two Projects In Excel - NPV Function
  17. 17- Calculate Net Present Value When Cash Flows Occur Irregularly - XNPV Function
  18. 18- Calculate The Beta Of A Portfolio In Excel - The Excel Hub
  19. 19- Calculate Scottish Income Tax 2021-22 Using VLOOKUP In Excel - Progressive Tax System
  20. 20- How To Calculate Depreciation Using The Straight Line Method In Excel
  21. 21- How To Calculate Depreciation Using The Reducing Balance Method In Excel
  22. 22- How To Calculate The Price Of A Bond In Excel
  23. 23- Calculate The Price Of A Bond With Semi Annual Coupon Payments In Excel
  24. 24- Calculate The Yield To Maturity Of A Bond In Excel
  25. 25- Calculate The YTM Of A Bond With Semi Annual Coupon Payments In Excel
  26. 26- YouTube Earnings Calculator Calculate Earnings Using Daily Views And CPM In Excel
  27. 27- Calculate The Macaulay Duration Of A Bond In Excel
  28. 28- Calculate The Effective Annual Rate In Excel Using The EFFECT Function
  29. 29- CFA Level 1 Revision Quantitative Methods The Time Value Of Money Reading 1
  30. 30- Calculate 2021-22 UK National Insurance - Using VLOOKUP In Excel
  31. 31- Calculate 2022-23 UK Income Tax - Using VLOOKUP In Excel
  32. 32- Calculate Risk And Return Of A 3-Asset Portfolio In Excel (Expected Return And Standard Deviation)
  33. 33- Calculate Risk And Return Of An N-Asset Portfolio In Excel (Expected Return And Standard Deviation)
  34. 34- How To Graph Active Exposures Of A Fund In Excel - The Excel Hub
  35. 35- Automate Investment Commentary - Dynamic Reporting On Stock Performance In Excel
  36. 36- Mortgage Rate Change Calculator - Assess Impact Of Rising Interest Rates On Monthly Payments
  37. 37- Calculate 2023-24 UK National Insurance In Excel - The Excel Hub
  38. 38- Calculate CAGR (Compound Annual Growth Rate) For An Investment Period Over A Period Of Days In Excel
  39. 39- Calculate 2023-24 UK Income Tax – Using VLOOKUP In Excel
  40. 40- Create A Residual Income Model To Value A Stock In Excel - The Excel Hub
  41. 41- Create A Dividend Discount Model To Value A Stock In Excel - The Excel Hub
  42. 42- Estimating VaR Using The Parametric Method - Value At Risk In Excel
  43. 43- Estimating VaR Using The Historical Simulation Method - Value At Risk In Excel
  44. 44- How To Calculate And Plot Bollinger Bands In Excel - The Excel Hub
  45. 45- Calculate 2024-25 UK Income Tax – Using VLOOKUP In Excel