Learn to calculate fixed asset depreciation in Excel using methods like straight-line, sum of the years' digits, and more for accurate financial analysis.
Learn about semivariance, a key metric for assessing a portfolio’s downside risk. Understand its formula and how to calculate potential negative variations below the mean.