Forum Login | Courses Login

IPMT Formula in Excel

IPMT Formula in Excel

by | Jun 18, 2020 | Online Business Courses

How to Use the IPMT Formula in Excel The IPMT formula returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate. This is something you can use to calculate investments or also loans and it will...
NPV Formula in Excel

NPV Formula in Excel

by | Jun 18, 2020 | Online Business Courses

How to Use the NPV Formula in Excel The Net Present Value (NPV) formula in Excel is used to determine the present value of future cash flows on investment and thereby how much money it will return over the term for decision-making purposes. Formula Explanation Rate:...
IRR Formula in Excel

IRR Formula in Excel

by | Jun 18, 2020 | Online Business Courses

How to Use the IRR Formula in Excel The IRR formula in Excel is used to determine the discount rate which makes the NPV equal to zero. If you calculate the IRR and it is greater than your expected rate of return (discount rate) then you should accept the project as an...
IF (OR) FORMULA in Excel

IF (OR) FORMULA in Excel

by | Jun 18, 2020 | Online Business Courses

How to Use the IF(OR) Formula in Excel The IF function can be used to perform a logical comparison between two values by testing for a condition and returning the result based on whether that condition is TRUE or FALSE. You can also use the OR function, one of the...
IF(AND) Formula in Excel

IF(AND) Formula in Excel

by | Jun 17, 2020 | Online Business Courses

How to Use the IF(AND) Formula in Excel The IF function can be used to perform a logical comparison between two values by testing for a condition and returning the result based on whether that condition is TRUE or FALSE. You can also use the AND function, one of the...