How to Compute IRR in Excel (Basic to Advanced)
December 22, 2020
Excel comes with great tools to compute the IRR on an investment. We are going to show you 3 methods in computing IRR and their limitations.
Black-Scholes Option Pricing (Excel formula)
December 22, 2020
Black-Scholes option pricing is one of the landmarks for quantitative finance. Let’s learn about the intuition and apply it to price options in Excel!
Categories
.
- Array Formula (3)
- Data validation (3)
- Excel Formula & Functions (34)
- Excel Skills (37)
- Excel Tips and Tricks (38)
- Finance (5)
- Formatting (8)
- Option Pricing (3)
- Pivot table (3)
- Sharing (8)
- Shortcuts (13)
- Solver (1)
- Technical (6)
- VBA (18)
