by Ilker | Aug 9, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to calculate simple interest in Excel. Download Workbook What is Simple interest? Simple interest is the most basic approach to calculate the amount earned from an investment or payment of a loan. Simple interest method... 
by Ilker | Aug 9, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to calculate compound interest in Excel. Download Workbook Compound interest Compound interest means "interest on the interest", which defines the interest calculation based on both the initial principal and the accumulated... 
by Ilker | Feb 2, 2021 | Excel Formulas
NORMSINV Excel formula is a Statistical function that calculates the inverse of the standard normal cumulative distribution of a specific probability. The standard normal distribution is a type of normal distribution with a mean of zero (0) and a standard deviation of... 
by Ilker | Feb 2, 2021 | Excel Tips & Tricks
In finance, option pricing is a term used for estimating the value of an option contract using all known inputs. Monte Carlo Simulation is a popular algorithm that can generate a series of random variables with similar properties to simulate realistic inputs. In this... 
by Ilker | Oct 11, 2019 | Excel Formulas
The Excel PPMT function is a Financial formula that calculates and returns the principal amount of the payment of a loan, based on constant payments and interest rate. In this guide, we’re going to show you how to use the PPMT function and also go over some tips and... 
by Ilker | Aug 27, 2019 | Excel Formulas
The Excel EFFECT function is a Financial formula that calculates and returns the effective annual interest rate, for a given nominal annual interest rate and number of compounding periods per year. The effective annual interest rate is used to compare financial loans... 
by Ilker | Aug 27, 2019 | Excel Formulas
The DURATION Excel function is a Financial formula that calculates and returns the annual duration of a security based on the Macauley duration formula. In this guide, we’re going to show you how to use the DURATION function and also go over some tips and error... 
by Ilker | Aug 26, 2019 | Excel Formulas
The Excel YIELD function is a Financial formula that calculates and returns the yield on a security that pays a periodic interest. A common use case for the YIELD function is calculating bond yields. In this guide, we’re going to show you how to use the Excel YIELD... 
by Ilker | Aug 22, 2019 | Excel Formulas
The Excel PRICEMAT function is a Financial formula that calculates and returns the price per $100 face value of a security that pays interest at maturity. In this guide, we’re going to show you how to use the PRICEMAT function and also go over some tips and error...